excel 2003 tutorial 4 graphs
TRANSCRIPT
![Page 1: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/1.jpg)
Excel: Using LINEST function, Plotting agraph, Adding Error Bars
Raghav K Chhetri01/24/2009
![Page 2: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/2.jpg)
Using LINEST function
NOTE: I mistakenly put (m) for the unit of time.
• Lets start with a tablefor time and velocity asshown on the right.
• LINEST functionreturns several outputs,so to begin with, select a2 by 5 array as shown.
![Page 3: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/3.jpg)
Under the Insert Tab, select Function. Then, make theselections as shown below. Hit OK.
![Page 4: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/4.jpg)
Select the y-values and x-values from the table.
Write ‘TRUE’ for the last two boxes. Hit OK.
![Page 5: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/5.jpg)
Now, highlight the formula in the formula bar.
Press Ctrl+Shift simultaneously and hit Enter (Macusers, press Command and hit Enter)
![Page 6: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/6.jpg)
Linest Function
• The array weselected earlieris now filledwith numbersas shown tothe right
• Lets see whatsome of thesenumbers mean
![Page 7: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/7.jpg)
Linest Function
![Page 8: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/8.jpg)
Plotting a graph• Select the x-column first.
Hold down the CRTL keyand select the y-columnnext.
• Choose XY scatter, undersubtype, select the first one asshown
![Page 9: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/9.jpg)
Plotting a graph
• Give an appropriate titleto the graph
• Label the axes (Don’tforget the UNITS!!)
![Page 10: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/10.jpg)
Plotting a graph
• Select ‘As new sheet’. Name the sheetappropriately.
![Page 11: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/11.jpg)
Plotting a graph
• Highlight the data points, select ‘Add Trendline’
![Page 12: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/12.jpg)
Plotting a graph
• Choose ‘Linear’ under‘Type’
• Select the options todisplay equation andR^2 value on chart
![Page 13: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/13.jpg)
Adding Error BarsNow that we have the plot, lets add the error bars.
• Select the data points andright click
• Select ‘Format Data Series’
![Page 14: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/14.jpg)
Adding Error Bars• Click on the ‘X Error Bar’
tab
• Select ‘Both’
• Under ‘Custom’, click on thewidget on the right of the +box
• Go back to the data sheetand select the uncertainty inx-values (next slide)
![Page 15: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/15.jpg)
Adding Error Bars
• Select the uncertaintyas shown, then click onthe widget on the right
• Repeat the same forthe - box once donewith the + box
• This adds the errorbars in the X-direction
![Page 16: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/16.jpg)
Adding Error Bars
• Repeat thesame procedurefor puttingerror bars in theY direction
• Once done,your graphshould look asshown to theright
![Page 17: Excel 2003 tutorial 4 graphs](https://reader033.vdocuments.us/reader033/viewer/2022052823/555927aad8b42a88038b5571/html5/thumbnails/17.jpg)
The End.