Article Title
Estimation Error in the Correlation of Two Random Variables: A Spreadsheet-Based Exposition
Abstract
Although the statistical term correlation is well-known across many academic disciplines, estimation error in the correlation has traditionally been considered to be a topic too difficult for students outside statistical fields. This pedagogic study presents an approach for the estimation that does not require any advanced statistical concepts. By using familiar spreadsheet functions to facilitate the required computations, it intends to make the analytical material involved accessible to more students.
Recommended Citation
Kwan, Clarence C. Y.
(2009)
"Estimation Error in the Correlation of Two Random Variables: A Spreadsheet-Based Exposition,"
Spreadsheets in Education (eJSiE):
Vol. 3:
Iss.
2, Article 2.
Available at:
http://epublications.bond.edu.au/ejsie/vol3/iss2/2
An Excel file containing the two figures in the final manuscript
Download