Hypothesis z-test for One Sample Mean using Excel’s Data Analysis

[@joshemman]

One-Sample Z-Test in Excel Using Summary Statistics: kzbin.info/www/bejne/mGGoo5WcadOSnbM

[@deshabhaktudu1884]

watched many videos, but there was no decision regarding the hypothesis test. But Joshua you are the master bro. Take a bow

[@joshemman]

My pleasure, Desha. 🙏

[@boomerbloomer]

for sure!

[@908572813]

the perfect tutorial that should be seen the second week after starting study statistics! tnx

[@jairustubal3171]

You really are a the most efficient in terms of relaying lessons.. short but 100% effective

[@belaynehbaye770]

I can not find words to express my gratitude , but in simple words '' THANK YOU VERY MU|CH Sir''

[@chee4281]

Thank you so much! It was so easy to understand and straight to the point. I was shocked by how easy it was. You are a great teacher!

[@tejaswinishenoy8252]

Very nicely and cleanly explained. Thank you

[@joshemman]

Z-test one-tailed example: kzbin.info/www/bejne/oX-uqpt7qtamsNU

[@mohammadabdullah6110]

You did an excellent job here, thanks so much for sharing this video with us👍👍

[@christywong4303]

The video content is so excellent, congratulations

[@karunkrishna2662]

Saved my life for tomorrow's Research Methodolgy Practical.

[@mithonaphal]

love you man . ur vdo 100% clear

[@wooddog007]

Thanks

[@joshemman]

Thanks for going out of yuour way to do this. Much appreciated.

[@MarcinKawka]

Oh man! This is more helpfull than the official Micro$oft support!

[@asiyasiddica4689]

it is an excellent video. Thank you so much for make my work done easily. Regards, from Bangladesh

[@boomerbloomer]

Thia Ià SOOOOO clear! Thank you!

[@RideSmoothTV]

Great video!!!! Helped out alot.

[@gregorydashnaw2522]

Excellent video Joshua

[@abdulmukhtor59]

hey bro, good one. It really helped me to understand the hypothesis testing and solve the problem. Thank you.

[@johnchristianmiranda7148]

better than my college professor

[@Anas-qq2jy]

this is great, thanks for upload

[@harishreddy7549]

How do you fix the null hypothesis as mu = 23 is it random wherein we can fix mu to any value for the null hypothesis

[@joshemman]

It will depend on the hypothesis you're testing.

[@harishreddy7549]

@@joshemman For example if i want to fix my null hypothesis as mu=25 to the above data set then what changes need to be done ..?

[@joshemman]

Replace the 23 with 25.

[@pushkarpatil6123]

Joshua what we do for if there is unknown variance and data n=250

[@manishchauhan5625]

Then use t-test

[@RioxFu]

Helpful video. Thank you!

[@dinbomaniquomijah8791]

HOW DO YOU USE THIS SAME PROCESS IF YOU HAVE NO DATA?

[@cococnk388]

Sir … Can I say that the z statistics does not depends on the alpha value .. Whereas the Z critical value dépend on the alpha value and whether the hypotheses is a tailed or paired one? Thanks

[@joshemman]

Yes, yes, and yes.

[@Falcon-sy7de]

Great tutorial, thank you

[@roshellw1]

HI, my excel asks for a value for output range what would i put there ?

[@ahmedawais1291]

Select an Any empty cell where you want your output results.

[@allydecoy6513]

What if i dont have hypnotized mean???

[@joshemman]

You cannot do a one sample Z-test without a hypothesized mean. It is the population mean, μ.

[@allydecoy6513]

@@joshemman (μ) = ∑X / N do i have to calculate for this (population mean formula) in order to get the hypnotized mean difference?

[@joshemman]

@@allydecoy6513 For one-sample test for mean, the hypothesized mean must be given. If you’re comparing two samples, then the hypothesized mean difference will be zero by default, unless otherwise stated.

[@danielleillana7029]

thank u! gamiton nako ni sa akuang pt!

[@atreus9876]

saba uy

[@danielleillana7029]

@@atreus9876 saba uy

[@ZleYee]

saba uy

