. Identify the categorical variable with three or more levels. Use…

QuestionAnswered step-by-step. Identify the categorical variable with three or more levels. Use…. 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 variablechoose 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 modelb) Interpret the estimated coefficient for the first independent variable in your outputc) 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 variablee) Provide the p-value and draw a conclusion for the test of joint significance of all of your independent variablesMarital Status Age CholChange BPChange VisionChange Happy1 Happy2 Happy3 Male?S 55 1.7 -1 -2 39 42 47 YM 53 6.4 5 5 26 35 38 NM 37 -2.85 0 -2 59 64 72 NDWS 42 -1.8 0 0 67 66 71 YS 41 -2.85 -4 0 26 33 40 NM 67 -2.9 -4 -1 28 27 26 YS 65 -2.4 0 -1 44 44 47 NM 61 -2.2 -2 6 38 46 54 YS 44 -1.15 1 2 34 35 34 YS 59 -0.65 1 2 63 70 75 NDWS 40 4.25 1 -2 48 52 53 NM 64 0.25 5 4 37 41 47 YM 40 -4 -7 4 48 50 55 NM 45 -1.8 2 0 69 74 76 NS 50 -1.65 -1 0 64 70 72 YM 50 2.95 3 -4 62 66 75 YM 45 -1.3 1 2 47 47 51 NS 60 7.5 9 6 55 58 62 NDWS 29 3.6 3 -2 35 43 43 YS 38 7.4 5 2 42 41 51 YDWS 56 -1.75 0 -1 55 57 63 YDWS 53 -1.15 1 -2 38 43 50 YM 60 1.75 3 -1 60 59 64 NS 51 6.6 4 -2 69 68 69 NS 68 -2.2 1 3 32 39 41 NM 62 6.4 6 0 30 35 41 YM 49 -1.7 -2 9 35 39 37 YS 50 -1.35 -3 -3 36 45 42 YS 59 2.75 3 4 36 38 43 YS 36 -3.15 -5 5 60 63 64 YS 43 0.1 3 6 48 57 60 NM 50 -4.25 -3 0 56 58 68 NS 28 4.5 4 0 55 57 57 NM 47 -2.25 -3 3 59 60 60 YM 49 -0.15 3 -4 43 46 50 YDWS 55 0.5 4 5 44 47 51 NM 59 -2 -3 1 30 38 41 YM 58 -2.3 -3 6 59 66 69 NDWS 39 -4.2 -8 0 57 65 72 YM 50 1.65 0 7 43 51 56 NM 67 -0.4 2 -2 50 54 55 NS 46 -2.65 1 3 40 41 41 YDWS 50 4.7 5 -4 62 67 66 YM 52 -2.55 -5 1 58 58 58 NS 34 -0.25 0 8 45 52 59 NS 40 6.6 9 2 48 54 57 YS 30 3.3 5 6 33 37 45 NS 59 2.95 3 6 37 44 46 NM 39 -3.65 -2 -2 49 58 62 NM 66 4.95 3 -4 59 62 67 NS 62 4.3 6 8 41 37 47 YM 31 3.35 5 2 46 51 52 YM 53 2.5 4 -5 46 50 52 YM 53 4.35 2 0 67 70 79 NM 63 4.05 3 2 39 39 44 YDWS 52 -3.35 -1 4 75 82 86 YM 45 3.9 7 -7 62 64 71 YDWS 47 -3.45 -3 -5 40 48 48 NS 62 -4.45 -4 4 51 58 66 NDWS 41 -2.9 -1 6 66 74 71 NDWS 55 -0.25 -1 4 35 38 41 NM 45 6.3 9 4 50 54 56 NM 46 -0.3 1 -4 37 36 43 NM 49 5.95 7 0 49 52 59 NDWS 43 -0.3 1 3 51 58 63 NDWS 61 4.55 3 -1 33 38 40 YS 48 5.55 3 7 41 44 50 NDWS 65 -3.65 -5 3 58 66 69 YDWS 63 6.45 9 6 33 31 36 YM 23 1.8 4 3 42 41 48 YDWS 46 -0.05 1 -5 44 48 56 NM 62 6.15 6 2 55 53 51 NM 45 -0.85 0 -2 42 45 49 YS 60 5.6 7 -2 24 29 29 YS 60 2.05 4 -2 81 84 87 YM 51 -2.45 -1 -1 40 44 49 YM 43 3.25 2 6 67 72 72 NM 63 5.85 5 3 65 63 67 YM 62 -1.35 -4 3 27 31 38 NM 51 7.1 9 5 49 54 57 NS 58 5.65 4 1 45 43 41 YM 70 0.65 1 2 33 44 46 YM 66 6.05 6 -2 43 49 48 NM 62 1.3 1 0 35 43 51 NM 48 -3.7 -6 -4 46 44 50 NM 44 3.15 5 -3 53 55 65 YM 68 6.1 6 0 40 47 46 NDWS 41 -1.9 1 -2 62 68 72 NM 55 6.15 6 2 68 72 76 YDWS 60 -1.6 2 6 68 79 84 YM 56 -4 -1 1 58 63 66 YDWS 61 5.6 5 7 65 64 63 YS 47 2.15 1 1 33 36 36 N MathStatistics and ProbabilityECO 232Share Question