| Excel Macros and Data Files for |
| Doing Statistics with Excel 97 |
| The Excel-workbook files contain data and macros applicable to their respective chapters. In addition, all the chapter macros are jointly included in one Excel-workbook file, MacDoIt.xls. It contains the following macros: |
| Macro Name | Input/Output Requirements |
| BinomialProbabilities | Interactive Input as shown in the following figure: |
|
|
| BoxPlot | Input: A single column data range. Output: A box plot placed on a new sheet. |
   |
|
| Outliers | Input: A single column data range. Output: A report showing outliers (if any). |
  |
|
| GetBinProbHeader | Input: None! Output: As show below: |
 |
|
| GetFrequencyTableHeader | Input: None! Output: As show below: |
 |
|
| GetInfoForBinSetup | Input: None. Output: As show below: |
 |
|
| GetProportionHeadings | Input: None! Output: As show below: |
 |
|
| NormalProbability | Input:
As shown in the Normal Probability form.
Output:
The Probability Output Panel and (optionally) worksheet.
|
  |
|
| ZTest | Input: None! Output: Data cells and formulas for doing the Z test for the mean. |
 |
|
| tTest | Input: None! Output: Data cells and formulas for doing the t test for the mean. |
 |
|
| Single Proportion Test | Input: None! Output: Data cells and formulas for doing the test for a single proportion. |
 |
|
| Two Proportion Test | Input: None! Output: Data cells and formulas for doing the test for two proportion. |
 |
|
| Split Data Set | Input: A single column data range. Output: A collection of samples organized by rows. |
  |
|
| PredictionIntervalLimits | Input:
Two columns of independent and dependent data to be stored on an empty sheet starting from cell A1. No labels (names) are allowed.
Output:
Data cells and formulas for generating predictions, residuals, and prediction intervals for linear regression.
|
 |
|
| Note: |
| In order to use the macros with a new workbook, open the workbook containing the data set along with MacDoIt.xls and. Then use the Tools | Macro | Macros … (View | Macros) command to run one of the macros shown in the Macro Name list box. |
| Software Update |
The data files and macros are modified from time to time. Based on the student feedback, the macros are improved and eventually expanded. To obtain the latest version of the data files and the macros, download DoingStatisticsWithExcelDataWorkbooks.zip or DoingStatisticsWithExcel2007DataWorkbooks.zip. Unziping the file will create a folder structure and files similar to the one accompanying the book. If you already have the chapter data files and want to obtain only the new macro file,
you can download the DoingStatisticsWithExcelMacroWorkbook.zip or DoingStatisticsWithExcel2007MacroWorkbook.zip. |