Question

In: Statistics and Probability

Suppose we wish to build a multiple regression model to predict the cost of rent (dollars)...

Suppose we wish to build a multiple regression model to predict the cost of rent (dollars) in a city based on population (thousands of people), and income (thousands of dollars). Use the alpha level of 0.05.

A. Is the whole regression model effective in predicting the cost of rent? Use alpha of 0.1. Make sure to show which values you use to make the decision.

B. Write down the multiple regression equation using actual names of IVs and DVs.

C. What is the value of the estimated intercept? Interpret the value in terms of rent (dollars) based on population (thousands of people), and income (thousands of dollars).

D. What is the values of the estimated slope for the variable “Income”? Interpret the value in terms of actual names of IVs and the DV.

E. What is the values of the estimated slope for the variable “Population”? Interpret the value in terms of actual names of IVs and the DV.

F. Does Income significantly influence the Rent at the alpha level of 0.01? Make sure to show which values you use to make the decision.

G. Does Population significantly influence the Rent at the alpha level of 0.01? Make sure to show which values you use to make the decision.

Data:

City Monthly Rent ($) 2018 Population (Thousands) 2010 Median Income (Thousands of Dollars)
Denver, CO 998 586.158 45.438
Birmingham, AL 711 212.237 301.704
San Diego, CA 1414 1307.402 61.962
Gainesville, FL 741 124.354 28.653
Winston-Salem, NC 750 239.617 41.979
Memphis, TN 819 646.889 36.535
Austin, TX 900 790.39 51.236
Seattle, WA 1219 618.66 58.99
Richmond, VA 735 204.214 37.735
Charleston, SC 812 120.083 47.799
College Park, MD 1407 30.413 66.9
Savannah, GA 789 136.286 32.778
Minneapolis, MN 988 394.578 45.625
Detroit, MI 650 713.777 29.447
Baton Rouge, LA 827 229.493 35.436

Solutions

Expert Solution

I used R software to solve this problem.

R code


Related Solutions

Suppose we wish to build a multiple regression model to predict the cost of rent (dollars)...
Suppose we wish to build a multiple regression model to predict the cost of rent (dollars) in a city based on population (thousands of people), and income (thousands of dollars). Use the alpha level of 0.05. City Monthly Rent ($) 2018 Population (Thousands) 2010 Median Income (Thousands of Dollars) Denver, CO 998 586.158 45.438 Birmingham, AL 711 212.237 301.704 San Diego, CA 1414 1307.402 61.962 Gainesville, FL 741 124.354 28.653 Winston-Salem, NC 750 239.617 41.979 Memphis, TN 819 646.889 36.535...
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...
Use Excel to develop a multiple regression model to predict Cost of Materials by Number of...
Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, New Capital Expenditures, Value Added by Manufacture, and End-of-Year Inventories. Locate the observed value that is in Industrial Group 12 and has 7 employees. Based on the model and the multiple regression output, what is the corresponding residual of this observation? Write your answer as a number, round to 2 decimal places. SIC Code No. Emp. No. Prod. Wkrs. Value Added by Mfg....
A multiple regression model is to be constructed to predict the final exam score of a...
A multiple regression model is to be constructed to predict the final exam score of a university student doing a particular course based upon their mid-term exam score, the average number of hours spent studying per week and the average number of hours spent watching television per week. Data has been collected on 30 randomly selected individuals: hide data Download the data Final score Mid-term Score Hours studying per week Hours watching TV per week 76 85 19 34 60...
A multiple regression model is to be constructed to predict the heart rate in beats per...
A multiple regression model is to be constructed to predict the heart rate in beats per minute (bpm) of a person based upon their age, weight and height. Data has been collected on 30 randomly selected individuals: hide data Heart Rate (bpm) Age (yrs) Weight (lb) Height (in) 78 23 245 70 91 44 223 68 79 42 178 67 60 33 200 58 57 25 99 68 59 35 123 64 78 30 204 62 98 56 200 63...
Use the following data to develop a multiple regression model to predict from and . Discuss...
Use the following data to develop a multiple regression model to predict from and . Discuss the output, including comments about the overall strength of the model, the significance of the regression coefficients, and other indicators of model fit. y x1 x2 198 29 1.64 214 71 2.81 211 54 2.22 219 73 2.70 184 67 1.57 167 32 1.63 201 47 1.99 204 43 2.14 190 60 2.04 222 32 2.93 197 34 2.15 Appendix A Statistical Tables *(Round...
1. In the iris data, build a linear regression model to predict Sepal.Length based on both...
1. In the iris data, build a linear regression model to predict Sepal.Length based on both Petal.Length and Species. a. Calculate the regression equation, including the interaction. b. From this equation, you should be able to find 3 regression lines (one for each Species). Interpret each of the 3 slopes of the lines in the context of the problem. Remember that both numerical variables are measured in centimeters. c. Plot the 3 regression lines in a scatterplot of Sepal.Length vs....
When we estimate a linear multiple regression model (including a linear simple regression model), it appears...
When we estimate a linear multiple regression model (including a linear simple regression model), it appears that the calculation of the coefficient of determination, R2, for this model can be accomplished by using the squared sample correlation coefficient between the original values and the predicted values of the dependent variable of this model. Is this statement true? If yes, why? If not, why not? Please use either matrix algebra or algebra to support your reasoning.
1.Develop a multiple linear regression model to predict the price of a house using the square...
1.Develop a multiple linear regression model to predict the price of a house using the square feet of living area, number of bedrooms, and number of bathrooms as the predictor variables     Write the reqression equation.      Discuss the statistical significance of the model as a whole using the appropriate regression statistic at a 95% level of confidence. Discuss the statistical significance of the coefficient for each independent variable using the appropriate regression statistics at a 95% level of confidence....
1) A multiple regression model to predict nacho sales at a baseball game yields the following...
1) A multiple regression model to predict nacho sales at a baseball game yields the following coefficients: Intercept 1500 Home Team Score 80 Temp. (Degrees F) 100 Home Team Loss? -2000 Assuming that all variables in this model are significant, what would be the expected result of the home team scoring another run? A- There would be no effect B- Nacho sales would increase by 80 C- Nacho sales would decrease by 80 D- Not enough info 2) The regression...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT