GBA 306 Statistical Methods of Business II – Case Study – Indiana Real Estate Ann Perkins, a realtor in Brownsburg, Indiana, would like to use estimates from a multiple regression model to help...

This assignment needs to be done in excel and then presented into a power point presentation


GBA 306 Statistical Methods of Business II – Case Study – Indiana Real Estate Ann Perkins, a realtor in Brownsburg, Indiana, would like to use estimates from a multiple regression model to help prospective sellers determine a reasonable asking price for their homes. She believes that the following four factors influence the asking price (Price) of a house: 1) The square footage of the house (SQFT) 2) The number of bedrooms (Bed) 3) The number of bathrooms (Bath) 4) The lot size (LTSZ) in acres She randomly collects online listings for 50 single-family homes. The data file is in the Blackboard “Case Study Indiana Real Estate Data File Excel” within the Case Study folder. Requirements and associated point values: Part 1 – Provide summary statistics (with Excel Data Analysis) by calculating the mean and standard deviation on the asking price, square footage, the number of bedrooms, the number of bathrooms, and the lot size. Explain each factor’s mean and standard deviation. What does each of these summary statistics tell us. A total of ten calculations 4 points each for a total of 40 points. Part 2 – Estimate and interpret a multiple regression model where the asking price is the response variable and the other four factors are the explanatory variables. The end result should be a Excel Regression Output SUMMARY OUTPUT Regression Statistics Multiple R R Square Adj. R Square Standard Error Observations ANOVA Df SS MS F Significance F Regression Residual Total Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept SQFT Bed Bath LTSZ Also provide the estimate model equation: Price = A total of 40 points will be assigned to Part 2. Part 3 – Interpret the resulting coefficient of determination. A total of 20 points will be assigned to Part 3. Part 4 – Write your findings in thorough, concise, and well-written report form. For an example review and refer to other reports throughout your textbook. There is at least one at the end of each chapter. Please note you are expected to use proper statistical terminology when appropriate but remember you are writing for a group who may not be as knowledgeable about statistics as you are. You must be sure they can understand your findings while also writing a professional report. A total of 50 points will be assigned to Part 4. Part 5 – Prepare your report in a PowerPoint Presentation and record your presentation within Relay according to the instructions provided in the Blackboard “PowerPoint Presentation Case Study Information” located within the Case Study folder. A total of 50 points will be assigned to Part 5. The submission link to attach your Case Study Report, PowerPoint Presentation and Excel Data Output Worksheet is in the same Case Study folder. You will record your PowerPoint Presentation under “Student Recordings” within Knowmia (formerly Relay). Refer to the course schedule for the Case Study due date. The case study is valued at a total of 200 points. Indiana_RealEstate PriceSQFTBedBathLTSZ 3999005.02644.50.3 3750003.2435 3720003.22535 3700004.927440.3 3250003.904331 3250002.64432.55 3195005.31832.52.5 3129003.14442.50.3 2999002.8435 2949003.80443.50.2 2690003.312531 2500003.37353.50.2 2499003.4622.50.6 2449943.19542.50.2 2449002.914330.3 2399002.881450.3 2349001.772323.6 2340002.24832.50.3 2299003.1252.50.2 2199002.94242.50.2 2099003.33242.50.2 2098503.40732.50.3 2069002.092320.3 2000003.859420.2 1949003.32642.50.1 1849001.874320.5 1799001.89231.50.7 1795002.542.50.5 1650002.43542.50.4 1599002.71432.50.2 1599001.8532.50.5 1550003.06843.50.2 1549002.48442.50.3 1520001.529420.4 1499002.87642.50.2 1485002.21142.50.1 1469001.571320.2 1455001.503420.5 1449001.656320.5 1449001.521320.6 1399001.315320.2 1379001.706320.3 1329002.12142.50.1 1299001.306320.5 1297361.402320.5 1250001.325320.3 1195001.234320.2 1103871.292310.2 1066991.3631.50.1 1029001.938310.1