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
. 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
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.
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
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 te
Dot Plot
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
Display the Initial PivotTable Field List and PivotTable
Report: Three steps are needed to display the initial PivotTable
Field List and PivotTable report.
1.
Step 1
Click the Insert tab on the Ribbon
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 valu