hwk4 - Hwk 4(due Thur(1 Textbook 1.70 1.88 1.89 1.92 1.94(2...

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

View Full Document Right Arrow Icon
Hwk 4 (due Thur. 9/10/09) (1) Textbook: 1.70, 1.88, 1.89, 1.92, 1.94 (2) Excel work (only turn in the templates) (2a) Read Excel Manual page 33-34 about boxplots. Input data from the Excel file ``2004_CAR’’ at the Blackboard site, and draw side-by-side boxplots for city vs highway. Be sure you check the ``Identify Outliers’’ on the graph box so any outliers can be shown. Hand in the single- page template. (2b) Read Excel Manual page 25-28 about histograms. Input data from the Excel file ``ta01_007’’ (Table 1.7 in the textbook) at the Blackboard site, then do the following: We only need the data in cells B1:B51 (just delete the ``reading’’ in column C). Create a histogram. Begin by entering the bin values (62, 63, . .., 67) in cells C2:C7, below the column title "My Bins" in cell C1. The "Output Range" should be D1, so you will automatically get from Excel an additional column with the title "Bin" in column D. Modify your histogram: remove the legend, close all gaps between bars, include one decimal place in the horizontal axis values (62.0, 63.0,
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 11/17/2011 for the course STOR 155 taught by Professor Andrewb.nobel during the Fall '08 term at UNC.

Page1 / 2

hwk4 - Hwk 4(due Thur(1 Textbook 1.70 1.88 1.89 1.92 1.94(2...

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