Finalize the PivotTable Report: To complete the PivotTable
Report, we need to group the columns representing meal prices
and place the row labels for quality rating in the proper order. The
following steps accomplish this.
Right-click in cell B4
. Eliminating the spaces between classes in a histogram for the
audit time data helps show that all values between the lower limit
of the first class and the upper limit of the last class are possible.
One of the most important uses of a histogram is to p
Figure 2.6 shows the resulting PivotTable Field List and the
corresponding PivotTable report. To construct the frequency
distribution shown in Table 2.5, we must group the rows
containing audit times. The following steps accomplish this.
Figure 2.22Tabular and Graphical Methods for Summarizing Data
With large data sets, computer software packages such as Excel
and StatTools are essential in constructing tabular and graphical
summaries of data.
Exploratory Data Analysis: The Stem-and-Leaf Display
The techniques of exploratory data analysis consist of simple
arithmetic and easy-to-draw graphs that can be used to
summarize data quickly. One techniquereferred to as a stemand-leaf displaycan be used
One of the simplest graphical summaries of data is a dot plot. A
horizontal axis shows the range for the data. Each data value is
represented by a dot placed above the axis. Figure 2.8 is the dot
plot for the audit time data in Table 2.4. The thr
Display the Initial PivotTable Field List and PivotTable
Report: Three steps are needed to display the initial PivotTable
Field List and PivotTable report.
Click the Insert tab on the Ribbon
In the Tables group, click the icon above th
Dividing the totals in the bottom row of the crosstabulation by the
total for that row provides a relative and percent frequency
distribution for the meal price variable.
Note that the sum of the values in each column does not add
exactly to the column to