Thread View: comp.apps.spreadsheets
1 messages
1 total messages
Started by J. Philip Craiger
Wed, 20 Jan 1993 20:02
problems with linest() function
Author: J. Philip Craiger
Date: Wed, 20 Jan 1993 20:02
Date: Wed, 20 Jan 1993 20:02
22 lines
1413 bytes
1413 bytes
This solution should solve the problem, but it is difficult to believe that there isn't a more elegant solution to the problem. I also find the same problem when using any of the functions in the analysis toolpak of ver. 4.0. If i were to compute a 10x10 correlation matrix, i would have to go through an select out all cases with missing values. If Microsoft is to gain support from the scientific community, they should try to correct this problem. Very few real world data sets that I've come across are absolutely free of missing values. I think their analysis toolpak is great, but has serious limitations. -- _______________________________________________ J. Philip Craiger, Ph.D. (Internet: craiger@nprdc.navy.mil) Navy Personnel Research and Development Center -- Code 161 San Diego, CA 92152-6800 (619-553-7961) -- _______________________________________________ J. Philip Craiger, Ph.D. (Internet: craiger@nprdc.navy.mil) Navy Personnel Research and Development Center -- Code 161
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads