Question

In: Statistics and Probability

Construct a model to predict the Savings based on the following predictors: Education Level, Salary, Cars,...

Construct a model to predict the Savings based on the following predictors: Education Level, Salary, Cars, Home, and SC Index. The dataset is below . Decide if any predictors should be removed using the p-value criterion and rerun the regression model. Compare the adjusted coefficients of determination.

Couple Educ Level Salary Cars Home SC Index Savings
1 4 90 19 83 3 289
2 2 95 35 134 3 1130
3 2 99 46 110 5 583
4 3 130 24 69 7 1049
5 4 126 42 153 7 612
6 2 73 35 127 2 650
7 3 111 34 98 7 675
8 4 140 53 191 9 347
9 2 52 33 119 2 420
10 2 99 50 147 6 39
11 4 101 40 132 3 5
12 3 134 50 208 10 553
13 2 62 36 91 1 659
14 3 139 45 258 8 648
15 4 84 21 221 4 5
16 2 46 28 124 1 630
17 4 104 40 184 2 698
18 1 54 21 50 1 1247
19 2 88 49 193 4 471
20 3 119 57 265 10 81

Solutions

Expert Solution

The regression output is:

Since Home is insignificant (p-value > 0.05), it should be removed from the regression model.

The new model is:

The adjusted R-square is 0.603.

The adjusted R-square value has increased as compared to the previous model.

The regression model is:

y = 950.9102 -371.5922*x1 + 18.1143*x2 - 17.9741*x3 - 95.2013*x4


Related Solutions

Explain what the gravity model of trade predict are the major predictors of trade flows between...
Explain what the gravity model of trade predict are the major predictors of trade flows between countries. Discuss how this model helps to explain trade flows using three of its leading trade partners as examples.
22-explain what the gravity model of trade predict are the major predictors of trade flows between...
22-explain what the gravity model of trade predict are the major predictors of trade flows between countries. discuss how this model helps to explain trade flows using three of its leading trade partners as examples.
In order to improve the linear model to predict an employee’s salary (in thousands), the researcher...
In order to improve the linear model to predict an employee’s salary (in thousands), the researcher decided to also include in the model the previous work experience (in years) and education of each employee (in years). The multiple regression linear model is as follows: Salaryi=β0+β1Employmenti+β2Experience+β3Education+εi The following information was obtained from the statistical software: Source                   df                  SS            MS                    F           P-value Model                      3      29231989 9743996                   ?                 .006   Error                      4      1739708    434927 Total                        7      30971697       Variable                Parameter...
What does the model predict economic growth? What does it predict the level of GDP?
Solow model without ideas accumulation Consider the simple Solow model without ideas accumulation in the long term (steady-state). What does the model predict economic growth? What does it predict the level of GDP?
Construct Lewis structure for each molecule && then predict the geometric structure of the molecule based...
Construct Lewis structure for each molecule && then predict the geometric structure of the molecule based on VSEPR theory. 1. H2O 2. C2H4 3. CH4 4. C2H2 5. CO2 6. N2 7. SF2 8. NH3 9. PH3 10. CH4O
Fit a multiple regression model that relates the salary to education, work experience, and time spent...
Fit a multiple regression model that relates the salary to education, work experience, and time spent at the bank so far. a - State what your model is. b - Determine whether the independent variables are significant, or not, at a level of significance of 5%. c - Which independent variable is most significant in explaining salary? Which is least significant? d - Is your overall model significant? Provide statistical proof by conducting an F-test for overall fit of the...
Fit a multiple regression model that relates the salary to education, work experience, and time spent...
Fit a multiple regression model that relates the salary to education, work experience, and time spent at the bank so far. a - State what your model is. b - Determine whether the independent variables are significant, or not, at a level of significance of 5%. c - Which independent variable is most significant in explaining salary? Which is least significant? d - Is your overall model significant? Provide statistical proof by conducting an F-test for overall fit of the...
The level of nitrogen oxides (NOX) in the exhaust of cars of a particular model varies...
The level of nitrogen oxides (NOX) in the exhaust of cars of a particular model varies Normally with mean 0.21 grams per mile (g/mi) and standard deviation 0.051 g/mi. Government regulations call for NOX emissions no higher than 0.29 g/mi. What is the probability (±0.001) that a single car of this model fails to meet the NOX requirement? A company has 12 cars of this model in its fleet. What is the probability (±0.001) that the average NOX level x⎯⎯⎯...
1. Consider a study where we use a person's education level to to predict how much...
1. Consider a study where we use a person's education level to to predict how much money they have invested. What type of variable is the dependent variable? Binary Discrete Continuous Qualitative 2. Consider an experiment where we use the amount of sugar in cereal to predict what shelf the cereal is placed on in the grocery store. What type of variable is the independent variable? A. Discrete B. Continuous C. Categorical D. Qualitative 3. You want to determine whether...
We want to build a multiple regression model to predict sr (the “Savings Ratio”) in the LifeCycleSavings datase
Use α = 0.05 unless told otherwise. --Everything should be r-code base. --data set is built-in in r code. Just type in LifeCycleSavings. --DATA ALREADY EXIST IN R. PLEASE JUST TYPE IN LifeCycleSavings in R. --DATA IS NOT MISSING We want to build a multiple regression model to predict sr (the “Savings Ratio”) in the LifeCycleSavings dataset (see ?LifeCycleSavings for more background info). a. Build a model that uses all the other variables in the data frame as predictors, including...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT