{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lab 04Template

# Lab 04Template - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

This preview shows pages 1–2. Sign up to view the full content.

Bradley Kendzora INSTRUCTIONS: DS 123 Lab #4 1. Under File, select Page Setup. Select the top tab: Sheet. Due: 3/10/08 In the Print window, select Gridlines and Row and Column Headers. 2. Set column A to width 10 and column C to 16. 3. Insert a page break above row 46. Question 1. Problem 9.22, p. 369-370 Miller's t-Test: Two-Sample Assuming Equal Variances \$119.25 \$121.32 Miller's Albert's \$122.34 Mean 121.92 114.81 \$120.14 Variance 1.96 3.39 \$122.19 Observations 10 10 \$123.71 Pooled Variance 2.67 \$121.72 Hypothesized Mean 0 \$122.42 df 18 \$123.63 t Stat 9.73 \$122.44 P(T<=t) one-tail 0 t Critical one-tail 2.55 Albert's P(T<=t) two-tail 0 \$111.99 t Critical two-tail 2.88 \$114.88 \$115.11 \$117.02 \$116.89 Hypotheses: H0: mu M - Mu A = 0 H0: mu M - Mu A =0 \$116.62 HA: mu M - Mu A /= 0 HA: mu M - Mu A =/0 \$115.38 \$114.40 Rejection Region: \$113.91 df = 18 Rej H0 if p-value < 0.01 \$111.87 2.88 2.88 Test Statistic: 9.73 p-value = 0 Conclusion: Since the test statistic of with at least 99% confidence. H0 with at least 99% confidence. Implication: conclude that the mean weekly expenses conclude that the mean weekly at Miller's and Albert's differ. expenses at Miller's and Albert's differ.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 2

Lab 04Template - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online