Linest() function returns error.

aryansss

New Member
Joined
Apr 5, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello,

I'm trying to run a simple regression analysis on my Y and X variables but I get this error 'LINEST() function returns error. Please check input ranges again'. I have checked that my columns does not contain any blank cells. What else can be a reason for this? I really need to do this regression. Please help. Below is the link to the data
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

joeu2004

Well-known Member
Joined
Mar 2, 2014
Messages
3,018
Office Version
  1. 2010
Platform
  1. Windows
I do not see any LINEST formulas in your example Excel file.
And you did not post the formula that gave you an error.
So there is nothing that anyone can say or do, apart from wild guesses.
Post a link to an Excel file that demonstrates the problem.

Include the LINEST formula that causes the error.

If you cannot include it in the file (because of a syntax error),
at least include it your posting.
Alternatively (better), include it as text in your Excel file.
In either case, present the formula exactly as you typed it
(copy-and-paste from the Formula Bar),
and let us know if you press ctrl+shift+Enter when you typed the formula.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,127,999
Messages
5,628,052
Members
416,289
Latest member
Jbelisari

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top