1. Please Perform ANOVA One-Factor Analysis by doing the following

a. Organize the data and show in MS Excel (5 points);

b. Write down one question that you could answers using ANOVA One Factor analysis with the Happiness_2011.xls dataset and state its null and alternate hypotheses (5 points);

c. Perform one ANOVA One-Factor analysis using two reasonable variables from the Happiness_2011.xls dataset (one quantitative variable and one qualitative group variable) and show the analysis results for the question (10 points);

d. Indicate whether you reject or accept the null hypothesis (5 points);

e. Interpret your findings from the analysis (5 points).

2. Please Perform one Chi-square Test by doing the following (Hint: Chapter 15/17, Nonparametric Methods: Chi-Square):

a. Organize the data and show in MS Excel (5 points);

b. Write down one potential question that you could answers using Chi-square test with the Happiness_2011.xls dataset and state its null and alternate hypotheses (5 points);

c. Perform one Nonparametric Methods: Chi-Square Test using any two reasonable variables from the Happiness_2011.xls dataset (two qualitative variables) and show the analysis results for the question (10 points);

d. Indicate whether you reject or accept the null hypothesis (5 points);

e. Interpret your findings from the analysis (5 points).

3. 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 (5 points);

b. Write down potential questions that you could answer using regression analysis for the Happiness_2011.xls dataset (5 points);

c. Perform one simple regression using any two reasonable variables from the Happiness_2011.xls file (two quantitative variables) and show the analysis results (10 points);

d. Interpret the findings from the simple regression analysis (5 points);

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 (10 points)

f. Interpret your findings from the multiple regression analysis (5 points).

2 Average 7 3 Ves Age Children Flucahon_Year Sibling Income Relahonship Mamed_1Yes Happy Happiness (3 levels) FO3 levels) F 3 levels) 58 4 3 9 Separated 0 1 Not klappy 1 Dolew/verage 151 3 12 > 18 Dance () 2 Prally Happy 2 Average 50 3 13 2 13 Widow: 0 1 Not Happy HAS 17 1 18 Never Mamad 0 2 Pratty Hapny 2 Average R4 3 12 1 # Widowcd 0 2 Prally I Inppy 1 Bew/verage 51 54 2 10 2 9 Divorced 0 2 Prelly Happy 1 Below Avurugu 50 B 9 2 5 Separated 0 1 Not to Happy 1 Below Average 61 3 15 2 16 Widuwuu 0 2 Prelly Happy 1 Below Avoruju BU 2 12 16 Divorced 0 RS 2 Prally Happy 1 Bew/verage 89 4. 11 2 17 Widowed 0 I Nul kyu Happy 1 Bolo Average 463 3 2 3 Divorced 0 1 Not Happy 1 Daleww/werage 42 1 13 2 9 Separated 0 0 I Nulku lappy 1 Dol Avora 38 4 9 9 1 2 11 Never Manied 0 1 Not too Happy 1 Below Average 24 0 12 2 10 Never Married 0 I Nulkuappy 1 Bolo Average 57 0 19 25 Widowed 0 2 Pretty Happy 3 Above Average 41 2 12 3 21 Divorced 0 2 Pretty lappy 3 Above Average 21 0 16 1 22 Never Manied 0 3 Very Happy 3 Above Averago 39 0 18 1 22 Never Maried 0 I Nul kui lappy 3 Above Average 55 1 1 16 3 22 Divorced 0 2 Pretty Happy 3 Above Average 19 01 13 3 23 Never Manted 0 2 tretty Happy 3 Above Average 2 12 12 19 Divorced 0 2 Pretty Happy 2 Average 11 3 12 3 18 Divorced 0 2 Pretty Happy 2 Average 40 0 16 3 18 Never Married 0 I Not to Happy 2 Average 18 1 1 13 3 11 Divorced 0 2 Pretty Happy 1 Below Average 41 2 14 0 15 Divorced 0 2 Pretty Happy 1 Below Average 08 2 12 3 16 Divorced 0 2 Pretty Happy 1 Below Average 24 1 1 14 3 13 Never Married 3 Very Happy 1 Below Average 38 12 0 13 Never Mamed 0 2 Pretty Happy 1 Below Average () 2 Hrally Happy 1 19 Never Wamed Below Average 38 0 17 1 1 15 Nover Manted 0 1 Not too Happy 1 Below Average Fi 11 3 16 Never Mamed () 1 Noto Happy 1 Polo Average 19 0 13 3 17 Never Mamed 0 0 2 Pretty Happy 1 Below Average 24 Il 115 3 11 Never Mamad C () 2 Pretty Happy 1 Malow Avenge 51 0 11 1 1 13 Divorced 0 3 Very Happy 1 Below Average 23 I 12 3 1! Never Manied 2 Prally Happy 1 Pelow Average 19 11 11 3 10 Naver Maricd 0 2 Prilly Happy 1 slew orng 33 TI 12 1 1/ Never Maned () 3 Very Happy 1 Polo Average ** :31 0 14 3 17 Nover Mamici 0 2 Prally Happy Below /warngr 1) 2 12 4 4 23 Widlowed 0 2 Pretty Happy 3 Above Average 44 2 1B 4 21 Separated 0 2 Prahy HAPPY 3 Abaverage 31 3 12 4 23 Separateci O 2 Prally Happy 3 Above Average 50 ta 1 17 4 20 Separated 0 1 Not Happy 2 Averagn 83 2 17 4 13 Divorced 0 2 Pratly I apply 2 Aviage 42 4 10 4 2 Divorced 2 Prally Happy 2 Average 43 20 0 4 20 Nove Married 0 I Not loupy 2 Average 405 1 17 4 19 Divorced ( 2 Prally Happy 2 Average BS 0 10 4 13 Naver Matric 0 2 Average 3 Very Happy 24 CI 12 4 A Never Mamad c) 2 Pretty Happy 48 3 18 4 2 Divorced 0 3 Very lappy 1 Below Average 50 2 12 4 15 Divorced 0 2 Prelly Happy 1 Below Average 20 13 0 4 10 Naver Maricd o 2 Pretty lappy 1 Below Average 38 1 12 4 13 Never Married 0 3 Very Happy 1 Below Average B1 0 18 4 17 Never Maricd 0 3 Very Tlappy 1 Below Average 61 4 12 1 14 Married 1 2 Pretty Happy 1 Below Avenue 54 3 1D 2 21 Married 1 3 Very Happy 3 Aboverage 51 0 0 16 2 24 Married 1 3 Very Happy 3 Above Average 45 2 12 2 22 Married 1 2 Pretty Happy 3 Abave Average 29 0 12 0 22 Married 1 I Nollo Happy 3 Above Average 55 2 12 2 18 Martied 1 2 Pretty Happy 2 Average 20 1 12 0 1 17 Married 1 3 Very Happy 1 Bulow Average 51 2 12 2 2 17 Married 1 2 Pretty Happy 1 Below Average 64 3 14 2 Married 1 2 Prelly Happy 1 Below Averju 53 2 12 2 13 Married 1 2 Pretty Happy 1 Below Average 62 3 12 0 15 Married 1 I Nutku Happy 1 Below Average 65 3 12 2 13 Married 1 2 Pretty Happy 1 Below Average 49 2 14 3 21 Mairied 1 1 3 Very Happy 3 ADOVO Average 33 1 12 1 22 Married 1 2 Pretty Happy 3 Above Average 82 3 18 3 25 Martie 1 3 Above Average 53 2 13 3 22 Married 1 2 Pretty Happy 3 Above Average 35 2 18 0 23 Meitied 1 2 'sy Happy 3. Above Average 52 2 11 3 21 Married 1 2 Pretty Happy 3 Above Average 38 0 12 0 21 MeiTied 1 2 Pretty Happy 3 Above Average 2 1 14 Married 1 Very Happy 3 Above Average 15 2 19 3 20 Meitied 1 2 latty Happy 3 Above Average 33. 4 18 () 15) Martina 1 3 Very Happy 2 AVRIAGA 11 4 12 3 19 Maitled 1 2 Melly Happy 2 Averago 114 1 3 1 12 18 MAITIR 1 2 Pralty HAPPY 7 Average 67 2 11 3 19 Meitled 1 3 Very Happy 2 Average 445 2 12 33 19 MAITIR 1 3 Very Happy 2 Average 44 3 12 0 19 Married 1 2 Prilly Hry 2 Average 12 3 3 12 3 150 MAITI 1 2 Pralty HAPPY 2 Average LI 1B 23 20 Married 1 3 Very Happy 2 Avenge 44 3 115 3 AMATIRd 1 3 Very HAPPY 2 Average 57 12 13 Married 1 1 2 Prilly HINRY 2 Aviac 3. 3 115 0 X MAITING 1 3 Very Happy 2 Average 34 15 3 25 Married 1 2 Prally Happy 3 Abave/crage 24 0 14 3 12 Married 1 3 Very Happy 1 Below Avon 15 3 18 4 21 Married 1 3 Very Happy 3 Abave Average 08 2 1B 4 4 1 23 Married 2 Prully lappy 3 Above Avurugu 85 2 14 4 22 Married 1 3 Very Happy 3 Abave/crage 1 31 1 16 4 22 Married 1 3 Very limppy 3 Above Awuruge 14 2 15 4 4 25 Maria 1 2 Prelly Happy 3 Abav /wenge 55 3 12 4 18 Marind 1 2 Pratly I lappy 2 Average 2 11 4 19 Married 1 3 Vary Happy 2 Average 37 2 2 16 4 20 Marrid 1 3 Very lipp 2 Average 23 0 16 4 17 Married 1 2 Pretly Happy 1 Below Average 3 12 4 14 Married 1 2 Pratly I lappy 1 Del Avery 28 0 0 16 1 15 Married 1 1 Not loo Happy 1 Below Average 0 13 4 16 Married 1 3 Verylluppy 1 Blow Average 68 5 12 4 16 Menied 2 Prelly Happy 1 Below Average 333 2 14 4 12 Married 1 2 Prilly I Inppy 1 DowAverage Health 14 WRIS) Health (4 Invois) 2 Poarcell 2 Poor Health 2 Pocutilanthi 2 Poor Health 2 Poatlasili 2 Pour Health 2 Pearl lealth 2 Pour Health 2 Poar Hewith 2 Poullaith 2 Pear Hasith 2 Pouillealth 2 Poor Health 2 Poullaith 3 Healthy 3 Ilealthy 3 Hes.lry 31 litry 3 Healthy 3 Heality 3 Healthy 3 Heality 3 Heady 3 Heality 3 Houlthy 3 Heality 3 Houltry 3 Healthy 3 Hently 3 Heality 3 Heality 3 Heady 3 3 Healthy 3 Healthy 3 Heality 3 Healty 3 Hality 4 Very Healthy 4 Very Healthy 4 Very Healthy 4 Very Heality 4 Very I lohy 4 Very Heality 4 Very I leality 4 Very Healthy 4 Very I loathy 4 Very Heality 4 Very losity 4 Very Healthy 4 Very lealthy 4 Very Healthy 4 Very I lealthy 1 Very poor Health 2 Poallaith 2 Pour Health 2 Poctical 2 Pour Health 2 Poor Health 2 Pour Health 2 Poor Health 2 Pour Health 2 Poor Health 2 Pour Health 2 Poor Health 3 Heality 3 Heady 3 Heality 3 Healthy 3 Heality 3 Hendry 3 Heality 3 Heality 3 Heality 3 Healthy 3 Healty 3 Henity 3 Heality 3 litry 3 Heality 31 lealthy 3 Heality 3 Heality 4 Very Healthy 3 Healthy 4 Very Healthy 4 Very loudy 4 Very Healthy 4 Very I lowlthy 4 Very Hanity 4 Very lealthy 4 Very Healthy 4 Very I loudy 1 Very Healthy 4 Very I lealthy 4 Very Healthy 4 Vory Ilutty 4 Very Healthy 4 Very I lealthy