Instruction: your answers should be based analyzing the MS Excel file Happiness_2011.xls on the Happiness Survey; MS Excel file is organized with multiple datasheet for you in the Happiness_2011.xls file. In this exam, you can treat ordinal variables as interval variables.
1. Please Perform ANOVA One-Factor Analysis by doing the following (Hint: Chapter 12, ANOVA):
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).
Note:
i. in Excel, you may use Sort function to select the data under different categories from the dataset, and then use the organized dataset to perform the analysis.
ii. For one-way/factor ANOVA test, please watch the video under Chapter 12: One way/factor ANOVA:
www.youtube.com/watch?v=leHOBf_-9kM
)
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).
Note:
i. in Excel, you may use PivotTable function to build your contingency table from the dataset, and then use the table to perform the analysis. See Video under Chapter 1: How to build a PivotTable in Excel (optional):
ii. For Chi-square test, please watch the video under Chapter 15/17:: Chi-Square Test (Test of Contingency Table or Test for Independence) In Excel using data analysis:
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).
Note:
i. in Excel, you may copy the columns of the variables you want to analyze from the Happiness_2011 dataset and paste them next to each other in a new datasheet.
ii. For simple regression analysis, please watch the video under Chapter 13: simple regression basics (Excel):
and its interpretation explanation of simple regression:
iii. For multiple regression analysis, please watch the video under Chapter 14: Multiple regression analysis using Excel:
and Multiple regression analysis interpretation:
http://www.youtube.com/watch?v=i7ml3SbWd0w
; Multiple regression analysis with dummy variables:
http://www.youtube.com/watch?v=F0tRzIjDoTs
>data
_ Yes
levels)
EQ (3 levels) levels)
Health (4 levels) 2
5 1 1 1 1 3 2 0 2 2 Average 2 3 2 Widowed 0 1 Not too Happy 2 Average 2 Poor Health 0 1 18 0 2 Pretty Happy 2 Average 2 Poor Health 3 12 1 8 Widowed 0 2 Pretty Happy 1 2 Poor Health 2 2 9 Divorced 0 2 Pretty Happy 1 Below Average 2 Poor Health 0 1 Not too Happy 1 Below Average 2 Poor Health 2 Widowed 0 2 Pretty Happy 1 Below Average 2 Poor Health 2 12 0 16 Divorced 0 2 Pretty Happy 1 Below Average 2 Poor Health 4 2 17 Widowed 0 1 Not too Happy 1 Below Average 2 Poor Health 3 9 2 3 Divorced 0 1 Not too Happy 1 Below Average 2 Poor Health 1 13 2 9 Separated 0 1 Not too Happy 1 Below Average 2 Poor Health 4 9 2 11 Never Married 0 1 Not too Happy 1 Below Average 2 Poor Health 0 12 2 16 Never Married 0 1 Not too Happy 1 Below Average 2 Poor Health 0 3 Widowed 0 2 Pretty Happy 3 3 2 12 3 Divorced 0 2 Pretty Happy 3 Above Average 3 Healthy Never Married 0 3 3 Above Average 3 Healthy 0 16 1 22 Never Married 0 1 Not too Happy 3 Above Average 3 Healthy 4 16 3 22 Divorced 0 2 Pretty Happy 3 Above Average 3 Healthy Never Married 0 2 Pretty Happy 3 Above Average 3 Healthy 0 16 3 18 Never Married 0 1 Not too Happy 2 Average 3 Healthy 1 13 3 11 Divorced 0 2 Pretty Happy 1 Below Average 3 Healthy 0 15 Divorced 0 2 Pretty Happy 1 Below Average 3 Healthy 2 12 3 16 Divorced 0 2 Pretty Happy 1 Below Average 3 Healthy 0 12 0 13 Never Married 0 2 Pretty Happy 1 Below Average 3 Healthy 0 6 3 15 Never Married 0 2 Pretty Happy 1 Below Average 3 Healthy 0 12 3 15 Never Married 0 2 Pretty Happy 1 Below Average 3 Healthy 0 12 1 17 Never Married 0 3 Very Happy 1 Below Average 3 Healthy 0 14 3 17 Never Married 0 2 Pretty Happy 1 Below Average 3 Healthy 2 12 4 23 Widowed 0 2 Pretty Happy 3 Above Average 4 2 16 4 21 Separated 0 2 Pretty Happy 3 Above Average 4 Very Healthy 3 12 4 23 Separated 0 2 Pretty Happy 3 Above Average 4 Very Healthy Separated 0 1 Not too Happy 2 Average 4 Very Healthy 2 17 4 18 Divorced 0 2 Pretty Happy 2 Average 4 Very Healthy 0 20 4 20 Never Married 0 1 Not too Happy 2 Average 4 Very Healthy 0 18 4 18 Never Married 0 3 Very Happy 2 Average 4 Very Healthy 3 10 2 21 Married 1 3 Very Happy 3 Above Average 2 Poor Health 2 12 2 22 Married 1 2 Pretty Happy 3 Above Average 2 Poor Health 1 12 0 17 Married 1 3 Very Happy 1 Below Average 2 Poor Health 2 12 2 13 Married 1 2 Pretty Happy 1 Below Average 2 Poor Health 3 12 0 15 Married 1 1 Not too Happy 1 Below Average 2 Poor Health 2 18 0 23 Married 1 2 Pretty Happy 3 Above Average 3 Healthy 2 11 3 21 Married 1 2 Pretty Happy 3 Above Average 3 Healthy 1 14 3 25 Married 1 3 Very Happy 3 Above Average 3 Healthy 2 19 3 25 Married 1 2 Pretty Happy 3 Above Average 3 Healthy 2 11 3 19 Married 1 3 Very Happy 2 Average 3 Healthy 0 16 3 20 Married 1 3 Very Happy 2 Average 3 Healthy 2 16 4 25 Married 1 2 Pretty Happy 3 Above Average 4 Very Healthy 3 12 4 14 Married 1 2 Pretty Happy 1 Below Average 4 Very Healthy
2
Age
Children
Education_Year
Sibling
Income
Relationship
Married
1
Happy
Happiness (
3
EQ (3 levels)
Health (
4
5
6
9
Widowed
0
Not too Happy
Below
Average
Very poor Health
61
12
1
8
Divorced
Pretty Happy
Poor Health
50
13
18
56
17
Never Married
64
Below Average
51
10
56 6 9 2 5
Separated
61 3
15
16
68
69
11
46
42
36
24
57
19
25
Above Average
Healthy
41
21
24 0 16 1
22
Very Happy
39
55
19 0 13 3
23
46 2 12 0 19 Divorced 0 2 Pretty Happy 2 Average 3 Healthy
41 3 12 3 18 Divorced 0 2 Pretty Happy 2 Average 3 Healthy
40
48
41 2
14
66
24 1 14 3 13 Never Married 0 3 Very Happy 1 Below Average 3 Healthy
38
59
38 0 17 1 15 Never Married 0 1 Not too Happy 1 Below Average 3 Healthy
36 6 11 3 16 Never Married 0 1 Not too Happy 1 Below Average 3 Healthy
19 0 13 3 17 Never Married 0 2 Pretty Happy 1 Below Average 3 Healthy
24 0 16 3 11 Never Married 0 2 Pretty Happy 1 Below Average 3 Healthy
51 0 11 1 13 Divorced 0 3 Very Happy 1 Below Average 3 Healthy
29
19 0 11 3 16 Never Married 0 2 Pretty Happy 1 Below Average 3 Healthy
33
31
60
Very Healthy
44
37
50 1 17 4
20
63
42 4 10 4 20 Divorced 0 2 Pretty Happy 2 Average 4 Very Healthy
43
46 1 17 4 19 Divorced 0 2 Pretty Happy 2 Average 4 Very Healthy
65
24 0 12 4 20 Never Married 0 2 Pretty Happy 2 Average 4 Very Healthy
46 3 16 4 2 Divorced 0 3 Very Happy 1 Below Average 4 Very Healthy
50 2 12 4 15 Divorced 0 2 Pretty Happy 1 Below Average 4 Very Healthy
20 0 13 4 10 Never Married 0 2 Pretty Happy 1 Below Average 4 Very Healthy
36 1 12 4 13 Never Married 0 3 Very Happy 1 Below Average 4 Very Healthy
61 0 16 4 17 Never Married 0 3 Very Happy 1 Below Average 4 Very Healthy
61 4 12 1 14 Married 1 2 Pretty Happy 1 Below Average 1 Very poor Health
54
54 0 16 2 24 Married 1 3 Very Happy 3 Above Average 2 Poor Health
49
29 0 12 0 22 Married 1 1 Not too Happy 3 Above Average 2 Poor Health
56 2 12 2 18 Married 1 2 Pretty Happy 2 Average 2 Poor Health
28
54 2 12 2 17 Married 1 2 Pretty Happy 1 Below Average 2 Poor Health
64 3 14 0 2 Married 1 2 Pretty Happy 1 Below Average 2 Poor Health
53
82
65 3 12 2 13 Married 1 2 Pretty Happy 1 Below Average 2 Poor Health
49 2 14 3 21 Married 1 3 Very Happy 3 Above Average 3 Healthy
33 4 12 1 22 Married 1 2 Pretty Happy 3 Above Average 3 Healthy
82 3 18 3 25 Married 1 3 Very Happy 3 Above Average 3 Healthy
53 2 13 3 22 Married 1 2 Pretty Happy 3 Above Average 3 Healthy
35
52
38 0 12 0 21 Married 1 2 Pretty Happy 3 Above Average 3 Healthy
27
45
35 4 18 0 19 Married 1 3 Very Happy 2 Average 3 Healthy
44 4 12 3 19 Married 1 2 Pretty Happy 2 Average 3 Healthy
64 1 12 3 18 Married 1 2 Pretty Happy 2 Average 3 Healthy
67
46 2 12 3 19 Married 1 3 Very Happy 2 Average 3 Healthy
44 3 12 0 19 Married 1 2 Pretty Happy 2 Average 3 Healthy
63 3 12 3 19 Married 1 2 Pretty Happy 2 Average 3 Healthy
30
44 3 16 3 20 Married 1 3 Very Happy 2 Average 3 Healthy
57 0 12 3 18 Married 1 2 Pretty Happy 2 Average 3 Healthy
35 3 16 0 20 Married 1 3 Very Happy 2 Average 3 Healthy
35 3 12 3 20 Married 1 2 Pretty Happy 2 Average 3 Healthy
24 0 14 3 12 Married 1 3 Very Happy 1 Below Average 3 Healthy
65 3 18 4 21 Married 1 3 Very Happy 3 Above Average 4 Very Healthy
66 2 16 4 23 Married 1 2 Pretty Happy 3 Above Average 4 Very Healthy
65 2 14 4 22 Married 1 3 Very Happy 3 Above Average 4 Very Healthy
31 1 18 4 22 Married 1 3 Very Happy 3 Above Average 4 Very Healthy
34
55 3 12 4 18 Married 1 2 Pretty Happy 2 Average 4 Very Healthy
36 2 11 4 19 Married 1 3 Very Happy 2 Average 4 Very Healthy
37 2 16 4 20 Married 1 3 Very Happy 2 Average 4 Very Healthy
23 0 16 4 17 Married 1 2 Pretty Happy 1 Below Average 4 Very Healthy
79
28 0 16 4 15 Married 1 1 Not too Happy 1 Below Average 4 Very Healthy
36 0 13 4 16 Married 1 3 Very Happy 1 Below Average 4 Very Healthy
68 5 12 4 16 Married 1 2 Pretty Happy 1 Below Average 4 Very Healthy
33 2 14 4 12 Married 1 2 Pretty Happy 1 Below Average 4 Very Healthy