Questions shown first; click to reveal solutions under each part.
Assume \(X \sim \mathcal{N}(\mu=350, \sigma=12)\).
=NORM.DIST(340,350,12,TRUE), =1-NORM.DIST(360,350,12,TRUE), =NORM.DIST(360,350,12,TRUE)-NORM.DIST(340,350,12,TRUE), =NORM.INV(0.95,350,12), =1-NORM.DIST(375,350,12,TRUE). For counts: mean=800*p, sd=SQRT(800*p*(1-p)).X: T1=<5, T2=5–15, T3=15–30, T4=>30. Y: A=<$10, B=$10–20, C=$20–30, D=$30–40, E=>$40.
| Y \\ X | T1<5 | T2 5–15 | T3 15–30 | T4 >30 | Row Sum | 
|---|---|---|---|---|---|
| A: < $10 | 4 | 3 | 1 | 0 | 8 | 
| B: $10–20 | 2 | 5 | 3 | 1 | 11 | 
| C: $20–30 | 1 | 3 | 4 | 2 | 10 | 
| D: $30–40 | 0 | 1 | 4 | 5 | 10 | 
| E: > $40 | 0 | 0 | 3 | 8 | 11 | 
| Col Sum | 7 | 12 | 15 | 16 | 50 | 
| Day | 1 | 2 | 3 | 4 | 5 | 
|---|---|---|---|---|---|
| X (study) | 3.5 | 4.0 | 5.0 | 6.0 | 6.5 | 
| Y (sleep) | 7.8 | 7.2 | 6.5 | 5.9 | 5.4 | 
End.