explain

how you got the variance, ID, and SD

using excel

Probability Distribution We are now going to use Excel to make a probability table and find the mean and sd. We would like to know how many pets people have in an apartment bullding called Pets Paradise. A survey completed by all apartment residents show that there are 84 apartments with no pets, 35 apartments with 1 pet and 11 apartments with 2 pets. We put our data in rows 1 and 2 . In Cell A1 we type pots and in cell A2 we type apartments. Now we type our data, O in B1,1 in Cl,2 in D1,84 in B2,35 in C2 and 11 in D2. Second row is frequencies and you will now make it probabilities. First let's get our population size. Enter population slzo in F1 and enter =b2+c+d2 in F2. Probability table will be located in rectangle A4-D5. First enter X(pets) in A4 and P(X) in A5. Now enter 0 in BA, 2 in CA, 2 in D4. Then enter =82/F2 in 85 . Exercise 1. Complete this probability table. Exercise 2. Verify that area A4-DS represents a probability distribution. Are all probabilities in 85,C5 and 05 nonnegative? Enter yes or no in cell G5. is the sum I of all probablities equal to 1 ? Enter sum in F4 and evaluate the sum of all probabilities in cell F5. Enter probalility distribution or not a probability distribution in HS, Now we start worldng on mean and sd. We will move our data into vertical format. Enter p(x) in A7 and X in B7. Enter =b4 in b8,=64 in B9 and =d4 in b10. Similarly, enter ab5 in a8,=05 in 29 and =d5 in a10. Enter MEAM in a12 and in C7, and calculate mean in B12 by entering formula. =AB8+A9B9+A10B10 Enter 10 in d7 and 510 in e7. Exercise 3. Complete the table in the rectangle a7.e10. Enter VasiMnef in a13 and SD in A14