Welcome to the KeithChamberlain wiki! This is where Keith posts information about his projects.

This section describes Keith's future/current and past projects.

1. Using Python in Excel
2. massDiff functions in Python and R
3. Optimal R^2 in weighted calibrations

NOTE: ChamberlainStatistics.com is now defunct. Links to blog posts will no longer work, however, PDF's of some of the posts may be made available.

1. Weighting and Transformation in Calibrations to overcome Heterogeneity of Variance: A Feb 23rd post from ChamberlainStatistics.com (link broken). Get the PDF with a TOC.
2. massDiff. A VBA project to realize "Chamberlain differences", usually regarding masses but including traditional (mathematical) definitions of differences, percent differences, log percent differences, and scaled differences.Exemplified in Feb 2018 blog post for ChamberlainStatistics.com (link broken).
3. All about the markdowns baby. A Feb 17, 2018 blog post (link broken) regarding LaTeX, Git, GitHub Desktop, Pandoc, Visual Studio Code, and converting Markdown documents with VBA code chunks, syntax highlighting, and citations styles to other document formats as a PDF.

1. Random. A project to realize seeded random number generation in Excel similar to that of Python and R. Exemplified in Dec 2017 blog posts.
2. Surrogate data in R, Excel and Python: The final chapter (link broken) A Dec 30th, 2017 blog post.
3. Surrogate data in Excel, R and Python: Excel VBA interface (link broken). A Dec 26th, 2017 blog post.
4. Surrogate data in Excel (link broken). A Dec 20th, 2017 blog post.
5. Generating Surrogate Data for R, Excel and Python: using Python (link broken). A Dec 19, 2017 blog post.
6. Surrogate calibration data in R & Excel (link broken). Calibration data in R. A Dec 15, 2017 blog post.
7. R^2 Defined (link broken). Illustrated and detailed definition of R^2. A June 10, 2017 blog post.
8. Misunderstanding of R^2 (link broken). A June 09, 2017 blog post.
9. R^2 As An Index of Fit (link broken). As used in the physical and chemical sciences. A May 27, 2017 blog post.

1. R^2 & The Chemical Sciences