new problem with linest

ssaifan

Active Member
Joined
Jul 29, 2003
Messages
355
i have Y values data in column AB//..

and I have X values data in columsn ...AC to AG ...

i m doing multiple linear regression using 5 X variables.....


so now.....may data starts in AB4...
but the problem is that i want to do ..
= linest ( y values , arrat ogf x values )

this is simple....if my data length is constant ..

now my data length is not constant ...it some times is say 50 rows...and sometimes 500 rows...

how do i deal with tis issue.......

as my linest in case 1 wud be .....= linest ( ab4 to ab54 , ac 4 to ag54 )..

or next time it ll be till 500 rows..
how do i make this range dynamic in my formala....


pls help....
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,994
Try using the offset function.

Something like:

=LINEST(OFFSET(AB1,,,COUNTA(AB:AB)),OFFSET(AC1:AG1,,,COUNTA(A:A)))
 

Watch MrExcel Video

Forum statistics

Threads
1,122,382
Messages
5,595,853
Members
414,027
Latest member
zippyfrog

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