Average rate of change in Excel

Knowing what is the average rate of change can be useful on many occasions. For example, you may want to know what’s the average number of kilometers the car makes.

Let’s take the first example. We take into consideration: time, distance, average speed, and rate of change.

Average speed and rate of change

In the following example, there is a time we drive and the distance we’ve already driven. We need to calculate the average speed and the rate of change.

First, let’s calculate the average speed. To do it, calculate the distance by time.

But first, we need to convert time to decimal hours. We can do it by multiplying time * 24. It’s also important to format these cells as a number.

Enter the following formula into cell C2 and AutoFill the remaining cells.

=B2/(A2*24)

Now, let’s calculate the rate of change. Enter 0 into D2 because change is zero.

In cell D3, enter the following formula.

=(C3-C2)/C2

AutoFill the remaining cells.

To calculate the average rate of change from the first time to the last, you have to use this formula.

=(C7-C2)/C2

The average rate of change is 13.53%.