• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to use the trendline to find percentage change?

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!! :)Screen Shot 2020-02-23 at 5.56.54 pm.png
 
Select your chart
Click on the trend line and then right click on it and select properties
Enable Display Equation on Chart
65767

Your chart will now look like this
65766

The Formula Y = -0.001x + 0.447 is the formula for the trend line

The x component -0.001x is the slope of the line
It has a slope of -0.1% ie: 100 x the value -0.001
 
Cross post
 
Back
Top