Using Excel: LINEST Function, Graph Plotting, and Error Bars, Lecture notes of MS Microsoft Excel skills

Download Using Excel: LINEST Function, Graph Plotting, and Error Bars and more Lecture notes MS Microsoft Excel skills in PDF only on Docsity!

Excel: Using LINEST function, Plotting a

graph, Adding Error Bars

Raghav K Chhetri

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.

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)

Linest Function

Plotting a graph

• Select the x-column first. Hold down the CRTL key and select the y-column next. - Choose XY scatter, under subtype, select the first one as shown

Plotting a graph

• Select ‘As new sheet’. Name the sheet

appropriately.

Plotting a graph

• Highlight the data points, select ‘Add Trendline’

Adding Error Bars

Now that we have the plot, lets add the error bars.

• Select the data points and right click
• Select ‘Format Data Series’

Adding Error Bars

• Click on the ‘X Error Bar’ tab
• Select ‘Both’
• Under ‘Custom’, click on the widget on the right of the + box
• Go back to the data sheet and select the uncertainty in x-values (next slide)

Adding Error Bars

• Repeat the same procedure for putting error bars in the Y direction
• Once done, your graph should look as shown to the right

The End.