Tutorial 1 excel - MICROSOFT EXCEL TUTORIAL 1) Calculations...

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

View Full Document Right Arrow Icon
MICROSOFT EXCEL TUTORIAL 1) Calculations Relative references (C6) - click on the cell - reference will change relative to original position Absolute references ($C$6) - click on cell and hit F4 - reference will remain fixed regardless Example: Fourier's Law q(x) = -kA(dT/dx) ~ -kA (T2-T1)/L Constants: k 20 W/mK Use standard A 0.45 m^2 Examples: L 0.2 m "=sum(cell1 "=average(c T1 (deg C) T2 (deg C) q (W) "=stdev(cell 10 45 -1575 20 53 -1485 30 64 -1530 40 71 -1395 50 77 -1215
Background image of page 1

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

View Full DocumentRight Arrow Icon
2) Graphing In most cases, use "scatter plot" feature as it does not assume any particular trend in the da Highlight data you want to plot (x-variable in column 1, y-variable in column 2) Insert - Scatter - select format you prefer Add legend labels - right click in graph area - Select Data - highlight series name - Edit - add Add axis titles - double click on chart area - Layout - Axis Titles - select alignment - type title Change position of axis labels - right click on axis - Format Axis - change ranges of values, p To add error bars, double click on graph - Layout - Error Bars - More Error Bar Options - Cu Example: q(x) = -kA(dT/dx) ~ -kA (T2-T1)/L
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/24/2010 for the course CHEM ENG 2A04 taught by Professor Toddhoare during the Winter '10 term at McMaster University.

Page1 / 8

Tutorial 1 excel - MICROSOFT EXCEL TUTORIAL 1) Calculations...

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