Question: Please help me with understanding how to calculate in Excel only please. Need elementary help as I am new to this concept. Thank you! The

Please help me with understanding how to calculate in Excel only please. Need elementary help as I am new to this concept. Thank you!

The operations manager at a compact fluorescent light bulb (CFL) factory needs to estimate the mean life of a large shipment of CFLs. The manufacturer's specifications are that the population standard deviation is 1,000 hours. A random sample of 64 CFLs indicated a sample mean life of 7,500 hours.

A)Construct a 95% confidence interval estimate for the population mean life of compact fluorescent light bulbs in this shipment.

B)Do you think that the manufacturer has the right to state that the compact fluorescent lightbulbs have a mean life of 8,000 hours, Explain?

C)Must you assume that the population compact fluorescent light bulb life is normally distributed? Explain?

D)Suppose that the standard deviation changes to 800 hours. What are your answers for (A) & (B)?

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!

Figure 3 shows the mechanism of a radial valve gear. The crank OA turns uniformly at 150 RPM and is pinned at A to rod AB. The point C in the rod is guided in a circular path with D as centre and DC...

Can you share an elementary explanation of how to calculate using Excel please? A hint is listed below. Thank you! The operations manager at a compact fluorescent light bulb (CFL) factory needs to...

Please help, I'm stuck! If you could include the excel charts for reference, that would be much appreciated! Thank you in advance! Using the Excel date file in TA3: Pivot Tables & Decision Support,...

Please Help, I will rate your answer for maximum stars, put a like, and put a good comment! Thank you Please answer fully and provide evidences for following questions: 1. Was it a good idea to hire...

please help me out need answer of question at the end of case (onlye need 200 words answer ) thank you CASE INVOLVING INTERPERSONAL CONFLICT ANALYSIS Educational Pension Investments Educational...

I need help with the Final Project presentation. (The last part) I attached my previous presentations to it as well Milestones 1, 2, 3 and the interview research. Please help, and please cite all...

Please help me answer the following question and use excel for the formulas because I am using this information to write a paper. The company is Starbucks and I am trying to learn this on my own but...

Hi , I have done all the journals and entires in general ledgers as well as subsidiary (subsidairy is matching . problem is in unadjusted trial balance which is not matching please help where my...

Please help, i have answered few and some are wrong, just want to prep myself up for Exams. Thank you! Please try to answer all of them and not just 1 thank you. Which of the following statements...

Please help! Is there a way to do this with Excel? If so , please do it that way. Thank you so much!! Top part of question cut off since we can't upload more than one pic anymore ( sorry about the...

On June 1, 2018, Marigold Company and Swifty Company merged to form Nash Inc. A total of 877,000 shares were issued to complete the merger. The new corporation reports on a calendar-year basis. On...

(a) If Fama Company, with a break-even point at $360,000 of sales, has actual sales of $480,000, what is the margin of safety expressed (1) In dollars and (2) As a percentage of sales? (b) If the...

Evaluate the iterated integral. 0 4 0 y 2 x 2 y d x d y

The finance director for the City of Green Falls printed the General Fund Revenues and Appropriations Ledgers shown below for the year just ended. The beginning-of-the-year fund balance was $160,160....

A. Voltage Measurements at 90 Hz Turn on your function generator. It defaults to a sine wave with a frequency of 1000 Hz. Set the Frequency to 90.000 Hz by using the decade buttons (below 100.000) to...

Eve agrees to sell her boutique to Shelley for $150,000. Shelley spends $60,000 on inventory and fixtures for the store, but then Eve repudiates the contract. Shelley is able to sell the inventory...

This is not a project and/or assignment for marks, as theses are textbook questions, and will not be copying the tutors work/answers. Please answer all the questions in the space provided and in full...

The following pair of assets differ only in the MARR. The problem asks you to determine the effect of this difference on the economic life and to explain the result. All assets decline in value by 20...

Do you think a team contract would improve the effectiveness of teams? Why or why not?

12. Think of a situation where you felt particularly powerless. It must be a real event that you remember relatively well. Try to think back. What was it you imagined just before you felt powerless...

13. Try to imagine how you would feel if you had tackled the problem, the con-flict, the challenge, etc., that made you powerless in task 12, for example upstairs, confident, confident, calm,...

15. Ask yourself the following questions: What do you want to remember from your everyday experiences? These are the experiences that fill most of your life. They may take 9099% of your time. What do...