MAT 240 Project One
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
MAT240
Subject
Economics
Date
Feb 20, 2024
Type
docx
Pages
9
Uploaded by MinisterSwanMaster994
Median Housing Price Prediction Model for D. M. Pan National Real Estate Company
1
Report: Housing Price Prediction Model for D. M. Pan National Real Estate Company
Dianna Sheely
Southern New Hampshire University
Median Housing Price Model for D. M. Pan National Real Estate Company
2
Introduction
As D.M. Pan National Real Estate Company requested, this project aims to create a model to predict median housing prices for homes sold in 2019. This report aims to help D.M Pan National Real Estate Company associates better understand the correlation between the square footage and listing prices of homes and give them a tool to use to predict home prices more accurately based on square footage. Since we want to determine the strength of the square footage and listing prices, it is appropriate to use simple linear regression in this analysis. This report will contain charts and graphs to visualize the correlation between these variables, square footage, and housing prices, such as a scatterplot and a histogram. If our linear model is appropriate, the histogram should look normal, and the scatterplot of residuals should show random scatter. Our (x) variable will be “square feet” and (y) the “listing price” on our charts and graphs. We expect a straight line and a strong correlation between the two variables. We expect that as “square feet” increases that the “listing price” will also increase. Our scatterplot should show a positive slope unless we have strong outliers.
Our analysis will also include lines and equations that will be useful, such as the regression line (or predicted line), which can be used to estimate (or forecast) the response variable. Our Predictor variable (x) is "square feet," and our Response variable (y) is "listing price.” Again, we expect that as the square feet of a home increase, the listing price will also increase. This regression line will help us to determine, for each one-unit of growth in the Predictor variable (square feet), how much of an increase there will be in the Response variable (listing price).
Median Housing Price Model for D. M. Pan National Real Estate Company
3
Data Collection
The following data is a randomly collected sample of 50 counties in the United States, selected from 999 counties from the provided Real Estate County Data spreadsheet for 2019. The
sample was determined using the Excel random function (=RAND), sorting the data from the lowest to the highest randomly generated number and selecting the first 50. Using the predictor variable (x), Median Square Feet, and the response variable (y), Median Listing Price, the below scatterplot was created to test the theory that our variables are related and create a
linear model to predict median housing prices in 2019. - 1,000 2,000 3,000 4,000 5,000 6,000 $0
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
Scatterplot of y vs. x
Median Square Feet
Meidan Lising Price
Figure 1
Median Housing Price Model for D. M. Pan National Real Estate Company
4
Data Analysis
Our data set needs to meet certain conditions to determine whether linear regression exists. The chosen sample must represent the population; there should be a linear relationship between the independent and dependent variables, and the variables need to be normally distributed. We can check this by creating a histogram of the residuals. Figure 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Only typed Answer and give Answer fast
arrow_forward
the following data represents a set do demands that have occurred over the last several years at a soap making company. The data were collected on an annual basis.
Year
Actual Demand (At)
Forecast (Ft)
1
310
2
365
3
395
4
415
5
450
6
465
7
a) using the SIMPLE AVERAGE method to predict the demand for the 7th year
b) the SIMPLE MOVING AVERAGE method to predict the demand for the 7th year
arrow_forward
The problem is based on the following data given. Observations of the demand for a certain part stocked at a parts supply depot during the calendar year 2013 were ( as shown ).
Determine the one-step-ahead forecasts for the demand for January 2014 using 3‑, 6-, and 12-month moving averages.
arrow_forward
Question 9
Regression analysis was applied between demand for a product (Y) and the price of the product (X), and the
following estimated regression equation was obtained.
Y = 120 - 15 X
Based on the above estimated regression equation, if price is increased by 2 units, then demand is expected
to:
O Increase by 120 units
Decease by 30 units
O Increase by 2Q units
Next
« Previous
Submi
No new data to save. Last checked at 9:51pm
arrow_forward
Options are: 520, 510, 454, 596, 346
arrow_forward
Economics
arrow_forward
The Wall Street Journal’s website, www.wsj.com, reported the number of cars and light-duty trucks sold through October of 2014 and October of 2015. The top sixteen manufacturers are listed here. The sales information for all manufacturers can be accessed in a data file below. Sales data are often reported in this way to compare current sales to last year’s sales.
Year-to-Date Sales
Manufacturer
Through October 2015
Through October 2014
General Motors Corp.
2,562,840
2,434,707
Ford Motor Company
2,178,587
2,065,612
Toyota Motor Sales USA Inc.
2,071,446
1,975,368
Chrysler
1,814,268
1,687,313
American Honda Motor Co Inc.
1,320,217
1,281,777
Nissan North America Inc.
1,238,535
1,166,389
Hyundai Motor America
638,195
607,539
Kia Motors America Inc.
526,024
489,711
Subaru of America Inc.
480,331
418,497
Volkswagen of America Inc.
294,602
301,187
Mercedes-Benz
301,915
281,728
BMW of North America Inc.…
arrow_forward
I Consider the demand for trading cards listed below.
Month
Demand
Jan.
51,000
48,000
Feb.
March
55,000
April
May
58,000
66,000
June
69,000
80,000
July
Aug.
95,000
Use Excel to prepare a forecast for September, October, and November using linear regression Print
out the sheet of results, as well as a sheet containing the formulas that you used ( can be
used to toggle between displaying values and displaying formulas or you can click on
Formulas>Formula Auditing→Show Formulas.)
and for the cars is 16.000
arrow_forward
In your company (electrical goods manufacturing), you want to
forecast demand as well
of a particular range of Smart TVs. Its monthly sales
previous year, are presented in the table below:
Month Sales
January 400
February 650
March 1,150
April 1,700
May 500
June 900
July 1,150
August 1900
September 600
October 650
November 1,600
December 2050
Based on the above historical sales data:
A) Create the corresponding graph and comment on the demand
(sales) in terms of
in trend, seasonality and periodicity
please draw the diagram!!!!
arrow_forward
7 Suppose the following model describes the relationship between annual salary (salary) and the number
of previous years of labor market experience (exper):
log(salary) = 10.6 + .027 exper.
(i) What is salary when exper = 0? When exper = 5? (Hint: You will need to exponentiate.)
(ii) Use equation (A.28) to approximate the percentage increase in salary when exper increases by
five years.
(iii) Use the results of part (i) to compute the exact percentage difference in salary when exper = 5
and
еxper
= 0. Comment on how this compares with the approximation in part (ii).
arrow_forward
Subject: Manegerial Economics & Policy
The maker of a leading brand of low-calorie microwavable food estimated the following
demand equation for its product using data from 26 supermarkets around the country for
the month of April:
Q = -5,200 - 42P + 20PX + 5.2l + 0.20A + 0.25M
(2.002) (17.5) (6.2) (2.5) (0.09) (0.21)
R2 = 0.55 n = 26 F = 4.88
Assume the following values for the independent variables:
Q = Quantity sold per month
P (in cents) = Price of the product = 500
PX (in cents) = Price of leading competitor’s product = 600
I (in dollars) = Per capita income of the standard metropolitan statistical area (SMSA) in which the supermarket is located = 5,500
A (in dollars) = Monthly advertising expenditure = 10,000
M = Number of microwave ovens sold in the SMSA in which the supermarket is located = 5,000
Using this information, answer the following questions: (remaining parts)
Do you think that this firm should cut its price to increase its market share/revenue? Explain.
What…
arrow_forward
Student question
Time Left: 00:09:02
Food manufacturers in the small island nation of Autarka have complained that the cost of cardboard, used to produce
the packaging for their products, is too high. The food manufacturers claim that the price of cardboard in Autarka is
much higher than in other countries. They allege that cardboard manufacturers are colluding to raise the price in
Autarka. There are three firms that manufacture cardboard in Autarka: Arthur's Accoutrements, Boris' Boxes, and Carl
's Cartons. These firms contend that the relatively high prices in Autarka are due both to the small size of the market
and to the fact that cardboard is too expensive to import by air or sea. Cardboard is a homogeneous good produced to
industry standard specifications. The annual demand for cardboard in Autarka is given by the function, Q
= 10,000,000 1,000,000P, where Q is the quantity demanded of cardboard for a given year, measured in square
metres, and P is the price per square metre.…
arrow_forward
DQ1: Electric Vehicles and Battery Supply Chain
As the automotive industry shifts toward electric vehicles (EVs), there is growing attention on the supply chain for batteries, a crucial component. Explore the relationship between supply and demand in the context of electric vehicles:
How has the growing demand for electric vehicles impacted the demand for battery components? How have companies like Tesla and other automakers responded to this increased demand?
Discuss the concept of supply constraints in the battery industry. How do factors like access to raw materials, technological advancements, and production capacity influence the supply of batteries for electric vehicles?
DQ2:
Think about a product or service that has undergone a dramatic increase in popularity in recent years, such as electric vehicles (EVs) or streaming services. Discuss how changes in consumer preferences and technological advancements have influenced the demand for this product or service. How have…
arrow_forward
Sonia is planning to start a new designer cloth shop. Her problem is to decide how large her shop should be. The annual returns will depend on both the size of her shop and a number of marketing factors related to the current market conditions and demand for designer wear. After a careful analysis, Sonia came up with the following table:
Size of shop
good market (R.O)
fair market (R.O)
poor market (R.O)
Samll scale
1024
9765
-500
Medium scale
1500
3000
-2000
Large scale
2000
3000
-4000
Very large scale
3000
5000
-7000
a)what will be her decision based on Pessimist criteria?
b) what will be her decision based on Optimistic criteria?
c) what will be her decision based on Laplace criteria?
arrow_forward
Below is a table containing data on product demand for the most recent three months along with the
forecasts that had been made for those three previous months. Calculate the MSE.
Month Demand Forecast
1
308
310
388
390
344
342
23
arrow_forward
Ypsilanti Market Research conducted a survey to find out whether people who earn more money purchase more expensive goods. The following graph
indicates the relationship between income the survey subjects earned and the price of the home that they purchased.
PRICE (Thousands of dollars per home)
500
450
400
350
300
250
200
150
100
50
L
0
10
20 30 40 50 60
70
80
INCOME (Thousands of dollars per year)
90 100
arrow_forward
The monthly demand of a company is showed below, please use the static method to forecast the
demand for Year 6.
Sales Year 1 Year 2 Year 3 Year 4 Year 5
JAN 2,000 3,000 2,000 5,000 5,000
FEB 3,000 4,000 5,000 4,000 2,000
MAR 3,000 3,000 5,000 4,000 3,000
APR 3,000 5,000 3,000 2,000 2,000
MAY 4,000 5,000 4,000 5,000 7,000
JUN 6,000 8,000 6,000 7,000 6,000
JUL 7,000 3,000 7,000 10,000 8,000
AUG 6,000 8,000 10,000 14,000 10,000
SEP 10,000 12,000 15,000 16,000 20,000
OCT 12,000 12,000 15,000 16,000 20,000
NOV 14,000 16,000 18,000 20,000 22,000
DEC 8,000 10,000 8,000 12,000 8,000
Total 78,000 89,000 98,000 115,000 113,000
arrow_forward
Demand Factor
Average American household income
Roundtrip airfare from Des Moines (DSM) to Atlantic City (ACY)
Room rate at the Continental Hotel and Casino, which is near the Rivers
PRICE (Dollars per room)
Use the graph input tool to help you answer the following questions. You will not be graded on any changes you make to this graph.
Note: Once you enter a value in a white field, the graph and any corresponding amounts in each grey field will change accordingly.
500
450
400
350
300
250
200
150
100
50
0
0
Demand
50 100 150 200 250 300 350 400 450 500
QUANTITY (Hotel rooms)
Graph Input Tool
Market for Rivers's Hotel Rooms
Price
(Dollars per room)
Quantity
Demanded
(Hotel rooms per
night)
Demand Factors
Average Income
(Thousands of
dollars)
Initial Value
$50,000 per year
$200 per roundtrip
$250 per night
Airfare from DSM to
ACY
(Dollars per
roundtrip)
Room Rate at
Continental
(Dollars per night)
350
150
50
200
250
?
arrow_forward
Gg.40.
arrow_forward
A random sample of 100 households has been selected in order to establish a price
index for housing utilities. The following average annual figures have been obtained.
Housing
Utilities
2017
Electricity 1,97
Gas
7,90
0,29
2,40
Telephone
Water
Price(Rand/Unit)
2018
2,05
8,25
0,30
2,45
2019
2,09
8,60
0,31
2,50
2017
62
9
296
55
Quantities
2018
64
9
297
56
2019
68
10
298
58
.
a) Find the price relative for Electricity, using (2017= 100). Interpret.
b) Find the quantity relative for Water, using (2018= 100). Interpret.
c) Calculate the Laspeyre's price index for 2019, using 2017 = 100. What is the
percentage increase in 2019 price over those in 2017? Interpret.
d) Calculate the Paasche's price index for 2018, using 2017 = 100. What is the
percentage increase in 2018 price over those in 2017? Interpret.
e) By how much has this households utility in these four utilities changed between
2017 and 2019? Assume price are held constant at base year 2017.
arrow_forward
Hello! Can someone please help me discuss the topic Consumer Price Index?
I need to discuss its definition, formula, and sample computation/ problem. Can you please help me? I do not have any knowledge about the topic, since it is my first time hearing about it. Thank you! Your efforts are very much appreciated!
arrow_forward
5. Exercise 5.5
A firm experienced the demand shown in the following table.
Fill in the table by preparing forecasts based on a five-year moving average, a three-year moving
average, and exponential smoothing (w = 0.9
forecasts may be begun by assuming Y t+ F Yt •)
and w = 0.3 ). (Note: The exponential smoothing
Moving Average
Actual Demand (5-year) (3-year)
Exponential Smoothing
(W = 0.9)
Year
(W = 0.3)
2000
900
2001
885
900
900
2002
875
2003
870
887 ▼
2004
870
877 ▼
2005
875
880
872 Y
2006
885
875
872
2007
900
875
877
2008
920
880
887 -
2009
945
890
902 Y
2010
905
922
The following table shows the square errors,
(Y; - T1-) , for forecasts from 2005 through
2009.
Fill the table by calculating the root mean square error (RMSE) for each of the methods.
Square Error
Exponential Smoothing
Moving Average
Year (5-year) (3-year) (W = 0.9)
(W = 0.3)
2005
25
9
25
25
2006
100
169
100
36
2007
625
529
256
361
2008
1,600
1,089
484
1,089
2009
3,025
1,849
729
2,304
RMSE
Based on the RMSE criterion,…
arrow_forward
A printer manufacturer estimates that the average purchaser of a printer will also purchase six ink refills over the lifetime of the printer. The relevant data are: Printer: price: $400, margin: $100 Refills: price: $40, margin: $30 The manufacturer is considering increasing the price of printers by 10% to $440. What volume decrease in the sales of printers is the stay-even sales change for the firm? (Ignore the issue of discounting the value of future ink refill sales. Imagine, for example, that all six are purchased upfront with the printer).
A. 11.5%
B. 12.5%
C. 13.5%
D. 14.5%
Use = % Q = (Pold - Cold)/(Pnew - Cold) - 1
arrow_forward
Solve using Excel
arrow_forward
10
00
Interest Rate (%)
N
B Investment
Demand
0 $30 60 90 120 150
Investment ($)
Price Level
Multiple Choice
AS
Real GDP ($)
AD₁ (1=120)
AD₂ (1=90)
*AD3 (1=60)
Refer to the graphs, in which the numbers in parentheses near the AD₁, AD2, and AD3 labels indicate
the level of investment spending associated with each curve. All numbers are in billions of dollars.
The interest rate and the level of investment spending in the economy are at point D on the
investment demand curve. To achieve the long-run goal of a noninflationary, full-employment output
Qfin the economy, the Fed should try to
decrease aggregate demand by increasing the interest rate from 2 to 4 percent.
decrease aggregate demand by increasing the interest rate from 4 to 6 percent.
increase aggregate demand by decreasing the interest rate from 4 to 2 percent.
increase the level of investment spending from $120 billion to $150 billion.
arrow_forward
Please help answer all questions related to the screenshot.
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Case Studies
Economic Development Planner
You have just been hired as an economic development planner working for a businesswoman who builds large shopping stores and malls in cities. The company wants to build a regional shopping center in a nearby city that is surrounded by a large rural population. To help them conduct a feasibility study, please address the following questions.
1. What type of population-related decisions should be made to determine the best location for the shopping center? For example, is there a demand for new retail stores?
2. What type of population and related information would you need to collect to help determine the best location for the center?
3. What types of analysis would you perform with the information?
arrow_forward
Economics Help: Please see attached ( Just state one option from the drop downs )
arrow_forward
Hand written solutions are strictly prohibited.
arrow_forward
5. Among important factors that affecting the price of land lot are size, number of mature trees and
distance to the lake. Using data for 60 recently sold land lots are shown below:
B
1 SUMMARY OUTPUT
2
3.
Regression Statistics
4 Multiple R
5 R Square
6 Adjusted R Square
7 Standard Error
0.4924
0.2425
0.2019
40.24
8 Observations
60
9.
10 ANOVA
Significance F
5.97
11
df
S
MS
9676.6
0.0013
12 Regression
13 Residual
3
29,030
90,694
56
1619.5
14 Total
59
119,724
15
16
Coefficients Standard Error
t Stat
P-value
0.0331
0.2156
17 Intercept
51.39
23.52
2.19
18 Lot size
0.700
0.559
1.25
19 Trees
0.679
0.229
2.96
0.0045
20 Distance
-0.378
0.195
-1.94
0.0577
a) Write the regression equation
b) What is the standard error of estimate? Interpret its value.
c) What is the coefficient of determination? Interpret its value.
d) What is the adjusted coefficient of determination? Interpret its value.
e) Test the validity of the model.
f) Interpret each of the coefficients.
g) Test at 5% level of…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Related Questions
- Only typed Answer and give Answer fastarrow_forwardthe following data represents a set do demands that have occurred over the last several years at a soap making company. The data were collected on an annual basis. Year Actual Demand (At) Forecast (Ft) 1 310 2 365 3 395 4 415 5 450 6 465 7 a) using the SIMPLE AVERAGE method to predict the demand for the 7th year b) the SIMPLE MOVING AVERAGE method to predict the demand for the 7th yeararrow_forwardThe problem is based on the following data given. Observations of the demand for a certain part stocked at a parts supply depot during the calendar year 2013 were ( as shown ). Determine the one-step-ahead forecasts for the demand for January 2014 using 3‑, 6-, and 12-month moving averages.arrow_forward
- Question 9 Regression analysis was applied between demand for a product (Y) and the price of the product (X), and the following estimated regression equation was obtained. Y = 120 - 15 X Based on the above estimated regression equation, if price is increased by 2 units, then demand is expected to: O Increase by 120 units Decease by 30 units O Increase by 2Q units Next « Previous Submi No new data to save. Last checked at 9:51pmarrow_forwardOptions are: 520, 510, 454, 596, 346arrow_forwardEconomicsarrow_forward
- The Wall Street Journal’s website, www.wsj.com, reported the number of cars and light-duty trucks sold through October of 2014 and October of 2015. The top sixteen manufacturers are listed here. The sales information for all manufacturers can be accessed in a data file below. Sales data are often reported in this way to compare current sales to last year’s sales. Year-to-Date Sales Manufacturer Through October 2015 Through October 2014 General Motors Corp. 2,562,840 2,434,707 Ford Motor Company 2,178,587 2,065,612 Toyota Motor Sales USA Inc. 2,071,446 1,975,368 Chrysler 1,814,268 1,687,313 American Honda Motor Co Inc. 1,320,217 1,281,777 Nissan North America Inc. 1,238,535 1,166,389 Hyundai Motor America 638,195 607,539 Kia Motors America Inc. 526,024 489,711 Subaru of America Inc. 480,331 418,497 Volkswagen of America Inc. 294,602 301,187 Mercedes-Benz 301,915 281,728 BMW of North America Inc.…arrow_forwardI Consider the demand for trading cards listed below. Month Demand Jan. 51,000 48,000 Feb. March 55,000 April May 58,000 66,000 June 69,000 80,000 July Aug. 95,000 Use Excel to prepare a forecast for September, October, and November using linear regression Print out the sheet of results, as well as a sheet containing the formulas that you used ( can be used to toggle between displaying values and displaying formulas or you can click on Formulas>Formula Auditing→Show Formulas.) and for the cars is 16.000arrow_forwardIn your company (electrical goods manufacturing), you want to forecast demand as well of a particular range of Smart TVs. Its monthly sales previous year, are presented in the table below: Month Sales January 400 February 650 March 1,150 April 1,700 May 500 June 900 July 1,150 August 1900 September 600 October 650 November 1,600 December 2050 Based on the above historical sales data: A) Create the corresponding graph and comment on the demand (sales) in terms of in trend, seasonality and periodicity please draw the diagram!!!!arrow_forward
- 7 Suppose the following model describes the relationship between annual salary (salary) and the number of previous years of labor market experience (exper): log(salary) = 10.6 + .027 exper. (i) What is salary when exper = 0? When exper = 5? (Hint: You will need to exponentiate.) (ii) Use equation (A.28) to approximate the percentage increase in salary when exper increases by five years. (iii) Use the results of part (i) to compute the exact percentage difference in salary when exper = 5 and еxper = 0. Comment on how this compares with the approximation in part (ii).arrow_forwardSubject: Manegerial Economics & Policy The maker of a leading brand of low-calorie microwavable food estimated the following demand equation for its product using data from 26 supermarkets around the country for the month of April: Q = -5,200 - 42P + 20PX + 5.2l + 0.20A + 0.25M (2.002) (17.5) (6.2) (2.5) (0.09) (0.21) R2 = 0.55 n = 26 F = 4.88 Assume the following values for the independent variables: Q = Quantity sold per month P (in cents) = Price of the product = 500 PX (in cents) = Price of leading competitor’s product = 600 I (in dollars) = Per capita income of the standard metropolitan statistical area (SMSA) in which the supermarket is located = 5,500 A (in dollars) = Monthly advertising expenditure = 10,000 M = Number of microwave ovens sold in the SMSA in which the supermarket is located = 5,000 Using this information, answer the following questions: (remaining parts) Do you think that this firm should cut its price to increase its market share/revenue? Explain. What…arrow_forwardStudent question Time Left: 00:09:02 Food manufacturers in the small island nation of Autarka have complained that the cost of cardboard, used to produce the packaging for their products, is too high. The food manufacturers claim that the price of cardboard in Autarka is much higher than in other countries. They allege that cardboard manufacturers are colluding to raise the price in Autarka. There are three firms that manufacture cardboard in Autarka: Arthur's Accoutrements, Boris' Boxes, and Carl 's Cartons. These firms contend that the relatively high prices in Autarka are due both to the small size of the market and to the fact that cardboard is too expensive to import by air or sea. Cardboard is a homogeneous good produced to industry standard specifications. The annual demand for cardboard in Autarka is given by the function, Q = 10,000,000 1,000,000P, where Q is the quantity demanded of cardboard for a given year, measured in square metres, and P is the price per square metre.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Economics: Applications, Strategies an...EconomicsISBN:9781305506381Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. HarrisPublisher:Cengage Learning
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning