Histograms - This will give a crude plot that is easy to...

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

View Full Document Right Arrow Icon
Histograms in EXCEL Get data set in EXCEL – Variable of interest should be in a given column (say, column D with a header row containing a label) Give the set of bin upper points you want for the histogram in another column (say, column G with a header row containing label) Place cursor in data area, select Tools -> Data Analysis -> Histogram. Fill in the Input Range with the cells of the raw data (say D1:D541 for a dataset with 540 observations and a header label) Fill in the Bin Range with the cells giving the upper points of the ranges (say G1:G13 for a histogram with 12 bins and a header label) Click on Labels (Don’t if there is no header row with labels) Click on New Worksheet Ply and Chart Output (then OK )
Background image of page 1

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

View Full DocumentRight Arrow Icon
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: This will give a crude plot that is easy to clean up Click on Chart and stretch it out Right click on a bar (where it says FREQUENCY) and select FORMAT DATA SERIES -> OPTIONS and reduce gap width to 0 Can also vary colors by point (technically RANGE) by clicking on that, then Click OK Further experimentation leads to improvements (e.g. background color by Right clicking on blank part of graph and selecting Format Plot Area Before (Original Output): Histogram 100 200 . rain100 Frequency Frequency Histogram 20 40 60 80 100 120 140 100 300 500 700 900 1100 More rain100 100 200 300 400 500 600 700 800 900 1000 1100 1200 More After (Using only above instructions):...
View Full Document

Page1 / 3

Histograms - This will give a crude plot that is easy to...

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