Needs to be an excel spread sheet for the problems and the work must be shown for problem 1 and a word document for the second problem. Here is the background and question
The AMS technical services department has embarked on a quality improvement effort. Its first project relates to main- taining the target upload speed for its Internet service sub- scribers. Upload speeds are measured on a standard scale
in which the target value is 1.0. Data collected over the past year indicate that the upload speed is approximately normally distributed, with a mean of 1.005 and a standard deviation of 0.10. Each day, one upload speed is measured. he upload speed is considered acceptable if the measure- ment on the standard scale is between 0.95 and 1.05.
1. Assuming that the distribution has not changed from what it was in the past year, what is the probability that the upload speed is a. less than 1.0?
b. between 0.95 and 1.0?
c. between 1.0 and 1.05?
d. less than 0.95 or greater than 1.05
2.The objective of the operations team is to reduce the probability that the upload speed is below 1.0. Should the team focus on process improvement that increases the mean upload speed to 1.05 or on process improve- ment that reduces the standard deviation of the upload speed to 0.075? Explain.