{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lab 02Template

# Lab 02Template - 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 #2 1. Under File, select Page Setup. Select the top tab: Sheet. Due: 2/11/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 8.53, p. 330 Bad Debt Ratios Bad Debt Ratios 7 4 Mean 6 6 Standard Error 0.69 7 Median 6 5 Mode 7 4 Standard Deviation 1.83 9 Sample Variance 3.33 Kurtosis -0.53 Skewness 0.46 Range 5 Minimum 4 Maximum 9 Sum 42 Count 7 Hypotheses: H0: mu <= 3.5 H0: ?? HA: mu > 3.5 HA: ?? Rejection Region: df = 6 Rej H0 if p-value < 0.05 1.94 Test Statistic: 3.62 0.01 Conclusion: with at least 95% confidence. with at least 95% confidence. Implication: conclude that the mean bad debt ratio conclude that the mean bad exceeds 3.5 percent. debt ratio exceeds 3.5 percent. t -Statistic p -value α = 0.05 = 0.05 t -coeff = Rej H0 if t > 1.943 t = p -value = Since the test statistic of t = 3.62284 falls Since the test statistic of

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 / 4

Lab 02Template - 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