Develop a regression model to predict selling price

Assignment Help Basic Statistics
Reference no: EM13857444

1) The following data give the selling price, square footage, number of bedrooms, and age of houses that have sold in a neighborhood in the past 6 months. Develop three regression models (in excel) to predict the selling price based upon each of the other factors individually. Which of these is best?

SELLING PRICE ($)

SQUARE FOOTAGE

BEDROOMS

AGE (YEARS)

84,000

1,670

2

30

79,000

1,339

2

25

91,500

1,712

3

30

120,000

1,840

3

40

127,500

2,300

3

18

132,500

2,234

3

30

145,000

2,311

3

19

164,000

2,377

3

7

155,000

2,736

4

10

168,000

2,500

3

1

172,500

2,500

4

3

174,000

2,479

3

3

175,000

2,400

3

1

177,500

3,124

4

0

184,000

2,500

3

2

195,500

4,062

4

10

195,000

2,854

3

3

2) Use the data in Problem 1 and develop a regression model to predict selling price based on the square footage and number of bedrooms. Use this to predict the selling price of a 2,000-square-foot house with 3 bedrooms. Compare this model with the models in Problem 1. Should the number of bedrooms be included in the model? Why or why not?

Reference no: EM13857444

Questions Cloud

Internet-based learning poses communication challenges : The very nature of Internet-based learning poses communication challenges. What are some of the specific communication hurdles we have to clear in an online course? Are some barriers easier to overcome than others? Are there some we just can't do muc..
Complex contractual environments : When relation-ship specific exchange occurs in complex contractual environments, the best way to purchase inputs is through-
Facilitate moving team through stages of team development : Explain in detail and provide examples of the advantages and challenges of working in teams discussed in your reading that you experienced. How did your team learn as a group and move forward in the team-building process? What was your experience as ..
Compare the ordinary method of slices factor of safety : Analyze the slope problem that we did in class today using all 5 methods the software offers, using a standard 1.5 factor of safety.  Compare the results with the Ordinary Method of Slices Factor of Safety.
Develop a regression model to predict selling price : Use the data in Problem 1 and develop a regression model to predict selling price based on the square footage and number of bedrooms. Use this to predict the selling price of a 2,000-square-foot house with 3 bedrooms.
Testing a thesis making a historical argument : Testing a thesis, making a historical argument, using refutation
Create an accurate scatter plot of the data : Create an accurate scatter plot of the data. This can be done by hand or using a program like Excel. Use Height as the x variable and Arm Span as the y variable. Does this graph show a linear relationship between x and y?
Mean absolute percentage errors-tracking signal : Provide the quantitative formulas for the following and a simple, solved exaple demonstrating how -to Cumulative Sum of Forecast Error (CFE), Mean Absolute Percentage Errors (MAPE), Median Absolute Deviation (MAD).
Explain the importance of these elements for muslims : Describe significant differences and similarities in how the branches of Islam (Sunni, Shiite, and Sufi) practice their traditions.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Problem on forecasting models and types of data

There are different types of forecasting models that can be used in business research. Each model is suitable for a type of historical demand data. Some data may have a trend, may be without a trend, or may be seasonal.

  Is lack of sleep causing traffic fatalities a study

is lack of sleep causing traffic fatalities? a study conducted under the auspices of the national highway traffic

  The oshkosh school system

There were about 15 flu cases per week, this flu season, in the Oshkosh school system.

  Probability of choosing four randomly

Choose a group of 4 adults at random. What is the probability that none of them enjoy drinking beer?

  Sample size with confidence level-standard deviation

We want to estimate the population mean within 5, with a 99 percent level of confidence. The population standard deviation is estimated to be 15. How large a sample is required?

  Good estimation of the population mean

Use technology to find the estimated minium required sample size. The minimum sample size required is ? Computer users round to the nearest whole number. What is a major obstacle to getting a good estimate of the population mean?

  Probability that student is a united states citizen

A class contains 30 students. Ten are female (F) and U.S. citizens (U); 12 are male (M) and U.S. citizens; 6 are female and non-U.S. citizens (N); 2 are male and non U.S. citizens. A name is randomly selected from the class roster and it is female..

  The australian newspaper is read by 70 of coalition voters

suppose it is known that 45 of the population are coalition voters 45 are alp voters and 10 vote for greens. suppose it

  Determining evidence of difference in median performance

Is there evidence of difference in median performance between two methods? (Use α = 0.05.)

  Test claim that mean age of people in us is sixty year

Use α = 0.10 and assume that the population is normally distributed. Write a paragraph that interprets the test's decision.

  In a region 80 of the population have brown eyes if 13

in a region 80 of the population have brown eyes. if 13 people are randomly selected find the probability that at least

  Use linear regression to forecast values for periods 11 to

use linear regression to forecast values for periods 11 to 13 for the following time

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd