For this assignment I have to analyze the regression (relationship between 2 independent variables and 1 dependent variable). Below is all of my data and values. I need help answering the questions that are at the bottom. Questions regarding the strength of the relationship
Model: Median wage (y) = 40.3774 - 2.0614 * Population + 0.0284 * GDP
Predictor |
Coefficient |
Estimate |
Standard Error |
t-statistic |
p-value |
Constant |
B0 |
40.3774 |
1.1045 |
36.558 |
0 |
Population |
B1 |
-2.0614 |
0.5221 |
-3.948 |
0.0003 |
GDP |
B2 |
0.0284 |
0.007 |
4.0403 |
0.0002 |
R-Squared |
R2 = 0.2538 |
Adjusted R-Squared |
R2 adj = 0.2227 |
Residual Standard Error |
5.6087 on 48 degrees of freedom |
Overall F-statistic |
8.1625 on 2 and 48 degrees of freedom |
Overall p-value |
0.0009 |
Analysis of Variance Table
Source |
df |
SS |
MS |
F-statistic |
p-value |
Regression |
2 |
513.5541 |
256.777 |
8.1625 |
0.0009 |
Residual Error |
48 |
1509.9841 |
31.458 |
||
E=Total |
50 |
2023.5381 |
40.4708 |
1. Find the model with the most explanatory power and significant estimates. Describe what your regression output shows regarding the statistical properties of your model.
2. What does this model suggest regarding the relationships between your variables?
3. Do you think your data more or less satisfy OLS regression assumptions? Explain why? Or why not?
4. Based on 3), do you think your analysis is reliable?
Sol:
For this assignment I have to analyze the regression (relationship between 2 independent variables and 1...
The ANOVA summary table to the right is for a multiple regression model with five independent variables. Complete parts (a) through (e). Source Degrees of Freedom Sum of Squares Regression 5 270 Error 28 110 Total 33 380 a. Determine the regression mean square (MSR) and the mean square error (MSE). b. Compute the overall FSTAT test statistic. FSTAT=_______________________ (Round to four decimal places as needed.) c. Determine whether there is a significant relationship between Y and the two independent...
The ANOVA summary table to the right is for a multiple regression model with five independent variables. Complete parts (a) through (e). Source Degrees of Freedom Sum of Squares Regression 5 270 Error 28 110 Total 33 380 a. Determine the regression mean square (MSR) and the mean square error (MSE). b. Compute the overall FSTAT test statistic. FSTAT=_______________________ (Round to four decimal places as needed.) c. Determine whether there is a significant relationship between Y and the two independent...
Regression Analysis Question: is there any relationship between the economic growth rate(GDP) and unemployment rate(Unemp_Rates), Poverty (Poverty_Rates), Technological and science workforce(ech_Scien_Wforce), high school graduate (HS_Grad_Rates) , and housing cost( Housing_Cost) This is a regression analysis result : Call: lm(formula = GDP_Rate ~ Unemp_Rates + Poverty_Rates + Tech_Scien_Wforce + HS_Grad_Rates + Housing_Cost) Residuals: Min 1Q Median 3Q Max -1.5562 -0.3988 -0.1126 0.4971 1.6748 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 15.822486 5.424619 2.917 0.00555 ** Unemp_Rates -0.053450 0.136427 -0.392...
are the assumptions behind any multiple regression model? (b). For a multiple regression model Y-Bo + βιΧ. + β2X2 +β3Xs + € where is the error term, to represent the relationship between Y and the four X- variables. We got the following results from the data: Source Sum of Squares degrees of freedom mean squares Regression 1009.92 Residual Total 2204.94 34 And also you are given: Variable X1 Σ.tx-xr 123.74 72.98 12.207 -Pr values -11.02 5.13 X2 X3 Y-intercept is...
1.Which variables are statistically significant at the 5% level? 2.Which variables are statistically significant at the 10% level? 3.Which variables are insignificant? 4.Please present the correlation matrix of the independent variables. 5.Please run the White test for heteroskedasticity, with cross-products AND PRESENT YOUR RESULTS. Please explain whether the test is significant or not. 6.If the White test is significant, please present the heteroskedasticity-consistent White regression results. 7.Can you test this model for autocorrelation? Why of why not? If you do,...
Drop down options are durability, impact properties, shock absorbing capabilities, the two independent variables. A regression analysis is performed to predict the durability of a brand of running shoe, based on the shock-absorbing capability and the change in impact properties over time. The resulting ANOVA table is below. Complete parts (a) through (d). Degrees of Sum of Freedom Squares Regression Error Total 10.45577 6.46314 16.91891 Mean Square 5.22789 0.28101 p-value 0.00002 18.60 2 23 25 a. Determine whether there is...
only part II is needed Regardless of your answer to (a), you come up with the following multiple regression model. b. Coefficients: Estimate Std. Error t value Pr>lt (Intercept) 72.2285 1.2697 56.89 2e-16 X2 X3 Residual standard error: 7.25 on 191 degrees of freedom Multiple R-squared: 0.494, Adjusted R-squared: 0.489 F-statistic: 93.3 on 2 and 191 DF, p-value: <2e-16 0.4590 0.0524-8.76 1.1e-15 0.4146 0.1290 3.21 0.0015** I) What percentage of the total variation in Life Expectancy can you explain with...
answer both please 0 41 A perfectly vertical scatter plot relationship between Y and X Question 18 (3 points) Since increasing the number of variables increases R2 why not include every variable in the regression equation? 1) Yes, you can include as many significant variables as you wish since computation power is the only limitation on regression modeling. 2) No, since adding more variables will eventually increase the degrees of freedom in the numerator of the F statistic and the...
Correlation This assignment will examine your ability to analyze the relationship between two variables, create an equation for predicting one variable from the other, and to critique the results of the data. You will be given the data for 2 psychological experiments looking at the relationship between variables. For these sets of data you will: (1) use the SPSS program to calculate the correlation and create a scatterplot (2) provide the appropriate output given from the program (3) describe this...
(13 points) Suppose you have a simple linear regression model such that Y; = Bo + B18: +€4 with and N(0,0%) Call: 1m (formula - y - x) Formula: F=MSR/MSE, R2 = SSR/SSTO ANOVA decomposition: SSTOSSE + SSR Residuals: Min 1Q Modian -2.16313 -0.64507 -0.06586 Max 30 0.62479 3.00517 Coefficients: Estimate Std. Error t value Pr(> It) (Intercept) 8.00967 0.36529 21.93 -0.62009 0.04245 -14.61 <2e-16 ... <2e-16 .. Signif. codes: ****' 0.001 '** 0.01 '* 0.05 0.1'' 1 Residual standard...