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!
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
Get Answers For Free
Most questions answered within 1 hours.