MAT 240 Project One Template
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
MAT240
Subject
Economics
Date
Apr 3, 2024
Type
docx
Pages
7
Uploaded by AmbassadorPencil13245
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
Shaterria Johnson
Southern New Hampshire University
Median Housing Price Model for D. M. Pan National Real Estate Company
2
Introduction
I have been hired by D.M. Pan National Real Estate Company to provide a report to see if the housing prices based on square footage are appropriate. This will help real estate agents determine if square footage should be a benchmark for home listing prices.
Using Linear regression is only appropriate if the relationship between the predictor variable (square footage) and the response variable(housing listing price) is linear.
The response variable must be a continuous numeric variable.
When using linear regression, I would expect the scatterplot to look like an upward continuous positive slope. The response variable is a random variable, while the predictor variable is assumed to be non-
random or fixed and measured without error. The relationship between the response and predictor variables must be linear, given by the model y ^ = b 0 + b 1 x2.
Data Collection
I selected a random sample of 50 by first using the Excel function on the data spreadsheet =rand() for all houses listed. After successfully randomizing the houses, I sorted the list from smallest to largest and chose the first 50 houses listed.
My predictor variable is the median square foot of the house and my response variable is the housing listing price.
Median Housing Price Model for D. M. Pan National Real Estate Company
3
- 1,000 2,000 3,000 4,000 5,000 6,000 - 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 900,000 Real Estate County Data 2019
Random Sample
Square footage
Median House listing price
Data Analysis
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
The following table indicates the unit prices (in Rands) and quantities of three goods held in the national warehouse of a DIY (“do it yourself”) store for the years 2020 and 2021. Item 2020 2021 Unit Price (p0) Quantity (q0)) Unit Price (p1) Quantity (q1) Mineral spirits R23.70 30 R27.70 45 10mm spanner R49.00 60 R65.00 50 25mm brush R58.00 30 R63.00 40 Q.8.1 Using 2020 as the base year, compute the price relatives in 2021 for the 10mm spanner and the 25mm brush. Interpret your answers. (8) Q.8.2 Again, using 2020 as the base year, compute the Paasche price index for all of the items for 2021. Interpret your answer.
arrow_forward
The table below is extracted from Goodland Republic Bureau of Statistics records for
2016 -2017. Use the information to answer the questions that follow.
Goodland Economy 2013 and 2018
I tem
Price 2017 (Base year) Price 2018
Price per
Price per
Unit ($) | Production
55,000
98,000
45,000 2,450.00
110,000
6.000 7,000.00
Unit ($)
Production
50,000
100,000
50,000 23,000.00
120,000
5,000
Rice ( tons)
Wheat (tons)
Tractors mid-size (units)
Cotton (tons)
Used cars
Manufacture garments
( tons)
Eggs (Trays)
Соса Cola (litres)
Pepsi Cola (litres)
Beef (tons)
Second hand cloths (tons)
Alcoholic Beverages (litres)
Milk (litres)
1.50
2.00
2.00
2.50
100.00
120.00
5,000.00
50.00
150,000
2,000
6,000
700
145,000
2,300
6,500
70.00
2.50
3.50
0.80
1.20
1.50
1.10
850
5,000
500
500
4,800
450
600
6.50
8.50
15.00
25.00
3.25
3.75
7,000
2.30
7,500
2.50
Examine the status of the economic welfare in Goodland Republic in 2018 based on
your GDP deflator, nominal GDP and Real GDP. Also, explain the reasons why it is…
arrow_forward
A company produces and sells a consumer product and is able to control the demand by varying the selling price. The
approximate relationship between price and demand is
2700
5000
p = 38 +
(for D>1)
D²
The company is seeking to maximize its profit. The fixed cost is $1,000 and the variable cost is $ 40 per unit. What is
the number of units and total amount that should be produced and sold each month to maximize profit?
arrow_forward
If the company does not change its current supply chain, what will its distributioncosts be for the following quarter?
arrow_forward
WHERE IS THE CHART COMING FROM I AM CONFUSED? FC=1200?
PLEASE EXPLAIN CHART USED AC=FC/Q-VC
(600x3.1) - (500x3.5)
110
=---
= 11
600-500
100
3.10= UC/600-11
3.50=UC/500-110
FC=1200 EURO
FC=1200 EURO
AC=UC/Q-VC
UC=UNIT COST
arrow_forward
Based on the following data for Al-Aqsa Company: (5 Marks)
- Price = $10
- Average total cost = $6
- number of units produced = 1000 unit
Calculate
Profit per unit
Total profit
arrow_forward
Complete the following table by calculating the contribution to profit and overhead for each of the 10 time periods and prices.
Time Period
Price
Quantity Sold
Total Contribution
($)
(Million)
($ Million)
1
2,400
0.2
2
2,200
0.2
3
2,000
0.2
4
1,800
0.2
5
1,700
0.2
6
1,600
0.2
7
1,500
0.2
8
1,400
0.2
9
1,300
0.2
10
1,200
0.2
Over the 10 periods, the total contribution to profits and fixed costs from price skimming is
million.
arrow_forward
Mustang Mobile charges $15 for each tetrabyte of data used on its smartphone plans. Use this information to create a table showing the charges for data based on the number of tetrabytes used.
arrow_forward
Complete the inventory table by calculating the total cost of purchases, the goods available for sale, the cost of the goods available for sale, and the
ending inventory.
Date of purchase
Beginning inventory
Units
Cost per
purchased unit
41
$830
Total cost
Retail price Total retail
per unit
value
$975
arrow_forward
FG Manufacturers wants to determine the effectiveness of their pricing decisions for their product Lylo. As a consultant, you have been asked to develop cost functions that will assist in arriving at the optimal price that will enable the company to maximize profits. During the year, you were provided with the following demand and costs functions for the product:
P = 400 – 6Q; where P is the unit selling price and Q is quantity in thousands of units.
TC = 8Q2 + 36Q + 150; where TC is total cost in thousands of dollars.
Determine the optimal sales revenue.
Calculate the maximum profit.
Briefly outline two (2) factors to be considered by managementswhen pricing decisions are being made.
arrow_forward
Jadual 1 menurnfukkan beberapa data harga dan kuantiti untuk sebuah ekonomi zederhana
jang menghasilkan darang dan perkhidmatan derikut.)
Table 1: Price and quantity for three types of product
[Jadual I: Harga dan kuantiti sontuk tiga jenis produk)
Product
[Produk)
Year 2019
[Tahun 20191
Price
(RM)
[Harga
(RM)
1.25
Year 2017
Year 2018
[Tahun 20181
Price
(RM) Kuanti) (RM) Kuanttij
[Harga
(RAM))
1
[Tahun 2017)
Quantity
Quantity
Kuantitij
Price
Quantity
[Harga
(RM))
A
180
200
200
B
90
75
90
100
100
120
0.6
675
0.5
600
0.5
630
(1)
Compute the values of nominal GDP in 2017, 2018 and 2019.
[Kirakan nilai-nilai KDNK nominal pada 2017, 2016 dan 2019)
(6 Marks/ Markah)
Compute the values of real GDP and GDP deflator in 2018 and 2019
(using 2017 as the base year).
[Kirakan nilai-nilat KDNK zebenar dan KDNK pendeflari pada 2018 dan 2019
(menggunakan tahun azas 2017))
(5 Marks/ Markak)
(iii) Compute the percentage change in the real GDP in 2018 and 2019
from the preceding year.
(Kinatan nerat…
arrow_forward
analysis of the data indicated that the demand curve for x product is estimated to be linear and given by equation Qd = 150-3P and the supply curve for x product appears to be linear as well and is estimated as Qs=P-10. Graphically draw these two curves, labeling all relevant looking (such as intercepts for each line) on the horizontal and vertical axes
arrow_forward
Suppose that the graph illustrates the market demand for soda per month with an equilibrium price of $3.00 and equilibrium
quantity of 4,000 sodas. Please indicate on the graph the effects of excess inventories that lower the price by $2 and place point
A at the new equilibrium.
Price (5)
6.0
5.0
4.0
3.0
2.0
1.0
0.0
O
3.0
4.
N
Demand
4,0
5
4
Quantity (thousands)
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
help
arrow_forward
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year’s operations (revenues and costs in thousands of dollars).
Store Revenues Costs
101 $4,120 $4,244
102 2,247 2,934
103 5,768 5,211
104 4,022 4,048
105 2,944 3,736
106 4,063 3,389
107 6,914 5,059
108 1,809 2,474
109 5,516 4,768
110…
arrow_forward
Uncertain and do not know how to solve
arrow_forward
Consider the housing construction industry. Assume that the industry is perfectly competitive in both input and output markets. Suppose that, through
collective bargaining, a labor union negotiates an industry-wide wage for various kinds of labor (electricians, plumbers, and so on). In particular, it
succeeds in negotiating a wage increase for carpenters from $15 to $20 per hour.
The following graph shows the labor demand of an individual firm.
On the following graph, show what happens at the firm level as a result of the union negotiations.
WAGE RATE (Dollars per hour)
30
25
20
15
10
5
0
0
20
40
60
80
Demand
Supply
100
120
QUANTITY OF LABOR (Number of workers)
Now consider the effects of the wage change on the entire industry.
Demand
Supply
?
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…
arrow_forward
Exercise2:
A company makes iron benches and wants to determine the break-even point. The total fixed
cost for the business is $60,000 and the variable cost is $40 per bench. It sells the bench for $100
per unit.
Determine the BEP and construct a graph.
arrow_forward
Bell Greenhouses has estimated its monthly demand for potting soil to be the following:
Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years:
MONTH
ADJUSTMENT FACTOR (%)
March
+2
June
+15
August
+10
December
−12
a.
Forecast Bell Greenhouses’ demand for potting soil in March, June, August, and December 2007.
Answer
b.
If the following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years, determine the seasonal adjustment factor to be used in making an April 2008 forecast.
YEAR
FORECAST
ACTUAL
2007
500
515
2006
452
438
2005
404
420
2004
356
380
2003
308
320
arrow_forward
Need graphs, as well as the following:
arrow_forward
The Retread Tire Company recaps tires. The fixed annual cost of the recapping operation is $60,000. The variable cost of recapping a tire is $9. The company charges $25 to recap a tire.
For an annual volume of 12,000 tires, determine the total cost, total revenue, and profit.
Determine the annual break-even volume for the Retread Tire Company operation.
Graphically illustrate the break-even point using a one way table that relates volume to profit.
arrow_forward
A trucking firm handles four commodities for a particular distributor. Total shipments for the commodities in the years 2000 and 2015, as well as the
prices in the year 2000, are reported in the following table.
Commodity
A
B
с
D
Shipments
2000
120
86
40
60
2015
95
73
55
70
Price/Shipment
2000
$1,200
$1,800
$2,000
$1,500
Develop a weighted aggregate quantity index with a 2000 base. (Round your answer to the nearest integer.)
¹2015 =
Comment on the growth or decline in quantities over the 2000-2015 period.
O Quantities are down slightly, by less than 5%.
O Quantities are down substantially, by more than 5%.
O Quantities are up slightly, by less than 5%.
O Quantities are up substantially, by more than 5%.
arrow_forward
"A taxi company currently has nine cabs in its fleet, and its total daily cost is $4,000. If the company added a 10th cab, its daily total cost would be $4,200, or $420 per cab. Adding the 10th cab will increase the daily total revenue by $300. Should the company add the 10th cab? (Yes/No)"
arrow_forward
A company produces and sells a consumer product and is able to control the demand for the product by
varying the selling price. The approximate relationship between price and demand is p= 200-0.05D
where p is the price per unit in dollars and D is the demand per month. The company is seeking to
maximize its profit. The fixed cost is $15000 per month and the variable cost is $50 per unit.
a. What is the number of units that should be produced and sold each month to maximize profit?
b. What is the domain of profitable demand during a month?
Show your spreadsheet.
arrow_forward
(ROUND OFF YOUR FINAL ANSWER TO TWO DECIMAL PLACES)
A company has established that the relationship between the sales price for one of its products and the quantity sold per month is
approximately p = 77-0.12D units. The fixed cost is $800 per month and the variable cost $25 per unit produced. What number of
units, D* should be produced per month and sold to maximize the profit per month related to the product?
Round your answer to 2 decimal places.
arrow_forward
Mead Plumbing currently sells thread seal tape at a price of $42.00 per roll. Their research
department has derived the price-demand equation as p = 60 -0.02x
where x is the number of tapes that can be sold at $p per roll of tape.
(d) If the current price changes by 10%, what will be the approximate percentage change in
demand?
(e) Find the price at which a percentage change in price produces the same percentage
change in demand.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co
Related Questions
- The following table indicates the unit prices (in Rands) and quantities of three goods held in the national warehouse of a DIY (“do it yourself”) store for the years 2020 and 2021. Item 2020 2021 Unit Price (p0) Quantity (q0)) Unit Price (p1) Quantity (q1) Mineral spirits R23.70 30 R27.70 45 10mm spanner R49.00 60 R65.00 50 25mm brush R58.00 30 R63.00 40 Q.8.1 Using 2020 as the base year, compute the price relatives in 2021 for the 10mm spanner and the 25mm brush. Interpret your answers. (8) Q.8.2 Again, using 2020 as the base year, compute the Paasche price index for all of the items for 2021. Interpret your answer.arrow_forwardThe table below is extracted from Goodland Republic Bureau of Statistics records for 2016 -2017. Use the information to answer the questions that follow. Goodland Economy 2013 and 2018 I tem Price 2017 (Base year) Price 2018 Price per Price per Unit ($) | Production 55,000 98,000 45,000 2,450.00 110,000 6.000 7,000.00 Unit ($) Production 50,000 100,000 50,000 23,000.00 120,000 5,000 Rice ( tons) Wheat (tons) Tractors mid-size (units) Cotton (tons) Used cars Manufacture garments ( tons) Eggs (Trays) Соса Cola (litres) Pepsi Cola (litres) Beef (tons) Second hand cloths (tons) Alcoholic Beverages (litres) Milk (litres) 1.50 2.00 2.00 2.50 100.00 120.00 5,000.00 50.00 150,000 2,000 6,000 700 145,000 2,300 6,500 70.00 2.50 3.50 0.80 1.20 1.50 1.10 850 5,000 500 500 4,800 450 600 6.50 8.50 15.00 25.00 3.25 3.75 7,000 2.30 7,500 2.50 Examine the status of the economic welfare in Goodland Republic in 2018 based on your GDP deflator, nominal GDP and Real GDP. Also, explain the reasons why it is…arrow_forwardA company produces and sells a consumer product and is able to control the demand by varying the selling price. The approximate relationship between price and demand is 2700 5000 p = 38 + (for D>1) D² The company is seeking to maximize its profit. The fixed cost is $1,000 and the variable cost is $ 40 per unit. What is the number of units and total amount that should be produced and sold each month to maximize profit?arrow_forward
- If the company does not change its current supply chain, what will its distributioncosts be for the following quarter?arrow_forwardWHERE IS THE CHART COMING FROM I AM CONFUSED? FC=1200? PLEASE EXPLAIN CHART USED AC=FC/Q-VC (600x3.1) - (500x3.5) 110 =--- = 11 600-500 100 3.10= UC/600-11 3.50=UC/500-110 FC=1200 EURO FC=1200 EURO AC=UC/Q-VC UC=UNIT COSTarrow_forwardBased on the following data for Al-Aqsa Company: (5 Marks) - Price = $10 - Average total cost = $6 - number of units produced = 1000 unit Calculate Profit per unit Total profitarrow_forward
- Complete the following table by calculating the contribution to profit and overhead for each of the 10 time periods and prices. Time Period Price Quantity Sold Total Contribution ($) (Million) ($ Million) 1 2,400 0.2 2 2,200 0.2 3 2,000 0.2 4 1,800 0.2 5 1,700 0.2 6 1,600 0.2 7 1,500 0.2 8 1,400 0.2 9 1,300 0.2 10 1,200 0.2 Over the 10 periods, the total contribution to profits and fixed costs from price skimming is million.arrow_forwardMustang Mobile charges $15 for each tetrabyte of data used on its smartphone plans. Use this information to create a table showing the charges for data based on the number of tetrabytes used.arrow_forwardComplete the inventory table by calculating the total cost of purchases, the goods available for sale, the cost of the goods available for sale, and the ending inventory. Date of purchase Beginning inventory Units Cost per purchased unit 41 $830 Total cost Retail price Total retail per unit value $975arrow_forward
- FG Manufacturers wants to determine the effectiveness of their pricing decisions for their product Lylo. As a consultant, you have been asked to develop cost functions that will assist in arriving at the optimal price that will enable the company to maximize profits. During the year, you were provided with the following demand and costs functions for the product: P = 400 – 6Q; where P is the unit selling price and Q is quantity in thousands of units. TC = 8Q2 + 36Q + 150; where TC is total cost in thousands of dollars. Determine the optimal sales revenue. Calculate the maximum profit. Briefly outline two (2) factors to be considered by managementswhen pricing decisions are being made.arrow_forwardJadual 1 menurnfukkan beberapa data harga dan kuantiti untuk sebuah ekonomi zederhana jang menghasilkan darang dan perkhidmatan derikut.) Table 1: Price and quantity for three types of product [Jadual I: Harga dan kuantiti sontuk tiga jenis produk) Product [Produk) Year 2019 [Tahun 20191 Price (RM) [Harga (RM) 1.25 Year 2017 Year 2018 [Tahun 20181 Price (RM) Kuanti) (RM) Kuanttij [Harga (RAM)) 1 [Tahun 2017) Quantity Quantity Kuantitij Price Quantity [Harga (RM)) A 180 200 200 B 90 75 90 100 100 120 0.6 675 0.5 600 0.5 630 (1) Compute the values of nominal GDP in 2017, 2018 and 2019. [Kirakan nilai-nilai KDNK nominal pada 2017, 2016 dan 2019) (6 Marks/ Markah) Compute the values of real GDP and GDP deflator in 2018 and 2019 (using 2017 as the base year). [Kirakan nilai-nilat KDNK zebenar dan KDNK pendeflari pada 2018 dan 2019 (menggunakan tahun azas 2017)) (5 Marks/ Markak) (iii) Compute the percentage change in the real GDP in 2018 and 2019 from the preceding year. (Kinatan nerat…arrow_forwardanalysis of the data indicated that the demand curve for x product is estimated to be linear and given by equation Qd = 150-3P and the supply curve for x product appears to be linear as well and is estimated as Qs=P-10. Graphically draw these two curves, labeling all relevant looking (such as intercepts for each line) on the horizontal and vertical axesarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Economics Today and Tomorrow, Student EditionEconomicsISBN:9780078747663Author:McGraw-HillPublisher:Glencoe/McGraw-Hill School Pub Co
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co