How to Calculate Derivative from Data Points in Excel

Get FREE Advanced Excel Exercises with Solutions!

A derivative is a common tool to calculate any rate of change of any value. You can calculate derivatives by using Excel. In this article, I will show how to calculate derivative from data points in Excel. Hopefully, this article will help you to make you more expert in Excel. I will attach illustrations for your better understanding.


Introduction to Derivatives

Derivatives mean the rate of change of any function. If we consider a function y = 2x+1. Then the derivative of this function will be

(y2-y1)/(x2-x1)

We can explain this phenomenon by that, the rate of change of the y function is actually the proportion of change of y and the proportion of change of x.


How to Calculate Derivative from Data Points in Excel: 2 Methods

Here, I consider a dataset of Distance covering a Tesla Car. I have two columns in the dataset B and C called Time (seconds) and Distance (meters). The dataset ranges from B5 to C10 cells. With this dataset, I will show how to Calculate derivative from Data Points in Excel. Let’s follow the steps of the methods carefully.

Datasetto calculate derivative from data points excel


1. Calculating Derivatives from Data Points in Excel by Using a Generic Formula

This is the first method of this article. I will use a generic formula to calculate derivative from Data points in Excel. I have added a new column in column D called Velocity (meters/seconds). The first value of velocity will be 0 because as this is the first value, there is no change in velocity there. Now, let’s follow the method step by step mentioned below.

Generic formula to calculate derivative from data points excel

Steps:

  • First, select the D6 cell.
  • Then, enter the following formula in the D6 cell:
=(C6-C5)/(B6-B5)

Generic formula to calculate derivative from data points excel

  • After that, press the Enter key.
  • Then, you will get the value 10.
  • Moreover, use Fill-handle to copy down the formula from D6 to D10 cells.

Generic formula to calculate derivative from data points excel

  • Hence, you will find the result just like the picture given below.

Generic formula to calculate derivative from data points excel


2. Using Graphs to Calculate Derivatives from Data Points in Excel

This is the last method of this article. You will also get knowledge of how to calculate derivatives from data points in Excel by using graphs. This method is another short and easy method. I will consider the same dataset here. Let’s follow the steps.

Using Graphs to calculate derivative from data points excel

Steps:

  • First, from the Insert option of your toolbar, insert a graph. However, the graph will be like the graph given below.

Using Graphs to calculate derivative from data points excel

  • Then, select the two consecutive points from the graph. I have selected the first two consecutive points.

Using Graphs to calculate derivative from data points excel

  • Now, select the D6 Then, write down the following formula in the D6 cell.
=(C6-C5)/(B6-B5)

Using Graphs to calculate derivative from data points excel

  • After pressing enter, you will find the result.

Using Graphs to calculate derivative from data points excel

  • Copy the formula from D6 to D10.
  • Consequently, you will find the result like the picture given below.

Using Graphs to calculate derivative from data points excel


How to Calculate First Derivative in Excel

The first derivative means to calculate the first-rate of change of a function. If the function is differentiated again then it will be called the second derivative. In this portion of this article, I will show how to calculate the first derivative in Excel. Here, I will consider the same dataset we used earlier. Let’s follow the procedure step by step.

Steps:

  • Select the D6 cell first.
  • Write down the following formula.
=(C6-C5)/(B6-B5)

  • After pressing Enter, you will get the result.
  • Then, Fill-Handle to copy down the formula from D6 to D10 cell.

  • As a result, you will get the velocities just like the picture given below.


Things to Remember

  • The first value of every method is taken as 0 by default as the car didn’t start running at that time.

Download Practice Workbook

Please download the workbook to practice yourself.


Conclusion

In this article, I have tried to explain how to Calculate Derivative from Data Points in Excel. I hope you have learned something new from this article. Now, extend your skill by following the steps of these methods. I hope you have enjoyed the whole tutorial. If you have any kind of queries feel free to ask me in the comment section. Don’t forget to give us your feedback.


<< Go Back to | Calculus in Excel | Excel for Math | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Souptik Roy
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo