Lab 01Template

Lab 01Template - 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 #1 1. Under File, select Page Setup. Select the top tab: Sheet. Due: 2/04/08 In the Print window, select Gridlines and Row and Column Headers. 2. Set column A to width 10 and columns C, E, and F width to 12. Question 1. Problem 5.30, p. 216 x-value Equations z-score a. Lower bound 7 =(D7-8)/.5 -2 Upper bound 9 =(D8-8)/.5 2 =NORMSDIST(F8)-NORMSDIST(F7) 0.95 b. x-value Equations z-score Lower bound 8.5 =(D13-8)/.5 1 Upper bound 9.5 =(D14-8)/.5 3 =NORMSDIST(F14)-NORMSDIST(F13) 0.16 c. x-value Equations z-score Lower bound 6.5 =(D19-8)/.5 -3 Upper bound 7.5 =(D20-8)/.5 -1 =NORMSDIST(F20)-NORMSDIST(F19) 0.16 d. x-value Equation z-score Bound 8 =(D25-8)/.5 0 =1-NORMSDIST(F25) 0.5 e. x-value Equation z-score Bound 7 =(D30-8)/.5 -2 =NORMSDIST(F30) 0.02 f. x-value Equation z-score Bound 7 =(D35-8)/.5 -2 =1-NORMSDIST(F35) 0.98 g. x-value Equation z-score Bound 10 =(D40-8)/.5 4 =NORMSDIST(F40) 1 h. x-value Equation z-score Bound 10 =(D45-8)/.5 =1-NORMSDIST(F45) Question 2. Problem 6.13, p. 250
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 lab report was uploaded on 04/16/2008 for the course IS 158 taught by Professor Moffitt during the Spring '08 term at CSU Fresno.

Page1 / 2

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