Question

Hello I am having trouble answering these question and do not know how to do it. please help!??

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.

3.) Round your answer four decimal places for each P(x) value.

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?
(Round your answer four decimal places.)?

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?
(Round your answer two decimal places)

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?
(Round your answer two decimal places.)

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

Answer 1

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