ENGR131_FA10_Purzer_4b - 4B Click to edit Master subtitle...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style 4/24/11 ENGR131 Transforming Ideas to Prof. Purzer & GTA Masaki Kakoi Section 002 11 4B
Background image of page 1

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

View Full DocumentRight Arrow Icon
4/24/11 Creating Histograms in Excel Check to see if Data … Data Analysis is available To make available: Click the Microsoft Office Button , and then click Excel Options Click Add-Ins In the Manage box, click Excel Add-ins , and then click Go In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK Mac Users – Excel 2008 for Mac does not have a histogram tool (not even through an add-in). You can make histograms manually, but it is easier to use Software Remote to access
Background image of page 2
4/24/11 Creating Histograms in Excel Need to identify: Input Range - Range of cell addresses containing the data being analyzed Bin Range - Range of cell addresses containing the right-hand-side values of the bins you plan to use (bin ranges are “right bounded” in Excel) Output Range - Upper-left cell in range where you wish results to be placed Chart Output - Must be checked, otherwise you get only table of values, no graphic output October 22, Note the scale on the x-axis : You can format the x-axis labels at +45º. This will place the labels closer to the right
Background image of page 3

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

View Full DocumentRight Arrow Icon
4/24/11 Exercise Download the file 4B_histogram_template.xlsx from the In- Class Activities folder on Blackboard.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/23/2011 for the course ENGR 131 taught by Professor Purzer during the Fall '10 term at Purdue University-West Lafayette.

Page1 / 22

ENGR131_FA10_Purzer_4b - 4B Click to edit Master subtitle...

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

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