5.1_Homework_Excel_Notes

Question 1 Determine if the following is a random variable: Social security numbers assigned sequentially. "sequentially" Not a random varible Question 2 Determine if the following is a random variable: Housing market prices. Housing market are g Random variable Question 3 Determine if the following is a random variable: The final grade of a student enrolling in a course. We don't know the st Too many variables to Random variable

Question 4 Determine if the following is a random variable: Number of customers defaulting on home mortgages. Random variable Question 5 Consider the following table representing enrollment into a particular course. Enrollment Odds Number of Students Enrolled Probability of Achieving Enrollment 27 0.27 28 0.31 29 0.41 30 0.27 Each outcome is within 0 and 1 Sum is 1.26 > 1 , so… No because the sum of the probabilities is not approximately 1. Impossible to determ Does the table meet the requirements of a probability distribution ? 1. Check th 2. Check th

5 0.00000124197 6 0.000000019206 7 0.000000000169711 8 0.0000000000006561 Question 8 Probability of Defective Units Number of Units Defective Probability 0 0.783743359 1 0.193915883 2 0.020990895 → 3 0.001298406 4 0.0000501961 5 0.00000124197 6 0.000000019206 7 0.000000000169711 8 0.0000000000006561 x = Number of Units p(x) = Defective Probability x * p(x) = What are the expected number of computers defective in the shipment? Number of Units x Defective Probability

↓ x * p(x) = Number of Units x Defective Expected value = Sum of each "x * p(x)" value

Sum of probabilty must = 1 → must add up to 1, similar to how each percen ..so =SUM(C77:C80) → 1.260000000 > Total probability is over 1 mine exactly how many people will default on their mortgages he sum of the probability If not excatly 1 , then it doest not meet the requirements of a probability distribution hat each probability is Between 0 and 1 * Cannot be negative * Cannot be over 1.0

Sum of probabilty must = 1 → must add up to 1, similar to how each percen ..so = SUM(C102:C110) → 1.000000000 = babilities being approximately 1. we need to put the probability from decimal form to percentage from Answer 0.783743359 x 100% 78 epresents the odds that a given number of computers in the shipment would be defective. he sum of the probability If not excatly 1 , then it doest not meet the requirements of a probability distribution hat each probability is Between 0 and 1 * Cannot be negative * Cannot be over 1.0 able, the probability of 0 units having a defect is 0.783743359 =

Probability

ntages must add to 100% 1

The Total sum of each answer after muliplying x and p(x) together ↓ Expected Value 0.240000002 st be in decimal form

Paste chart into this cell ↓ Number of Units Defective Probability 0 0.783743359 1 0.193915883 2 0.020990895 3 0.001298406 4 0.0000501961 5 0.00000124197 6 0.000000019206 7 0.000000000169711 8 0.0000000000006561 ↓ x p(x) x * p(x) 0 0.783743359 0 1 0.193915883 0.193915883 2 0.020990895 0.04198179 3 0.001298406 0.003895218 4 0.000050196 0.0002007844 5 0.000001242 6.20985E-06 Anwser 6 0.000000019 1.152342E-07 0.24 7 0.000000000 1.187977E-09 8 0.000000000 5.2488E-12 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 Multiply x and probability p(x) together *Answer must

* For notes for personal use to help determine each variable x = Number of Units p(x) = Defective Probability x * p(x) = Number of Units x Defective Probability ↓ x * p(x) = Expected value = Add each "x * p(x)" value into a sum total The Total sum of each answer after muliplying x and p(x) together ↓ Expected Value 0.240000002 Number of Units x Defective Probability be in decimal form

Paste chart into this cell ↓ ↓ x p(x) x * p(x) 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 Anwser 0 0.000000000 0 0.00 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 0 0.000000000 0 Multiply x and probability p(x) together *Answer must

* For notes for personal use to help determine each variable x = p(x) = x * p(x) = x ↓ x * p(x) = Expected value = Add each "x * p(x)" value into a sum total The Total sum of each answer after muliplying x and p(x) together ↓ Expected Value 0.000000000 be in decimal form