Question

**** PLEASE SHOW HOW TO SOLVE IN EXCEL NOT HANDWRITTEN*** The average cost per night of...

**** PLEASE SHOW HOW TO SOLVE IN EXCEL NOT HANDWRITTEN***

  1. The average cost per night of a hotel room in New York City is $325. Assume this estimate is based on a sample of 100 hotels and that the sample standard deviation is $75.
    1. What is the 95% confidence interval estimate of the population mean?
    2. What is the 99% confidence interval estimate of the population mean?

Homework Answers

Answer #1

We have given sample mean=325

sample Standard Deviation=75

Size=100

In,excel

a)95% confidence interval for population mean is

We use CONFIDENCE function in excel

Confidence Interval = x ± CONFIDENCE

95% confidence interval 310.3003 339.6997

b) 99% confidence interval for population mean is

99% confidence interval 305.6813 305.6813

Excel work

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question 1 (15 Marks) The average cost per night of a hotel room in New York...
Question 1 The average cost per night of a hotel room in New York City is $273 (SmartMoney, March 2009). Assume this estimate is based on a sample of 45 hotels and that the sample standard deviation is $65. a. With 95% confidence, what is the margin of error? b. What is the 95% confidence interval estimate of the population mean? c. Two years ago the average cost of a hotel room in New York City was $229. Discuss the...
The average cost per night of a hotel room in New York City is $275 (SmartMoney,...
The average cost per night of a hotel room in New York City is $275 (SmartMoney, March 2009). Assume this estimate is based on a sample of 45 hotels and that the sample standard deviation is $70 a. With 95% confidence, what is the margin of error? b. What is the 95% confidence interval estimate of the population mean? c.Two years ago the average cost of a hotel room in New York City was $229. Discuss the change in cost...
7. If I have a population of an unknown mean and unknown standard deviation, what is...
7. If I have a population of an unknown mean and unknown standard deviation, what is the 95% confidence interval estimate of the mean if a. A random sample of size 25 gives a mean of 50 and a standard deviation of 12 b. A random sample of size 16 gives a mean of 50 and a standard deviation of 12 8. The average cost per night of a hotel room in New York City is $325. Assume this estimate...
Can you please show work in Excel terms? New York City is the most expensive city...
Can you please show work in Excel terms? New York City is the most expensive city in the United States for lodging. The mean hotel room rate is $203 per night (USA Today, April 30, 2012). Assume that room rates are normally distributed with a standard deviation of $53. Use Table 1 in Appendix B. a. What is the probability that a hotel room costs $225 or more per night (to 4 decimals)? b. What is the probability that a...
The average cost of a hotel room is said to be $170 per night. To determine...
The average cost of a hotel room is said to be $170 per night. To determine if this is true, a random sample of 50 hotels is taken and resulted in a mean of $172.50 and an S of $15.40. At 98% confidence level, the positive value of the critical value is______ (Hint use Excel T.INV function)
The average hotel price in Moscow is $216 per night with a standard deviation of $32....
The average hotel price in Moscow is $216 per night with a standard deviation of $32. The average hotel price in Cancun is $161 per night with a standard deviation of $22. The average hotel price in Bangkok is $100 per night with a standard deviation of $17. A room at the Emerald Hotel in Moscow costs $200 per night, a room at the Ocean View Hotel in Cancun costs $183 per night, and a room at the Emperor Hotel...
Chap 8 1.         Studies show that massage therapy has a variety of health benefits and it...
Chap 8 1.         Studies show that massage therapy has a variety of health benefits and it is not too expensive. A sample of 10 typical one-hour massage therapy sessions showed an average charge of $59. The population standard deviation for a one-hour session is $5.50. a.         What assumptions about the population should we be willing to make if a margin of error is desired? b.         Using 95% confidence, what is the margin of error? c.         Using 99% confidence, what is...
Based on a random sample of 1120 ​adults, the mean amount of sleep per night is...
Based on a random sample of 1120 ​adults, the mean amount of sleep per night is 8.91 hours. Assuming the population standard deviation for amount of sleep per night is 3.2 ​hours, construct and interpret a 95​% confidence interval for the mean amount of sleep per night. A 95​% confidence interval is ​(___,___)
Please include bell shaped curve. Playbill magazine reported that the mean annual household income of its...
Please include bell shaped curve. Playbill magazine reported that the mean annual household income of its readers is $124,250. (Playbill, January 2006). Assume this estimate of the mean annual household income is based on a sample of 75 households, and based on past studies, the population standard deviation is known to be σ = $33,225. a. Develop a 90% confidence interval estimate of the population mean. b. Develop a 95% confidence interval estimate of the population mean. c. Develop a...
Question 7     You work for a hotel chain. You boss wants to know what the...
Question 7     You work for a hotel chain. You boss wants to know what the mean price for a comparable hotel room in Kansas City to help her determine what she should charge for your chain's rooms. You sample 101 random hotels similar to your own and get the daily cost of a room for each. You compute a mean cost of $96.50. The standard deviation of your sample is $19.50. What is the 95% confidence interval for the...