Scatter Diagram and Trendline
A scatter diagram is a graphical presentation of the relationship
between two quantitative variables, and a trendline is a line that
provides an approximation of the relationship. As an illustration,
consider the advertising/
Click the Insert tab on the Ribbon
In the Tables group, click the icon above the word PivotTable
When the Create PivotTable dialog box appears,
Choose Select a table or range
Enter A1:A21 in the Table/Range box
Choose Existing Workshe
Crosstabulation of Quality Rating and Meal Price for 300 Los
$10 $20 $30 $40 Tot
Very Good 34
A set of data, even if modest in size, is often difficult to interpret
directly in the form in which it is gathered. Tabular and graphical
methods provide procedures for organizing and summarizing data
so that patterns are revealed and the data ar
Right-click the vertical axis and choose Format Axis from
the list of options that appear
When the Format Axis dialog box appears,
Go to the Axis Options section
Select Fixed for the Major Unit and enter 1.0 in the
Rotating this page counterclockwise onto its side provides a
picture of the data that is similar to a histogram with classes of
6069, 7079, 8089, and so on.
Although the stem-and-leaf display may appear to offer the same
information as a histogram, it has
The data in two or more crosstabulations are often combined or
aggregated to produce a summary crosstabulation showing how
two variables are related. In such cases, we must be careful in
drawing a conclusion because a conclusion based upo
Report. The following steps show how to use Excels PivotTable
Field List to assign the Quality Rating field to the rows, the Meal
Price ($) field to the columns, and the Restaurant field to the body
of the PivotTable report.
In the PivotTable Fi
Show the relative frequency distribution.
Show the cumulative frequency distribution.
Show the cumulative relative frequency distribution.
What proportion of patients needing emergency service
wait 9 minutes or less?
Relative Frequency and Percent Frequency Distributions
We define the relative frequency and percent frequency
distributions for quantitative data in the same manner as for
qualitative data. First, recall that the relative frequency is the
proportion of th