Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show values from other sheet | Excel Worksheet Functions | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
LINEST bug with cubic polynomials in Excel 2003 | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Show a date based on today | Excel Worksheet Functions |