Estimation Error in the Correlation of Two Random Variables: A Spreadsheet-Based Exposition

Clarence C. Y. Kwan
2009 Spreadsheets in Education  
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
more » ... accessible to more students.
doaj:599ca376912d4b7b82d329b6d1b99bd1 fatcat:2eupd5k2zbdiblyepdui3zeh7a