exceltutorial - Excel: Using LINEST function, Plotting a...

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

View Full Document Right Arrow Icon
Excel: Using LINEST function, Plotting a graph, Adding Error Bars Raghav K Chhetri 01/24/2009
Background image of page 1

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

View Full DocumentRight Arrow Icon
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.
Background image of page 2
Under the Insert Tab, select Function. Then, make the selections as shown below. Hit OK.
Background image of page 3

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

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

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

View Full DocumentRight Arrow Icon
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
Background image of page 6
Linest Function
Background image of page 7

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

View Full DocumentRight Arrow Icon
Select the x-column first. Hold down the CRTL key and select the y-column next. • Choose XY scatter, under
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online