Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / April 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Niccole D - 25 Apr 2008 00:36 GMT
What are the best tutorials  for using excel for stastical analysis graphs
and other graphs such as Line of best fit?
Kelly O'Day - 25 Apr 2008 01:45 GMT
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

> What are the best tutorials  for using excel for stastical analysis graphs
> and other graphs such as Line of best fit?
Jerry W. Lewis - 25 Apr 2008 11:07 GMT
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

> 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_analysis_with_Excel.htm
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.