On the Data sheet, go to the Data Tab and click onData Analysis. Double click onAnova: Single Factor. ForInput Range, select the range A1:C20, and keep the defaultGrouped By Columns. Check theLabels in first row box and keep the defaultAlpha=0.05. SelectOutput Range under Output Option and typeF1.

In cell C4, find the mean weight loss for Medication 1.

In cell C5, find the mean weight loss for Medication 2.

In cell C6, find the mean weight loss for Medication 3.

In cell C7, find the sum of squares between the groups.

In cell C8, find the sum of squares within the groups.

In cell C9, find the total sum of squares.

In cell C10, find the mean sum of squares between the groups.

In cell C11, find the mean sum of squares within the groups.

In cell C12, find the total mean sum of squares.

What is the appropriate null hypothesis to test in this case? Choose your answer from the dropdown menu in cell C13.

In cell C14, find the test value.

In cell C15, find the critical value.

By assessing the values in cells C14 and C15, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell C16.

Justify the answer you chose in cell C16. Choose your answer from the dropdown menu in cell C17.

Based on your answer in cell C17, we can conclude at alpha = 0.05 that: Choose your answer from the dropdown menu in cell C18.

What is the probability of a Type I error in this test? Choose your answer from the dropdown menu in cell C19.

In cell C20, find the observed level of significance (p-value) for the test.

By considering the p-value, can the same conclusion be made about rejecting or not rejecting the null hypothesis at alpha = 0.05? Choose your answer from the dropdown menu in cell C21.

In cell C22, find the p-value.

Hint: use the F.DIST.RT function

If the level of significance (alpha) was reduced to 0.01, find the critical value in cell C23.

Hint: use the F.INV.RT function

Do you reject the null hypothesis at alpha=0.01? Choose your answer from the dropdown menu in cell C24.

Justify the answer you chose in cell C24. Choose your answer from the dropdown menu in cell C25.

Based on your answer in cell C25, we can conclude at alpha = 0.01 that: Choose your answer from the dropdown menu in cell C26.

If the level of significance (alpha) was reduced to 0.001, find the critical value in cell C27.

Hint: use the F.INV.RT function

Do you reject the null hypothesis at alpha=0.001? Choose your answer from the dropdown menu in cell C28.

Justify the answer you chose in cell C28. Choose your answer from the dropdown menu in cell C29.

Based on your answer in cell C29, we can conclude at alpha = 0.001 that: Choose your answer from the dropdown menu in cell C30.

Medication 1	Medication 2	Medication 3
1.84	4.750	6.900
2.5	5.700	10.500
4.6	10.450	3.450
6.44	14.250	5.750
5.52	4.750	8.050
6.44	4.750	5.750
1.84	6.650	4.600
0.5	14.250	5.750
5.52	6.650	3.500
6.44	6.650	3.450
8.28	5.700	11.500
7.36	12.350	8.050
2.76	8.550	10.350
4.6	12.350	2.300
	7.600	12.650
	8.550	8.800
	11.400
	3.800
	13.300

I need the to know the functions for each of the questions and the answers .. example = F.INV.RT