Remember Me?

#1
June 12th 05, 10:19 PM
 lashio Posts: n/a
Simple Slope Formulation

Can you change the known X's range to Row reference of known Y's?
I am trying to eleminate columnA. Thanks
=INDEX(LINEST(B1:B5,A1:A5),1)
=INDEX(LINEST(B13:B17,A13:A17),1)

#2
June 14th 05, 02:25 PM
 Jerry W. Lewis Posts: n/a

There are at least two interpretations of your request:

1. You could Insert|Name|Define and define two names, "yValues" with a
formula of B1:B5, and "xValues" with a formula of =OFFSET(xValues,0,-1)
which would allow you to reference values in A1:A5 without typing the
explicit reference. Then when you change the range for yValues, the
range for xValues would ajdust automatically.

2. You could use
=LINEST(B1:B5,ROW(B1:B5))
and then do a search and replace of B1:B5 to B13:B17 to use x values of
1,2,3,4,5 in your first case, and 13,14,15,16,17 in the second case.

Note that you could use
=LINEST(B1:B5)
as a shortcut to have the x values be 1,2,3,...

Jerry

lashio wrote:

Can you change the known X's range to Row reference of known Y's?
I am trying to eleminate columnA. Thanks
=INDEX(LINEST(B1:B5,A1:A5),1)
=INDEX(LINEST(B13:B17,A13:A17),1)

#3
June 15th 05, 06:04 AM
 lashio Posts: n/a

Hi, Jerry
Thank you very much.
=LINEST(B1:B5) is what I needed.

"Jerry W. Lewis" wrote in message
...
There are at least two interpretations of your request:

1. You could Insert|Name|Define and define two names, "yValues" with a
formula of B1:B5, and "xValues" with a formula of =OFFSET(xValues,0,-1)
which would allow you to reference values in A1:A5 without typing the
explicit reference. Then when you change the range for yValues, the range
for xValues would ajdust automatically.

2. You could use
=LINEST(B1:B5,ROW(B1:B5))
and then do a search and replace of B1:B5 to B13:B17 to use x values of
1,2,3,4,5 in your first case, and 13,14,15,16,17 in the second case.

Note that you could use
=LINEST(B1:B5)
as a shortcut to have the x values be 1,2,3,...

Jerry

lashio wrote:

Can you change the known X's range to Row reference of known Y's?
I am trying to eleminate columnA. Thanks
=INDEX(LINEST(B1:B5,A1:A5),1)
=INDEX(LINEST(B13:B17,A13:A17),1)

#4
June 15th 05, 01:15 PM
 Jerry W. Lewis Posts: n/a

Jerry

lashio wrote:

Hi, Jerry
Thank you very much.
=LINEST(B1:B5) is what I needed.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Gary Brown Excel Worksheet Functions 0 May 18th 05 05:25 PM Capillod Charts and Charting in Excel 3 May 13th 05 03:16 PM SweetShellyGal Excel Discussion (Misc queries) 1 March 11th 05 05:00 PM Brian Keanie Excel Discussion (Misc queries) 3 February 5th 05 02:56 AM Delmar Excel Discussion (Misc queries) 0 December 2nd 04 05:55 PM

All times are GMT +1. The time now is 05:20 PM.