Please use template provided. You have been hired by the

Please use template provided.

You have been hired by the D. M. Pan National Real Estate Company to develop a model to predict housing prices for homes sold in 2019. The CEO of D. M. Pan wants to use this information to help their real estate agents better determine the use of square footage as a benchmark for listing prices on homes. Your task is to provide a report predicting the housing prices based square footage. To complete this task, use the provided real estate data set for all U.S. home sales as well as national descriptive statistics and graphs provided.

Directions

Using the Project One Template located in the What to Submit section, generate a report including your tables and graphs to determine if the square footage of a house is a good indicator for what the listing price should be. Reference the National Statistics and Graphs document for national comparisons and the Real Estate Data spreadsheet (both found in the Supporting Materials section) for your statistical analysis.

Note: Present your data in a clearly labeled table and using clearly labeled graphs.

Specifically, include the following in your report:

Introduction

  1. Describe the report: Give a brief description of the purpose of your report.
    1. Define the question your report is trying to answer.
    2. Explain when using linear regression is most appropriate.
      1. When using linear regression, what would you expect the scatterplot to look like?
    3. Explain the difference between response and predictor variables in a linear regression to justify the selection of variables.

Data Collection

  1. Sampling the data: Select a random sample of 50 houses.
    1. Identify your response and predictor variables.
  2. Scatterplot: Create a scatterplot of your response and predictor variables to ensure they are appropriate for developing a linear model.

Data Analysis

  1. Histogram: For your two variables, create histograms.
  2. Summary statistics: For your two variables, create a table to show the mean, median, and standard deviation.
  3. Interpret the graphs and statistics:
    1. Based on your graphs and sample statistics, interpret the center, spread, shape, and any unusual characteristic (outliers, gaps, etc.) for the two variables.
    2. Compare and contrast the shape, center, spread, and any unusual characteristic for your sample of house sales with the national population. Is your sample representative of national housing market sales?

Develop Your Regression Model

  1. Scatterplot: Provide a graph of the scatterplot of the data with a line of best fit.
    1. Explain if a regression model is appropriate to develop based on your scatterplot.
  2. Discuss associations: Based on the scatterplot, discuss the association (direction, strength, form) in the context of your model.
    1. Identify any possible outliers or influential points and discuss their effect on the correlation.
    2. Discuss keeping or removing outlier data points and what impact your decision would have on your model.
  3. Find r: Find the correlation coefficient (r).
    1. Explain how the r value you calculated supports what you noticed in your scatterplot.

Determine the Line of Best Fit. Clearly define your variables. Find and interpret the regression equation. Assess the strength of the model.

  1. Regression equation: Write the regression equation (i.e., line of best fit) and clearly define your variables.
  2. Interpret regression equation: Interpret the slope and intercept in context.
  3. Strength of the equation: Provide and interpret R-squared.
    1. Determine the strength of the linear regression equation you developed.
  4. Use regression equation to make predictions: Use your regression equation to predict how much you should list your home for based on the square footage of your home.

Conclusions

  1. Summarize findings: In one paragraph, summarize your findings in clear and concise plain language for the CEO to understand. Summarize your results.
    1. Did you see the results you expected, or was anything different from your expectations or experiences?
      1. What changes could support different results, or help to solve a different problem?
      2. Provide at least one question that would be interesting for follow-up research.

You can use the following tutorial that is specifically about this assignment. Make sure to check the assignment prompt for specific numbers used for national statistics. The videos may use different national statistics. You should use the national statistics posted with this assignment.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

For your response posts to your peers, choose two different

For your response posts to your peers, choose two different confidence intervals for your responses. Do you think the agents would prefer a different confidence interval than their management? What advantages and disadvantages would there be in having different confidence intervals for the agents? Explain your thought process and reasoning

Overview In this assignment, you will evaluate a current organizational

  Overview In this assignment, you will evaluate a current organizational structure and recommend structural changes that can help address the concerns the organization identified regarding collaboration, communication, and autonomy. Scenario You work for an organization that has traditionally been very formalized, and managers have had a very broad span

Rhetoric, Argumentation, & Multi-modal Communication

Rhetoric, Argumentation, & Multi-modal Communication Guiding Prompts: You do not need to answer all of the following questions, select those you find useful. -What have you learned about argumentation and persuasion through the process of generating two multi-modal compositions? -Explain how creating a multi-modal composition helped you to articulate your

