🔍
Hypothesis t-test for One Sample Mean using Excel’s Data Analysis - YouTube
Channel: Joshua Emmanuel
[0]
Welcome!
In this tutorial I’m going to be conducting
[3]
a one-sample hypothesis t-test in Excel using
the built-in Data Analysis command.
[9]
I’ll be testing if the population mean age
is significantly greater than 20 based on
[15]
this sample data.
We’re testing if the mean is greater than
[18]
20, so this has to be the alternative hypothesis
because it contains no equality.
[25]
And the null hypothesis will be µ ≤ 20.
We will be conducting a t-test because the
[32]
population standard deviation is unknown.
Next I’m going to launch Excel to generate
[37]
the statistics for the test.
[41]
Here in Excel, we will be using the Built-in Data Analysis command to generate the statistics
[47]
for testing the hypothesis.
Click on the Data tab, and on the right here,
[53]
you should see the Data Analysis command.
If it’s not there, please see description
[58]
on how to load it.
[59]
Now, there is no listed function in Data Analysis
for one sample t-tests. But we’re going
[65]
to trick or fool Excel to do it.
First, we create a Dummy second variable here.
[75]
And input at least two 0s in it.
[78]
Next, click Data, Data Analysis.
And Scroll down to the second to the last
[86]
option here.
t-test: Two-Sample Assuming Unequal Variances
[92]
Click OK.
[94]
For Variable 1 range, select the actual data.
And for variable 2 range, select the dummy
[102]
data.
[105]
For the hypothesized Mean Difference, input
20 (the test value from the hypothesis).
[112]
I’m going to check labels here because I selected
the labels.
[118]
For the significance level alpha, I’m going
to leave it at 0.05.
[122]
For out output range, I’m just going to
select it, click in this white cell, and click
[127]
anywhere on the sheet.
[129]
And then click OK.
[130]
I’m going to double-click here to expand
the cells.
[134]
Right-click on the dummy column here to delete
it (since we don’t need it).
[138]
And then I’m going to clean up the title
a little bit.
[142]
Call it One-sample here.
[146]
And then delete the word, Difference, here
because we don’t need it.
[150]
And that’s the output.
____
[153]
So here is our cleaned up output from Excel.
Let’s set up a rejection or critical region:
[160]
Since this is a one-tailed test, we will use
the one tailed critical value here.
[165]
And because it's a right-tailed test, we
will reject the null hypothesis if the t statistic
[171]
is greater than the critical value of 1.740.
For the test statistic, we have a t-stat value
[180]
here of 2.577.
Again because this is a one-tailed test, our
[186]
p-value will be the one-tailed p-value here
which is 0.0098.
[192]
Next we make a decision on whether or not
to reject the null hypothesis.
[196]
Now, the test statistic 2.577 is greater than
the critical value 1.740. As a result, we
[205]
will reject the null hypothesis.
We can also use the p-value to arrive at the
[210]
same decision.
The p-value rule is to reject H0 if the p-value
[216]
is less than α.
Our p-value here is 0.0098 which is less than
[222]
our α of .05. And that again tells us to
reject the null hypothesis.
[228]
Our conclusion will then be that:
There is enough evidence to infer that the
[233]
mean age is significantly greater than 20.
[237]
And that concludes this hypothesis testing
video. Thanks for watching.
Most Recent Videos:
You can go back to the homepage right here: Homepage