Question

Hello, something I'm doing on Excel is wrong and need to know how to do this correctly on Excel, now written out.

A sample of the sales at 50 Haute Dog restaurants is taken and the sample mean is $30,000 per day

with a sample standard deviation of $2000. The population standard deviation is not known.

a. What is the 90% confidence interval for the daily sales at all restaurants.

b. What is the probability that the average sales are really $32,000 or more per day?

Assume that the population average is $30,000 per day and the std. Deviation is $2k.

Answer #1

Solution:

We are given n=50, Xbar = 30000, S = 2000

Part a

Confidence interval for population mean is given as below:

Confidence interval = Xbar ± t*S/sqrt(n)

Confidence level = 90%

df = n – 1 = 50 – 1 = 49

Critical t value = 1.6766

(by using excel command =TINV(1 – 0.90, 49))

Confidence interval = 30000 ± 1.6766*2000/sqrt(50)

Confidence interval = 30000 ± 1.6766* 282.8427125

Confidence interval = 30000 ± 474.2002

Lower limit = 30000 - 474.2002 = 29525.80

Upper limit = 30000 + 474.2002 = 30474.20

Confidence interval = ($29525.80, $30474.20)

Part b

Here, we have to find P(Xbar>32000)

Z = (Xbar - µ) / [σ/sqrt(n)]

Z = (32000 – 30000) / [2000/sqrt(50)]

Z = 2000/[2000/7.071068]

Z = 2000/282.8427

Z = 7.071068

P(Z<7.071068) = 1.00 (by using z-table/excel)

(Use excel command =normsdist(7.071068))

P(Z>7.071068) = 0.00

P(Xbar>32000) = 0.00

1. The use of a production smoothing
strategy creates inventory for products that experience a seasonal
fluctuation in demand. True or False ?
2. Companies belonging to the same
industry segment should have the same inventory
turns. True or False ?
3. Which of the following is a work-in-process inventory for
C&A Bakery?
A. Flour
B. Cupcakes freshly out of the oven
C. Ovens
D. Cupcake mix prepared from scratch
4. C&A has on average $6000 in inventory and its daily...

1. What is an ISP (Integrated Service Provider) for supply
chains? (1 point)
A. A consultant agency which integrates the supply chain for
companies
B. A 2 PL or a 3PL, but not a 4PL
C. A company supplying transportation and warehousing
services
D. A logistics service company specialized in suppling VAS (value
added
services)
2. What characterizes a 4 PL? (1 point)
A. They are non-asset based and provides integrated services
primarily
supplied by asset based providers, for example...

MK Restaurant: Branding of Thai-Style Hotpot
The restaurant industry is one of the most competitive in
Thailand. With a large number of players ranging from restaurants
in five-star hotels, global fast-food chains to small stalls along
the streets and everything in between, the Thais are spoiled for
choice. In addition, as the world becomes globalized, consumers are
familiar with international dishes and would not hesitate to try
new offerings from the other side of the globe. As a...

Using the model proposed by Lafley and Charan, analyze how
Apigee was able to drive innovation.
case:
W17400
APIGEE: PEOPLE MANAGEMENT PRACTICES AND THE CHALLENGE OF
GROWTH
Ranjeet Nambudiri, S. Ramnarayan, and Catherine Xavier wrote
this case solely to provide material for class discussion. The
authors do not intend to illustrate either effective or ineffective
handling of a managerial situation. The authors may have disguised
certain names and other identifying information to protect
confidentiality.
This publication may not be...

What role could the governance of ethics have played
if it had been in existence in the organization? Assess the
leadership of Enron from an ethical perspective.
THE FALL OF ENRON: A STAKEHOLDER FAILURE
Once upon a time, there was a gleaming headquarters
office tower in Houston, with a giant tilted "£"' in front, slowly
revolving in the Texas sun. The Enron Corporation, which once
ranked among the top Fortune 500 companies, collapsed in 2001 under
a mountain of debt...

Discuss ethical issues that can be identified in this
case and the mode of managing ethics Enron finds itself in this
case. How would you describe the ethical culture and levels of
trust at Enron? Provide reasons for your assessment.
THE FALL OF ENRON: A STAKEHOLDER FAILURE
Once upon a time, there was a gleaming headquarters
office tower in Houston, with a giant tilted "£"' in front, slowly
revolving in the Texas sun. The Enron Corporation, which once
ranked among...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 26 minutes ago

asked 32 minutes ago

asked 32 minutes ago

asked 33 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago

asked 3 hours ago

asked 3 hours ago