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

Videos

Textbook Question
100%
Book Icon
Chapter 10.4, Problem 36E

Winter visitors are extremely important to the economy of Southwest Florida. Hotel occupancy is an often-reported measure of visitor volume and visitor activity (Naples Daily News, March 22, 2012). Hotel occupancy data for February in two consecutive years are as follows.

Chapter 10.4, Problem 36E, Winter visitors are extremely important to the economy of Southwest Florida. Hotel occupancy is an

  1. a. Formulate the hypothesis test that can be used to determine whether there has been an increase in the proportion of rooms occupied over the one-year period.
  2. b. What is the estimated proportion of hotel rooms occupied each year?
  3. c. Using a .05 level of significance, what is your hypothesis test conclusion? What is the p-value?
  4. d. What is the 95% confidence interval estimate of the change in occupancy for the one-year period? Do you think area officials would be pleased with the results?

a.

Expert Solution
Check Mark
To determine

State the null and alternative hypotheses.

Answer to Problem 36E

Null hypothesis:H0:p1p20

Alternative hypothesis:Ha:p1p2>0

Explanation of Solution

Calculation:

It is given that winter visitors are important to the economy of the southwest region of State F.

The given data is about the hotel room occupancy in the month of February in two consecutive years.

Here, p1 represents the population proportion of rooms occupied for the current year and p2 represents the population proportion of rooms occupied for the previous year.

State the hypothesis:

Null hypothesis:

H0:p1p20

That is, the proportion of rooms occupied in the current year is less than or equal to the proportion of rooms occupied in the previous year.

Alternative hypothesis:

Ha:p1p2>0

That is, the proportion of rooms occupied in the current year is greater than the proportion of rooms occupied in the previous year.

b.

Expert Solution
Check Mark
To determine

Find the estimated proportion of hotel rooms occupied in each year.

Answer to Problem 36E

The estimated proportion of hotel rooms occupied in the current year is 0.84, and the estimated proportion of hotel rooms occupied in the previous year is 0.81.

Explanation of Solution

Calculation:

The estimated proportion of hotel rooms occupied in the current year is obtained as follows:

p¯1=x1n1=1,4701,750=0.84

Thus, the estimated proportion of hotel rooms occupied in the current year is 0.84.

The estimated proportion of hotel rooms occupied in the previous year is obtained as follows:

p¯2=x2n2=1,4581,800=0.81

Thus, the estimated proportion of hotel rooms occupied in the previous year is 0.81.

c.

Expert Solution
Check Mark
To determine

Find the p-value and provide a conclusion at α=0.05 from the results.

Answer to Problem 36E

The p-value is 0.009.

There is sufficient evidence to conclude that the proportion of rooms occupied in the current year is greater than the previous year.

Explanation of Solution

Calculation:

The test statistic for hypothesis tests about p1p2 is as follows:

z=(p¯1p¯2)p¯(1p¯)(1n1+1n2).

Here, p¯1 is the sample proportion for a simple random sample from population 1, p¯2 is the sample proportion for a simple random sample from population 2, p¯ is the pooled estimator of p, n1 is the sample size for population 1, n2 is the sample size for population 2, and zα2 is the critical value.

Pooled estimator:

p¯=n1p¯1+n2p¯2n1+n2=1,750(0.84)+1,800(0.81)1,750+1,800=2,9283,550=0.8248

Substitute p¯1 as 0.84, p¯2 as 0.81, n1 as 1,750, n2 as 1,800, and p¯ as 0.8248 in the z formula.

z=(0.840.81)0.8248(10.8248)(11,750+11,800)=0.03(0.14450496)(0.00113)=0.030.01278=2.35

Thus, the test statistic z-value is 2.35.

Here, the test is a right tail test.

Software procedure:

Step-by-step procedure to obtain the probability value using Excel.

  • Open an EXCEL sheet and select the cell A1.
  • Enter the formula =1-NORM.S.DIST(2.35,TRUE) in the cell A1.
  • Press Enter.

The output obtained using EXCEL software is given below:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List), Chapter 10.4, Problem 36E

From the output, the p-value is approximately 0.009.

Rejection rule:

If the p-valueα, reject the null hypothesis.

If the p-value>α, do not reject the null hypothesis.

Conclusion:

Here, the p-value is less than the level of significance.

That is, the p-value(=0.009)<α(=0.05).

