Question
In: Statistics and Probability
b. Write down potential questions that you could answer using regression analysis for the Happiness_2011.xls dataset...
b. Write down potential questions that you could answer using regression analysis for the Happiness_2011.xls dataset
c. Perform one simple regression using any two reasonable variables from the Happiness_2011.xls file (two quantitative variables) and show the analysis result
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
| Age | Children | Education_Year | Sibling | Income | Happiness (3 levels) | EQ (3 levels) | Health (4 levels) |
| 52 | 5 | 6 | 1 | 9 | Not too Happy | Below Average | Very poor Health |
| 61 | 3 | 12 | 2 | 18 | Pretty Happy | Average | Poor Health |
| 50 | 3 | 13 | 2 | 18 | Not too Happy | Average | Poor Health |
| 56 | 0 | 17 | 1 | 18 | Pretty Happy | Average | Poor Health |
| 64 | 3 | 12 | 1 | 8 | Pretty Happy | Below Average | Poor Health |
| 51 | 2 | 10 | 2 | 9 | Pretty Happy | Below Average | Poor Health |
| 56 | 6 | 9 | 2 | 5 | Not too Happy | Below Average | Poor Health |
| 61 | 3 | 15 | 2 | 16 | Pretty Happy | Below Average | Poor Health |
| 68 | 2 | 12 | 0 | 16 | Pretty Happy | Below Average | Poor Health |
| 69 | 4 | 11 | 2 | 17 | Not too Happy | Below Average | Poor Health |
| 46 | 3 | 9 | 2 | 3 | Not too Happy | Below Average | Poor Health |
| 42 | 1 | 13 | 2 | 9 | Not too Happy | Below Average | Poor Health |
| 36 | 4 | 9 | 2 | 11 | Not too Happy | Below Average | Poor Health |
| 24 | 0 | 12 | 2 | 16 | Not too Happy | Below Average | Poor Health |
| 57 | 0 | 19 | 3 | 25 | Pretty Happy | Above Average | Healthy |
| 41 | 2 | 12 | 3 | 21 | Pretty Happy | Above Average | Healthy |
| 24 | 0 | 16 | 1 | 22 | Very Happy | Above Average | Healthy |
| 39 | 0 | 16 | 1 | 22 | Not too Happy | Above Average | Healthy |
| 55 | 4 | 16 | 3 | 22 | Pretty Happy | Above Average | Healthy |
| 19 | 0 | 13 | 3 | 23 | Pretty Happy | Above Average | Healthy |
| 46 | 2 | 12 | 0 | 19 | Pretty Happy | Average | Healthy |
| 41 | 3 | 12 | 3 | 18 | Pretty Happy | Average | Healthy |
| 40 | 0 | 16 | 3 | 18 | Not too Happy | Average | Healthy |
| 48 | 1 | 13 | 3 | 11 | Pretty Happy | Below Average | Healthy |
| 41 | 2 | 14 | 0 | 15 | Pretty Happy | Below Average | Healthy |
| 66 | 2 | 12 | 3 | 16 | Pretty Happy | Below Average | Healthy |
| 24 | 1 | 14 | 3 | 13 | Very Happy | Below Average | Healthy |
| 38 | 0 | 12 | 0 | 13 | Pretty Happy | Below Average | Healthy |
| 59 | 0 | 6 | 3 | 15 | Pretty Happy | Below Average | Healthy |
| 38 | 0 | 17 | 1 | 15 | Not too Happy | Below Average | Healthy |
| 36 | 6 | 11 | 3 | 16 | Not too Happy | Below Average | Healthy |
| 19 | 0 | 13 | 3 | 17 | Pretty Happy | Below Average | Healthy |
| 24 | 0 | 16 | 3 | 11 | Pretty Happy | Below Average | Healthy |
| 51 | 0 | 11 | 1 | 13 | Very Happy | Below Average | Healthy |
| 29 | 0 | 12 | 3 | 15 | Pretty Happy | Below Average | Healthy |
| 19 | 0 | 11 | 3 | 16 | Pretty Happy | Below Average | Healthy |
| 33 | 0 | 12 | 1 | 17 | Very Happy | Below Average | Healthy |
| 31 | 0 | 14 | 3 | 17 | Pretty Happy | Below Average | Healthy |
| 60 | 2 | 12 | 4 | 23 | Pretty Happy | Above Average | Very Healthy |
| 44 | 2 | 16 | 4 | 21 | Pretty Happy | Above Average | Very Healthy |
| 37 | 3 | 12 | 4 | 23 | Pretty Happy | Above Average | Very Healthy |
| 50 | 1 | 17 | 4 | 20 | Not too Happy | Average | Very Healthy |
| 63 | 2 | 17 | 4 | 18 | Pretty Happy | Average | Very Healthy |
| 42 | 4 | 10 | 4 | 20 | Pretty Happy | Average | Very Healthy |
| 43 | 0 | 20 | 4 | 20 | Not too Happy | Average | Very Healthy |
| 46 | 1 | 17 | 4 | 19 | Pretty Happy | Average | Very Healthy |
| 65 | 0 | 18 | 4 | 18 | Very Happy | Average | Very Healthy |
| 24 | 0 | 12 | 4 | 20 | Pretty Happy | Average | Very Healthy |
| 46 | 3 | 16 | 4 | 2 | Very Happy | Below Average | Very Healthy |
| 50 | 2 | 12 | 4 | 15 | Pretty Happy | Below Average | Very Healthy |
| 20 | 0 | 13 | 4 | 10 | Pretty Happy | Below Average | Very Healthy |
| 36 | 1 | 12 | 4 | 13 | Very Happy | Below Average | Very Healthy |
| 61 | 0 | 16 | 4 | 17 | Very Happy | Below Average | Very Healthy |
| 61 | 4 | 12 | 1 | 14 | Pretty Happy | Below Average | Very poor Health |
| 54 | 3 | 10 | 2 | 21 | Very Happy | Above Average | Poor Health |
| 54 | 0 | 16 | 2 | 24 | Very Happy | Above Average | Poor Health |
| 49 | 2 | 12 | 2 | 22 | Pretty Happy | Above Average | Poor Health |
| 29 | 0 | 12 | 0 | 22 | Not too Happy | Above Average | Poor Health |
| 56 | 2 | 12 | 2 | 18 | Pretty Happy | Average | Poor Health |
| 28 | 1 | 12 | 0 | 17 | Very Happy | Below Average | Poor Health |
| 54 | 2 | 12 | 2 | 17 | Pretty Happy | Below Average | Poor Health |
| 64 | 3 | 14 | 0 | 2 | Pretty Happy | Below Average | Poor Health |
| 53 | 2 | 12 | 2 | 13 | Pretty Happy | Below Average | Poor Health |
| 82 | 3 | 12 | 0 | 15 | Not too Happy | Below Average | Poor Health |
| 65 | 3 | 12 | 2 | 13 | Pretty Happy | Below Average | Poor Health |
| 49 | 2 | 14 | 3 | 21 | Very Happy | Above Average | Healthy |
| 33 | 4 | 12 | 1 | 22 | Pretty Happy | Above Average | Healthy |
| 82 | 3 | 18 | 3 | 25 | Very Happy | Above Average | Healthy |
| 53 | 2 | 13 | 3 | 22 | Pretty Happy | Above Average | Healthy |
| 35 | 2 | 18 | 0 | 23 | Pretty Happy | Above Average | Healthy |
| 52 | 2 | 11 | 3 | 21 | Pretty Happy | Above Average | Healthy |
| 38 | 0 | 12 | 0 | 21 | Pretty Happy | Above Average | Healthy |
| 27 | 1 | 14 | 3 | 25 | Very Happy | Above Average | Healthy |
| 45 | 2 | 19 | 3 | 25 | Pretty Happy | Above Average | Healthy |
| 35 | 4 | 18 | 0 | 19 | Very Happy | Average | Healthy |
| 44 | 4 | 12 | 3 | 19 | Pretty Happy | Average | Healthy |
| 64 | 1 | 12 | 3 | 18 | Pretty Happy | Average | Healthy |
| 67 | 2 | 11 | 3 | 19 | Very Happy | Average | Healthy |
| 46 | 2 | 12 | 3 | 19 | Very Happy | Average | Healthy |
| 44 | 3 | 12 | 0 | 19 | Pretty Happy | Average | Healthy |
| 63 | 3 | 12 | 3 | 19 | Pretty Happy | Average | Healthy |
| 30 | 0 | 16 | 3 | 20 | Very Happy | Average | Healthy |
| 44 | 3 | 16 | 3 | 20 | Very Happy | Average | Healthy |
| 57 | 0 | 12 | 3 | 18 | Pretty Happy | Average | Healthy |
| 35 | 3 | 16 | 0 | 20 | Very Happy | Average | Healthy |
| 35 | 3 | 12 | 3 | 20 | Pretty Happy | Average | Healthy |
| 24 | 0 | 14 | 3 | 12 | Very Happy | Below Average | Healthy |
| 65 | 3 | 18 | 4 | 21 | Very Happy | Above Average | Very Healthy |
| 66 | 2 | 16 | 4 | 23 | Pretty Happy | Above Average | Very Healthy |
| 65 | 2 | 14 | 4 | 22 | Very Happy | Above Average | Very Healthy |
| 31 | 1 | 18 | 4 | 22 | Very Happy | Above Average | Very Healthy |
| 34 | 2 | 16 | 4 | 25 | Pretty Happy | Above Average | Very Healthy |
| 55 | 3 | 12 | 4 | 18 | Pretty Happy | Average | Very Healthy |
| 36 | 2 | 11 | 4 | 19 | Very Happy | Average | Very Healthy |
| 37 | 2 | 16 | 4 | 20 | Very Happy | Average | Very Healthy |
| 23 | 0 | 16 | 4 | 17 | Pretty Happy | Below Average | Very Healthy |
| 79 | 3 | 12 | 4 | 14 | Pretty Happy | Below Average | Very Healthy |
| 28 | 0 | 16 | 4 | 15 | Not too Happy | Below Average | Very Healthy |
| 36 | 0 | 13 | 4 | 16 | Very Happy | Below Average | Very Healthy |
| 68 | 5 | 12 | 4 | 16 | Pretty Happy | Below Average | Very Healthy |
| 33 | 2 | 14 | 4 | 12 | Pretty Happy | Below Average | Very Healthy |
Solutions
Expert Solution
b. Write down potential questions that you could answer using regression analysis for the Happiness_2011.xls dataset
Is there a relationship between Children and Age?
c. Perform one simple regression using any two reasonable variables from the Happiness_2011.xls file (two quantitative variables) and show the analysis result
| r² | 0.174 | |||||
| r | 0.417 | |||||
| Std. Error | 1.393 | |||||
| n | 101 | |||||
| k | 1 | |||||
| Dep. Var. | Children | |||||
| ANOVA table | ||||||
| Source | SS | df | MS | F | p-value | |
| Regression | 40.4522 | 1 | 40.4522 | 20.84 | 1.44E-05 | |
| Residual | 192.1815 | 99 | 1.9412 | |||
| Total | 232.6337 | 100 | ||||
| Regression output | confidence interval | |||||
| variables | coefficients | std. error | t (df=99) | p-value | 95% lower | 95% upper |
| Intercept | -0.1523 | |||||
| Age | 0.0423 | 0.0093 | 4.565 | 1.44E-05 | 0.0239 | 0.0606 |
d. Interpret the findings from the simple regression analysis
There is a significant relationship between Children and Age.
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
| R² | 0.177 | |||||
| Adjusted R² | 0.160 | |||||
| R | 0.421 | |||||
| Std. Error | 1.398 | |||||
| n | 101 | |||||
| k | 2 | |||||
| Dep. Var. | Children | |||||
| ANOVA table | ||||||
| Source | SS | df | MS | F | p-value | |
| Regression | 41.1915 | 2 | 20.5957 | 10.54 | .0001 | |
| Residual | 191.4422 | 98 | 1.9535 | |||
| Total | 232.6337 | 100 | ||||
| Regression output | confidence interval | |||||
| variables | coefficients | std. error | t (df=98) | p-value | 95% lower | 95% upper |
| Intercept | -0.0895 | |||||
| Age | 0.0426 | 0.0093 | 4.581 | 1.36E-05 | 0.0242 | 0.0611 |
| Dummy | -0.1719 | 0.2794 | -0.615 | .5399 | -0.7264 | 0.3826 |
f. Interpret your findings from the multiple regression analysis
There is a significant relationship between Children and Age.
orchestra answered 2 years agoRelated Solutions
You will be using your Framingham dataset for the following questions. 7. Calculate a multivariable regression...
You
will be using your Framingham dataset for the following questions.
7. Calculate a multivariable regression where the outcome is
total serum cholesterol and the independent variables are BMI, age,
sex and smoking status. Interpret.
8. Use the regression from question 7 to answer the
following.
a. What is the predicted total serum cholesterol for a 50
year-old man who doesn’t smoke and whose BMI is 25?
b. What is the predicted total serum cholesterol for a 25
year-old woman...
You will be using your Framingham dataset to answer the following questions. You will be performing...
You will be using your Framingham dataset to answer
the following questions. You will be performing hypothesis testing.
For each question, please write out the null hypothesis, alternate
hypothesis, which test statistic you will be using (based on
variable type). Then report the results from performing the
analysis using SPSS. Make sure to report the test statistic,
significance level, and whether you will accept or reject the null
hypothesis and why. Finally, if you find significant differences,
report the proper....
3. Load the dataset called ec122a.csv and decide the appropriate regression to run. Write down what...
3. Load the dataset called ec122a.csv and decide the appropriate
regression to run. Write down what transformations, corrections,
etc... you make and why.
y1
x1
5.3478787576716
-0.930542577578737
-69.4411002445282
-14.3360876802962
17.6647698924475
1.81741420842464
98.6511466667161
16.8769469917607
14.7965900933862
1.44147861051093
-34.5302655286703
-8.00737844994315
93.0899709372717
15.9601981407006
9.21693205816442
0.677367144474178
82.6007511115692
13.940352476942
115.798113882096
21.2544523041556
210.387049747658
38.2407928740359
25.53810654411
2.87106608048978
103.832140647001
18.1287219709914
69.9887102526973
11.9894172917371
115.53192498448
20.8016798770016
121.344292025264
22.0189019228638
92.7341812552436
15.9508245127554
141.336831165046
25.3838968113616
43.9676084746945
6.62783843142594
170.312498248916
30.6056891002234
100.141722965535
18.0744156617512
135.127526516403
25.1557427275658
35.4910615569294
5.34067840867235
49.0886162426323
7.66630180243485
183.23305880313
33.6747888141339
133.899669788226
31.0484776835843
119.472386558899
19.6774321421239
158.382012262513...
Estimate the demand curve using regression analysis. Write down the equational form. Interpret the coefficients, statistical...
Estimate the demand curve using regression analysis. Write down
the equational form. Interpret the coefficients, statistical
significance and R2. What are the limitations of your specification
(omitted variables, correlation vs. causality)?
Quantity
Price
84
59
80
65
85
54
83
61
81
64
84
58
87
48
78
68
82
63
76
70
79
65
75
80
Estimate the demand curve using regression analysis. Write down the equational form. Interpret the coefficients, statistical...
Estimate the demand curve using regression analysis. Write down
the equational form. Interpret the coefficients, statistical
significance and R2. What are the limitations of your specification
(omitted variables, correlation vs. causality)?
Quantity
Price
84
59
80
65
85
54
83
61
81
64
84
58
87
48
78
68
82
63
76
70
79
65
75
80
Estimate the demand curve using regression analysis. Write down the equational form. Interpret the coefficients, statistical...
Estimate the demand curve using regression analysis. Write down
the equational form. Interpret the coefficients, statistical
significance and R2. What are the limitations of your specification
(omitted variables, correlation vs. causality)?
Quantity
Price
84
59
80
65
85
54
83
61
81
64
84
58
87
48
78
68
82
63
76
70
79
65
75
80
In the sports industry what types of questions could you ask and assess using linear regression?
In the sports industry what types of questions could you ask and
assess using linear regression?
Solve it by R Use the “d_logret_6stocks” dataset to answer the questions. Test by using α=...
Solve it by R
Use the “d_logret_6stocks” dataset to answer the questions. Test
by using α= .01. (General Motor: GenMotor).
(1) Regress the return of General Motor on the returns of
Citigroup (with intercept). Report the estimated coefficients. Is
there any evidence to show strong linear relationship between these
two variables at significance level 5%?
(2) Suppose we “know” the return of Citigroup tomorrow is 0.05,
what is the predicted return of General Motor tomorrow?
(3) Compute the correlation of...
Use this information to answer the questions below: A regression has been run for you using...
Use this information to answer the questions below:
A regression has been run for you using the SAS and the
following regression equation was obtained:
Y = 30-2X + U.
The following data are given to you for your use in analyzing
the assumptions about the OLS model.
Obs
Y
X
(X-)
(Y-)
(X-)(Y-)
(X-)2
(Y-)2
U
U2
u(-1)
X2
1
10
4
2
50
3
3
10
2
4
30
1
1 Give the problem which is caused...
Write down a brief report of the results from this regression analysis explaining: (1) what is...
Write down a brief report of the results from this regression
analysis explaining: (1) what is the impact of each variable over
the demand? (2) How strong are the results from this analysis to
support a forecast? (3) What are the limitations you foresee by
using this analysis to forecast production for the following five
years?
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.72916937
R
Square
0.53168797
Adjusted R Square
0.51496254
Standard Error
72.98925047
Observations
30
ANOVA
df
SS
MS
F...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 1. Explain the important areas that need to be considered for a migration of web or...
- SUBJECT: CYBER ESSENTIALS Convert between binary and hexadecimal values Question 7: Convert binary number to a...
- The Parties: Kara & Karl Kelsey – owners of Karacal Kitchens Nia Netsuke – home owner...
- Write a Reverse Polish Calculator, RPN in JAVA Each time an operand is encountered, two values...
- NPV AND IRR A store has 5 years remaining on its lease in a mall. Rent...
- New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line....
- Net present Value: Blanda Incorporated mangement is considering investing in two alternative production systems. The systems...
ADVERTISEMENT