Question: I've been asked to find the solution via excel. Any assistance would be greatly appreciated. Thank you The quality-control manager at a compact fluorescent light

I've been asked to find the solution via excel. Any assistance would be greatly appreciated. Thank you

The quality-control manager at a compact fluorescent light bulb (CFL) factory needs to determine whether the mean of life of a large shipment of CFL's is equal to 7,500 hours. The population standard deviation is 1,000. A random sample of 64 CFL's indicates a sample mean life of 7,250 hours.

A)At the 0.05 level of significance, is there evidence that the mean life is different from 7,500 hours?

B)Compute the p-value and interpret its meaning?

C)Construct a 95% confidence interval estimate of the population mean life of the CFL's.

D)Compare the results of (A) and (C). What conclusions do you reach?

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

Students Have Also Explored These Related Mathematics Questions!

I've been asked to solve the problem below using Excel. Can you explain the steps for excel and how to best answer each question please? Thank you The operations manager at a compact fluorescent...

Need assistance with calculating in Excel ONLY, when applicable. New to this concept, need an elementary explanation to help grasp. Again, need help with calculating in Excel( Formulas). Thank you!...

Instructions for Students: Answer ONLY part a in Question 4. Questions carry equal marks. You have to show the work to earn marks. Answers must be uploaded on Moodle under Assignment II. Unless...

I've been asked to solve using Excel. Can you please tell me the appropriate functions in excel and briefly explain what is needed with each question? Thank you! The quality-control manager at a...

The TTC has set a bus mechanical reliability goal of 3,800 bus miles. Bus mechanical reliability is measured specifically as the number of bus miles between mechanical road calls. Suppose a sample of...

I need help with the following questions. Done in excel and please show work!! Thank you 9.49 You are the manager of a restaurant that delivers pizza to college dormitory rooms. You have just changed...

Question 36 Homework: Module 7- Fundamental of Hypothesis Testing & Hypo Save Score: 0 of 1 pt 36 of 51 (43 complete) HW Score: 72.09%, 36.77 of 51 pts Instructor-created question Question Help A...

For the exclusive use of M. Xin, 2016. CASE: OIT-71B DATE: 10/15/10 WALMART'S SUSTAINABILITY STRATEGY (B): 2010 UPDATE I don't think there's better money that we're spending anywhere. Fred Krupp,...

Requirements 1. The report is at least five pages long, and please follow APA formatting. 2. Include your name, section, and student ID on the title page. 3. In the report, you should include the...

Calculate the pI of (a) Ala, (b) His, and (c) Glu.

Standardize the NASDAQ column into a new column, z 3 , and conduct a principal component analysis on all three variables (z 1 , z 2 , and z 3 ). a. Calculate the eigenvectors and eigenvalues. b....

On January 1 , 2 0 2 0 , Parent, Inc., acquired a 6 0 percent interest in the common stock of Subsidiary, Inc., for $ 3 8 4 , 6 0 0 . Subsidiary's book value on that date consisted of common stock of...

What are some of the key steps that you believe need to be taken in order to have any meaningful reconciliation with Indigenous peoples, How do you think we are progressing on these commitments?

A job order cost sheet for Lowry Company is shown below. Job No. 92 For 2,000 Units Date Direct Materials Direct Labor Manufacturing Overhead Beg. bal. Jan. 1 6,400 6,300 4,977 8 6,300 12 9,000 7,560...

The sign is subjected to its mass of 130k9 and a wind force of 750N in the x direction. Ignoring the weight of the pole and the horizontal cross member, determine the 6 reactions at the fixed support...

The MSRP on a Nissan Maxima 3.5 SV is $39,625. The interest rate on a 36-month lease is 3.4% compounded monthly. What is the monthly lease payment, assuming a down payment of $6400 and a residual...

Presented below are selected transactions of Blossom Company. Blossom sells in large quantities to other companies and also sells its product in a small retail outlet. March 1 Sold merchandise on...

You are the project manager in charge of developing an app for your most important client due in 10 months for $100,000. After 5 months, your project starts to run behind schedule and over budget and...

1. Discuss the following statements: (a) A circle becomes a straight line when viewed on a very small scale. (b) Breaking patterns creates change.

2. Develop your own loop models for the following conditions. At least one model shall be developed for each of the points under (a-j) a) If A shows anger towards B, what will Bs reaction be? b) What...

1. To gain an understanding of the fact that relationships are something more than only cause and effect chains.