A Microsoft Excel Companion for Business Statistics
This manual/workbook provides step-by-step instructions for using Excel to solve most of the problems found in introductory business statistics. Numerous visual examples of screen captures show data input, pull-down menus, dialog boxes, and statistical results. The workbook introduces the statistical capabilities of Excel to students who have little or no prior experience with Microsoft Windows and/or Excel. Chapter 1 includes a brief introduction to the Windows environment and an introduction to Excel.
What people are saying - Write a review
We haven't found any reviews in the usual places.
DESCRIPTIVE GRAPHS AND CHARTS
14 other sections not shown
Other editions - View all
A Microsoft Excel Companion for Business Statistics (Book Only)
No preview available - 2004
4—Chart ANOVA axis box of Figure box plot cell A5 Chapter check box chi-square Click on OK coefficient column command button compute confidence interval confidence level control limit critical value data analysis tool data values Descriptive Statistics dialog box displayed enter the formula enter the labels equal Estimate and Confidence example exponential smoothing forecast formula in cell frequency given in cell histogram hypothesis test icon input INSERT FUNCTION linear Lower-Tailed test manual menu bar mouse pointer normal distribution null hypothesis option button p-value approach Pivot Table point estimate population means population proportions population variances probability distribution procedure quartile regression analysis reject the null relationship results of Figure rows sample means sample statistics shown in cell shown in Figure significant standard deviation Standard Error statistical functions statistical inference Subsection subsequent pull-down menu t-TEST test statistic text box trendline feature TWO-SAMPLE value in cell worksheet