statistics
posted by Carolyn on .
The number of grams of carbohydrates in a 12ounce serving of a regular soft drink is listed here for a random sample of sodas. Find the 99% confidence interval for the mean number of carbohydrates in all brands of soda.
48 37 52 40 43 46 41 38
41 45 45 33 35 52 45 41

Hope this helps:
Mean 42.625
Standard Error 1.37196635
Median 42
Mode 41
Standard Deviation 5.487865402
Sample Variance 30.11666667
Kurtosis 0.413446348
Skewness 0.110205125
Range 19
Minimum 33
Maximum 52
Sum 682
Count 16
Confidence Level(99.0%) 4.04279092
This is really easy to do. Just type the data into excel and then go to "DataData Analysis (make sure you have enabled this)" Then go to "Descriptive Statistics and enter in the C.I. and anything else. Good Luck