Scientific Data Analysis Toolkit: A Versatile Add-in to Microsoft Excel for Windows

Autor/inn/en	Halpern, Arthur M.; Frye, Stephen L.; Marzzacco, Charles J.
Titel	Scientific Data Analysis Toolkit: A Versatile Add-in to Microsoft Excel for Windows
Quelle	In: Journal of Chemical Education, 95 (2018) 6, S.1063-1068 (6 Seiten)Infoseite zur Zeitschrift PDF als Volltext Verfügbarkeit
Zusatzinformation	ORCID (Halpern, Arthur M.)
Sprache	englisch
Dokumenttyp	gedruckt; online; Zeitschriftenaufsatz
ISSN	0021-9584
DOI	10.1021/acs.jchemed.8b00084
Schlagwörter	Science Activities; Data Analysis; Spreadsheets; Computer Oriented Programs; Chemistry; Regression (Statistics); Indiana + Suchen Sie Ihr Suchwort? Auswertung; Spread sheet; Spredsheets; Spreadsheet; Tabellenkalkulation; Computerprogramm; Chemie; Regression; Regressionsanalyse
Abstract	Scientific Data Analysis Toolkit (SDAT) is a rigorous, versatile, and user-friendly data analysis add-in application for Microsoft Excel for Windows (PC). SDAT uses the familiar Excel environment to carry out most of the analytical tasks used in data analysis. It has been designed for student use in manipulating and analyzing data encountered in the physical and biological sciences, from first-year courses, to the graduate level, and in research. A particularly useful feature of SDAT is its ability to perform rigorous regression analysis using both standard and user-defined model functions. This tool, which can accommodate up to seven fitting parameters, provides the standard deviation of regression of the fit, the standard uncertainties of the fitting parameters, and the covariance matrix. It also supports weighted regression analysis. SDAT includes the following functionalities: Descriptive Statistics, Integrate, Differentiate, Smooth, Spline, Plot, and Regression Analysis. The use of the Regression Analysis tool is illustrated with several examples including the unweighted and weighted analysis of the nonlinear and linearized forms an exponential decay and an example of the use of the covariance term in a propagation of errors calculation. Other example topics are chemical and enzyme kinetics, vapor pressure, and quantum chemistry computational results. SDAT is provided as associated content. (As Provided).
Anmerkungen	Division of Chemical Education, Inc and ACS Publications Division of the American Chemical Society. 1155 Sixteenth Street NW, Washington, DC 20036. Tel: 800-227-5558; Tel: 202-872-4600; e-mail: eic@jce.acs.org; Web site: http://pubs.acs.org/jchemeduc
Erfasst von	ERIC (Education Resources Information Center), Washington, DC
Update	2020/1/01