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 dispersion of values about the sample average is represented by the: (a) Variance (b) Expected value (c) Probability distribution (d) Standard deviation
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 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
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
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
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
Southern States Bank and Trust
Southern States Bank and Trust monitors its drive-thru service times
electronically to ensure that its speed of service is meeting the company's
goal. A sample of drive-thru times at the UCF branch was recently taken and
is shown here. The frequency is the number of service times and the time
interval is the service time in minutes.
Time Interval Frequency
10 - 19
5
20 29
12
30 39
13
40 49
11
50 59
6.
Compute the mean for these sample data.
(Round to the nearest 2 decimal places, if needed.)
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
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
5
What is the z-score that bounds a tail area of 0.15?
a
1.10
b
1.07
c
1.04
d
1.01
arrow_forward
The 2018 statistics shows that the average life expectancy of females in Canada has risen to 83.9 years. Assuming the standard
1
deviation of their life expectancy was 7.4 yoars, determine the minimum percentage of females in Canada whose life expectancy was
between 75.02 and 92.78 years.
Type your numerical answer here.
Numbers only
arrow_forward
(c) The price of a 14 oz cup of coffee in Sunshine cafés is a random variable C
with an expected value of $3.00 and a standard deviation of $1. At any given
shop, the price doesn't vary, but it varies independently across shops. Tomorrow
morning, you plan to buy two 14 oz cups of coffee from the same shop while your
friend plans on buying two from two different shops.
(i) How much do you expect to spend on coffee tomorrow and with what standard
deviation?
(ii) How much do you expect your friend to spend and with what standard
deviation?
(iii) Who do you think has a better idea and why?
arrow_forward
A film processing service monitors the quality of the developing process with light-sensitive equipment. The accuracy measure is a number with a target value of zero. Suppose that an X- chart with subgroups of size five is used to monitor the process and the control limits are UCL = 1.5 and LCL = -1.5. Assume that the estimate for the process mean is zero and for the process standard deviation is 1.30.a. What is the value of α for this control chart?b. Find the UCL and LCL based on three-sigma limits.c. Suppose that the process mean shifts to 1. What is the probability that the shift is detected on the first subgroup after the shift occurs?
arrow_forward
0 2
A courier company guarantees its customers that the average time to pick up their packages is 20
minutes with a tolerance of ± 4 minutes. The company collected data on 30 actual arrival times
and determined that the average is 20 minutes and standard deviation of this sample was 1
minutes. What is the Cpk of this package service process?
01
Less than 1
O Great than 2
1.33
arrow_forward
Suppose ACT Reading scores are normally distributed with a mean of 21.4 and a standard deviation of 5.9. A university plans to award scholarships to students whose scores are in the top 9%. What is the minimum score required for the scholarship? Round your answer to the nearest tenth, if necessary.
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 dispersion of values about the sample average is represented by the: (a) Variance (b) Expected value (c) Probability distribution (d) Standard deviationarrow_forwardFor 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_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.6827arrow_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
- 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_forward4 The fraction of z-scores that fall within z = ±1.60 is ________. a 0.8904 b 0.8729 c 0.8558 d 0.8390arrow_forwardUse 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
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