{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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,

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.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online