I was recently marked down on a lab project for using the excel function to find the confidence interval for 95% certainty. I properly used the function but retrieved a different answer than my professor who used Descriptitive Statistics under the Data Analysis-Tools feature.
The only way I can recover the points is to figure out why the answers were different.
The sample size is 20, Mean 25.87, Max Value 28, Min Value 24.2, Standard Deviation 1.01, Range 3.80, Mode 26 and Median 25.75
Any ideas why our values were different? did excel possibly use different tables?
-Spencer
Bookmarks