Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to put a Science graph on the computer but I need to use a line
of best fit is is possible to do this with any Microsoft producat in particular exel? |
#2
![]() |
|||
|
|||
![]()
Gavin,
Yes, Excel offers several options. Depending on your data, you could first look at Excel's charting trendline options. After you create a chart, click on it once. Then go to the standard toolbar and select Chart - Add Trendline. Next, this site shows how to calculate a best fit line via linear regression calculations: http://www.pdbook.com/index.php/exce...ar_trendlines/ http://www.pdbook.com/index.php/exce..._new_x_values/ Finally, take a look at Excel's INDEX, LINEST, and CORREL functions. Also, if you have the Analysis ToolPak installed, Excel will calculate all of the regression coefficients for you. ---- Regards, John Mansfield http://www.pdbook.com "Gavin" wrote: I would like to put a Science graph on the computer but I need to use a line of best fit is is possible to do this with any Microsoft producat in particular exel? |
#3
![]() |
|||
|
|||
![]()
Select the data series in the chart, then select Chart | Add
Trendline... and pick the type of trendline and the options of interest. You may also want to see Trendline coefficients http://www.tushar-mehta.com/excel/ti...efficients.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I would like to put a Science graph on the computer but I need to use a line of best fit is is possible to do this with any Microsoft producat in particular exel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
how do I draw a line in a chart at a specific location | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Macro - Skipping a line | Excel Worksheet Functions |