LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 137
Default Excel 2007 Polynomial Order Incorrect

We recently upgraded to Office 2007. When we attempt to do a trendline in
Excel, the order of polynomials is always one below what it is stated to be
and the highest ordered polynomial is always wrong. (i.e. on a fourth order
polynomial, it will only display polynomials through the third order and in
the equation, the third ordered polynomial value is wrong, the others are
correct).

We tried installing the hot fix from KB 938541 as well as right clicking on
the equation for the chart and adding significant digits under Format
Trendline Label.

A sample file showing the problem can be downloaded from:

https://share.chicagogsb.edu/seos/10...fe4b9af27f96a6

Thank you in advance for any assistance provided.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determining the apex of a order 2 polynomial Frank Pytel Charts and Charting in Excel 3 August 31st 07 05:20 PM
How do I solve for x in a second-order polynomial trend? DianeD Charts and Charting in Excel 2 February 23rd 07 04:04 PM
How do I determine which order to use in a polynomial trendline? Nina Charts and Charting in Excel 1 January 25th 07 05:58 PM
Automating Polynomial Order Selection in Linest Nick Flyger Excel Worksheet Functions 3 October 4th 06 09:51 AM
Polynomial Formula Incorrect? DCLittlejohn Charts and Charting in Excel 1 June 27th 05 08:50 PM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"