cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

Rate of Change from a Data Matrix

jcohn
1-Visitor

Rate of Change from a Data Matrix

I was able to extract the data based on the identifier in row 0. I want to calculate a rate of change based on dates in row 2 for values found in rows 4 to 12. I will also calculate rates of change from the most recent date on all previous dates. I read over the papers on indexes and range variables so I don't think I change the range variable for data set comparisons. I was able to calculate the rate of change by separating out each data set into vectors but this sounds messy. Hopefully your answer with allow me to solve other pending questions for data analysis. Thanks

ACCEPTED SOLUTION

Accepted Solutions
RichardJ
19-Tanzanite
(To:jcohn)

Is this what you are after?

The new date values are halfway between the date values used to calculate the rate at a given point.

View solution in original post

2 REPLIES 2
RichardJ
19-Tanzanite
(To:jcohn)

Is this what you are after?

The new date values are halfway between the date values used to calculate the rate at a given point.

jcohn
1-Visitor
(To:RichardJ)

Thank you,

Seems to work great.

Announcements

Top Tags