Statistical Explorations with Microsoft ExcelWith the clearly written explanations and exercises in this manual and its accompanying diskette, students will enhance their understanding of statistical concepts while they are learning the basics of Microsoft Excel. Written with the first-time Excel user in mind, STATISTICAL EXPLORATIONS WITH MICROSOFT EXCEL offers step-by-step instructions. Students learn how to get started on Excel, read and draw boxplots and histograms, and work with Chart Wizard. This manual is ideal for professors who want to integrate a lab component into their courses.With the manual's lab exercises, students use their newly acquired Excel skills to solve problems and--in the process--sharpen their understanding of many concepts and ideas essential to the mastery of introductory statistics. |
Contents
Getting Started | 1 |
Exercises | 23 |
Numerical Measures of Data | 29 |
Copyright | |
24 other sections not shown
Common terms and phrases
Add-Ins Atlanta Braves box and write boxplot calculations Category cell A1 Central Limit Theorem chapter chart sheet Chart Wizard click in cell Click the OK column confidence interval contingency table Count of Smoker data set data values Delete dialog box distribution Double-click Edit menu Enter the command example Excel 97 Exercise expected values female five-number summary formula Gender gridlines histogram Homework Average illustration key and click key and press labels look Macro male median menu and select Midterm Score normal curve OK button OK Cancel Open a text Open the worksheet option p-value Pivot Wizard PivotTable produce Pull recalculate relative frequency sample means sample proportions SAT score scatter plot Section Select cell SHIFT key shown simulation standard deviation STAT Statistics Step Teen Crime Terry Pendleton text box Toolbar Tools menu Toronto Blue Jays total number trendline variables vertical Violent Crime window workbook worksheet entitled