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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,238
Messages
5,836,186
Members
430,406
Latest member
pmav

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