LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
telespiza
 
Posts: n/a
Default How do I get LINEST to show all stats?

I'm using Excel 2000 on a Windows 2000 system, but I've also had this problem
on other systems. When I try to get the LINEST worksheet function to display
additional linear regression statistics (by setting the fourth argument for
the function to TRUE), the only thing that shows up is the slope of the
regression line. The directions for using the function, and Microsoft Excel
Help, both say that setting this argument to TRUE will output an array of
additional regression statistics required to test for significance of the
slope, but this never happens.

Does anybody know what else might need to be done for this to work?

Thanks,
Andrew
 
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
Show values from other sheet TONY Excel Worksheet Functions 0 August 31st 05 03:03 PM
numbers being entered show in formula bar but not in cell? Jim in Florida Excel Discussion (Misc queries) 2 May 13th 05 06:36 PM
LINEST bug with cubic polynomials in Excel 2003 byundt Excel Worksheet Functions 3 March 21st 05 02:15 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM
Show a date based on today DJ Dusty Excel Worksheet Functions 2 November 12th 04 03:20 AM


All times are GMT +1. The time now is 09:18 AM.

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"