Question

# Hello I am having trouble answering these question and do not know how to do it....

1a.Central Perk coffee shop wanted to know how many customers they serve after 5pm. They have decided to collect data for four months, indicating the number of customers during these dates and they published the results in the table below.

 Number of Customers 0 10 20 30 40 50 60 Frequency 17 15 20 25 20 15 8 Probability P (x)

Fill in the P(x) row for the table above.
1.) Please click the box right of P (x).

2.) Only type and key in the decimal values that you calculated for each box entry.

1b.Central Perk coffee shop wanted to know how many customers they serve after 5 pm. They have decided to collect data for four months, indicating the number of customers during these dates and they published the results in the table below.

 Number of Customers 0 10 20 30 40 50 60 Frequency 17 15 20 25 20 15 8 Probability P (x) [a] [b] [c] [d] [e] [f] [g]

After you calculated P (x) values for the table above;

What is the probability that a randomly selected date will have 30 or more customers after 5 pm?

1c.Central Perk coffee shop wanted to know how many customers they serve after 5 pm. They have decided to collect data for four months, indicating the number of customers during these dates and they published the results in the table below.

 Number of Customers 0 10 20 30 40 50 60 Frequency 17 15 20 25 20 15 8 Probability P (x) [a] [b] [c] [d] [e] [f] [g]

After, you calculated the P(x) values for the table above;

What is the expected number of customers during these four months in Central Perk coffee shop after 5 pm?

1d.Central Perk coffee shop wanted to know how many customers they serve after 5 pm. They have decided to collect data for four months, indicating the number of customers during these dates and they published the results in the table below.

 Number of Customers 0 10 20 30 40 50 60 Frequency 17 15 20 25 20 15 8 Probability P (x) [a] [b] [c] [d] [e] [f] [g]

After you calculated P(x) values for the table above;

What is the standard deviation of this data distribution indicating Central Perk coffee shop?

I need to know how to put the answers in  Excel commands if you can please. Thank you!

a)

 Number of customers Frequency Probability 0 17 17 / 120 = 0.1417 10 15 15 / 120 = 0.125 20 20 20 / 120 = 0.1667 30 25 25 / 120 = 0.2083 40 20 20 / 120 = 0.1667 50 15 15 / 120 = 0.125 60 8 8 / 120 = 0.0667 Total 120 1.00

b) probability that a randomly selected date will have 30 or more customers after 5 pm = 68/120

= 0.5667

c)

 Number of customers Frequency, f fx fx² 0 17 0 0 10 15 150 1500 20 20 400 8000 30 25 750 22500 40 20 800 32000 50 15 750 37500 60 8 480 28800 Total 120 3330 130300

Mean, μ = ∑fx / n = 3330/120 = 27.75

d)

Standard deviation, σ = √((∑fx² - (∑fx)²/n)/(n)) = √((130300 - 3330²/120)/(120)) = 17.7699 = 17.77

#### Earn Coins

Coins can be redeemed for fabulous gifts.