Question

In: Math

MBA 6300 Case Study No. 2 There are numerous variables that are believed to be predictors...

MBA 6300 Case Study No. 2

There are numerous variables that are believed to be predictors of housing prices, including living area (square feet), number of bedrooms, and number of bathrooms. The data in the Case Study No. 2.xlsx file pertains to a random sample of houses located in a particular geographic area.

  1. Develop the following simple linear regression models to predict the sale price of a house based upon a 90% level of confidence. Write the regression equation for each model.
    1. Sale price based upon square feet of living area.
    2. Sale price based upon number of bedrooms.
    3. Sale price based upon number of bathrooms.
  2. Develop the following multiple linear regression models to predict the sale price of a house based upon a 90% level of confidence. Write the regression equation for each model.
    1. Sale price based upon square feet of living area and number of bedrooms.
    2. Sale price based upon square feet of living area and number of bathrooms.
    3. Sale price based upon number of bedrooms and number of bathrooms.
    4. Sale price based upon square feet of living area, number of bedrooms, and number of bathrooms.
  3. Discuss the joint statistical significance of each of the preceding simple and multiple linear regression models at a 90% level of confidence and 95% level of confidence.
  4. Discuss the individual statistical significance of the coefficient for each independent variable for each of the preceding simple and multiple linear regression models at a 90% level of confidence and 95% level of confidence.
  5. Compare any of the preceding simple and multiple linear regression models that were found to be jointly and individually statistically significant at a 90% level of confidence and select the preferred regression model. Explain your selection using the appropriate regression statistics.
  6. Interpret the coefficient for each independent variable (or variables) associated with your selected preferred regression model.
  7. Using the preferred regression model, predict the sale price of a house with the following values for the independent variables: 3,000 square feet of living area, 3 bedrooms, and 2.5 bathrooms. (Hint: You should only use the values for those independent variables that are specifically associated with your selected preferred regression model.)

Prepare a single Microsoft Excel file using a separate worksheet for each question and upload your Excel file.

The system will not let me post all of the data needed to answer the question... it says that it is too long . could you save this information so i can add the data ?

Solutions

Expert Solution

Since we are asked to use excel , we should have the data analysis tool which can be added in add-in

1)Now in data analysis select regression and enter sales price data in input y range and the confidence level as .90

2)First enter the living room area in input x range and select output range and click continue

The regression equation is of the form Y = a+bX , where a is the coefficient value of constant and b is the coefficient value of living area size .

Now repeat step 1 and in step 2 , replace ling room size by the number of bedrooms and write down the regression equation from the output

For the third one repeat the same with number of bathrooms in x range and write the corresponding equation

From the three outputs , the independent variable is insignificant when the p value of the corresponding regression coefficient is less than level of significance (.1)

Now for the multiple regression model , everything remains the same and the input range is being added with a comma with living area and number of bedrooms , living room area and number of bathrooms , number of bedrooms and number of bathrooms and finally all the three independent variables and right the corresponding models from the output and the interpretation is given based on the p value of regression coefficient .

When the level of significance is reduced there is a greater chance of getting the more significant models because many will be eliminated when the p value is greater than .05

For predicting the sales price , choose the model for which there is atleast one significant independent variable and if there are many models having significant independent variables , select the model with the largest R2 value

Substitute the necessary values in the selected model and get the predicted sales price

If still any doubts , copy the data and paste the entire data in table format in the comment section so that I can help you out


Related Solutions

There are numerous variables that are believed to be predictors of housing prices, including living area...
There are numerous variables that are believed to be predictors of housing prices, including living area (square feet), number of bedrooms, and number of bathrooms. The data in the Case Study No. 2.xlsx file pertains to a random sample of houses located in a particular geographic area. Develop the following simple linear regression models to predict the sale price of a house based upon a 90% level of confidence. Write the regression equation for each model. Sale price based upon...
Case study: The problem of the case , a company that specialized in researching in numerous...
Case study: The problem of the case , a company that specialized in researching in numerous of blood tests and plasma substitutes for surgical procedures. The company have over 10 labs in Canada, including Vancouver and the head offices in Calgary. Ed Worthy joined Techno Greats ten years ago as a researcher after he graduated from college. After three years working for the company, he got promoted to be a Lab Supervisor before he transferred to Calgary to be the...
CASE STUDY 2: Correlation and Regression are investigating the relationship between two continuous variables such as...
CASE STUDY 2: Correlation and Regression are investigating the relationship between two continuous variables such as height and weight, time and speed or the concentration of an injected drug and heart rate. a) In your opinion, discuss the importance of Correlation and Regression as a tools for analysis purposes. b) Find any correlation and regression that have been applied in business from the online platform. From the data you required to: i. State the Independent and Dependent Variable ii. Draw...
Are any variables not useful predictors of home price at a significance level of α =...
Are any variables not useful predictors of home price at a significance level of α = 0.05? State the P-values of these variables. Intuitively, what does this mean with respect to pricing properties? (Show your results)                                                    (8 Points) df SS MS F Significance F Regression 8 4.6E+12 5.75E+11 65.04884 7.3335E-50 Residual 186 1.64E+12 8.84E+09 Total 194 6.25E+12 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 184455.9 44755.82 4.121383 5.67E-05 96161.5757 272750.1 96161.58...
1. You have a number of variables -- a response variable and some proposed predictors. A...
1. You have a number of variables -- a response variable and some proposed predictors. A correlation matrix may help to give an idea of the strength of the linear relationships present. For the purposes of regression analysis, what would be desirable in terms of … a) …the observed correlation between each proposed predictor and the response variable? (2) b) …the observed correlations among the predictors themselves? (2) 2. Explain the fact that, over the course of a year, the...
Case Study Louise Simms, newly graduated with a master of business administration (MBA) degree, was hired...
Case Study Louise Simms, newly graduated with a master of business administration (MBA) degree, was hired by a prestigious multinational firm based in the United States. With minimal training, she was sent to join a company partner to negotiate with a high- ranking Middle Eastern government official. The partner informed Simms that he would introduce her to the government contact and then leave her to “get the job done.” Her assignment was to “do whatever it takes to win the...
The following case study (Rinehart?Thompson) at hypothetical St. John Hospital illustrates numerous issues that the HIPAA...
The following case study (Rinehart?Thompson) at hypothetical St. John Hospital illustrates numerous issues that the HIPAA privacy rule presents and which HIPAA?covered entities must address on a daily basis. As you conclude Chapter 9 and the HIPAA privacy rule requirements, use this case study to identify the issue(s) presented on each date, determining how each situation should be handled in order to comply with the HIPAA privacy rule. From May 26?30, Mary Jones was hospitalized in St. John Hospital, located...
The following case study (Rinehart-Thompson) at hypothetical St. John Hospital illustrates numerous issues that the HIPAA...
The following case study (Rinehart-Thompson) at hypothetical St. John Hospital illustrates numerous issues that the HIPAA privacy rule presents and which HIPAA-covered entities must address on a daily basis. As you conclude chapter 10, use this case study to identify the issue(s) presented on each date, determining how each situation should be handled in order to comply with the HIPAA privacy rule. Background: From May 26-30, Mary Jones was hospitalized in St. John Hospital, located in Johnson County, for Type...
In a multi linear regression case study, the dependent variable is house_value, the independent variables are...
In a multi linear regression case study, the dependent variable is house_value, the independent variables are house_age, crime_rate, tax_rate, trying to build a model to predict the house value, how to state model assumptions? What's the assumption in this case? Thanks!
1. Identify the explanatory and response variables in your study. 2. Explain why the study is...
1. Identify the explanatory and response variables in your study. 2. Explain why the study is an observational study or an experiment. 3. Can we conclude that there is a causal relationship between the explanatory and response variables? This is the Study: https://www.sciencedaily.com/releases/2018/10/181009210738.htm Planned intermittent fasting may help to reverse type 2 diabetes, suggest doctors writing in the journal BMJ Case Reports after three patients in their care, who did this, were able to cut out the need for insulin...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT