The Chemical EducatorISSN: 14304171 (electronic version) Abstract Volume 29
(2024) pp 3436 Analytical Calibration Curve Using Weighted Least Squares RegressionPrasanth Sambaraju* ^{}Independent Researcher, K104, Aparna Cybercommune, Nallagandla, Hyderabad500019, India, prashanth.kng1@gmail.com Published: 25 January 2024 Abstract. Calibration curve in analytical chemistry is used to demonstrate the linear relationship between different standard analyte concentrations and instrument response by using linear regression. One of the important assumptions in linear regression is homoscedasticity, variance of the residuals is constant for the calibration data. Weighted regression is used when this assumption is not met. The goal of this paper is to create a spreadsheet using Microsoft Excel to perform weighted least square linear regression by evaluating different weighting factors.
Key Words: In the Classroom; analytical chemistry; calibration curve, linear regression, homoscedasticity, weighting factors, spreadsheet (*) Corresponding author. (Email: prashanth.kng1@gmail.com) Article in PDF formatt(226 KB) HTML fomat Supporting Materials: An Excel file used in calculations and a file containing Compiled R code. (2332 KB)
