Forum Discussion

EseOmats1425's avatar
EseOmats1425
Copper Contributor
Dec 17, 2024

Getting a Large regression model to work

Hi all,

I compiled a large dataset to do some multivariate linear regression modelling.  I have one Y variable and 15 X (dependent) variables.  I think I set everything up properly with no missing data points, but I keep geeting an error with the LINEST() function.  It says check your input ranges and won't even run.  Can someone tell me what I may be missing?

BI & Data Analysis
excel

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 17, 2024

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources