|Guide Particulars :|
Spreadsheets have develop into one of the common types of pc software program, second solely to phrase processors. Spreadsheet software program permits the consumer to mix information, mathematical formulation, textual content, and graphics collectively in a single report or workbook. For that reason, spreadsheets have develop into indispensable instruments for enterprise, as they’ve additionally develop into common in scientific analysis. Excel particularly has received quite a lot of approval for its ease of use and energy.
As spreadsheets have expanded in energy and ease of use, there was elevated curiosity in utilizing them within the classroom. There are various benefits to utilizing Excel in an introductory statistics course. An essential benefit is that college students, notably enterprise college students, usually tend to be acquainted with spreadsheets and are extra snug working with information entered right into a spreadsheet. Since spreadsheet software program is quite common at faculties and universities, a statistics teacher can train a course with out requiring college students to buy an extra software program bundle. Having recognized the strengths of Excel for instructing primary statistics, it might be unfair to not embrace a number of warnings. Spreadsheets should not statistics packages, and there are limits to what they will do in changing a full-featured statistics bundle.
For this reason we have now included our personal downloadable add-in, StatPlus™. It expands a few of Excel’s statistical capabilities. (We clarify the usage of StatPlus the place applicable all through the textual content.) Utilizing Excel for something apart from an introductory statistics course would in all probability not be applicable because of its limitations. For instance, Excel can simply carry out balanced two-way evaluation of variance however not unbalanced two-way evaluation of variance. Spreadsheets are additionally restricted in dealing with information with lacking values. Whereas we suggest Excel for a primary statistics course, we really feel it’s not applicable for extra superior evaluation.
Data analysis with Microsoft Excel (updated for Office 2007)
Author(s): Kenneth N. Berk, Partrick Carey
Publisher: Cengage Learning, Year: 2009
Download Data Analysis with Microsoft Excel by Kenneth N. Berk and Patrick Carey PDF