Question: please show all work for thumbs up with answer NU COUNTY 1 2 # OF OUTAGES 14 5 24 20 18 3 4 SAMPLE SIZE

please show all work for thumbs up with answer

NU COUNTY 1 2 # OF OUTAGES 14 5 24 20 18 3 4 SAMPLE SIZE 750 750 750 750 750 750 750 750 5 6 7 8 750 750 750 9 10 11 12 13 14 15 750 32 16 17 12 7 17 15 17 14 10 24 8 17 10 24 40 16 17 18 19 750 750 750 750 750 750 750 750 750 20 21 Copy the data into Excel. Make sure to show your calculations in Excel 1. Calculate the outage rate (percent of broken street lights sampled) for each county: 2. What type of control chart should be created to evaluate the street light outages? 3. Find the center line. UCL and Cl. for a 95 percent conhdence (at Z-1.96) control chart, 4. Graph the control chart including the outage rates for each county, the center line, UCL and LCL (Preferably complete this in Excel. However, I will accept o neatly drown graph thot clearly depicts all data points and lines) 5. Is the process in control? Are there inconsistencies in the street light outages across the state? Why or why not

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 General Management Questions!

Bloomberg CASEO Businessweek STUDIES 4 Weighted Average Cost of Capital Analyze how the theoretical concepts This lesson explores how several companies and industries are of weighted average cost of...

Please show your work. Also show the excel functions. H Adjustable Rate Mortgage Excel Assignment 3 Consider the following information and answer each of the questions below using arithmetic,...

!! Please Show ALL Work !! !! Please answer C and D !! George Clausen ( age 48 ) is employed by Kline Company and is paid an annual salary $42,536. He has just decided to join the company's Simple...

Please answer the orange/ highlighted areas utilizing the Excel function and formula. Thank You! C28 A F H K L L M M N N o R S T U - fx INCOME STATEMENTS - Baker Fruit Drinks - Years Ending December...

The first completed picture is the first part that has already been completed. It's just there if you need help with the second part. Could you please post the formulas from excel as well? Thank you...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

In an effort to improve the civil services that are provided in the state of NJ, an intense effort has begun to identify locations where street lights are currently not working and to determine if...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

Instructions: Please provide your discussion and stepbystep howto guide on the problems below. Work must be presented on a Word File but you need an excel file to show work. Use Illustrations from...

Final Exam - HIMS 650 Fall 2015 SOLUTIONS Directions: Please answer all questions. There are 14 questions and the exam is worth 25% of your total grade. The questions are not equally weighted. The...

The local RCMP detachment monitors the average speed on one of our busy highways in the province. The detachment wants to find whether the mean speed is more than 110 km/h. A random speed check of 62...

1.1. 1.2. 1.3. 1.4. Consider the following four bonds given in the table below, where coupons are paid out once per year: Bond A B C D Maturity 1 2 3 4 Coupon Rate 1% 5% 0% 10% Price, $ 926.6055...

The business loan pricing method which starts with a base rate such as a bank's prime rate and adds a markup for default and term risk is known as what?

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...