LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 20th 16, 09:13 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Dec 2016
Posts: 1
Default LINEST with r2 = -1.18 ???

Hi all
this is funny. Missing values are a problem with LINEST
However, the very Excel that does not allow for missing values, ignores them when plotting a polynomial function
Since I exactly need the regression parameters from a polynomial regression of the fomr y=a*X^3+b*X^2+c*X+d, then the question becomes, how I can *automatically* get out the parameters from the equation in the plot into a set of cells.
I would also need t-test and significance but that can be solved later
Thank you!

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
LINESt [email protected] Excel Discussion (Misc queries) 1 December 8th 08 04:54 PM
linest use in vba Larry Excel Programming 1 January 14th 08 05:06 AM
LINEST bug Mark Schreiber Excel Worksheet Functions 2 April 27th 07 07:26 PM
LINEST() Bove Farm Excel Worksheet Functions 1 May 29th 06 05:54 AM
LINEST [email protected] Excel Discussion (Misc queries) 2 February 20th 06 10:56 AM

All times are GMT +1. The time now is 03:58 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017