How to calculate Williamson-York regression in excel (Cantrell)

In this video I show you how to calculate total linear least squares regression in excel for atmospheric measurements using a spreadsheet created by Chris Cantrell using the Williamson-York method which is called a bivariate fit.

The article I got the spreadsheet from:

Cantrell, C. A.: Technical Note: Review of methods for linear least-squares fitting of data and application to atmospheric chemistry problems, Atmos. Chem. Phys., 8, 5477-5487, https://doi.org/10.5194/acp-8-5477-2008, 2008.
--------------------------------------------------------------------------------
#Excel #exceltutorial #excelcharts

SUBSCRIBE: https://goo.gl/c46YPs

Microsoft Office 365, 2016, Office Insider, Version 1901

These data are related to my PhD research
---------------------------------------------------------------------------------
RECENT VIDEOS:
How to delete cells diagonally in excel    • How to delete cells diagonally in excel  
How to calculate Spearman's correlation in excel with missing values    • How to calculate Spearman's correlation in...  
Geography data types and filled maps in excel    • Geography data types and filled maps in excel