MAT 240 Project One
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
240
Subject
Economics
Date
Jan 9, 2024
Type
docx
Pages
5
Uploaded by BrigadierKuduMaster186
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
Amiee Sizemore
Southern New Hampshire University
Median Housing Price Model for D. M. Pan National Real Estate Company
2
Introduction
Describe the report:
D. M. Pan National Real Estate Company has requested that we create a
house pricing model that will predict house values for sales in 2019. The CEO plans to use this
data to make decisions about the square footage as a real estate listing price benchmark. In my
report, I will compare housing costs and its relationship to square footage.
Data Collection
S
ampling the data:
I generated 50 random house data sets by using Excel's "=rand()" function,
and then I randomly rearranged each row using the Data tab's sorting options. To collect my final
data, I selected the first 50 rows that were generated.
Sampling the data:
In the scatter plot below, "X" stands for square footage (the predictors) and
"Y" for listing price (the response).
Scatterplot:
A linear regression model provides a deeper understanding of the relationships
between two variables. The scatterplot should show a fairly random pattern, if appropriate.
While
the predictor variable (x) is fixed (non-random), the response variable (y) is a random variable.
The scatterplot shows a weak, but positive correlation due to the random and positive pattern.
This shows that while one variable increases, so does the other.
1,000
2,000
3,000
4,000
5,000
-
100,000
200,000
300,000
400,000
500,000
600,000
700,000
Median Housing Price Model for D. M. Pan National Real Estate Company
3
Data Analysis
Histogram:
Histogram:
Summary statistics:
Interpret the graphs and statistics:
The results in the data analysis support the theory
that the listing price of homes will increase with the square footage amount. The mean listing
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
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
QUESTION 3
Read the article on “Kaalzua" to answer questions 3a, 3b and 3c
Kaalzua: The modern-day furniture for the modern city dweller
Source: 29 Nov 2021, Mint
Kaalzua is a new-age furniture brand which designs and innovates flat pack furniture and products for
the city dwellers. The Delhi based start-up offers digitally fabricated, hassle free flat pack solutions that
solve the modern-day problems. They believe in a judicious balance of human expertise and smart
technology. The products are prepared in such a way that they can easily be assembled without any
screws, glue or welding. The le cad has moulded the digital fabrication process to accommodate
different sustainable matenaastaarier than wood, like bamboo, recycled plastic etc. At present the
furniture products are avang. Aôn the e-commerce platform www.kaalzua.com . The start-up has also
partnered with major onlig skail stores. With this strong online presence, they plan to soon expand
into experience centers e the country.…
arrow_forward
helpp
arrow_forward
Explain the following demand determinants:
(1) Income
(2) Price of related goods and services
(3) Taste or preferences of consumers
(4) Size of Population
(5) Expected Price of the Product in the future periods
arrow_forward
The ABC Toy Company makes a few types of toy cars on one of its production line. Based on orders received and forecasts of future demand, it is estimated that the demand (in units) for the next four seasons is: Fall 10,000; Winter 8000; Spring 7,000; Summer 12,000. Inventory at the beginning of Fall is 660 units. At the beginning of Fall, ABC has 30 workers.
Relevant costs: hiring: $100/worker hiredlayoff: $200/worker laid offinventory holding: $5/unit/seasonbackorder: $10/unitregular time cost: $5/hour
Assume that the productivity is 0.5 units per worker hour, with eight hours per day and 60 days per season. Inventory cost is estimated based on the ending inventory for each period. The relevant costs are shown in the accompanying table.(a) Find the total cost of the level plan.(b) Find the total cost of the chase plan.(c) Suppose that ABC has negotiated with the union on the option of using the regular workforce on overtime ($8/hour) during Winter and Spring, if necessary. Overtime is…
arrow_forward
answer #1 only :))
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
The table below shows the annual percentage change in sales for five locations of J&J Burger.
Pct. Change, 2019- Pct. Change, 2020-
Location
2021
2020
6
-3
-12
-6
11
3
7
10
-2
2
Camarillo
Oxnard
Ventura
Thousand Oaks
Simi Valley
If the total sales at the Oxnard location are $125,864 in 2021, what were the sales at that same location at the end of 2019? Round to the nearest whole dollar.
Type your answer...
arrow_forward
A firm keeps a record of sales and prices over the past seven months, resulting in the following table: Price (ZMW/ton) Sales (tons) Nov. 1985 7.5 84.5 Dec. 8.0 82.0 Jan. 1986 8.0 84.0 Feb. 7.2 92.0 March 7.0 95.0 April 8.0 92.0 May 8.5 91.5 Use these observations to estimate demand as a linear function of both price and time. Further, utilise this function to estimate demand for the following month, on the assumption that: (a) price remains unchanged, (b) price increases to ZMW9/ton. Hence estimate the price elasticity of demand between these prices and find the price which would maximise sales revenue. Given the nature of the observations, comment on any difficulties in interpreting your results for decision-making purposes.
arrow_forward
[The following information applies to the questions displayed below.]
Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system.
Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 160 $ 1,280 August 4 Sale ($225 each) 5 August 11 Purchase 10 150 1,500 August 13 Sale ($240 each) 8 August 20 Purchase 10 140 1,400 August 26 Sale ($250 each) 11 August 29 Purchase 11 130 1,430 $ 5,610 For the specific identification method, the August 4 sale consists of rackets from beginning inventory, the August 13 sale consists of rackets from the August 11 purchase, and the August 26 sale consists of one racket from beginning inventory and 10 rackets from the August 20 purchase.
3. Using LIFO, calculate ending inventory and cost of goods sold at August 31.
arrow_forward
Subject: Business economics
Remaining:
Q3) Colgate sells its standard size toothpaste for Rs. 25. Its sales have been on an average 8000 units per month over the last year. Recently, its competitor Sparkle reduced the price of its same standard size toothpaste from Rs. 35 to Rs. 30. As a result Colgate sales declined by 1500 units per month.
Calculate the cross elasticity between the two products.
What does your estimate indicate about the relationship between the two?
arrow_forward
Use the green rectangle (triangle symbols) to compute total revenue at various prices along the demand curve.
Note: You will not be graded on any changes made to this graph.
PRICE (Dollars per scooter)
TOTAL REVENUE (Dollars)
195
180
165
910
150
1130
800
1020
090
135
580
120
470
105
360
On the following graph, use the green point (triangle symbol) to plot the weekly total revenue when the market price is $30, $45, $60, $75, $90,
$105, and $120 per scooter.
250
75
140
60
45
30
15
0
Demand
03 6 9 12 15 18 21 24 27 30 33 36 39
QUANTITY (Scooters)
0 15 30 45
Total Revenue
60 75 90 105 120 125 150 165 180 195
PRICE (Dollars per scooter)
A
Total Revenue
?
(?)
According to the midpoint method, the price elasticity of demand between points A and B is approximately
Suppose the price of scooters is currently $30 per scooter, shown as point B on the initial graph. Because the demand between points A and B is
in total revenue per week.
a $15-per-scooter increase in price will lead to
In general,…
arrow_forward
I need the 3 answers below please!
arrow_forward
3. Factors affecting the number of houses for resale
4. Residential market analysis with accounting methods - calculation of the estimate total
housing demand and expected total supply (example - exercise)
arrow_forward
MOER
The table below shows how supply and demand
Price ($/gal) Demand (million of gal.)
1
1.2
790
700
1.4
640
1.6
580
1.95
497
2.2
450
2.4
430
2.6
420
2.8
390
3
360
Note: there is some randomization in the above data to account for price fluctuations. Make sure to check that
you input the correct data in your device.
Perform the following work
• Assume that Supply has a quadratic relationship with the price. Find this relationship (the help buttons
contain an article to compute trend-lines in Excel):
-21.935p² + 207.365p+339.085 Round your answer to 3 decimal places
S(p)
●
D(p):
=
1.53
• Assume that the Demand has a quadratic relationship with the price. Find this relationship (the help
button links to an article to compute trend-lines in Excel):
85.561p² - 543.789p + 1236.729 Round your answer to 3 decimal places
Video
Solve | Sn...
of gasoliine vary depending on the price:
Supply (million of gal.)
511
550
600
641
660
680
700
720
735
786
605
-
• Use the trendlines to find the price…
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
Question#5Nile.com, the online bookseller, wants to increase its total revenue. One strategy is to offer a 10% discount on every book it sells. Nile.com knows that its customers can be divided into two distinct groups according to their likely responses to the discount. The accompanying table shows how the two groups respond to the discount.
Group A Group B(sales per week) (sales per week)
Volume of sales beforethe 10% discount 1.55 million 1.50 million
Volume of sales afterthe 10% discount 1.65 million 1.70 million
Using the midpoint method, calculate the price elasticities of demand for group A and group B.Explain how the discount will affect total revenue from each group.Suppose Nile.com knows which group each customer belongs to when he or she logs on and can choose whether or not to offer the 10% discount. If Nile.com wants to increase its total revenue, should discounts be offered to group A or to group B, to neither group, or to both groups?
arrow_forward
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past
year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety
laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows:
DEMAND (UNITS)
4,130
4,230
MONTH
January
February
March
3,930
4,330
4,930
4,630
5,230
4,830
5,330
5,630
6,230
5,930
April
May
June
July
August
September
October
November
December
a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the
general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.)
Month
Forecast
January
February
March
April
May
June
July
August
September
October
November
December
arrow_forward
4. 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 Production Unit ($) Production Unit (S) 50,000 1.50 55,000 2.00 100.000 2.00 98000 250 50,000 23,000.00 45,000 2,450.00 120.000 100.00 110,000 120.00 5.000 5,000.00 6,000 7,000.00 Rice (tons) Wheat (tons) Tractors mid-size (units) Cotton (tons) Used cars Manufacture garments (tons) Eggs (Trays) Coca Cola (litres) Pepsi Cola (litres) Beef (tons) Second hand cloths (tons) Alcoholic Beverages (litres) Milk (litres) 150,000 2.000 6,000 700 5,000 500 500 7000 50.00 2.50 0.80 1.10 6.50 15.00 3.25 230 145,000 2,300 6.500 850 4.800 450 600 7.500 70.00 3.50 1.20 1.50 8.50 25.00 3.75 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
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
Unit ($) Production Unit ($)
1.50
2.00
Price per
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)
Coca Cola (litres)
Pepsi Cola (litres)
Beef (tons)
Second hand cloths (tons)
Alcoholic Beverages (litres)
Milk (litres)
55,000
2.00
98,000
2.50
45,000 2,450.00
120.00
100.00
5.000.00
110,000
6,000 7,000.00
145,000
2,300
6,500
850
150,000
2,000
6,000
700
5,000
500
500
7,000
50.00
70.00
3.50
1.20
1.50
2.50
0.80
1.10
6.50
4,800
450
600
8.50
15.00
3.25
2.30
25.00
3.75
2.50
7,500
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
Table 1: Price and quantity for three types of product
[Jadual 1: Harga dan kuantiti untuk tiga jenis produk]
Product
[Produk]
Year 2017
[Tahun 2017]
Price
Year 2018
Year 2019
[Tahun 2018]
Quantity
[Kuantiti]
[Tahun 2019]
Price
(RM)
[Harga
(RM)]
1.25
Quantity
[Kuantiti]
Price
Quantity
[Kuantiti)
(RM)
[Harga
(RM)]
1.
(RM)
[Harga
(RM)]
1
180
200
200
90
75
90
100
100
120
0.6
675
0.5
600
0.5
630
(i)
Compute the values of nominal GDP in 2017, 2018 and 2019.
Kirakan nilai-nilai KDNK nominal pada 2017, 2018 dan 2019.1
ABC
arrow_forward
Suppose that your demand schedule for CDs is as follows:
Price (Tk.) Quantity Quantity
Demanded (Income: Tk. 30000) Demanded (Income: 50000)
---------------------------------------------------------------------------------------------------
10 32 90
20 16 40
40 8 15
80 4 7
160 2 3…
arrow_forward
2.11 A company wants to develop a level production plan for a family of products. The open-
ing inventory is 100 units, and an increase to 130 units is expected by the end of the plan.
The demand for each month is given in what follows. Calculate the total production,
daily production, and production and ending inventory for each month.
Month
May
Jun
Jul
Aug
Total
Working Days
21
19
20
10
Forecast Demand
115
125
140
150
Planned Production
Planned Inventory
100
arrow_forward
Nile.com, the online bookseller, wants to increase its total revenue. One strategy is to offer a 10% discount on every book it sells. Nile.com knows that its customers can be divided into two distinct groups according to their likely responses to the discount. The accompanying table shows how the two groups respond to the discount.
Group A Group B(sales per week) (sales per week)
Volume of sales beforethe 10% discount 1.55 million 1.50 million
Volume of sales afterthe 10% discount 1.65 million 1.70 million
A. Using the midpoint method, calculate the price elasticities of demand for group A and group B. B. Explain how the discount will affect total revenue from each group. C. Suppose Nile.com knows which group each customer belongs to when he or she logs on and can choose whether or not to offer the 10% discount. If Nile.com wants to increase its total revenue, should discounts be offered to group A or to group B, to neither group, or to both groups?
arrow_forward
19. Canadians' New Focus on Thrift
Canadian shoppers' shift to greater thriftiness has been unkind to retailers like Bikini Village and Le Chateau, which recently posted losses, but it may be a boon for budget stores like Dollarama Inc., which recently generated double-digit sales.
Source: The Financial Post, July 3, 2011
Draw a graph to show the effect of increased thriftiness on sales at (i) Bikini Village and (ii0 Dollarama.
Use the following information to work Problems 20 and 21.
Boom Time For "Gently Used" Clothes Most retailers are blaming the economy for their poor sales, but one store chain that sells used name-brand children's clothes, toys, and furniture is boldly declaring that an economic downturn can actually be a boon for its business. Last year, the company took in $20 million in sales, up 5% from the previous year. Sales are already up 5% this year.
Sources: CNN, April 17, 2008
20. a. According to news clip, is used clothing a…
arrow_forward
10
arrow_forward
[5th_item] *problem situation in the photo below*
Required:
What do you tell your boss (estimate of the number of additional workers in Manila who would lose their jobs as a result of a higher minimum wage)?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- 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_forwardQUESTION 3 Read the article on “Kaalzua" to answer questions 3a, 3b and 3c Kaalzua: The modern-day furniture for the modern city dweller Source: 29 Nov 2021, Mint Kaalzua is a new-age furniture brand which designs and innovates flat pack furniture and products for the city dwellers. The Delhi based start-up offers digitally fabricated, hassle free flat pack solutions that solve the modern-day problems. They believe in a judicious balance of human expertise and smart technology. The products are prepared in such a way that they can easily be assembled without any screws, glue or welding. The le cad has moulded the digital fabrication process to accommodate different sustainable matenaastaarier than wood, like bamboo, recycled plastic etc. At present the furniture products are avang. Aôn the e-commerce platform www.kaalzua.com . The start-up has also partnered with major onlig skail stores. With this strong online presence, they plan to soon expand into experience centers e the country.…arrow_forwardhelpparrow_forward
- Explain the following demand determinants: (1) Income (2) Price of related goods and services (3) Taste or preferences of consumers (4) Size of Population (5) Expected Price of the Product in the future periodsarrow_forwardThe ABC Toy Company makes a few types of toy cars on one of its production line. Based on orders received and forecasts of future demand, it is estimated that the demand (in units) for the next four seasons is: Fall 10,000; Winter 8000; Spring 7,000; Summer 12,000. Inventory at the beginning of Fall is 660 units. At the beginning of Fall, ABC has 30 workers. Relevant costs: hiring: $100/worker hiredlayoff: $200/worker laid offinventory holding: $5/unit/seasonbackorder: $10/unitregular time cost: $5/hour Assume that the productivity is 0.5 units per worker hour, with eight hours per day and 60 days per season. Inventory cost is estimated based on the ending inventory for each period. The relevant costs are shown in the accompanying table.(a) Find the total cost of the level plan.(b) Find the total cost of the chase plan.(c) Suppose that ABC has negotiated with the union on the option of using the regular workforce on overtime ($8/hour) during Winter and Spring, if necessary. Overtime is…arrow_forwardanswer #1 only :))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_forwardThe table below shows the annual percentage change in sales for five locations of J&J Burger. Pct. Change, 2019- Pct. Change, 2020- Location 2021 2020 6 -3 -12 -6 11 3 7 10 -2 2 Camarillo Oxnard Ventura Thousand Oaks Simi Valley If the total sales at the Oxnard location are $125,864 in 2021, what were the sales at that same location at the end of 2019? Round to the nearest whole dollar. Type your answer...arrow_forwardA firm keeps a record of sales and prices over the past seven months, resulting in the following table: Price (ZMW/ton) Sales (tons) Nov. 1985 7.5 84.5 Dec. 8.0 82.0 Jan. 1986 8.0 84.0 Feb. 7.2 92.0 March 7.0 95.0 April 8.0 92.0 May 8.5 91.5 Use these observations to estimate demand as a linear function of both price and time. Further, utilise this function to estimate demand for the following month, on the assumption that: (a) price remains unchanged, (b) price increases to ZMW9/ton. Hence estimate the price elasticity of demand between these prices and find the price which would maximise sales revenue. Given the nature of the observations, comment on any difficulties in interpreting your results for decision-making purposes.arrow_forward
- [The following information applies to the questions displayed below.] Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 160 $ 1,280 August 4 Sale ($225 each) 5 August 11 Purchase 10 150 1,500 August 13 Sale ($240 each) 8 August 20 Purchase 10 140 1,400 August 26 Sale ($250 each) 11 August 29 Purchase 11 130 1,430 $ 5,610 For the specific identification method, the August 4 sale consists of rackets from beginning inventory, the August 13 sale consists of rackets from the August 11 purchase, and the August 26 sale consists of one racket from beginning inventory and 10 rackets from the August 20 purchase. 3. Using LIFO, calculate ending inventory and cost of goods sold at August 31.arrow_forwardSubject: Business economics Remaining: Q3) Colgate sells its standard size toothpaste for Rs. 25. Its sales have been on an average 8000 units per month over the last year. Recently, its competitor Sparkle reduced the price of its same standard size toothpaste from Rs. 35 to Rs. 30. As a result Colgate sales declined by 1500 units per month. Calculate the cross elasticity between the two products. What does your estimate indicate about the relationship between the two?arrow_forwardUse the green rectangle (triangle symbols) to compute total revenue at various prices along the demand curve. Note: You will not be graded on any changes made to this graph. PRICE (Dollars per scooter) TOTAL REVENUE (Dollars) 195 180 165 910 150 1130 800 1020 090 135 580 120 470 105 360 On the following graph, use the green point (triangle symbol) to plot the weekly total revenue when the market price is $30, $45, $60, $75, $90, $105, and $120 per scooter. 250 75 140 60 45 30 15 0 Demand 03 6 9 12 15 18 21 24 27 30 33 36 39 QUANTITY (Scooters) 0 15 30 45 Total Revenue 60 75 90 105 120 125 150 165 180 195 PRICE (Dollars per scooter) A Total Revenue ? (?) According to the midpoint method, the price elasticity of demand between points A and B is approximately Suppose the price of scooters is currently $30 per scooter, shown as point B on the initial graph. Because the demand between points A and B is in total revenue per week. a $15-per-scooter increase in price will lead to In general,…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you