hwk5 - Hwk 5 (due Tue. 9/15/09) (1) Textbook 1.108, 1.110,...

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

Hwk 5 (due Tue. 9/15/09) (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 instruction that I emailed you Wednesday 9/9 evening). 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. Use the built-in Excel functions to calculate each of the following quantities, and put the answers

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.

This note was uploaded on 11/17/2011 for the course STOR 155 taught by Professor Andrewb.nobel during the Fall '08 term at UNC.

Page1 / 2

hwk5 - Hwk 5 (due Tue. 9/15/09) (1) Textbook 1.108, 1.110,...

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

View Full Document
Ask a homework question - tutors are online