• You are running a trial for an experimental diabetic drug. Subjects were divided randomly into a treatment group and

placebo control group.

After taking the drug for 60 days, the following results were obtained.

Observed Data
	None	Mild	Moderate	Severe
Treatment	56	76	43	89
Placebo	17	22	23	54

I need to know the following value with regular values and in excel

Expected Values
	None	Mild	Moderate	Severe
Treatment
Placebo
What should be the appropriate null and alternative hypotheses for this study.
	Null:
	Alternative:

What is the Chi-square test for independence, using the "=chisq.test()" function that was introduced in the previous tab to obtain a P-value . what if I need to do in excel

Please note that you do not have to input the degrees of freedom as you do with the "=t.test()" function because for chi-square, df = (Rows -1)(Columns -1)

P =

Do I should reject the null hypothesis at the level of alpha = 0.05? Why and why not