. Identify the categorical variable with three or more levels. Use this to define groups. Then choose any quantitative variable, and perform a one-way ANOVA test in Excel's Data Analysis menu. Report the following in the excel file you submit: 1a. State the null and alternative hypothesis using words (not symbols) 1b. Report the significance level (you choose this), the test statistic, and the p-value. 1c. Make a conclusion that someone without statistical training can understand. 2. Estimate a linear regression model using the following criteria: dependent variable selection, y - Drug Trial data -> use BPChange as your dependent variable

choose any two quantitative variables - create one additional quantitative variable by modifying or combining two existing ones in your data *Warning* if your new variable is a sum or difference of the two you already chose, the model will not work and Excel will return an error message. 3. Provide or interpret the following from your regression output: a) Report and interpret R2 for your model b) Interpret the estimated coefficient for the first independent variable in your output c) Demonstrate the interpretation of the third independent variable in your output by choosing realistic values for each independent variable, calculating the predicted value of y, and then recalculating y after increasing the value for your third variable by 1. d) Provide the p-value and draw a conclusion for a test of the significance of your third independent variable e) Provide the p-value and draw a conclusion for the test of joint significance of all of your independent variables

Marital Status	Age	CholChange	BPChange	VisionChange	Happy1	Happy2	Happy3	Male?
S	55	1.7	-1	-2	39	42	47	Y
M	53	6.4	5	5	26	35	38	N
M	37	-2.85	0	-2	59	64	72	N
DWS	42	-1.8	0	0	67	66	71	Y
S	41	-2.85	-4	0	26	33	40	N
M	67	-2.9	-4	-1	28	27	26	Y
S	65	-2.4	0	-1	44	44	47	N
M	61	-2.2	-2	6	38	46	54	Y
S	44	-1.15	1	2	34	35	34	Y
S	59	-0.65	1	2	63	70	75	N
DWS	40	4.25	1	-2	48	52	53	N
M	64	0.25	5	4	37	41	47	Y
M	40	-4	-7	4	48	50	55	N
M	45	-1.8	2	0	69	74	76	N
S	50	-1.65	-1	0	64	70	72	Y
M	50	2.95	3	-4	62	66	75	Y
M	45	-1.3	1	2	47	47	51	N
S	60	7.5	9	6	55	58	62	N
DWS	29	3.6	3	-2	35	43	43	Y
S	38	7.4	5	2	42	41	51	Y
DWS	56	-1.75	0	-1	55	57	63	Y
DWS	53	-1.15	1	-2	38	43	50	Y
M	60	1.75	3	-1	60	59	64	N
S	51	6.6	4	-2	69	68	69	N
S	68	-2.2	1	3	32	39	41	N
M	62	6.4	6	0	30	35	41	Y
M	49	-1.7	-2	9	35	39	37	Y
S	50	-1.35	-3	-3	36	45	42	Y
S	59	2.75	3	4	36	38	43	Y
S	36	-3.15	-5	5	60	63	64	Y
S	43	0.1	3	6	48	57	60	N
M	50	-4.25	-3	0	56	58	68	N
S	28	4.5	4	0	55	57	57	N
M	47	-2.25	-3	3	59	60	60	Y
M	49	-0.15	3	-4	43	46	50	Y
DWS	55	0.5	4	5	44	47	51	N
M	59	-2	-3	1	30	38	41	Y
M	58	-2.3	-3	6	59	66	69	N
DWS	39	-4.2	-8	0	57	65	72	Y
M	50	1.65	0	7	43	51	56	N
M	67	-0.4	2	-2	50	54	55	N
S	46	-2.65	1	3	40	41	41	Y
DWS	50	4.7	5	-4	62	67	66	Y
M	52	-2.55	-5	1	58	58	58	N
S	34	-0.25	0	8	45	52	59	N
S	40	6.6	9	2	48	54	57	Y
S	30	3.3	5	6	33	37	45	N
S	59	2.95	3	6	37	44	46	N
M	39	-3.65	-2	-2	49	58	62	N
M	66	4.95	3	-4	59	62	67	N
S	62	4.3	6	8	41	37	47	Y
M	31	3.35	5	2	46	51	52	Y
M	53	2.5	4	-5	46	50	52	Y
M	53	4.35	2	0	67	70	79	N
M	63	4.05	3	2	39	39	44	Y
DWS	52	-3.35	-1	4	75	82	86	Y
M	45	3.9	7	-7	62	64	71	Y
DWS	47	-3.45	-3	-5	40	48	48	N
S	62	-4.45	-4	4	51	58	66	N
DWS	41	-2.9	-1	6	66	74	71	N
DWS	55	-0.25	-1	4	35	38	41	N
M	45	6.3	9	4	50	54	56	N
M	46	-0.3	1	-4	37	36	43	N
M	49	5.95	7	0	49	52	59	N
DWS	43	-0.3	1	3	51	58	63	N
DWS	61	4.55	3	-1	33	38	40	Y
S	48	5.55	3	7	41	44	50	N
DWS	65	-3.65	-5	3	58	66	69	Y
DWS	63	6.45	9	6	33	31	36	Y
M	23	1.8	4	3	42	41	48	Y
DWS	46	-0.05	1	-5	44	48	56	N
M	62	6.15	6	2	55	53	51	N
M	45	-0.85	0	-2	42	45	49	Y
S	60	5.6	7	-2	24	29	29	Y
S	60	2.05	4	-2	81	84	87	Y
M	51	-2.45	-1	-1	40	44	49	Y
M	43	3.25	2	6	67	72	72	N
M	63	5.85	5	3	65	63	67	Y
M	62	-1.35	-4	3	27	31	38	N
M	51	7.1	9	5	49	54	57	N
S	58	5.65	4	1	45	43	41	Y
M	70	0.65	1	2	33	44	46	Y
M	66	6.05	6	-2	43	49	48	N
M	62	1.3	1	0	35	43	51	N
M	48	-3.7	-6	-4	46	44	50	N
M	44	3.15	5	-3	53	55	65	Y
M	68	6.1	6	0	40	47	46	N
DWS	41	-1.9	1	-2	62	68	72	N
M	55	6.15	6	2	68	72	76	Y
DWS	60	-1.6	2	6	68	79	84	Y
M	56	-4	-1	1	58	63	66	Y
DWS	61	5.6	5	7	65	64	63	Y
S	47	2.15	1	1	33	36	36	N