Regression Analysis: 'Regression-LINEST() function returns error.'

Dharr

New Member
Joined
Apr 3, 2013
Messages
2
Hey all,

Just a quick question regarding the regression analysis function in excel. I was previously facing the constant error message: ''Regression-LINEST() function returns error. Please check input ranges again'. This was because there were blank cells in my data. After following the steps to the solution, i.e filling the blank cells with 0's, I am still facing this error. What should I do about it?

I would appreciate some quick feedback on the issue that I'm facing.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Hi Andrew,

Thank you. Below are a portion of the data:

PC_FRUVEG
172.00
149.00
160.00
172.00
172.00
172.00
172.00
172.00
216.00
216.00
172.00
160.00
160.00

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Median_Inc
51622
51957
30896
41076
46086
26980
31449
39997
35614
38028
40292
30728
34101

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

The data that I'm analysing has over 3000 counts of different categories with blank cells in different areas, so the above is just a small sample of it.

I used the regression analysis bit under Data> Data Analysis and selected all data including labels (with the labels box ticked) after filling the blank spots with 0's.

On another note, I tried filtering the data of the blanks, leaving only the numbers. I tried the regression analysis after that and it still did not work.

Thanks.
 
Upvote 0
I had no problem with the data you posted, even if it included zeroes. Are you sure that all your numbers are really numbers? You can put your workbook on a share like Box.com if you want and I'll take a look.
 
Upvote 0

Forum statistics

Threads
1,217,326
Messages
6,135,906
Members
449,970
Latest member
pfisher99

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
Back
Top