Excel Histogram and Inverse Rate Cooling Curve Tutorial

Excel Histogram and Inverse Rate Cooling Curve Tutorial - A...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Histogram and Inverse Rate Cooling Curve Tutorial This tutorial will demonstrate how to create a histogram with bins for every 0.1°C using MS Excel 2003. The steps should be similar for other versions of the software. Follow along using file ethanandrewlarryFC-L1.xls. 1. Open the file in Excel. 2. Delete the furnace overheating data. I deleted the first 84 entries so that my first data point is numbered 85. 3. Make a bin column in column D (cell D13 if you look at what I did) starting with the highest temperature. Create a formula in cell D14 by typing ‘=D13- 0.1’. Drag the formula box down until you go below the lowest temperature of interest. You do not need to go all the way to room temperature, but go at least 20°C below the lowest transformation shown on the phase diagram. 4. Click the ‘tools’ drop down menu and go to ‘data analysis.’
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: A pop-up window will appear. Select ‘histogram.’ If you do not see ‘data analysis’ in your ‘tools’ drop down, you need to install the data analysis pack from your install disks. 5. After you click histogram, the histogram window will open. In the input range box, you need to put the data column you are interested in. Choose the data (not the text) contained in column B. In the bin range box, choose the data in column D. In the box labeled new worksheet, choose a name for this histogram. I chose 35Bi for obvious reasons. Make sure you have the tick box ‘chart output’ checked. 6. You should have your histogram and plot now. You can right click on the plot, select location, and choose new sheet. This will give you a much larger view of the plot. 7. Repeat for the composition at T2....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online