Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 18, Problem 39SE

a.

To determine

Check whether the median sales price in St. Louis is significantly lower than the national median of $180,000 or not.

a.

Expert Solution
Check Mark

Answer to Problem 39SE

The median sale price for single-family homes in St. Louis is less than the national median price of $180,000.

Explanation of Solution

Calculation:

The given information is that the national median sales price for single family home is $180,000. The level of significance is 0.05.

The hypotheses are given below:

Null hypothesis:

H0:Median180,000.

That is, the median sales price in St. Louis is significantly greater than or equal to the national median of $180,000.

Alternative hypothesis:

Ha: Median <180,000.

That is, the median sales price in St. Louis is significantly lower than the national median of $180,000.

For a sign test, the mean μ=0.5n, standard deviation σ=0.25n and n=50

The mean is,

μ=0.5(50)=25

Thus, the mean is 25.

The standard deviation is,

σ=0.25(50)=12.5=3.5355

Thus, the standard deviation is 3.5355.

There are 18 plus signs in the lower tail.

The probability of 18 plus signs in the lower tail can be obtained by using the continuity correction factor and normal approximation. Hence, the p-value is obtained by using normal distribution with μ=25 and σ=3.5355

P(18 or fewer plus signs)=P(x18.5)=P(z18.5253.5355)=P(z1.84)

Procedure:

Step by step procedure to obtain the above probability using Table 1 of Appendix B is given below:

  • Locate the value –1.8 in the column, named z.
  • Move towards the right along the row of –1.8, till the column named 0.04 is reached.
  • The cell at the intersection of the row –1.8 and the column 0.04 gives the cumulative probability corresponding to the standard normal variable value –1.84.

Thus, P(z<1.84)=0.0329

Now,

P(18or fewer plus signs)=0.0329

Rejection rule:

If p-valueα, then reject the null hypothesis (Ha).

Conclusion:

Here the level of significance α=0.05.

Here, p-value(=0.0329)<α(=0.05).

That is, p-value is less than significance level.

Therefore, the null hypothesis is rejected.

Hence, it can be concluded that the median sale price for single-family homes in St. Louis is less than the national median price of $180,000.

b.

To determine

Check whether the median sales price in Denver is significantly higher than the national median of $180,000 or not.

b.

Expert Solution
Check Mark

Answer to Problem 39SE

The median sale price for single-family homes in Denver is greater than the national median price of $180,000.

Explanation of Solution

Calculation:

The hypotheses are given below:

Null hypothesis:

H0:Median180,000.

That is, the median is less than or equal to 180,000.

Alternative hypothesis:

Ha: Median >180,000.

That is, median is greater than 180,000.

There are 13+27=40 observations in the data set.

For a sign test, the mean μ=0.5n, standard deviation σ=0.25n and n=40

The mean is,

μ=0.5(40)=20

Thus, the mean is 20.

The standard deviation is,

σ=0.25(40)=10=3.1623

Thus, the standard deviation is 3.1623.

There 27 plus signs in the upper tail.

The probability of 27 plus signs in the upper tail can be obtained by using the continuity correction factor and normal approximation. Hence, the p-value is obtained by using normal distribution with μ=20 and σ=3.1623.

P(27 or more plus signs)=P(x26.5)=P(z26.5203.1623)=P(z2.06)=1P(z<2.06)

Procedure:

Step by step procedure to obtain the above probability using Table 1 of Appendix B is given below:

  • Locate the value 2.0 in the column, named z.
  • Move towards the right along the row of 2.0, till the column named 0.06 is reached.
  • The cell at the intersection of the row 2.0 and the column 0.06 gives the cumulative probability corresponding to the standard normal variable value 2.06.

Thus, P(z<2.06)=0.9803

Therefore,

P(27 or more plus signs)=10.9803=0.0197

The upper-tail p-value is 0.0197.

Rejection rule:

If p-valueα, then reject the null hypothesis (Ha).

Conclusion:

Here the level of significance α=0.05.

Here, p-value(=0.0197)<α(=0.05).

That is, p-value is less than significance level.

Therefore, the null hypothesis is rejected.

Hence, it can be concluded that the median sale price for single-family homes in Denver is greater than the national median price of $180,000.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 18 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Statistics 4.1 Point Estimators; Author: Dr. Jack L. Jackson II;https://www.youtube.com/watch?v=2MrI0J8XCEE;License: Standard YouTube License, CC-BY
Statistics 101: Point Estimators; Author: Brandon Foltz;https://www.youtube.com/watch?v=4v41z3HwLaM;License: Standard YouTube License, CC-BY
Central limit theorem; Author: 365 Data Science;https://www.youtube.com/watch?v=b5xQmk9veZ4;License: Standard YouTube License, CC-BY
Point Estimate Definition & Example; Author: Prof. Essa;https://www.youtube.com/watch?v=OTVwtvQmSn0;License: Standard Youtube License
Point Estimation; Author: Vamsidhar Ambatipudi;https://www.youtube.com/watch?v=flqhlM2bZWc;License: Standard Youtube License