1.Please Perform regression analysis by doing the following (Hint: Chapter 13 on simple regression and 14 on multiple regression):

a. Organize the data and show in MS Excel;

b. Write down potential questions that you could answer using regression analysis for thehappiness.xls dataset;

c. Perform onesimple regressionusing any two reasonable variables from the happiness.xls file(two quantitative variables) and show the analysis results;

d. Interpret the findings from the simple regression analysis;

e. Add one or more quantitative variable (including dummy variable that have values of 0 and 1) to the analysis in #b, perform one multiple regression analysis

f. Interpret your findings from the multiple regression analysis.

Happy(3 levels, 1 not too happy, Health (4 levels, 1 very poor health, Age Children Education_Year 2, pretty happy, 3 very happy) 2, poor health, 3 healthy, 4, very healthy) Income Relationship Married_(1Yes, 1No) 62 6 9 Widowed 12 2 18 Divorced 18 Widowed o 18 Never Married w 8 Widowed 9 Divorced 5 Separated w N 16 Widowed ON 16 Divorced WAN 17 Widowed 12 3 Divorced 9 Separated 14 -+ oo 11 Never Married 16 Never Married 25 Widowed w 650 5 5 21 Divorced 22 Never Married SAOON 22 Never Married o ww 22 Divorced ow 23 Never Married 19 Divorced OWN 18 Divorced 18 Never Married ON 11 Divorced 15 Divorced 16 Divorced 13 Never Married w 13 Never Married 15 Never Married 15 Never Married 16 Never Married N 17 Never Married 11 Never Married 13 Divorced 15 Never Married N m 16 Never Married 38 w w 17 Never Married 39 17 Never Married 40 50 23 Widowed 41 44 16 A 21 Separated37 12 IN 23 Separated 50 20 Separate 63 18 Divorced A 20 Divorced o - 20 Never Married 19 Divorced 18 Never Married 20 Never Married 2 Divorced -ONwoo 15 Divorced 10 Never Married 36 13 Never Married 61 17 Never Married 14 Married 21 Married 24 Married 22 Married 22 Married 18 Married 17 Married HN NN NN NN NN NN mm 17 Married 2 Married -ONNNWANWWNWN-NONOWAS 13 Married 15 Married 13 Married 21 Married 22 Married w w 25 Married 22 Married HN M N N N -NM NM NNNNMNMNNmm NNmm 23 Married 21 Married J W 21 Married 25 Married w w 25 Married 19 Married 19 Married N+ + HNNmmo 18 Married 19 Married 19 Married 19 Married 63 19 Married 30 w w 20 Married 44 16 20 Married\f