Regression - LINEST() Function Error

lzaidel

New Member
Joined
Dec 8, 2016
Messages
2
Hi Excel experts,
I'm trying to run a linear regression on two columns with integers as values after filtering them for blanks (missing values) and after filtering the rows based on "yes"/"no" values of another column in the table.

When I run the regression, I get the following error:

Regression - LINEST() Function Error

Question:

1. How can I temporarily filter out the entire rows for which there are no values in a cell within that row?


2. How can I deal with this error in order to run the regression?


IDQ1Q3Q4
113Y
254Y
422Y
542Y
632Y
712Y
812Y
912Y
1012Y
1111Y
1254Y
1322Y
1412Y
1552Y
1722Y
1812Y
3123Y
3412Y
3811Y
3921Y
4021Y
4122Y
4222Y
4341Y
4421Y
451Y
4622Y
4841Y
491Y
5021Y
5121Y
5223Y
5322Y
5411Y
5512Y
561Y
5712Y
6011Y
6121Y
6232Y
6542Y
6612Y
6733Y
6813Y
6912Y
7022Y
7122Y
7222Y
7422Y
7611Y
7722Y
7812Y
8021Y
8132Y
8232Y
8312Y
8522Y
8632Y
8722Y
8842Y
8932Y
9021Y
9422Y
9522Y
9622Y
9732Y
9832Y
10013Y
10121Y
10211Y
10332Y
10412Y
10513Y
10712Y
10821Y
11012Y
11322Y
11413Y
11512Y
11913Y
12133Y
12311Y
12511Y
12631Y
12713Y
12821Y
12931Y
13011Y
13133Y
13412Y
1351Y
13612Y
13821Y
1392Y
1401Y
14122Y
14222Y
14621Y
14742Y
14814Y
1511Y
15243Y
15342Y
15412Y
15521Y
15612Y
15712Y
15812Y
15911Y
16012Y
16222Y
16322Y
16623Y
16812Y
17043Y
17432Y
17513Y
17613Y
18022Y
18122Y
18222Y
18312Y
18413Y
18523Y
18834Y
18923Y
19141Y
19321Y
19511Y
20211Y
20333Y
20412Y
20552Y
20612Y
20712Y
20812Y
21021Y
21121Y
21322Y
22112Y
22212Y
22514Y
22732Y
22813Y
22932Y
23212Y
23312Y
23513Y
23732Y
23841Y
23921Y
24111Y
24232Y

<tbody>
</tbody><colgroup><col><col span="3"></colgroup>

Thank you in advance.

Lee
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

63falcondude

Well-known Member
Joined
Jan 15, 2016
Messages
3,572
I would keep the raw data on one worksheet and the edited data on another. Instead of filtering the raw data, copy and paste it to another sheet and delete what you don't want. Then go from there.
 

lzaidel

New Member
Joined
Dec 8, 2016
Messages
2
I would keep the raw data on one worksheet and the edited data on another. Instead of filtering the raw data, copy and paste it to another sheet and delete what you don't want. Then go from there.

Ok, will do. If I approach it like you suggested, will I not get that "Regression - LINEST() Function Error"?

Thanks,
Lee
 

Watch MrExcel Video

Forum statistics

Threads
1,122,554
Messages
5,596,814
Members
414,104
Latest member
imamalidadashzada

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