hwk5 - Hwk 5 (due Wed. 5/18/11) (1) Textbook 1.108, 1.110,...

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

View Full Document Right Arrow Icon
Hwk 5 (due Wed. 5/18/11) (1) Textbook 1.108, 1.110, 1.111: For each density curve, identify which point marks the mean, the median, and also the mode. 1.114 (2) Excel Work (Only turn in the template) Read the Excel Manual pages 30 – 32: the part regarding numerical measures … Make sure ``Analysis ToolPak’’ is activated in your Excel Add-Ins (following the instructions given in Excel add-ins.doc at the Bb site). You should be comfortable with both methods of accessing Excel's built-in functions: (i) Typing the function directly into the cell, or (ii) Selecting the function from the "Insert Function" menu. Now open a new worksheet and input the data-set from Textbook Table 1.9 (page 29), found in file ta01_009 at the Blackboard site. Put the GPA data in column A, with the label "GPA" in cell A1; delete all the other columns of data. Sort the GPA data in ascending order, so that you can easily determine what the median is; type the value of the median into cell E5.
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.

Page1 / 2

hwk5 - Hwk 5 (due Wed. 5/18/11) (1) Textbook 1.108, 1.110,...

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