JCE Online Journal of Chemical EducationDivision of Chemical Education, American Chemical SocietyAmerican Chemical Society
 | Subscriptions  | Software Orders  | Support  | Contributors  | Advertisers  | 

JCE Print

JCE Digital Library

JCE Software

Only@JCE Online

About JCE


  Home > JCE Print > Journal of Chemical Education > Issues > 2006  > December  >
Information • Textbooks • Media • Resources
JCE WebWare: Web-Based Learning Aids
Looking behind the Spreadsheet Trendline
William F. Coleman
Chemistry Department, Wellesley College, Wellesley, MA 02481

Edward W. Fedosky
University of Wisconsin–Madison, Madison, WI 53715

Cover
December 2006
Vol. 83 No. 12
p. 1884

Full Text
Over the past decade many colleges and universities have placed increased emphasis on having students develop statistical and data analysis skills in a range of disciplines. Some institutions now require that all students complete at least one course with a strong component of data analysis, whether the data are from chemical experiments, the census, or some other source. As chemists, one of our concerns should be to ensure that students view data analysis as an integral part of any quantitative experiment, and, as far as possible, do not treat this process as a “black box”.

The authors of A Method of Visual Interactive Regression, a spreadsheet application, have developed a visual approach to linear least-squares curve fitting that drives home the idea of minimizing the sum of the squares of the deviations in order to find the best fit to a set of data that are being described by a linear relationship. For many students these visualizations are likely to persist a great deal longer than the mathematical derivations of the equation for the slope and the intercept. The visualizations will provide a useful connection between a set of equations and the buttons on a calculator or the insertion of a “trendline” in a spreadsheet.

More Information
*
Citation
Coleman, William F.; Fedosky, Edward W. J. Chem. Educ. 2006 83 1884.
*
Keywords
Computational Chemistry; Computer-Based Learning; Mathematics / Symbolic Mathematics
*
History
Created:
Last Updated:
10/30/2006
10/31/2006
  Home > JCE Print > Journal of Chemical Education > Issues > 2006  > December  > Page 1884


Subscriptions

JCE HS CLIC

Our Secondary School editors work hard to distill all the JCE materials to produce a fraction of particular interest to high school teachers. We call it CLIC.


Contributions Welcome
JCE welcomes your submission

Advertisers
In recent years we have worked hard to better match our advertisers with our readers. When shopping for chemistry education materials, visit our advertisers' WWW sites first.

Be An Ambassador
Take JCE along on your outreach missions. Copies of the Journal, guest access to JCE Online, our publications catalog, and more are available for your participants.