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.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Welcome to MrExcel.

Please post some sample data and details of the steps you are taking.
 

Dharr

New Member
Joined
Apr 3, 2013
Messages
2
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.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,472
Messages
5,601,854
Members
414,479
Latest member
Beau the dog

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