Find the Y-Intercept and Slopes

Find the Y-intercept and slopes for the two independent variables and interpret them. Predict the per capita income when the percentage of the labor force in Agriculture is only 4,  average years of schooling is 15. And Health Index is 100. Find the overall explanatory power (Coefficient of Determination) of the model and interpret it. Also, find the adjusted coefficient of Determination and interpret it. Find the standard error of the estimate. From the ANOVA table find SSR, SSE, and SST and the F-value. Perform the F-test and comment on the overall usefulness of the model. What are the degrees of freedom for Regression, Error, and Total? Perform t-test for the statistical significance of individual coefficients. Plot the errors or residuals by countries and comment on the visible pattern. Plot the errors separately by each explanatory variable and comment on the visible patterns with respect to heteroscedasticity.

 

Don't use plagiarized sources. Get Your Custom Essay on
Find the Y-Intercept and Slopes
Just from $13/Page
Order Essay

Eco 309-

Total points 125. Submit through D2L in Word/Excel format, single or multiple files. Must show all Excel work, answer all parts of the question, and write necessary explanations to earn full points. You have to use Excel to solve this numerical problem (project).

The following table gives the data for per capita income in thousands of US dollars with the percentage of the labor force in Agriculture, the average years of schooling of the population over 25 years of age, and overall health index for 15 developed countries in 2015 (data modified for educational purpose). Develop a multiple regression model for per capita income (dependent variable) using Excel and answer the questions below the table. You can use symbols Y, X1, X2 and X3 for the variables in your calculation. Show your computer output.

 

Country number per capita % of labor in Agriculture Average yrs of schooling Overall Health Index
1 30 9 8 70
2 40 10 13 80
3 39 8 11 77
4 36 7 10 75
5 38 10 12 76
5 50 4 16 95
7 42 5 10 82
8 39 5 10 80
9 44 6 12 85
10 48 8 14 92
11 45 7 12 90
12 52 4 16 98
13 47 9 14 90
14 45 5 10 85
15 48 8 13 90

 

 

Find the Y-intercept and slopes for the two independent variables and interpret them. Predict the per capita income when percentage of labor force in Agriculture is only 4, average years of schooling is 15. And Health Index is 100. Find the overall explanatory power (Coefficient of Determination) of the model and interpret it. Also find the adjusted coefficient of Determination and interpret it. Find the standard error of estimate. From the ANOVA table find SSR, SSE and SST and the F-value. Perform the F-test and comment on the overall usefulness of the model. What are the degrees of freedom for Regression, Error and Total? Perform t-test for the statistical significance of individual coefficients. Plot the errors or residuals by countries and comment on the visible pattern. Plot the errors separately by each explanatory variable and comment on the visible patterns with respect to heteroscedasticity.

ORDER NOW »»

and taste our undisputed quality.