Question

Using the table below, find the Probability of Ordering as a decimal and percent. Please show your work and formulas you would use in excel.

# of pizzas ordered	# of customers who ordered	Probability of ordering (decimal value)	Probability of ordering (as a percent)
1	8
2	9
3	6
4	1
5	0
6	0
7	0
8	0
Sum total	24

Answer 1

Paste in A1 exactly in a new excel sheet.

# of pizzas ordered	# of customers who ordered	Probability of ordering (decimal value)	Probability of ordering (as a percent)
1	8	=B2/$B$10	=B2/$B$10
2	9	=B3/$B$10	=B3/$B$10
3	6	=B4/$B$10	=B4/$B$10
4	1	=B5/$B$10	=B5/$B$10
5	0	=B6/$B$10	=B6/$B$10
6	0	=B7/$B$10	=B7/$B$10
7	0	=B8/$B$10	=B8/$B$10
8	0	=B9/$B$10	=B9/$B$10
Sum total	24	=SUM(C2:C9)	=SUM(D2:D9)

# of pizzas ordered	# of customers who ordered	Probability of ordering (decimal value)	Probability of ordering (as a percent)
1	8	0.333333	33.3333%
2	9	0.375000	37.5000%
3	6	0.250000	25.0000%
4	1	0.041667	4.1667%
5	0	0.000000	0.0000%
6	0	0.000000	0.0000%
7	0	0.000000	0.0000%
8	0	0.000000	0.0000%
Sum total	24	1.000000	100.0000%

Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!