a 700- to 1,050-w0rd pap3r analyzing your responses from the

a 700- to 1,050-w0rd pap3r analyzing your responses from the Adlerian Lifestyle Assessment. Consider the following questions: Family Constellation: What did you notice about birth order, sibling descriptions, and parental figures? Describe any observations you made about family values or the environment. What stands out the most about your role

Parts 1, 2, 3 and 4 have the same questions.

Parts 1, 2, 3 and 4 have the same questions. However, you must answer with references and different writing, always addressing them objectively, as if you were different students. Similar responses in wording or references will not be accepted. Parts 5, 6, 7 and 8 have the same questions. However,

For this assignment, take on the role of principal at

  For this assignment, take on the role of principal at the school of your choice. Plan a morning of activities that you could implement to welcome your six new teachers before the school year starts. Create an agenda that includes a combination of presentations and activities that introduce new

Assignment: Assessing and Diagnosing Patients With Anxiety Disorders, PTSD, and

   Assignment: Assessing and Diagnosing Patients With Anxiety Disorders, PTSD, and OCD “Fear,” according to the DSM-5-TR, “is the emotional response to real or perceived imminent threat, whereas anxiety is anticipation of future threat” (APA, 2022). All anxiety disorders contain some degree of fear or anxiety symptoms (often in combination

Discussion Forum: Social Class Bias? No unread replies. No replies.

Discussion Forum: Social Class Bias? No unread replies. No replies. Consider the following: video segment (Links to an external site.)Discuss what you consider the most valid and legitimate points made in the segment as well as any points you feel are not valid or legitimate.  Explain your reasoning.  Also, consider the

I submitted a final paper for my business and technical

I submitted a final paper for my business and technical writing class but I scored too low for passing. The instructor left me feedback on the paper and I need help fixing it so it can be passing. I have attached the assignment I submitted with the teachers comments on

Health and Medical Discussion Questions Nursing Assignment Help

1- Kinesio tape – what’s up with that? – Kinesiology tape has been around for more than 4 decades, but its use has grown since the 2008 Beijing Olympics, perhaps thanks to its application to American beach volleyball athletes utilizing the tape. What do the several manufacturers of this tape

BUSM077: HRM in the Public Services Short-Essay Questions

The short-essay accounts for 30% of your final mark and is based on a 1,500 words report. Please submit your essays via the special link created in QMPlus. Please find below the essay questions. Please refer to the assessment criteria on QMplus. Happy writing!   Question 1.      Police Scotland are

Develop a strategic plan for Procter and Gamble and share

Develop a strategic plan for Procter and Gamble and share it with stakeholders. Create a 10 slide presentation with Speaker Notes for key stakeholders to solicit their approval of the strategic plan. Address the following in your presentation:  An introduction with mission and vision statements Core values, ethics, and social

Two general technology trends in my workplace are that EHRs

Two general technology trends in my workplace are that EHRs and the use of technology are getting increasingly ingrained in the workflow, with increasingly complex technology. And also that my clients are utilizing apps and their smartphones as part of their care.   I recently changed agencies and went from an

Healthy People 2020 identifies objectives related to exercise and fitness.

 Healthy People 2020 identifies objectives related to exercise and fitness. Identify ways the nurse practitioner can promote healthy lifestyles and improved exercise compliance of their patients. What technologies are available that can assist patients and providers?    Length: A minimum of 280 words, not including references Citations: At least one

376 solve 1 Nursing Assignment Help

Expert Solution Preview Introduction: As a medical professor in charge of creating college assignments and evaluating student performance, it is crucial to provide accurate and comprehensive answers to content-related questions. In this case, the content revolves around unknown information, so I will offer detailed insights without disclosing the identity of

Sage bookkeeping programming is a fantastic bookkeeping answer for overseeing

   Sage bookkeeping programming is a fantastic bookkeeping answer for overseeing business finance. The arrangement accompanies astounding elements to assist clients with effectively dealing with their business record and lift business efficiency. In spite of the fact that it is integrated with fantastic elements Sage programming can in any case

Selected questions you feel strongly about Question #7: Before entering

 Selected questions you feel strongly about Question #7: Before entering therapy, clients should be made aware of the purposes, goals, techniques, policies, and procedures involved.  Answer: I strongly agree with this statement Explain answer. Include the question, your answer, and why you decided what you did. Cite specific areas of