Bishawajit Chakraborty
A partial derivative in mathematics is the function’s derivative with respect to one of the variables while keeping the others constant (as opposed to the total derivative, in which all variables are allowed to vary). In differential geometry and vector calculus, partial derivatives are used. This article will show you how to find partial derivatives in Excel using a very basic function.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it yourself.
Step-by-Step Procedures to Find Partial Derivatives in Excel
In this article, we will demonstrate to you how to find partial derivatives in Excel by making equations using the Equation command from the Insert tab, and then we will determine the first and second derivatives for all the variables in the equation as well as their corresponding results.
Step 1. Utilizing Equation Command to Make Derivatives Equations
To write any mathematical equation in Excel, we have a dedicated command called “Equation.” We can almost write any equation in a mathematical form using the Equation command. To utilize the command, just follow the procedures below.
- Firstly, go to the Insert tab.
- Secondly, choose the Symbols tool.
- Thirdly, click on the Equation command and then you will make the desired equation that you want to work with.
- Here, we will write an equation for determining the partial derivatives of X and Y variables.
- So, the given equation is shown below.
Read More: How to Calculate Derivative from Data Points in Excel
Step 2. Computing First Derivative for First Variable
We will calculate the first derivative with respect to the variable X in this section. In the image below, you will see the first derivative for the given function.
- Here, we will calculate the first derivative with respect to variable X.
Read More: How to Make First Derivative Graph on Excel (With Easy Steps)
Step 3. Computing Second Derivative for First Variable
Similar to Step 2, we will find the second derivative for the given function by using the following formula.
- Then, we will evaluate the second derivative with respect to variable X.
Read More: How to Do Integration in Excel (2 Handy Approaches)
Step 4. Computing First Derivative for Second Variable
.In this section, we will calculate the first derivative with respect to the variable Y. The given image demonstrates to you the first derivative of the given function.
- Here, we will calculate the first derivative with respect to variable Y.
Read More: How to Do Differentiation in Excel (With Easy Steps)
Step 5. Computing Second Derivative for Second Variable
In this part, we will determine the second derivatives for the variable Y by using the following formula for partial derivatives.
- Then, we will evaluate the second derivative with respect to variable Y.
Step 6. Showing Final Result
In the final section, we will simulate the partial derivatives in numerical form. To do that, we assign some values for X, Y, and n.
- In this part, you will see the following formula for determining the result for the first derivatives of variable X.
=K6*(K4^(K6-1)*(K5^K6))- Then, press ENTER.
- Finally, the given image shows the result of the first derivatives of variable X.
- After that, write down the following formula for the second derivatives.
=K6*(K6-1)*(K4^(K6-2)*(K5^K6))- Besides, hit ENTER.
- Lastly, the given image shows the result of the first and second derivatives of variable X.
- After that, you will see the following formula for determining the result for the first derivatives of variable Y.
=K6*(K5^(K6-1)*(K4^K6))- Then press ENTER.
- Therefore, the given image displays the result of the first derivatives of variable Y.
- Then, write down the following formula for the second derivatives.
=K6*(K6-1)*(K5^(K6-2)*(K4^K6))- Besides, hit ENTER.
- As a result, the given image displays the result of the first and second derivatives of variable Y.
Conclusion
In this article, we’ve covered step-by-step procedures to find partial derivatives in Excel. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.
