Regression

A

Adrianjay

Sometimes I receive an error message of "Regression -
Linest () functions returns error. Please check input
ranges". The input ranges appear to be okay (no blank
cells), in fact if I increase or decrease the number of
in the input x range the regression model works fine.
Does anyone know what the problem is? Does anyone have
any suggestions? Thanks for you help.
 
G

Guest

What is the error message. #NUM? or other This tells you what the thrown exception is.
Linest fails if the data is singular, has partial colinearity, or you have not correctly defined the ranges and set the right calling (inputs) sequences.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top