RelativeResourceManager111

- Next indicate the data ranges and options for this “histogram tool”… 6 Prof Victor B Marshall Based on the options selected Excel then

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

View Full Document Right Arrow Icon
6/7/09 1 Prof. Victor B. Marshall How to Create Histograms in Excel Prof. Victor B. Marshall
Background image of page 1

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

View Full DocumentRight Arrow Icon
6/7/09 2 Prof. Victor B. Marshall First, create a table with the data for the histogram. In this case, I have also calculated the average, min and max for each row as well as for the full data set…
Background image of page 2
6/7/09 3 Prof. Victor B. Marshall Next, select the “data analysis…” option from the tools menu. You may have to install this option from the Excel CD…
Background image of page 3

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

View Full DocumentRight Arrow Icon
6/7/09 4 Prof. Victor B. Marshall Next, select the histogram tool…
Background image of page 4
6/7/09 5 Prof. Victor B. Marshall
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Next, indicate the data ranges and options for this “histogram tool”… 6/7/09 6 Prof. Victor B. Marshall Based on the options selected, Excel then generates a table (not show), and a graph (shown below). As indicated, this data appears to follow a normal (bell shaped) distribution… 6/7/09 7 Prof. Victor B. Marshall Using a special package (not included in Excel), it can be seen that this data does in fact closely follow a normal distribution with a mean of 49.23 and a standard deviation of 9.82…...
View Full Document

This note was uploaded on 11/15/2011 for the course MGT 3200 taught by Professor Moodie during the Fall '08 term at Kennesaw.

Page1 / 7

- Next indicate the data ranges and options for this “histogram tool”… 6 Prof Victor B Marshall Based on the options selected Excel then

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

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