TCE ForumWhats NewSearchOrders


The Chemical Educator

ISSN: 1430-4171 (electronic version)

Table of Contents

Abstract Volume 29 (2024) pp 34-36

Analytical Calibration Curve Using Weighted Least Squares Regression

Prasanth Sambaraju*

Independent Researcher, K-104, Aparna Cybercommune, Nallagandla, Hyderabad-500019, India,
Received January 14, 2022. Accepted January 7, 2024.

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. (E-mail:

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)

The Chemical Educator 1996-2024