312 Fundamentals of Statistics
c. Create a PivotTable of Political Party
versus Gender, removing any blank
categories from the table. Is there evi-
dence to suggest that political affi lia-
tion depends on gender?
d. Create a PivotTable of Political Party
versus Age, removing any blank cate-
gories from the table. Age is an ordinal
variable. Using the appropriate test
statistic, analyze whether there is any
signifi cant relation between age and
political affi liation.
e. Save your changes to the workbook
and write a report summarizing your
conclusions.- The Montana workbook discussed in
Exercise 12 also contains information on
the public’s assessment of the fi nancial
status of the state. Analyze the results
from this survey.
a. Open the Montana workbook from
the Chapter07 folder and save it as
Montana Financial Statistics.
b. Create a PivotTable comparing the
Financial Status variable to the
Gender variable. Is there statistical
evidence that gender plays a roll in
how individuals view the economy?
c. Create a PivotTable of Financial Status
and Income. Note that both are ordinal
variables. Is there statistical evidence
of a relation between the two?
d. Create a PivotTable of Financial
Status and Age. Once again note that
both variables are ordinal. Using the
appropriate statistical test, determine
whether there is evidence of a relation
between age and the assessment of the
state’s fi nancial status.
e. Create a PivotTable comparing Finan-
cial Status and Political Party. Is there
statistical evidence of a relation be-
tween the two?
f. Save your changes to the workbook
and write a report summarizing your
observations.