Related Experiment Video
Updated: Sep 10, 2025

Facilitating the Analysis of Immunological Data with Visual Analytic Techniques
Published on: January 2, 2011
Taffit: An Excel Tool for Fitting Tafel Data
1Department of Chemistry, University of Iowa, Iowa City, Iowa 52242, United States.
Abstract:
Tafel analysis is widely used to characterize electrode kinetics. The technique has found use in electrochemistry, catalysis, materials, and corrosion research. Accurate Tafel analysis is especially critical in comparison of electrocatalysts. However, classical Tafel analysis (CTA) relies on the user's subjective selection of a linear range in the Tafel plot; dependent on linear regression of the user-selected range, kinetic parameters can vary by orders of magnitude. As use of CTA in the literature grows, a need is identified for more reliable, user-independent Tafel analysis. Here, Taffit, an algorithm constructed in the widely available Microsoft Excel, is presented. Taffit generates a Tafel plot from linear sweep voltammetric data and determines the exchange current density j 0, charge transfer coefficient α, and Tafel slopes by closest statistical fit. Comparisons between Taffit and CTA are made for the hydrogen evolution reaction (HER, 2H+ + 2e ⇌ H2) on glassy carbon (GC) and platinum electrodes. Taffit finds log j 0 values of -7.2 and -3.9 for GC and Pt under H2 at pH 0, as measured without resistive compensation. This is the first report of j 0 for HER on GC. Because algorithmic fitting in the low overpotential region uses both cathodic and anodic branches of the Tafel plot, Taffit has greater precision than CTA. Agreement is also shown between literature values reported by CTA and those obtained by Taffit for HER on metal phosphide and selenide electrocatalysts. The Taffit algorithm substantially reduces subjectivity to improve the accuracy and precision of Tafel analysis.
Related Concept Videos
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Microsoft Excel: Student's t-Test
To conduct a t-test in Excel, use the T.TEST function or the "Data...
Overview of Microsoft Excel as a Data Analysis Tool
Microsoft Excel: Regression Analysis
To perform regression...
Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis
Mean: The arithmetic average of all data points. It is calculated by adding all the values together and dividing by the number of values. The mean is sensitive to extreme values (outliers).
Median: The middle value when the data points are arranged in ascending or descending...
Microsoft Excel: Median, Quartile range, and Box Plots
Median and Quartile Range: The median is calculated using the formula `=MEDIAN(range)', which provides the middle value of your data set. Quartiles divide your data into four equal parts. To find the first and third quartiles, use ‘=QUARTILE(range, 1)' and ‘=QUARTILE(range, 3)', respectively. The interquartile range (IQR), which...

