best tutorials for graphs ( line of best fit) for excel

[Niccole D]

What are the best tutorials for using excel for stastical analysis graphs
and other graphs such as Line of best fit?

 

[Kelly O'Day]

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_analysis_with_Excel.htm

Post back if you have more specific questions.

Kelly O'Day

koday at processtrends dot com

 

[Jerry W. Lewis]

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,stats)

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