LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Trendline formula does not mimic actual trendline

I am doing a regression on real data to find the right formula. The data is as follows:
Wall Real time
2.2 3
2.4 3.3
2.6 3.6
2.8 3.9
3 4.2
3.2 4.5
3.4 4.9
3.6 5.35
3.8 5.8
4 6.35
4.2 6.8
Excel comes up with a formula: y= 0.0153x2+0.1931x+2.8388, The R2 is 0.9991. When I compute my data with the formula these are the resulting figures:
Calc. time
3.37494
3.43472
3.49634
3.5598
3.6251
3.69224
3.76122
3.83204
3.9047
3.9792
4.05554
Not at all like the real data. I tried other trendlines but none works. What am I doing wrong? I did this with some other data and it worked fine.

Thanks for your help.

Ottmar
 
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
Trendline formula juanpablo Excel Discussion (Misc queries) 6 October 18th 09 08:56 AM
Formula in Trendline juanpablo Excel Discussion (Misc queries) 0 October 16th 09 08:20 PM
Trendline Formula Problems John1791 Charts and Charting in Excel 2 June 19th 07 06:11 PM
log trendline formula dr chuck Excel Programming 5 February 17th 07 08:14 PM
Using Trendline Formula Maarten Excel Programming 2 February 12th 05 02:14 AM


All times are GMT +1. The time now is 07:19 PM.

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

About Us

"It's about Microsoft Excel"