

PSI PEPSI DIET DIET WT VOL 0.7925 0,7868 0.7846 22 0,7938 0.7861 0,7844 0.7795 0,7883 0,7879...
Please answer question 6.
Data set for problem :
Testing Claims About Variation. In Exercises 5-16, test the given claim. Identify the null hypothesis, alternative hypothesis, test statistic, P-value or critical value(s), conclusion about the null hypothesis, and final conclusion that addresses the original claim. Assume that a simple random sample is selected from a normally distributed population. 5. Cans of Coke Data Set 19 in Appendix B includes volumes (oz) of a simple random sample of 36 cans of...
Via Excel please
11. Weights of Coke. Construct a frequency table for the weights (in pounds) given below of 36 cans of regular Coke. Start the first bin at 0.7900 pound and use a bin width of 0.0050 pound. Discuss your findings. 0.8192 0.8194 0.8211 0,8176 0.8062 0.81430.8110 0.8152 0.7901 0.8152 0.8079 0.8161 0.8161 0.8163 0.8194 0.8247 0.8165 0.8172 0.8150 0.8264 0.8207 0.8073 0.8295 0.8170 0.8150 0.81890.8181 0.8284 0.8128 0.8229 0.8251 0.8244 0.8244 0.8126 0.8044 0.8192 12. Weights of Diet...
Weights of Diet coke. Construct a frequency table for the weights (in pounds) given below of 36 cans of Diet Coke. Start the first bin at 0.775 pound and use a bin width of 0.0050 pound. 0.775 0.7758 0.776 0.7771 0.7773 0.7802 0.7806 0.7811 0.7813 0.7822 0.7822 0.7822 0.7826 0.783 0.7833 0.7839 0.7844 0.7852 0.7852 0.7852 0.7859 0.7861 0.7868 0.787 0.7872 0.7874 0.7874 0.7879 0.7879 0.7881 0.7885 0.7892 0.7896 0.7907 0.791 0.7923 0.7923
Please answer questions 4 and 6 with steps.
Sample data from Exercise 1 used for question 4 :
6.5 6.6 6.7 6.8 7.1 7.3 7.4 7.7 7.7 7.7
data set for question 6
4. Hypothesis Test For the sample data from Exercise 1, we have s = 0.5 and we want to use that sample to test the claim that the sample is from a population with a standard devia- tion less than 1.8 min (as it was in the...
can someone show me how to enter this into EXCEL
I need to know how this is supposed to be entered and
the EXCEL formula to use...
what should my
spread sheet look like?
tutorials aren't showing me... please help!
thank you
12. Weights of Diet Colke. Construct a fre- quency table for the weights (in pounds) given below of 36 cans of Diet Coke. Start the first bin at 0.7750 pound and use a bin width of 0.0050 pound....