Advertisement

Residual sum of squares in validations

Discussions about HPLC, CE, TLC, SFC, and other "liquid phase" separation techniques.

4 posts Page 1 of 1
Dear All,

I have a doubt with the calculation of residual sum of squares in linearity studies.Can any body explain how to calculate in linearity study or is there any literature available on net?

Thanks in advance,
Bhaskar

Hi,

I entered my data into MS Excel spreadsheets. When you perform a linear regression on your data, part of the output is the residual sum of squares. I don't recall the actual formula to calculate it by hand, but if I find something I will post it. Spreadsheets have saved me a lot of time with some of my calculations. =)

I'm with redzilla. I tried to do the rsq calculation by hand ONCE :shock: .

Found the function in Microsoft Excel and haven't looked back since. :lol:

I got the following calculation. Please correct me if I am wrong.


Replicate 25% 50%
1 155 242
2 149 247
3 155 257
X 459 746
n 3 3
x bar(Average) 153 248.6666667
Sigma x square 70251 185622
Sigma x whole square 210681 556516
sigma x whole square/n 70227 185505.3333
Residual sum of square 24 116.6666667

The difference between sigma x square and sigma x whole square/n is nothing but RSS.

Also please explain me what is the significance of the RSS(residual sum of squares) in linearity study?

Bhaskar
4 posts Page 1 of 1

Who is online

In total there are 18 users online :: 0 registered, 0 hidden and 18 guests (based on users active over the past 5 minutes)
Most users ever online was 4374 on Fri Oct 03, 2025 12:41 am

Users browsing this forum: No registered users and 18 guests

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry