Case Study – Indiana Real Estate: Statistical Methods of Business

Please review the following (3) PDFs for all the information and instructions related to the case study. Completed needs to have 10 PowerPoint slides and findings in excel document shown in the instructions and assignment examples.

1.Case Study Instructions and Rubric – GBA306 Stats II – Indiana Real Estate.pdf
2. Indiana Real Estate Data File.xlsx
3. Case Study PowerPoint Presentation Information.pdf

Case study Assignment
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.

POWERPOINT PRESENTATION INSTRUCTIONS
Each student will prepare a PowerPoint Slide presentation to present a thorough review
of your report on “Case Study Indiana Real Estate.” Students will be required to record
and deliver their presentation using Yuja, a lecture capture recording system provided
by Athens State University.
Requirements:
1. Review the Chapter 14 textbook material and solve for each of the problem
statements provided in the Case Study – Indiana Real Estate.
2. Your PowerPoint Presentation will consist of five (5) parts which will require formal
responses to each of the posed steps. Remember you are presenting to an
audience of your peers.
3. These steps will be followed by the student during the presentation.
o Introduction Title Slide: State your name, institution, the course, your
professor’s name, the case study title.
o Give a brief description of the background by providing an overview of the
case study.
o Present the type of statistical method used and why you chose it in order
to find a solution.
o Respond to the Case Study problem statements by evaluating, analyzing,
and interpreting your statistical analysis. Slides should be developed
to show how you solved the calculations. Here you would include your
Excel data analysis output.
o Summarize your findings in a conclusion. What should the real estate
agent report to the sellers and why?

Case Study – Indiana Real Estate: Statistical Methods of Business

We offer the best custom writing paper services. We have answered this question before and we can also do it for you.

GET STARTED TODAY AND GET A 20% DISCOUNT coupon code DISC20

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.