# exceltutorial - Excel Using LINEST function Plotting a...

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

Excel: Using LINEST function, Plotting a graph, Adding Error Bars Raghav K Chhetri 01/24/2009

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

View Full Document
Using LINEST function NOTE: I mistakenly put (m) for the unit of time. • Lets start with a table for time and velocity as shown on the right. • LINEST function returns several outputs, so to begin with, select a 2 by 5 array as shown.
Under the Insert Tab, select Function. Then, make the selections as shown below. Hit OK.

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

View Full Document
Select the y-values and x-values from the table. Write ‘TRUE’ for the last two boxes. Hit OK.
Now, highlight the formula in the formula bar. Press Ctrl+Shift simultaneously and hit Enter (Mac users, press Command and hit Enter)

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

View Full Document
Linest Function The array we selected earlier is now filled with numbers as shown to the right Lets see what some of these numbers mean
Linest Function

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

View Full Document
Select the x-column first. Hold down the CRTL key and select the y-column next. • Choose XY scatter, under
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 03/26/2010 for the course PHYS 116L taught by Professor Rowan during the Fall '10 term at University of North Carolina Wilmington.

### Page1 / 17

exceltutorial - Excel Using LINEST function Plotting a...

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

View Full Document
Ask a homework question - tutors are online