fish31
New Member
Hi all
I’m trying to use the trendline to find the percentage change in revision percentage over time (the difference of max. and min. points of the blue dotted trendline in the graph).
These are the formulae that I have in hand but I am not too sure what they mean... Wondering if anyone can help explain the below formulae work?
After getting the percentages (rev/job):
- To get percentage decrease per month, use the formula “=LOGEST(RANGE)-1”
- To get percentage decrease over the entire range of months, use “=LOGEST(RANGE)^(COLUMNS(RANGE)-1)-1” or “=LOGEST(RANGE)^(ROWS(RANGE)-1)-1” depending on whether you have the values laid out in columns or months
Thank you for your help!!
I’m trying to use the trendline to find the percentage change in revision percentage over time (the difference of max. and min. points of the blue dotted trendline in the graph).
These are the formulae that I have in hand but I am not too sure what they mean... Wondering if anyone can help explain the below formulae work?
After getting the percentages (rev/job):
- To get percentage decrease per month, use the formula “=LOGEST(RANGE)-1”
- To get percentage decrease over the entire range of months, use “=LOGEST(RANGE)^(COLUMNS(RANGE)-1)-1” or “=LOGEST(RANGE)^(ROWS(RANGE)-1)-1” depending on whether you have the values laid out in columns or months
Thank you for your help!!