FInal Project Assessment
coh7482
Probability.xlsxFrequency Table
| MALE DATA | ||
| Participant | Post | Age |
| 1 | Negative | 17 |
| 2 | Positive | 16 |
| 3 | Negative | 17 |
| 4 | Negative | 18 |
| 5 | Negative | 18 |
| 6 | Positive | 17 |
| 7 | Positive | 17 |
| 8 | Positive | 18 |
| 9 | Positive | 17 |
| 10 | Negative | 15 |
| 11 | Negative | 15 |
| 12 | Positive | 17 |
| 13 | Positive | 17 |
| 14 | Positive | 18 |
| 15 | Positive | 16 |
| sum | 253 | |
| Ages | Probability | |
| 16 | 0.3137254902 | |
| 17 | 0.3333333333 | |
| 18 | 0.3529411765 | |
| Lower Limit | 16 | |
| Upper Limit | 18 | |
| PROBABILITY | 1 | |
| FEMALE DATA | ||
| Participant | Post | Age |
| 1 | Negative | 15 |
| 2 | Negative | 14 |
| 3 | Negative | 15 |
| 4 | Negative | 15 |
| 5 | Negative | 15 |
| 6 | Negative | 15 |
| 7 | Negative | 13 |
| 8 | Positive | 16 |
| 9 | Negative | 15 |
| 10 | Negative | 15 |
| 11 | Negative | 15 |
| 12 | Positive | 14 |
| 13 | Negative | 16 |
| 14 | Negative | 15 |
| 15 | Positive | 15 |
| Ages | PROBABILITY | |
| 13 | 0.224137931 | |
| 14 | 0.2413793103 | |
| 15 | 0.2586206897 | |
| 16 | 0.275862069 | |
| 58 | 1 | |
| 13 | ||
| LOWER LIMIT | 16 | |
| UPPER LIMIT | ||
| PROBABILITY | 1 |
Cacluating probability in excel accommodate PROB function indicated as =PROB(range, prob_range, [lower_limit], [upper_limit]). Similarly in detremining the probabaility of male data and ages, there is a significat computataion of porbability as =PROB(A21:A23,B21:B23,B25,B26), giving one. This is becuase we have male data and the probabaility of sleceting male participant in the data set is 1.
Cacluating probability in excel accommodate PROB function indicated as =PROB(range, prob_range, [lower_limit], [upper_limit]). Similarly in detremining the probabaility of female data and ages, there is a significat computataion of porbability as =PROB(A53:A56,B53:B56,B60,B61)giving 1. This is becuase we have female dat variables and the probabaility of sleceting male participant in the data set is 1.
