Practical Instrumental Analysis - Second Level PDF
Document Details
Uploaded by CushyOtter2616
Kafrelsheikh University
Tags
Summary
This document covers practical instrumental analysis, a second level course in pharmaceutical analytical chemistry. It introduces the method of least squares for linear regression and its application to plotting calibration curves using Excel. Data for KMnO4 is included for demonstration purposes.
Full Transcript
Department of Pharmaceutical Analytical Chemistry Practical Instrumental Analysis Second Level Linear Regression Using Least Squares Method The least squares method is a statistical procedure to find the best fit for a set of data points by minim...
Department of Pharmaceutical Analytical Chemistry Practical Instrumental Analysis Second Level Linear Regression Using Least Squares Method The least squares method is a statistical procedure to find the best fit for a set of data points by minimizing the sum of the offsets or residuals of points from the plotted curve. Observed values Calculated values Q. Write a linear equation that best fits the data in the table shown below using least squares method? KMno4 Conc. (mol/L) A 0.5 × 10-4 0.11 1 × 10-4 0.21 1.5 × 10-4 0.32 2 × 10-4 0.41 2.5 × 10-4 0.52 How to use Excel to plot a calibration curve?
