Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 12th 05, 10:19 PM
lashio
 
Posts: n/a
Default 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   Report Post  
Old June 14th 05, 02:25 PM
Jerry W. Lewis
 
Posts: n/a
Default

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   Report Post  
Old June 15th 05, 06:04 AM
lashio
 
Posts: n/a
Default

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   Report Post  
Old June 15th 05, 01:15 PM
Jerry W. Lewis
 
Posts: n/a
Default

You're welcome. Glad it helped.

Jerry

lashio wrote:

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
i want to create a simple mailing list can u help Gary Brown Excel Worksheet Functions 0 May 18th 05 05:25 PM
Need to get slope of peaks on excel graph Capillod Charts and Charting in Excel 3 May 13th 05 03:16 PM
How do I create a simple drop down box/List SweetShellyGal Excel Discussion (Misc queries) 1 March 11th 05 05:00 PM
Simple But Stumped Brian Keanie Excel Discussion (Misc queries) 3 February 5th 05 02:56 AM
how can i get the slope function to ignore missing data? Delmar Excel Discussion (Misc queries) 0 December 2nd 04 05:55 PM


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

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017