6) Does the dataseem closer to being normal (empirical rule) or not? Use your answers from problems 1-5 above to explain.
7) Your employer, Woodbridge Electric Inc., wants to offer a warranty on the new compact fluorescent light bulb that they have produced and tested. You are called into a meeting and operational experts provide the following data: meanbulb life = 8000 hours, standard deviation= 400 hours (assume a normal distribution). The financial people tell you that the firm cannot afford to replace more than 2.5% of the bulbs under warranty. Some members of the board of directors are pressuring you to come up with a warranty of 7000 hours. The marketing people are pressuring you to create a warranty of 7500 hours. Use the data and adhere to the 2.5% financial constraint above to make your calculations and recommend the highest warranty that you can. What do you recommend as a warranty?
8) Why did you choose this figure as the warranty? What percentage of bulbs would need to be replaced if you chose a warranty of 7000 or 7500? Justify your answer statistically. How do you explain this to the board of directors, marketing people and financial people?
9)The Operational experts of Woodbridge Electric have announced a breakthrough in the production process and the mean of the same bulb has increased to 9000 hours and the standard deviation has decreasing to 200 hours (again assume a normal distribution). Using the same 2.5% constraint how does this affect the warranty? Is this good news or bad for the customers and the firm?
I’ve started this assignment but I need help with questions 6,7,8 & 9. Please be thorough in answers. Is question 5 plot correctly?
Date Sweet Crude $ Brent Crude $
17-May-90 18.89 17.05
18-May-90 18.78 17.08
21-May-90 18.26 16.65
22-May-90 17.51 16.48
23-May-90 16.25 15.7
24-May-90 16.02 15.8
25-May-90 16.12 15.95
29-May-90 18 15.48
30-May-90 17.88 15.98
31-May-90 17.47 15.3
1-Jun-90 17.51 15.43
4-Jun-90 17.09 15.35
5-Jun-90 16.41 14.78
6-Jun-90 16.91 14.8
7-Jun-90 16.65 15.03
8-Jun-90 16.78 14.68
11-Jun-90 16.82 14.73
12-Jun-90 17.39 14.95
1) Use the per-barrel oil price data provided above to create a line chart using Excel that plots both prices. Be sure that the date is on the X-axis and the price in dollars is on the Y-Axis. (Chapter 2)
2) Use the per-barrel oil price data provided above to create a Bar chart using Excel that plots both prices. Be sure that the date is on the X-axis and the price in dollars is on the Y-Axis. (Chapter 2)
3Create descriptive statistics including mean, mode, median, range, high, low, variance and standard deviation for the two different oil prices above. Comment on the similarities and differences. (Chapter 3)Sweet Crude
Date Sweet Crude Descriptive Statistics …
The percentage of bulbs replaced with a warranty are determined. The expert determines how board of directors market to people with warranty.