[@danielleillana7029]

@@ZleYee hater

[@lowiilagraayyss8317]

Unsa ang year sa imohang excel?

[@LouisChang98]

Thanks a lot. Save my statistics quiz :)

[@yousafbhatti5289]

Why are dummy variables = 0 used?

[@joshemman]

The 0 dummy is used because the Excel function is designed to work with 2 variables. We are tricking Excel to help solve our one-variable problem. If you don't provide a second variable, it won't work. We have to use a value of 0 so the mean and variance are both 0.

[@yousafbhatti5289]

@@joshemman thank you so much! gained a new subscriber :)

[@MrPridizzle]

Oh haaaaill yeah! Stone Cold Steve Austin approves of this video!

[@cococnk388]

Gréât one sir

[@samkab677]

Whtat if ho 23 ? What will be the hypothesized mean?

[@joshemman]

23

[@samkab677]

@@joshemman do we get the Same results for p value and same conclusion if ho>=23 and h1

[@joshemman]

@@samkab677 ho>=23 and h1

[@anonymeironikerin2839]

Hello Joshua, are you sure that you used the correct values of your sample? Based on your sample I get a z-Score of - 1,25083 and the p-Value for two is 0,211000324. Besides, I also get a different mean (21,943) and not 21,8.

[@joshemman]

Here's the data used: Age 25 30 23 21 24 22 24 25 22 21 22 18 20 24 24 22 23 19 21 20 21 21 19 21 19 24 20 20 20 23 22 23 19 22 19

[@anonymeironikerin2839]

Joshua Emmanuel Thank you very much for your quick answer😊

[@michelleisenhour1028]

So, the data you used in Excel is, in fact, different than the sample data. You have three 25's in the sample data and only two 25's in your Excel data (observation 27 should be 25, but you used 20 in Excel).

[@nickmilan2739]

thankyou, very helpful

[@RossMKF1]

What do I do if I have no data other than the mean difference, mean, amount of data or n, standard deviation, and alpha. I have to do this on Excel instead of the formula.

[@joshemman]

Use =(meandiff/(stdev/sqrt(n)) to calculate Z. If Z is negative, then use =NORMSDIST(Z) to find the p-value. If Z is positive, then use =1- NORMSDIST(Z) to find the p-value. If you're conducting a 2-tailed test, use =2*NORMSDIST(Z) and 2*(1-NORMSDIST(Z)) respectively. "meandiff" equals "(x-bar - mu)".

[@RossMKF1]

Joshua Emmanuel Thank you I’ll try it out and see how it goes, I appreciate man!

[@xoxsusufulxox]

What if the variance is unknown?

[@joshemman]

You can calculate it if you have raw data and perform a t-test: kzbin.info/www/bejne/nJqwd6Scltmcm6c

[@sacuponkimberlyfaithl.7154]

How to get the hyphotesized mean difference 23?

[@williamcattr267]

How about demonstrating this with a word problem??? "Some first-time home buyers-especially millennials are raiding their retirement accounts to cover the down payment on a home. An economist is concerned that the percentage of millennials who will dip into their retirement accounts to fund a home now exceeds 20%. He randomly surveys 190 millennials with retirement accounts and finds that 50 are borrowing against them. a. Set up the null and the alternative hypotheses to test the economist's concern. b. Calculate the value of the test statistic and the p-value. c. Determine if the economist's concern is justifiable at α=0.05."

[@joshemman]

Here you go 😀 kzbin.info/www/bejne/qqWyf6aNaZmDo5Y

[@soniaangelinadachi715]

Why VARIABLE 1 VARIABLE be 25?

[@joshemman]

See 00:10. σ = 5 -> σ^2 = 25

[@soniaangelinadachi715]

So, variable 1 variance should be square?

[@joshemman]

@@soniaangelinadachi715 σ = standard deviation σ^2 = variance If you already have variance you don't have to square it. Only square if you have standard deviation.

[@soniaangelinadachi715]

@@joshemman Okay, thank you so much..

[@أحمدالشافعي-ط4ر]

thanks a lot ...

[@inderveernatt2202]

ADMS 2320 anyone?