Question: Course OPRE: 506 Course Material: Book: Title: Statistics for Managers Using Microsoft Excel Authors: Levine, David M., Stephan, David F. and Szabat, Kathryn A. Edition:

Course OPRE: 506

Course Material:

Book: Title: Statistics for Managers Using Microsoft Excel

Authors: Levine, David M., Stephan, David F. and Szabat, Kathryn A.

Edition: 9th Year: 2021

Publisher: Pearson

Instructions must follow:

- Do not use any artificial intelligence tools (ChatGPT or any other similar software) to answer problems.

- Include all details and steps performed to find your answers.

- Must do STEP by Step Solutions properly.

Please answer the following questions giving all details.

1. The manager of a grocery store claims that the mean shopping time in her store is 20 minutes. In a sample of 100 shoppers at that grocery store, the mean shopping time was 21.50 minutes with a standard deviation of 5.50 minutes. Using the 0.05 level of significance, is there evidence that the mean shopping time at the grocery store is different from the claimed value of 20 minutes?

a. State the null and alternative hypothesis for this problem.

b. Determine the sample test statistic value for this problem.

c. Determine the critical test statistic value for this problem.

d. What is your statistical decision for this problem?

2. The operations manager at a light bulb factory wants to determine whether there is any difference in the mean life expectancy of bulbs manufactured on two different types of machines. A random sample of 25 light bulbs from machine I indicates a sample mean of 400 hours and a sample standard deviation of 100 hours. A similar sample of 25 light bulbs from machine II indicates a sample mean of 410 hours and a sample standard deviation of 110 hours. For this problem:

a. What is the value of the pooled-variance tSTAT test statistic for testing H0: 1 = 2?

b. In finding the critical value, how many degrees of freedom are there?

c. Using the level of significance = 0.01, what is the critical value for a one-tail test of the hypothesis H0: 1 < 2 against the alternative H1: 1 > 2?

d. What is your statistical decision?

3. To test the effectiveness of a business school preparation course, 10 students took a general business test before and after the course. The results are given below.

Student

Exam Score

Before the Course

Exam Score

After the Course

1640790
2700790
39201,020
4760730
5460570
6850880
7830790
8640630
9590605
10680780

a. Use an appropriate hypothesis test, at 0.05 level of significance, to determine whether there is evidence of a difference between before and after scores of the students.

b. What assumption is necessary to perform the hypothesis test in (a)?

c. Construct a 95% confidence interval estimate of the mean difference in before and after scores. Interpret the interval. What is your decision based on this confidence interval estimate?

4. The following information is available for two samples selected from independent normally distributed populations.

Population A: n1 = 25, S1 = 7.5

Population B: n2 = 20, S2 = 6.4

a. At the 0.05 level of significance, is there evidence of a difference between 12 and 22?

b. Suppose that you want to perform a one-tail test. At the 0.05 level of significance, what is the upper-tail critical value of F to determine whether there is evidence that? What is your statistical decision?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock