Question 1

Forty-eight patients, each suffering from kidney disease, hyperthyroidism, or diabetes, were randomly assigned to one of four different drug treatments, and the decrease in their systolic blood pressure was recorded. You can find the data in the Excel file provided. Answer the following questions:

1. Set up an appropriate table in Excel for performing a two-way ANOVA.
2. Perform the two-way ANOVA test.
3. Determine whether there are any significant (p < 0.05) main effects or an interaction effect. Explain what this means in the context of the diseases and BP treatments.

please provide excel steps

Question 1
	Disease
Kidney Disease	Hyperthyroidism	Diabetes
Treatment	ACE Inhibitor	8, 20, 12, 15	25, 35, 41, 19	16, 19, 28, 24
Beta Blocker	12, 4, 6, 10	16, 14, 23, 27	19, 25, 23, 32
Diuretic	13, 15, 22, 10	18, 14, 12, 29	12, 15, 14, 8
Calcium Channel Blocker	13, 5, 7, 12	20, 23, 19, 9	36, 17, 38, 21