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 rela
1.
Show the relative frequency distribution.
Answer
2.
Show the cumulative frequency distribution.
Answer
3.
Show the cumulative relative frequency distribution.
Answer
4.
What proportion of patients
Step 1
Click the Insert tab on the Ribbon
Step 2
In the Tables group, click the icon above the word PivotTable
Step 3
When the Create PivotTable dialog box appears,
Choose Select a table or range
Ente
Table 2.10
Crosstabulation of Quality Rating and Meal Price for 300 Los
Angeles Restaurants
Meal Price
Quality
$10 $20 $30 $40 Tot
Rating
Good
19
29
39
49
al
42
40
2
0
84
Very Good 34
64
46
6
150
Exce
Summary
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 summari
1.
Step 10
Right-click the vertical axis and choose Format Axis from
the list of options that appear
2.
Step 11
When the Format Axis dialog box appears,
o
Go to the Axis Options section
o
Select Fixed
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 appe
Simpsons Paradox
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
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
o
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, rec