please show steps in excel. thanks Problem 05-32 Algo (Continuous Probability Di

Question

please show steps in excel. thanks

Problem 05-32 Algo (Continuous Probability Distributions) Assume that the traffic to the web ( ion vistors in a sinole day? If needed, round vour answer to four decimial dioits. (b) What is the probability that the web site has 3 million or more visitors in a single day? If ne (c) what is the probability tat the web site has between 3 milio b site of Smiley's People, Inc., which sells customized T-shirts, follows a normal distribution, with a mean of 4.52 million visitors per day and a standard deviation of 880,000 visitors per day bability that the web site has fewer than 5 million visitors in a single day? If needed, round your answer to four deoimal digits eded, round your answer to four decimal dioits. n and 4 million visitors in a single day? If needed, round your answer to four decimal digits daily web traffic volume without purchasing additional server capacity. What is the amountof web traffic that will require Smiley's Peopie to purchase add d) Assume that 85% of the time, the smiley's People web servers can handle the round your answer to two decimal digits 0 Ieon Key Problem o5-32 Algo (Continuous Probability Distributions)

Explanation / Answer

(a) To find the P(X<5).

solution: steps in excel

Excel work : =NORM.DIST(5,B1,B2,1)

(b)

Excel work : =1-NORM.DIST(3,B1,B2,1)

(c)

Excel work : =NORM.DIST(4,B1,B2,1)-NORM.DIST(3,B1,B2,1)

Here, B1 denotes mean and B2 denotes standard deviation.

mean 4.52 sd 0.88 P(X<5) 0.70728

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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