{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Tutorial 1 excel

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

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

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

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

View Full Document
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 - Cus Example:
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online