If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
best tutorials for graphs ( line of best fit) for excel
What are the best tutorials for using excel for stastical analysis graphs
and other graphs such as Line of best fit? |
#2
|
|||
|
|||
best tutorials for graphs ( line of best fit) for excel
Niccole:
Here's a link to my chart gallery of Excel statistical charts. http://processtrends.com/TOC_chart_gallery.htm Here's a link to my page on trend analysis with Excel. This page shows several regression techniques that you can use with Excel. http://processtrends.com/toc_trend_a...with_Excel.htm Post back if you have more specific questions. Kelly O'Day koday at processtrends dot com "Niccole D" Niccole wrote in message ... What are the best tutorials for using excel for stastical analysis graphs and other graphs such as Line of best fit? |
#3
|
|||
|
|||
best tutorials for graphs ( line of best fit) for excel
Your discussion of LINEST (LOGEST behaves similarly) explicitly continues the
misconception, fostered by Excel's Help, that LINEST is limited to simple linear regression. Actually the x data can be a rectangular region, in which case LINEST does multiple regression linear in the unknowns. Polynomial regression is a special case that can be handled by array formulas without the need to have the power columns explicitly exist on the worksheet, as in =LINEST(ycolumn,xcolumn^{1,2,3,...},intercept,stat s) The ATP regression tool simply reformats and expands (not always intelligently) the output of LINEST. Prior to 2003, LINEST could get into numerical difficulty quickly on polynomial regressions that the chart trendline handled quite well. "Improvements" to charting in 2007 make it unreliable in many instances that LINEST now handles easily. Jerry "Kelly O'Day" wrote: Niccole: .... Here's a link to my page on trend analysis with Excel. This page shows several regression techniques that you can use with Excel. http://processtrends.com/toc_trend_a...with_Excel.htm |
Thread Tools | |
Display Modes | |
|
|