How To Do One Sample T Test In Excel
A one sample t-exam is used to test whether or not the mean of a population is equal to some value.
This tutorial explains how to deport a ane sample t-test in Excel.
How to Bear a I Sample t-Test in Excel
Suppose a botanist wants to know if the mean elevation of a certain species of constitute is equal to fifteen inches. She collects a random sample of 12 plants and records each of their heights in inches.
The following image shows the height (in inches) for each plant in the sample:
We can utilize the following steps to conduct a one sample t-exam to determine if the mean summit for this species of plant is actually equal to 15 inches.
Stride one: Notice the sample size, sample mean, and sample standard difference.
Kickoff, we need to discover the sample size, sample mean, and sample standard divergence, which volition all be used to carry the one sample t-test.
The post-obit image shows the formulas we tin can use to calculate these values:
Step 2: Summate the test statistict.
Side by side, nosotros will calculate the test statistictusing the following formula:
t = x – µ / (s/√northward)
where:
10 = sample hateful
µ = hypothesized population mean
s = sample standard deviation
n = sample size
The following epitome shows how to summatetin Excel:
The test statistictturns out to be-1.68485.
Footstep three: Calculate the p-value of the test statistic.
Next, we need to calculate the p-value associated with the test statistic using the following function in Excel:
=T.DIST.2T(ABS(x), deg_freedom)
where:
ten = test statistict
deg_freedom = degrees of freedom for the test, which is calculated as n-1
NERD NOTES:
The function T.DIST.2T() returns the p-value for a 2-tailed t-test. If you're instead conducting a left-tailed t-test or a correct-tailed t-exam, you would instead apply the functions T.DIST() or T.DIST.RT(), respectively.
The following image shows how to summate the p-value for our test statistic:
The p-value turns out to be0.120145.
Step 4: Interpret the results.
The two hypotheses for this particular one sample t exam are as follows:
H0:µ = fifteen (the mean acme for this species of establish is fifteen inches)
HA:µ ≠xv (the mean superlative isnot15 inches)
Because the p-value of our test (0.120145)is greater than alpha = 0.05, nosotros neglect to reject the null hypothesis of the test. We do non have sufficient evidence to say that the mean meridian for this particular species of establish is different from fifteen inches.
Farther Reading:
How to Conduct a Two Sample t-Test in Excel
How to Conduct a Paired Samples t-Test in Excel
Source: https://www.statology.org/one-sample-t-test-excel/
Posted by: mcclearylonswellot.blogspot.com
0 Response to "How To Do One Sample T Test In Excel"
Post a Comment