histogram - are included in the Input Range and Bin Range ....

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

View Full Document Right Arrow Icon
1. Histogram Select Tools > Data Analysis from the main Excel menu bar. This will bring up the window below. Select Histogram from this window. The histogram window should now appear as shown below.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The following needs to be filled in: The Input Range is the cell addresses of the data. The Bin Range is the cell addresses of the classes. Check the Labels box because the labels
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: are included in the Input Range and Bin Range . • Select Output Range and give a cell address where you want the frequency distribution to be put in the spreadsheet • Check the Chart Output box. This will produce a plot called a “histogram”. The completed window should look like the following:...
View Full Document

This note was uploaded on 02/07/2012 for the course BUS 265 taught by Professor Kim during the Summer '11 term at Minnesota.

Page1 / 3

histogram - are included in the Input Range and Bin Range ....

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online