STAT200 Chamberlain College of Nursing Poison Distribution Excel Formula

STAT200 Chamberlain College of Nursing Poison Distribution Excel Formula

I need a excel document with formulas on discreat probability, distribution with technology-(excel) and poison distribution.

Below is the example for the distribution with technology question that I need to answear, I need a excel with formula that I can just input the value.

A researcher asked

1,000
randomly selected people to pick a number between

1
and

20
. Let

X
represent the number picked. The table below shows the probability distribution of the data. Find the mean and the standard deviation of the probability distribution using Excel.

• Round the mean and standard deviation to one decimal place.

x

P(x)

1

0.048

2

0.045

3

0.049

4

0.046

5

0.048

6

0.053

7

0.050

8

0.048

9

0.054

Help
Copy to Clipboard
Download CSV

---

Provide your answer below:

---

$$mean=, standard deviation=