The data for per capita income in thousands of us

Assignment Help Applied Statistics

Reference no: EM13717704

The following table gives the data for per capita income in thousands of US dollars with the percentage of the labor force in Agriculture and the average years of schooling of the population over 25 years of age for 15 developed countries in 2000 (data modified for educational purpose). Develop a multiple regression model for per capita income (dependent variable) using Excel or MegaStat and answer the questions below the table. You can use symbols Y, X1 and X2 for the variables in your calculation. Show your computer output.
Country number per capita % of labor in Agriculture Average years of schooling
1 20 9 7
2 26 10 12
3 24 8 11
4 21 7 11
5 22 10 12
5 42 4 16
7 27 5 11
8 24 5 9
9 28 6 12
10 32 8 14
11 30 7 12
12 40 4 16
13 34 9 14
14 30 5 10
15 35 8 13

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 3 and average years of schooling is 15. 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 Perform t-test for the statistical significance of individual coefficients.

Reference no: EM13717704

Questions Cloud

Carbon dioxide dissolves in water and water evaporates : Carbon dioxide dissolves in water and water evaporates into the atmosphere during the experiment. How do these two factors affect the results of your analysis in this experiment

Define chemical equation for the galvanic cell reaction : What is the balanced chemical equation for the galvanic cell reaction expressed using shorthand notation below

Determine the temperature of state : Air initially at 290 K, 1 bar undergoes the following processes: polytropic compression to 5 bar with n = 1.19 and isentropic expansion to 1 bar. Sketch the processes on a T-s diagram, Determine the temperature of state 2 and

Define what volume of solution do i have in a flask : What volume of solution do I have in a flask if the empty flask weighs 250g, the total flask with solution weighs 320g, and the density of the solution is 1.5g/ml

The data for per capita income in thousands of us : The following table gives the data for per capita income in thousands of US dollars with the percentage of the labor force in Agriculture and the average years of schooling of the population over 25 years of age for 15 developed countries in 20..

Explain what is the molarity of a phosphoric acid stock used : What is the molarity of a phosphoric acid stock used to make 750ml of a dilute 4M solution if 52ml of the stock was used?

Calculate the adjusted retention volume of the analyte : In a capillary GC separation the analyte of interest elutes at 7.2min, and the unretained peak elutes at 2.2min. Given column dimensions of 30m x 0.5mm ID, calculate the adjusted retention volume of the analyte.

Determine the final volume of the argon : One cubic meter of argon initially at 300 K is compressed such that the change in the specific enthalpy is -0.27 kJ/kg-K and the temperature is reduced 100 K. Determine the final volume of the argon. (k = 1.67)

Company w is testing a sales software : Company W is testing a sales software. Its sales force of 500 people is divided into four regions: Northeast, Southeast, Central, and West. Each sales person is expected to sell the same amount of products. During the last 3 months, only half ..

User Account

All Pages