From the rejection rule, the null hypothesis is rejected.

Therefore, there is sufficient evidence to conclude that the proportion of rooms occupied in the current year is greater than that in the previous year.

c.

Expert Solution
Check Mark
To determine

Obtain the 95% confidence interval estimate of the change in occupancy for the one-year period.

Explain whether the area officials are pleased with the results or not.

Answer to Problem 36E

The 95% confidence interval is (0.005,0.055).

Yes, the area officials are pleased with the results.

Explanation of Solution

Calculation:

The formula for the confidence interval estimate of the difference between two populations is as follows:

p¯1p¯2±zα2p¯1(1p¯1)n1+p¯2(1p¯2)n2.

Here, p¯1 is the sample proportion for a simple random sample from population 1, p¯2 is the sample proportion for a simple random sample from population 2, n1 is the sample size for population 1, n2 is the sample size for population 2, and zα2 is the critical value.

Critical value:

α=0.05α2=0.052=0.025

The cumulative area to the left is obtained as follows:

Area to the left=1Area to the right=10.025=0.975

Use Table 1: Cumulative probabilities for the standard Normal Distribution to find the critical value.

  • Locate the area of 0.975 in the body of Table 1.
  • Move left until the first column and note the values as 1.9.
  • Move upward until the top row is reached and note the value as 0.06.

Thus, the value of z0.025 is 1.96.

The 95% confidence interval estimate of the change in occupancy for the one-year period is obtained below:

p¯1p¯2±zα2p¯1(1p¯1)n1+p¯2(1p¯2)n2=(0.840.81)±1.960.84(10.84)1,750+0.81(10.81)1,800=0.03±1.960.0000768+0.0000855=0.03±1.96(0.0127)=0.03±0.025

                                                            =(0.030.025,0.03+0.025)=(0.005,0.055)

Thus, the 95% confidence interval is (0.005,0.055)_.

Interpretation:

There is 95% chance that the proportion of increase in hotel room occupancy over the one-year period lies between 0.005 and 0.055.

Since there is an increase in the hotel occupancy rate, the officials are expected to be pleased with the occupancy rate.

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 10 Solutions

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

Ch. 10.2 - Consider the following data for two independent...Ch. 10.2 - Prob. 12ECh. 10.2 - Annual Cost of College. The increasing annual cost...Ch. 10.2 - Are nursing salaries in Tampa, Florida, lower than...Ch. 10.2 - Hotel prices worldwide are projected to increase...Ch. 10.2 - Effect of Parents’ Education on Student SAT...Ch. 10.2 - Comparing Financial Consultant Ratings....Ch. 10.2 - Researchers at Purdue University and Wichita State...Ch. 10.3 - Consider the following hypothesis test. The...Ch. 10.3 - The following data are from matched samples taken...Ch. 10.3 - Prob. 21ECh. 10.3 - The price per share of stock for a sample of 25...Ch. 10.3 - Credit Card Expenditures. Bank of America’s...Ch. 10.3 - Domestic Airfare. The Global Business Travel...Ch. 10.3 - Prob. 25ECh. 10.3 - PGA Tour Scores. Scores in the first and fourth...Ch. 10.3 - Price Comparison of Smoothie Blenders. A personal...Ch. 10.4 - Consider the following results for independent...Ch. 10.4 - Prob. 29ECh. 10.4 - Corporate Hiring Outlook. A Businessweek/Harris...Ch. 10.4 - Impact of Pinterest on Purchase Decisions. Forbes...Ch. 10.4 - Mislabeled Fish. Researchers with Oceana, a group...Ch. 10.4 - Minnesota had the highest turnout rate of any...Ch. 10.4 - Oil wells are expensive to drill, and dry wells...Ch. 10.4 - In a test of the quality of two television...Ch. 10.4 - Winter visitors are extremely important to the...Ch. 10.4 - Prob. 37ECh. 10 - Prob. 38SECh. 10 - SUV Lease Payments. Statista reports that the...Ch. 10 - Prob. 40SECh. 10 - Kitchen Versus Bedroom Remodeling Costs. The...Ch. 10 - Effect of Siblings on SAT Scores. In Born...Ch. 10 - Country Financial, a financial services company,...Ch. 10 - Prob. 44SECh. 10 - Prob. 45SECh. 10 - News Access Via Computer. The American Press...Ch. 10 - For the week ended January 15, 2009, the bullish...
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
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License