very easy Stat

book1.xlsx

Sheet1

		Bottle Number	Ounces	Bottle Number	Ounces	Bottle Number	Ounces
		1	14.23	11	15.77	21	16.23
		2	14.32	12	15.8	22	16.25
		3	1498	13	15.82	23	16.31
		4	15	14	15.87	24	16.32
		5	15.11	15	15.98	25	16.34
		6	15.21	16	16	26	16.46
		7	15.42	17	16.02	27	16.47
		8	15.47	18	16.05	28	16.51
		9	15.65	19	16.21	29	16.91
		10	15.74	20	16.21	30	16.96
16.02, 16.05, 16.21, 16.21, 16.23, 16.25, 16.31, 16.32, 16.34, 16.46, 16.47, 16.51, 16.91, 16.96
	1. Calculate the mean, median, and standard deviation for ounces in the bottles.
	2. Construct a 95% Confidence Interval for the ounces in the bottles.
	3. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test.
	4. Provide the following discussion based on the conclusion of your test:
	a. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future.