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

  Singer suggests that although the right to sell blood does

singer suggests that although the right to sell blood does not threaten the formal right to give blood it is

  Probability that person will fall in book keeping category

One person's file is chosen at random. Find out probability that selected person will fall into following categories. Book keeping.

  Find probability that mean contents of a six-pack are less

If the contents in the population of all cans follow a normal distribution, what is the probability that the mean contents of a six-pack are less than 12 oz?

  Sample proportion of a sample size

A sample proportion is calculated from a sample size of 394. How large of a sample would we need in order to decrease the standard error by a factor of 9?

  Suppose we watch the price of the dow jones industrial

suppose we watch the price of the dow jones industrial index for three days.assume there is a 6040 chance that the

  A student in a laboratory course on quality control methods

a student in a laboratory course on quality control methods measures the length of a bolt several times. when would it

  Let x and y be independent exponential random variables

let x and y be independent exponential random variables with respective parameters 2 and 3. find the cdf and density of

  Is promotion worth it if the tickets cost a given value

SmartMinds University is running a promotional raffle that offers a chance to win either a 1-year discount on tuition cost (which results in a $500 savings) or a 2-year discount on bookstore purchases. Is this promotion worth it if the tickets cost..

  A company wished to study the effectiveness of a coffee

a company wished to study the effectiveness of a coffee break on productivity of its workers. the productiveness of

  Linear programming-island water sports

Island Water Sports is a business that provides rental equipment and instruction for a variety of water sports in a resort town. On one particular morning, a decision must be made of how many Wildlife Raft Trips and how many Group Sailing Lessons ..

  The train company wants to state that waiting times in

question trains arrive at a station at the rate of 25 per hour.a what is the probability that the time between trains

  Distribution of amounts purchasing normal distribution

The mean amount purchased by a typical customer at Churchill's Grocery Store is $23.50 with a standard deviation of $5.00. Assume the distribution of amounts purchased follows the normal distribution. For a sample of 50 customers, answer the follo..

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