Slope using dates

B

beto

Hi, I want to get the slope from Column C using a certain range of dates from
Column A. I did this already for getting the max value, but I do not how to
do it using Slope.

Example I did using Max:
=MAX(IF(ISNUMBER(MATCH($A$2:$A$500,M2:N2,0)),$c$2:$c$500))
M2=8/25/2009
N2=8/27/2009

"I need Slope"

ColumnA ColumnB ColumnC
8/24/2009 345 34
8/25/2009 345 465
8/25/2009 567 566
8/25/2009 456 465
8/26/2009 456 876
8/26/2009 244 243
8/26/2009 123 264
8/26/2009 876 436
8/27/2009 678 134
8/27/2009 484 134
8/27/2009 356 654
8/27/2009 456 456
8/27/2009 234 123
8/28/2009 567 453
 
P

Pete_UK

You have several values in column C for 8/25/2009 and for 8/27/2009.
Do you want to take the average of these for each date, or the first,
or the last ???

Slope is the change in Y divided by the corresponding change in X, or
in your case:

(Cn - Cm) / (An - Am)

so if you can explain which values of C you want to take for those
dates then it's quite easy to plug them into this formula.

Hope this helps.

Pete
 
B

beto

"Do you want to take the average of these for each date, or the first,
or the last ???"

Both options would help me a lot, taking the average for each date and then
do the slope.
Also taking the first and last.

Please if you can tell me how to do it I would appreciate it a lot.
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top