You will compute the probability of a given event based on t

You will compute the probability of a given event based on the data provided.

The population data base is constant for all questions.

The event changes for each question as indicated.

You must use the correct Excel 2010 function for 100% credit.


x	probability	Event
15	0.08	A = greater than 16
16	0.15	B = less than 20
17	0.10	C = greater than and equal to 17
18	0.13	D = less than and equal to 19
19	0.12	E = greater than 17 and less than and equal to 20
20	0.10
21	0.20
22	0.12

	Event		Probability
Question 9	A
Question 10	B
Question 11	C
Question 12	D
Question 13	E

I have put the given probabilities from B2 to B9 here.

Thus, here are the results:

x	probability	Event
15	0.08	A = greater than 16
16	0.15	B = less than 20
17	0.1	C = greater than and equal to 17
18	0.13	D = less than and equal to 19
19	0.12	E = greater than 17 and less than and equal to 20
20	0.1
21	0.2
22	0.12

	Event		Probability	Formula used
Question 9	A		0.77	=SUM(B4:B9)
Question 10	B		0.58	=SUM(B2:B6)
Question 11	C		0.77	=SUM(B4:B9)
Question 12	D		0.58	=SUM(B2:B6)
Question 13	E		0.35	=SUM(B5:B7)