Question

I need a step by step for entering in excel.

For this assignment, your group will utilize the preliminary data collected in the Topic 2 assignment. Considering the specific requirements of your scenario, complete the following steps using Excel. The accuracy of formulas and calculations will be assessed.

1. Select the appropriate discrete probability distribution. If using a binomial distribution, use the constant probability from the collected data and assume a fixed number of events of 20. If using a Poisson distribution, use the applicable mean from the collected data.
2. Identify the following: the probability of 0 events occurring, the probability of <5 events occurring, and the probability of ≥10 events occurring.
3. Using the mean and standard deviation for the continuous data, identify the applicable values of X for the following: Identify the value of X of 20% of the data, identify the value of X for the top 10% of the data, and 95% of the data lies between two values of X.

Answer 1

Sol:

1).

	20	n
	0.4	p
		cumulative
X	P(X)	probability
0	0.00004	0.00004
1	0.00049	0.00052
2	0.00309	0.00361
3	0.01235	0.01596
4	0.03499	0.05095
5	0.07465	0.12560
6	0.12441	0.25001
7	0.16588	0.41589
8	0.17971	0.59560
9	0.15974	0.75534
10	0.11714	0.87248
11	0.07099	0.94347
12	0.03550	0.97897
13	0.01456	0.99353
14	0.00485	0.99839
15	0.00129	0.99968
16	0.00027	0.99995
17	0.00004	0.99999
18	0.00000	1.00000
19	0.00000	1.00000
20	0.00000	1.00000
	1.00000
	8.000	expected value
	4.800	variance
	2.191	standard deviation

2)

. 0 = 0.00004

< 5 = 0.05095

10 = 0.24466

3).

		cumulative
X	P(X)	probability
0	0%	0%
1	0%	0%
2	0%	0%
3	1%	2%
4	3%	5%
5	7%	13%
6	12%	25%
7	17%	42%
8	18%	60%
9	16%	76%
10	12%	87%
11	7%	94%
12	4%	98%
13	1%	99%
14	0%	100%
15	0%	100%
16	0%	100%
17	0%	100%
18	0%	100%
19	0%	100%
20	0%	100%

X of 20% = 6

X of top 10% = 11

95% = 4 < X < 12