Graphing the 1st Derivative on excel?

Click For Summary
SUMMARY

The discussion focuses on graphing the first derivative of a titration curve (pH vs NaOH added) using Microsoft Excel. Users can calculate the derivative (dy/dx) by determining the change in pH per change in volume (delta pH/delta volume) and then graphing this result. The process is described as straightforward, emphasizing the utility of Excel for this type of analysis.

PREREQUISITES
  • Basic understanding of titration curves and endpoints
  • Familiarity with Microsoft Excel graphing tools
  • Knowledge of calculating derivatives (dy/dx)
  • Experience with data manipulation in Excel
NEXT STEPS
  • Learn how to calculate derivatives in Excel using formulas
  • Explore Excel's graphing features for visualizing data
  • Research methods for determining titration endpoints
  • Investigate advanced Excel functions for data analysis
USEFUL FOR

Chemistry students, laboratory technicians, and anyone involved in data analysis or graphing in Excel, particularly in the context of titration experiments.

higherme
Messages
126
Reaction score
0
I have a titration curve (pH vs NaOH added) and i want to determine the endpoint of this graph
i want to use excel to make a graph of it's derivative (dy/dx) but i don't know how?

does anyone know how?
is there an option i can choose when making the graph?
 
Physics news on Phys.org
You can calculate dy/dx (actually delta pH/delta volume) and graph the result. Pretty straightforward that way.
 

Similar threads

What is the Importance of Choosing the Correct Endpoint in a Titration?
  • · Replies 7 ·
Replies
7
Views
5K
Potentiometric titration by ''mathematica''
  • · Replies 5 ·
Replies
5
Views
3K
Calculate mw of unknown using titration
  • · Replies 2 ·
Replies
2
Views
3K
What is the equivalence point on this graph?
  • · Replies 2 ·
Replies
2
Views
3K
Shape of titration curve in vol (NaOH) vs vol (HCl)
  • · Replies 5 ·
Replies
5
Views
9K
Need to find the equivalence point volume from the first derivative graph?
  • · Replies 2 ·
Replies
2
Views
7K
Exam asks me for a case where ▲x > dx?
  • · Replies 5 ·
Replies
5
Views
1K
How Do You Determine the Decay Constant from a Secondary Graph?
  • · Replies 1 ·
Replies
1
Views
1K
Undergrad Error bars in Excel (standard deviation, standard error, percentage)
  • · Replies 4 ·
Replies
4
Views
3K
Titration of Sulfurous Acid: Calculating pH with Ka Values
  • · Replies 3 ·
Replies
3
Views
3K