3-3 Assignment - Real Estate Analysis part 2
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
240 APPLIE
Subject
Economics
Date
Jun 3, 2024
Type
docx
Pages
5
Uploaded by DoctorTurtle5212
Housing Price Prediction Model for D.M. Pan Real Estate Company
Colleen Del Valle
Southern New Hampshire University
Median Housing Price Prediction Model for D.M. Pan National Real Estate Company
2
Module Two Notes
The listing price random sample mean is $213,636, the median is $231,127, and the standard deviation is $153,707. The mean for square feet is 3,078, with the median being 2,984, following up with the standard deviation of 1,127. The difference in mean price between the random sample and the National Summary Statistics is $128,729, the median difference is $86,873, and the standard deviation is $27,793. The difference of square footage between the Pacific Region and National mean is 967, the median comes in at 1,103, and lastly the standard deviation is 206. The regional sample does not seem to be reflective of the national model just because of the gap differences in listing prices alone. The square footage is a little closer but still has a noticeable difference. How I conducted the simple random sample was by copying and pasting the data specific to the Pacific region into
a new workbook, from there I generated random numbers in the ‘G’ column with the ‘RAND’ function. After getting my random numbers, I highlighted all the columns with data, clicked the ‘Data’ tab at the top of the document, then clicked ‘Sort’ and had it sort the information randomly from smallest to largest. After it was all randomly sorted, I took the first 30 samples and copied them onto a separate worksheet. To get the mean, median, and standard deviation of the random listing price I used the ‘average’, ‘median’, and stdev.s’ functions on the spreadsheet.
Below I have added a side by side of the Pacific Region and the National Summary Statistics.
Listing Price (Dep. Var)
sample
national
mean price
$213,636 $342,365
median price
$318,000
Median Housing Price Prediction Model for D.M. Pan National Real Estate Company
3
$231,127 std dev price
$153,707
$125,914
Sq Ft (Indep. Var.)
sample
national
mean sqft
3,078 2,111
median sqft
2,984 1,881
std dev sqft
1127
921
Regression Equation
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 temperatures (in oF) were recorded inside the building of a remote pumping station: 99, 87, 93, 90, and 96. The variance of these readings is closest to: (a) 11.7 (b) 22.5 (c) 31.1 (d) 38.6
arrow_forward
The dispersion of values about the sample average is represented by the: (a) Variance (b) Expected value (c) Probability distribution (d) Standard deviation
arrow_forward
The historic average and standard deviation of the percentage moisture content MC of a product is E(MC) = 78.5% and sMC = 10.5%, respectively.The results of a sample of size 5 taken over the last 5 hours included the following 4 data points and the sample average: 81, 74, 83, 66, x̄ = 79 . If the guideline is to maintain the product’s moisture within 1 standard deviation of the historic average, the number of sample values outside these limits is:a. 3b. 2c. 1d. none
arrow_forward
For the Given values of 56, 67.9, 68, 53.8 and 69.8, Calculate
a) Mean
b) Algebraic Sum of deviation
c) Variance
d) Standard Deviation.
arrow_forward
The value of the ideal standard deviation is (two decimal places, no zeroes anywhere)
arrow_forward
In 2008, SAT math scores were normally distributed with a mean of
522 and a standard deviation of 102. What percentage of test takers
scoree between 420 and 624 on the math portion?
0.3173
0.6587
0.3413
0.6827
arrow_forward
A discrete variable Q, extra inventory units, has integer values from 1 to 10. When sampled 100 times, the following observed probability distribution was obtained: Q 1 2 3 6 9 10 P(Q) 0.2 0.2 0.2 0.1 0.2 0.1 (a) Determine the sample average and standard deviation by hand. (b) Determine the sample average and standard deviation by spreadsheet. (c) Determine the values 1 and 2 standard deviations from the mean. Of the 100 sample points, how many fall within these two ranges?
arrow_forward
A magazine conducts an annual survey in which readers rate their favorite cruise ship. All ships are rated on a 100-point scale, with higher values indicating better service. A sample of 33 ships that carry fewer than 500 passengers resulted in an average rating of 85.59, and a sample of 44 ships that carry 500 or more passengers provided an average rating of 81.40. Assume that the population standard deviation is 4.55 for ships that carry fewer than 500 passengers and 3.97 for ships that carry 500 or more passengers.
A) What is the point estimate of the difference between the population mean rating for ships that carry fewer than 500 passengers and the population mean rating for ships that carry 500 or more passengers? (Use smaller cruise ships − larger cruise ships.)
(b) At 95% confidence, what is the margin of error? (Round your answer to two decimal places.)
(c) What is a 95% confidence interval estimate of the difference between the population mean ratings for the two sizes of…
arrow_forward
Consider the following events: Scientists reveal that eating oranges decreases the risk of diabetes, and at the same time, farmers use a new fertilizer
that makes orange trees produce more oranges.
Show the effect of these two events on the market for oranges.
arrow_forward
The average and standard deviation of the amount of GST paid by all sole trader businesses in Australia in a twelve month period were $5.602
thousand and $1.637 thousand respectively. If a sample of 120 sole trader businesses was chosen, find the sample average value above which only
15% of sample averages would lie. Give your answer in dollars (to the nearest dollar).
arrow_forward
The average amount of debt families have is 2.5 times their annual income with a standard deviation 0.75 times their annual income. How much debt does a family have to have (relative to their annual income) to be in the top 5% with the LOWEST debt load?
arrow_forward
Students in the population of all students taking E270 were asked to state how much they spent
on textbooks in the current semester.
Jse the following textbook expense data (in dollars) to answer the following 5 questions.
475
550
540
350
330
510
335
530
370
455
525
545
515
435
335
485
540
645
435
405
340
470
455
345
650
375
520
275
465
330
555
460
455
380
520
620
580
335
565
420
510
465
540
545
350
410
440
530
505
455
655
520
360
405
325
525
545
350
450
435
265
385
540
465
460
560
495
530
385
685
470
375
545
555
520
490
440
495
570
370
340
435
360
590
550
430
425
390
490
430
665
610
655
410
560
390
365
595
550
385
440
395
395
505
545
430
575
530
415
265
420
470
350
525
325
620
325
525
505
335
490
560
240
425
460
435
280
510
485
510
665
335
430
375
555
445
460
490
360
420
470
425
410
680
295
415
230
475
430
395
370
380
375
490
410
330
610
430
305
590
605
315
485
400
480
375
500
445
310
455
355
575
310
370
265
415
345
575
395
385
650
540
435
380
380
495
460
370
400
550
575
385
555
535…
arrow_forward
Question of the day:
A machine is designed to produce insulating
washers for electrical devices of average
thickness of 0.025 cm. A random sample of 10
washers was found to have an average
thickness of 0.024 cm with a standard deviation
of 0.002 cm. Test the significance of the
deviation. Value of t for 9 degrees of freedom at
5% level is 2.262?
arrow_forward
A speciality software development firm is planning to offer one of four new software products and wishes to maximize profit, minimize risk, and increase market share. A weight of 55% is assigned to
annual profit potential, 25% to profitability risk, and 20% to market share. Use the tabular additive method for this situation and identify the product that would be best for the firm to introduce.
New Product Profit Potential (R) Profit Potential (R) Profit Risk (R) Market Share
Sw
200K
35K
High
Sw
300K
45K
Low
Sw
II
200K
55K
Medium
Sw
IV
160K
34К
Medium
O A. SWIII
O B. SWII
O C. SWIV
O D. SWI
O O O
arrow_forward
4
The fraction of z-scores that fall within z = ±1.60 is ________.
a
0.8904
b
0.8729
c
0.8558
d
0.8390
arrow_forward
Use the body temperatures, in degrees Fahrenheit, listed in the accompanying table. The range of the data is 3.3°F. Use the range rule of thumb to estimate the value of the standard deviation. Compare the result to
the actual standard deviation of the data rounded to two decimal places, 0.69°F, assuming the goal is to approximate the standard deviation within 0.2°F.
The estimated standard deviation is °F.
(Round to two decimal places as needed.)
Compare the result to the actual standard deviation.
The estimated standard deviation is
C
the actual standard deviation. Thus, the estimated standard deviation
Data table
the goal.
99 98.2 97.5 98.4 99.2 98 98.7 98.5 98.1 98.1 98.5 99.3
98.7 96.7 96.5 98.7 98 97.3 98.4 98 97.7 98.3 98.9 97.1
99 97.1 98.7 98.6 99.4 97.6 97.6 97.7 97.9 99.4 98.7 99.6
97.8 97.9 99 98.3 97.7 98.7 98.2 98.7 97.6 98 97.7 98.6
98.5 98.3 97.7 99 96.3 98 98.2 96.8 97.3 97.3 97.5 98.5
97.6 97.7 97.2 97.7 98 98.8 99 98.5 98 97.8 97 97.3
99.1 98.7 98.6 98.3 98.4 99 98…
arrow_forward
Find the standard deviation of a series of ACT scores listed below
16, 31, 19, 32,12
The standard deviation is?________________
(Type an integer or rounded to the nearest hundredth as needed)
arrow_forward
Wharton Econometric Forecasting, LLC has been hired to analyze demand in 30 regional markets for Product Y, a major item. A statistical analysis of demand in these markets shows (standard errors in parentheses):
QY = 26,950 − 450P + 220PX + 0.08A + 0.01I
(11,000) (150) (180) (0.3) (0.05)
R2 = 0.95
Standard Error of the Estimate = 10
Here, QY is market demand for Product Y, P is the price of Y in dollars, A is dollars of advertising expenditures, PX is the average price in dollars of another (unidentified) product, and I is dollars of household income. In a typical market, the price of Y is $100, PX is $70, advertising expenditures are $50,000, and average family income is $60,000.
Use the estimated demand function to calculate the expected value of QY in a typical market.
Calculate the 95% confidence interval within which you would expect to find actual values of sales.…
arrow_forward
Wharton Econometric Forecasting, LLC has been hired to analyze demand in 30 regional markets for Product Y, a major item. A statistical analysis of demand in these markets shows (standard errors in parentheses):
QY = 26,950 − 450P + 220PX + 0.08A + 0.01I
(11,000) (150) (180) (0.3) (0.05)
R2 = 0.95
Standard Error of the Estimate = 10
Here, QY is market demand for Product Y, P is the price of Y in dollars, A is dollars of advertising expenditures, PX is the average price in dollars of another (unidentified) product, and I is dollars of household income. In a typical market, the price of Y is $100, PX is $70, advertising expenditures are $50,000, and the average family income is $60,000.
1. Which variables in this regression model are statistically significant at the 95 percent confidence level? Show your work.
arrow_forward
The height (in inches) of a random sample of 28 players in NCAA Division 1 basketball teams is shown to the left.
x
75
80
75
87
77
77
67
83
77
80
73
82
73
71
80
76
72
78
68
74
74
72
76
86
77
77
78
8
Sum of deviations: ∑(x − x̅) = _______
a
-0.5
b
0
c
0.5
d
1
arrow_forward
Question:
The average hourly wage of a sample of 150
workers in a plant 'A' was Dollar 2.56 with a
standard deviation of Dollar 1-08. The average
hourly wage of a sample of 200 workers in
plant 'B' was Dollar 2.87 with a standard
deviation of Dollar 1.28. Can an applicant
safely assume that the hourly wages paid by
plant 'B' are higher than those paid by plant 'A'?
arrow_forward
A company manufactures two types of typewriters–electrical (E) and manual(M). The revenue function of the company, in thousands is: R(E,M)= 8E+5M+2EM- E2-2M2+20. Determine the quantity of electrical and manual typewriters which lead to maximum revenue. Also calculate the maximum revenue.
arrow_forward
The height (in inches) of a random sample of players in NCAA Division 1 basketball teams is shown to the left.
x
75
80
75
87
77
77
67
83
77
80
73
82
73
71
80
76
72
78
68
74
74
72
76
86
77
77
78
9
Sum of squared deviations: ∑(x − x̅)² = _______.
a
555.83
b
573.02
c
590.74
d
609.01
arrow_forward
The cost C(Q) of producing a quantity Q of widgets to satisfy demand isC(Q) = 4000+20Q, but the quantity demanded is random. If the mean and standarddeviation of demand are 500 and 200, respectively, then what are the mean andstandard deviation of costs?
arrow_forward
Estimate the average revenue
A company sells two products whose demand functions are given by
x1 = 500 – 2. 5p1 and x2 = 750 – 3p2
The total revenue is given by
R = X1P1 + X2P2
Estimate the average revenue when price p, varies between $25 and $50 and price
P2varies between $75 and $125.
arrow_forward
The life of button batteries is normally distributed with a mean of 68.1 hours and a standard deviation of 18 hours 936 of the button batteries will last more than
how many hours? (2 decimal places)
arrow_forward
A company manufactures two types of typewriters-electrical (E) and manual (M). The revenue
function of the company, in thousands is: R(E, M) = 8E + 5M + 2EM – E² – 2M² + 20. Determine the
quantity of electrical and manual typewriters which lead to maximum revenue. Also calculate the
maximum revenue.
arrow_forward
When there are at least two values for a parameter and it is not possible to estimate the chance that each may occur, this situation is known as: (a) Uncertain (b) Risk (c) Deterministic (d) Cost estimating
arrow_forward
Calculate standard deviation
Marks: 0-10,10-20,20-30,30-40,40-50
Frequency :10,15,10,10,5
arrow_forward
Dependent Variable: Pass
Experience
Male
Malex Experience
Constant
Probit
Logit
(1)
(2)
0.031
0.040
(0.009) (0.016)
0.712
(0.126)
Linear
Probability
(3)
0.006
(0.002)
1.059
0.774
(0.221) (0.034)
Probit
(4)
-0.333
(0.161)
1.282
(0.124)
Logit
(5)
-0.622
(0.303)
2.197
(0.242)
Linear
Probability
(6)
-0.071
(0.034)
0.900
(0.022)
Probit
(7)
0.041
(0.156)
-0.074
(0.259)
-0.015
(0.019)
0.806
(0.200)
Problem 1. (~SW 11.2) Using the results of column (2):
(a) Does the probability of passing the test depend on Experience? Explain.
(b) Matthew has 10 years of driving experience. What is the probability that he will pass the test?
(c) Christopher is a new driver (zero years of experience). What is the probability that he will pass
the test?
(d) Sketch the predicted probabilities from the probit and logit regressions in column (1) and (2)
for values of Experience between 0 and 60. Are the probit and logit models similar?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education
Related Questions
- The following temperatures (in oF) were recorded inside the building of a remote pumping station: 99, 87, 93, 90, and 96. The variance of these readings is closest to: (a) 11.7 (b) 22.5 (c) 31.1 (d) 38.6arrow_forwardThe dispersion of values about the sample average is represented by the: (a) Variance (b) Expected value (c) Probability distribution (d) Standard deviationarrow_forwardThe historic average and standard deviation of the percentage moisture content MC of a product is E(MC) = 78.5% and sMC = 10.5%, respectively.The results of a sample of size 5 taken over the last 5 hours included the following 4 data points and the sample average: 81, 74, 83, 66, x̄ = 79 . If the guideline is to maintain the product’s moisture within 1 standard deviation of the historic average, the number of sample values outside these limits is:a. 3b. 2c. 1d. nonearrow_forward
- For the Given values of 56, 67.9, 68, 53.8 and 69.8, Calculate a) Mean b) Algebraic Sum of deviation c) Variance d) Standard Deviation.arrow_forwardThe value of the ideal standard deviation is (two decimal places, no zeroes anywhere)arrow_forwardIn 2008, SAT math scores were normally distributed with a mean of 522 and a standard deviation of 102. What percentage of test takers scoree between 420 and 624 on the math portion? 0.3173 0.6587 0.3413 0.6827arrow_forward
- A discrete variable Q, extra inventory units, has integer values from 1 to 10. When sampled 100 times, the following observed probability distribution was obtained: Q 1 2 3 6 9 10 P(Q) 0.2 0.2 0.2 0.1 0.2 0.1 (a) Determine the sample average and standard deviation by hand. (b) Determine the sample average and standard deviation by spreadsheet. (c) Determine the values 1 and 2 standard deviations from the mean. Of the 100 sample points, how many fall within these two ranges?arrow_forwardA magazine conducts an annual survey in which readers rate their favorite cruise ship. All ships are rated on a 100-point scale, with higher values indicating better service. A sample of 33 ships that carry fewer than 500 passengers resulted in an average rating of 85.59, and a sample of 44 ships that carry 500 or more passengers provided an average rating of 81.40. Assume that the population standard deviation is 4.55 for ships that carry fewer than 500 passengers and 3.97 for ships that carry 500 or more passengers. A) What is the point estimate of the difference between the population mean rating for ships that carry fewer than 500 passengers and the population mean rating for ships that carry 500 or more passengers? (Use smaller cruise ships − larger cruise ships.) (b) At 95% confidence, what is the margin of error? (Round your answer to two decimal places.) (c) What is a 95% confidence interval estimate of the difference between the population mean ratings for the two sizes of…arrow_forwardConsider the following events: Scientists reveal that eating oranges decreases the risk of diabetes, and at the same time, farmers use a new fertilizer that makes orange trees produce more oranges. Show the effect of these two events on the market for oranges.arrow_forward
- The average and standard deviation of the amount of GST paid by all sole trader businesses in Australia in a twelve month period were $5.602 thousand and $1.637 thousand respectively. If a sample of 120 sole trader businesses was chosen, find the sample average value above which only 15% of sample averages would lie. Give your answer in dollars (to the nearest dollar).arrow_forwardThe average amount of debt families have is 2.5 times their annual income with a standard deviation 0.75 times their annual income. How much debt does a family have to have (relative to their annual income) to be in the top 5% with the LOWEST debt load?arrow_forwardStudents in the population of all students taking E270 were asked to state how much they spent on textbooks in the current semester. Jse the following textbook expense data (in dollars) to answer the following 5 questions. 475 550 540 350 330 510 335 530 370 455 525 545 515 435 335 485 540 645 435 405 340 470 455 345 650 375 520 275 465 330 555 460 455 380 520 620 580 335 565 420 510 465 540 545 350 410 440 530 505 455 655 520 360 405 325 525 545 350 450 435 265 385 540 465 460 560 495 530 385 685 470 375 545 555 520 490 440 495 570 370 340 435 360 590 550 430 425 390 490 430 665 610 655 410 560 390 365 595 550 385 440 395 395 505 545 430 575 530 415 265 420 470 350 525 325 620 325 525 505 335 490 560 240 425 460 435 280 510 485 510 665 335 430 375 555 445 460 490 360 420 470 425 410 680 295 415 230 475 430 395 370 380 375 490 410 330 610 430 305 590 605 315 485 400 480 375 500 445 310 455 355 575 310 370 265 415 345 575 395 385 650 540 435 380 380 495 460 370 400 550 575 385 555 535…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Economics (12th Edition)EconomicsISBN:9780134078779Author:Karl E. Case, Ray C. Fair, Sharon E. OsterPublisher:PEARSONEngineering Economy (17th Edition)EconomicsISBN:9780134870069Author:William G. Sullivan, Elin M. Wicks, C. Patrick KoellingPublisher:PEARSON
- Principles of Economics (MindTap Course List)EconomicsISBN:9781305585126Author:N. Gregory MankiwPublisher:Cengage LearningManagerial Economics: A Problem Solving ApproachEconomicsISBN:9781337106665Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike ShorPublisher:Cengage LearningManagerial Economics & Business Strategy (Mcgraw-...EconomicsISBN:9781259290619Author:Michael Baye, Jeff PrincePublisher:McGraw-Hill Education
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education