Can you do it in excel! Thank you! Continuing the quality improvement effort, th

Question

Can you do it in excel!
Thank you! Continuing the quality improvement effort, the upload speed for SAMS internet service subscribers has been monitored. As before, 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 speeds are approximately normally distributed, with a mean of 1.005 and a standard deviation of 0.10 6. Each day, at 25 random times, the upload speed is measured. If the distribution has not changed from what 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. Less than 0.95 or greater than 1.05 7. Compare your results in question and question M6. What conclusions can you reach concerning the differences?

Explanation / Answer

6) X: Upload speed.

Mean = 1.005

Standard deviation = 0.10

n = 25

a) we have to find P(X<1)

Use excel function =NORMDIST(1,1.005,0.1,1)

So we get P(X<1) = 0.4801

b) We have to find P(0.95 < X < 1)

P(0.95 < X < 1) = P(X<1) - P(X< 0.95) = 0.4801 - 0.29116 = 0.1889

( Use excel function =NORMDIST(0.95,1.005,0.1,1))

c) We have to find P(X< 0.95) or P(X > 1.05)

We have already find P(X<0.95) = 0.29116

P(X > 1.05) = 1 - P(X<1.05) = 1 - 0.673645 = 0.3264

So P(Less than 0.95 or greater than 1.05) = 0.29116 + 0.3264 = 0.6175

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.