LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Hugh
 
Posts: n/a
Default Polinomial - What's Wrong

Hi All,
Please refer to the earlier Post. But here it is again.
Below is the data for a graph. x is the x axis, and Data the applicable Data
for the graph.
X Data formula
1.0000 0.0688 -0.0012
2.0000 0.1277 0.0370
3.0000 0.1800 0.0756
4.0000 0.2272 0.1146
5.0000 0.4471 0.1541
6.0000 0.6924 0.1940
7.0000 1.0000 0.2343
8.0000 1.3455 0.2751
9.0000 1.5503 0.3163
10.0000 1.7955 0.3580
11.0000 2.0820 0.4001

A Polinomial trendline is then applied to the graph line.
A polinmial graph has r2=.9894, so pretty good fit.
The trend formula is y = 0.0148x2 + 0.0375x - 0.0398
This is entered into the Formula column as
((0.0148*x)^2)+(0.0375*x)-0.0398

If this data is taken and put into the same graph as a new line it bears no
remblance to the original polinomial trend line.
Which part of how thick I am, is failing to grasp the simple answer to this?
Please be polite in replies, (though I may be too thick to understand them)
:)

Thanks



 
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
I get wrong dates when i paste from a different sheet into a new s mmollat Excel Discussion (Misc queries) 2 January 6th 05 07:35 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM
multi-level subtotals are in the wrong position Worksheet Guru need Excel Worksheet Functions 1 December 6th 04 05:22 PM
Logic statement returns wrong answer. Tony Excel Worksheet Functions 2 December 2nd 04 05:07 AM
IF function displays wrong amount JAnderson Excel Worksheet Functions 4 November 6th 04 06:41 PM


All times are GMT +1. The time now is 02:09 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"