Lab 02Template

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/16/2008 for the course IS 158 taught by Professor Moffitt during the Spring '08 term at CSU Fresno.

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 Right Arrow Icon
Ask a homework question - tutors are online