Business Statistics Discussions(2) and 1 Assignment
KAYT
HmwkAssignCalculations.xlsxCI_calculation
| Confidence Interval (C.I.) on difference between two proportions | |||||||||||
| Treadmill | Exercise Bike | ||||||||||
| p1 | 0.3621621622 | p2 | 0.4471544715 | ||||||||
| q1 | 0.6378378378 | q2 | 0.5528455285 | ||||||||
| n1 | 185 | n2 | 123 | ||||||||
| Service contract | 67 | Service contract | 55 | ||||||||
| zc | 1.96 | 95% Confidence Level | zc | 1.96 | |||||||
| sigma(p1) | 0.0692591064 | sigma(p2) | 0.0878687008 | ||||||||
| 0.2929030558 | <= | p1 | <= | 0.4314212685 | 0.3592857707 | <= | p2 | <= | 0.5350231724 | ||
| Sigma(p1-p2) | 0.1118826725 | ||||||||||
| Proportion difference | -0.0849923094 | ||||||||||
| Confidence Interval | Min | max | |||||||||
| -0.1968749819 | 0.0268903631 |
