Project Description:
Data was collected from several classes of Business students enrolled in a private religious affiliated university during the fall
semester of the 2016 presidential election year. The variables collected included: 1) Sex - Female/Male; 2) HS - Private/Public;
3) Party - Democrat/Republican/Other (includes Independent, Libertarian, and Green); 4) Registered - Yes/No; 5) Likely Vote 0-100%. For the purpose of this project, you will only be using the variables, Party and Registered. The purpose of this project
is to describe graphically and numerically a categorical relationship and to understand the difference among joint, marginal, and
conditional probabilities. Use this summary analysis to help you determine whether the choice of a student's political party is
Instructions:
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type
values, as you will not receive full credit for your answers. For the purpose of grading the project you are required to perform
the following tasks:
Step
1
2
3
4
5
6
7
8
9
10
11
12
13
14
14
15
16
17
Describing a Categorical Relationship
roject Description:
ata was collected from several classes of Business students enrolled in a private religious affiliated university during the fall
emester of the 2016 presidential election year. The variables collected included: 1) Sex - Female/Male; 2) HS - Private/Public;
) Party - Democrat/Republican/Other (includes Independent, Libertarian, and Green); 4) Registered - Yes/No; 5) Likely Vote -100%. For the purpose of this project, you will only be using the variables, Party and Registered. The purpose of this project
to describe graphically and numerically a categorical relationship and to understand the difference among joint, marginal, and
onditional probabilities. Use this summary analysis to help you determine whether the choice of a student's political party is
nstructions:
se a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type
alues, as you will not receive full credit for your answers. For the purpose of grading the project you are required to perform
he following tasks:
Instructions
Start Excel. Download and open the workbook named:
Describing_a_Categorical_Relationship_Start.
In cells C8-F13, insert a pivot table putting political party affiliation on the rows and values areas and registered to vote on the columns area
Insert PivotTable
Go to the Voting Data worksheet. Select the PivotTable in the Tables group of the Insert tab of the Ribbon.
Selecting Data Series
Choose Select a table or range and select columns A-F on the Voting Data worksheet. Select Existing Worksheet and choose
cell H2 on the Voting Data worksheet as the location for the pivot table. Do not check any additional boxes in the Create
Edit PivotTable
In the PivotTable Fields list, drag-and-drop the Registered field into the columns area and Party field into the rows and values
areas. In the Fields list, open the drop-down menu to the right of the Registered field and uncheck the (blank) box. Then open
the drop-down menu for the Party field and uncheck the (blank) box. Select design Pivot Style Light 20 in the PivotTable Styles
group of the Design tab of the Ribbon. Set Times New Roman, size 14 pt. font to the text in the pivot table in the Home tab of
Moving PivotTable
Select the pivot table. Then choose Move PivotTable in the Actions group of the Analyze tab on the Ribbon. In the Move
PivotTable dialog, select cells C8-F13 on the Problem worksheet.
Note: Filters should be set to both the Registered and Party fields. Other options will not be graded.
In cells C17-F22, insert a pivot table putting political party affiliation on the rows and values areas and registered to vote on the columns are
Insert PivotTable
Go to the Voting Data worksheet. Select the PivotTable in the Tables group of the Insert tab of the Ribbon.
Selecting Data Series
Choose Select a table or range and select columns A-F on the Voting Data worksheet. Select Existing Worksheet and choose
cell H9 on the Voting Data worksheet as the location for the pivot table. Do not check any additional boxes in the Create
Edit PivotTable
In the PivotTable Fields list, drag-and-drop the Registered field into the columns area and Party field into the rows and values
areas. In the Fields list, open the drop-down menu to the right of the Registered field and uncheck the (blank) box. Then open
the drop-down menu for the Party field and uncheck the (blank) box. In the Values area, open the drop-down list to the right of
the field name and select the Value Field Settings option. Choose % of Grand Total in the Show Values As tab. Click on Number
Format button and set percentage format that displays two decimal places. Select design Pivot Style Light 20 in the PivotTable
Moving PivotTable
Select the pivot table. Then choose Move PivotTable in the Actions group of the Analyze tab on the Ribbon. In the Move PivotTable dialog, sel
Note: Filters should be set to both the Registered and Party fields. Other options will not be graded.
In cells C26-F31, insert a pivot table putting political party affiliation on the rows and values areas and registered to vote on
the columns area and showing the values as ‘% of Row Total’. Use columns A-F on the Voting Data worksheet. Choose cell
H16 on the Voting Data worksheet as the location for the pivot table. In the PivotTable Fields list, drag-and-drop the
Registered and Party fields into appropriate areas. Select to show all values except the blanks for the Registered and Party
fields. Choose % of Row Total and set percentage format that displays two decimal places in the Show Values As tab of the
Value Field Settings. Select design Pivot Style Light 20. Set to the text in the pivot table Times New Roman, size 14 pt. font.
Change the name of the pivot table to Table3. Move the pivot table in cells C26-F31 on the Problem worksheet.
In cell J35, identify the probability that the business student is a registered voter.
In cell J36, choose the type of probability in step 5) from the drop-down menu.
In cell J37, identify the probability that the business student is registered and a Republican.
In cell J38, choose the type of probability in step 7) from the drop-down menu.
In cell J39, identify the probability that the business student is registered to vote given they are Republicans.
In cell J40, choose the type of probability in step 9) from the drop-down menu.
In cell J41, identify the probability that the business student is registered to vote if they are a Democrat.
In cell J43, identify the probability that the business student is not registered to vote and not affiliated with either the Democratic or the Repu
In cells C47-G47 insert a Clustered Column Chart to show the distribution of the registered (Yes/No) across the three political parties.
Inserting Chart
Select the Column Chart and then the Clustered Column Chart from the provided chart options in the Charts group of the Insert tab of the Rib
Selecting Data Series
Choose Select Data in the Design tab on the Ribbon. Delete any series created automatically using the Remove button and add new series usi
Add a new series for the distribution of those not registered to vote across the three political parties using cells D28-D30 as the Series values
Add new series for the distribution of the registered to vote across the three political parties using cells E28-E30 as the Series values. Use ce
Edit Category Labels using cells C28-C30 as the Axis label range.
Edit Chart Elements
Select design Style 1 in the Design tab of the Ribbon. Then go to the Add Chart Elements drop-down list. Add the legend and
choose the Right option. Add the data labels and choose the Outside End option.
Chart Size and Position
Go to the Format tab on the Ribbon. Set the chart height and width so the entire chart fits within cells C47-G47.
In cells C51-G51 insert a Stacked Column Chart to show the distribution of the registered Yes/No across the three political parties.
Inserting Chart
Select the Column Chart and then the Stacked Column Chart from the provided chart options in the Charts group of the Insert tab of the Ribb
Selecting Data Series
Choose Select Data in the Design tab on the Ribbon. Delete any series created automatically using the Remove button and add new series usi
Add a new series for the distribution of those not registered to vote across the three political parties using cells D28-D30 as the Series values
Add new series for the distribution of the registered to vote across the three political parties using cells E28-E30 as the Series values. Use ce
Edit Category Labels using cells C28-C30 as the Axis label range.
Edit Chart Elements
Select design Style 1 in the Design tab of the Ribbon. Then go to the Add Chart Elements drop-down list. Add the legend and
choose the Right option. Add the data labels and choose the Center option.
Chart Size and Position
Go to the Format tab on the Ribbon. Set the chart height and width so the entire chart fits within cells C51-G51.
In cell C60, based on steps 13-14, identify whether the distribution of being registered to vote or not appears to differ between
the three party affiliations. Choose from the drop-down menu the letter from A to D corresponding to one of the options listed
Identify whether the analysis supports that being registered to vote is independent of party affiliation. Choose the correct answer from the dro
Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
Total Score
Points Possible
0
2
2
2
1
1
1
1
1
1
1
1
2
2
2
1
1
0
20
Describing a Categorical Relationship
Use the data collected from business students at a private religious affiliated University in
whether the choice of a student's political party is independent of being registered to vote d
determine independence, it is important to understand the difference between joint and con
distributions and how to interpret these results visually using appropriate bar charts.
Use a cell reference or a single formula where appropriate in order to receive full credit. Do
receive full credit for your answers.
1-2)
Construct a pivot table putting political party affiliation on the rows and values area
from Party and Registered fields. Follow the directions in steps 1-2 in the instruction
3) Construct a pivot table putting political party affiliation on the rows and values area
'% of Grand Total'. Remove the blanks from Party and Registered fields. Follow the
pivot table in cells C17-F22.
4) Construct a pivot table putting political party affiliation on the rows and values area
'% of Row Total'. Remove the blanks from Party and Registered fields. Follow the d
table in cells C26-F31.
Given this is a representative sample of business students at a religious affiliated un
religious affiliated university, calculate the following probabilities and identify their
5)
6)
7)
8)
9)
10)
11)
12)
In cell J35, identify the probability that the business student is a registered voter.
In cell J36, choose the type of probability in step 5) from the drop-down menu.
In cell J37, identify the probability that the business student is registered and a Repu
In cell J38, choose the type of probability in step 7) from the drop-down menu.
In cell J39, identify the probability that the business student is registered to vote giv
In cell J40, choose the type of probability in step 9) from the drop-down menu.
In cell J41, identify the probability that the business student is registered to vote if t
In cell J43, identify the probability that the business student is not registered to vote
the Democratic or the Republican party.
13) Construct a clustered column chart to visually show the distribution of registered (Y
step 13 in the instructions document. Insert the chart in cells C47-G47.
14) Construct a stacked column chart to visually show the distribution of registered (Ye
step 14 in the instructions document. Insert the chart in cells C51-G51.
15) In cell C60, based on steps 13-14, identify whether the distribution of being register
affiliations. Choose from the drop-down menu the letter from A to D corresponding
A Yes, because the majority of students in both the Democrat and Republican parties a
'Other' parties are not registered to vote.
B Yes, because the distribution of Yes/No changes considerably for each party observ
C No, because the 'Other' party is about equally split between registered and not regist
D No, because the distributions of registered Yes/No are similar between the Democra
16-17) Identify whether the analysis supports that being registered to vote is independent o
down menu in cell C64.
iated University in the fall of the 2016 presidential election year to determine
registered to vote during the fall semester of a presidential election. In order to
tween joint and conditional probabilities, how to obtain these probability
e bar charts.
ceive full credit. Do not copy and paste values or type values, as you will not
ws and values areas and registered to vote on the columns area. Remove the blanks
-2 in the instructions document. Insert the pivot table in cells C8-C13.
ws and values areas and registered to vote on the columns area. Show the values as
d fields. Follow the directions in step 3 in the instructions document. Insert the
ws and values areas and registered to vote on the columns area. Show the values as
fields. Follow the directions in step 4 in the instructions document. Insert the pivot
igious affiliated university, if one randomly selects a business student attending a
es and identify their types.
registered voter.
p-down menu.
gistered and a Republican.
p-down menu.
gistered to vote given they are Republicans.
p-down menu.
gistered to vote if they are a Democrat.
ot registered to vote and not affiliated with either
ion of registered (Yes/No) across the three political parties. Follow the directions in
7-G47.
n of registered (Yes/No) across the three political parties. Follow the directions in
1-G51.
on of being registered to vote or not appears to differ between the three party
to D corresponding to one of the options listed in cells C55-I58.
Republican parties are registered to vote, while the majority of students in the
r each party observed.
tered and not registered.
tween the Democrats and the Republicans.
te is independent of party affiliation. Choose the correct answer from the drop-
Sex
Female
Female
Female
Female
Male
Male
Female
Female
Female
Female
Male
Male
Male
Female
Male
Male
Female
Female
Male
Female
Male
Female
Female
Female
Female
Male
Female
Male
Male
Male
Female
Male
Female
Female
Male
Female
Male
Female
Male
Male
Male
Female
Female
Female
Female
Male
HS
Public
Private
Private
Public
Public
Private
Public
Public
Public
Public
Private
Public
Private
Public
Public
Private
Public
Private
Public
Public
Private
Public
Private
Private
Public
Public
Public
Private
Public
Private
Public
Public
Public
Public
Public
Public
Private
Public
Public
Public
Public
Public
Public
Public
Public
Public
Job
Income
Job satisfaction
Job satisfaction
Job satisfaction
Income
Job satisfaction
Job satisfaction
Income
Job satisfaction
Income
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Income
Income
Income
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Income
Income
Job satisfaction
Income
Income
Income
Job satisfaction
Job satisfaction
Job satisfaction
Income
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Income
Job satisfaction
Job satisfaction
Job satisfaction
Income
Job satisfaction
Income
Registered
Yes
No
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
No
No
Yes
No
Yes
Yes
No
No
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
No
No
No
Yes
Party
Republican
Republican
Republican
Democrat
Other
Democrat
Republican
Democrat
Republican
Republican
Other
Republican
Republican
Democrat
Republican
Republican
Republican
Republican
Democrat
Democrat
Republican
Democrat
Democrat
Democrat
Republican
Other
Other
Republican
Other
Other
Republican
Republican
Democrat
Republican
Republican
Republican
Other
Democrat
Democrat
Democrat
Republican
Democrat
Republican
Republican
Democrat
Republican
LikelyVote
90
75
90
40
0
99
75
75
50
90
50
78
50
100
100
78
100
100
0
100
100
100
100
100
0
0
100
75
100
80
50
30
90
0
100
70
90
100
35
100
0
75
80
0
0
Male
Female
Female
Female
Female
Female
Female
Male
Male
Female
Male
Male
Female
Female
Male
Male
Female
Female
Female
Female
Female
Female
Male
Male
Male
Female
Male
Female
Male
Female
Male
Male
Male
Female
Female
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Female
Public
Private
Public
Public
Private
Public
Public
Public
Public
Public
Public
Public
Public
Public
Public
Private
Private
Public
Private
Private
Private
Public
Private
Public
Public
Private
Private
Public
Public
Public
Private
Public
Public
Private
Private
Public
Public
Public
Public
Public
Public
Public
Private
Public
Private
Public
Public
Income
Job satisfaction
Income
Income
Income
Income
Income
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Job satisfaction
Income
Job satisfaction
Job satisfaction
Income
Income
Job satisfaction
Job satisfaction
Job satisfaction
Yes
No
No
No
No
No
No
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
No
No
No
Yes
Republican
Other
Republican
Republican
Democrat
Republican
Other
Republican
Other
Other
Republican
Democrat
Republican
Republican
Republican
Republican
Other
Republican
Other
Republican
Democrat
Republican
100
1
75
75
0
75
0
100
0
100
25
100
50
100
40
70
1
0
50
0
0
100
Job satisfaction
Job satisfaction
Job satisfaction
Income
Job satisfaction
Income
Job satisfaction
Job satisfaction
Income
Job satisfaction
Income
Income
Income
Income
Yes
Yes
No
Yes
Yes
Yes
Yes
No
Yes
Yes
No
No
Yes
Yes
Yes
Yes
No
Yes
Yes
No
No
Yes
Yes
Yes
Republican
Other
Other
Republican
Democrat
Republican
Democrat
Other
Republican
Other
Republican
Republican
Republican
Democrat
Republican
Republican
Republican
Democrat
Democrat
Republican
Other
Democrat
Other
Republican
50
100
0
10
100
50
100
0
100
0
60
60
70
100
20
95
70
75
100
Job satisfaction
Job satisfaction
Income
Job satisfaction
Income
Job satisfaction
Job satisfaction
Job satisfaction
Income
0
88
50
50
Male
Female
Male
Female
Male
Male
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Female
Male
Male
Male
Female
Female
Female
Female
Male
Male
Male
Male
Male
Male
Male
Male
Female
Male
Female
Male
Public
Public
Public
Public
Public
Public
Public
Private
Private
Private
Private
Public
Public
Public
Public
Public
Private
Public
Public
Public
Public
Public
Private
Private
Public
Public
Public
Public
Private
Private
Public
Public
Private
Public
Private
Public
Public
Public
Public
Private
Public
Public
Public
Public
Public
Private
Public
Job satisfaction
Income
Job satisfaction
Income
Income
Job satisfaction
Income
Income
Job satisfaction
Income
Yes
No
Yes
No
Yes
Yes
No
Yes
No
No
Democrat
Other
Democrat
Other
Republican
Republican
Democrat
Republican
Republican
Democrat
Income
Income
Job satisfaction
Income
Income
Income
Income
Income
Income
Income
Job satisfaction
Income
Job satisfaction
Job satisfaction
Job satisfaction
Income
Income
Job satisfaction
Income
Job satisfaction
Income
Job satisfaction
Income
Job satisfaction
Income
Job satisfaction
Income
Income
Income
Income
Job satisfaction
Job satisfaction
Job satisfaction
Income
Job satisfaction
Income
No
No
Yes
Yes
Yes
No
No
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Democrat
Republican
Democrat
Republican
Republican
Other
Other
Democrat
Republican
Republican
Republican
Democrat
Democrat
Other
Other
Republican
Republican
Other
Republican
Other
Democrat
Democrat
Republican
Democrat
Democrat
Democrat
Republican
Republican
Democrat
Democrat
Other
Democrat
Republican
Republican
Democrat
Democrat
80
70
10
100
35
20
0
0
40
0
0
100
100
100
0
0
100
50
30
100
100
65
50
100
80
0
100
100
90
100
0
0
75
70
100
100
100
0
10
100
50
100
0
100
Male
Private Income
Yes
Other
90
Office 2016 – myitlab:grader – Instructions
Excel Project
Describing a Categorical Relationship V3
Project Description:
Data was collected from several classes of Business students enrolled in a private religious affiliated university
during the fall semester of the 2016 presidential election year. The variables collected included: 1) Sex Female/Male; 2) HS - Private/Public; 3) Party - Democrat/Republican/Other (includes Independent, Libertarian,
and Green); 4) Registered - Yes/No; 5) Likely Vote - 0-100%. For the purpose of this project, you will only be
using the variables, Party and Registered. The purpose of this project is to describe graphically and numerically a
categorical relationship and to understand the difference among joint, marginal, and conditional probabilities. Use
this summary analysis to help you determine whether the choice of a student's political party is independent or
dependent of whether the student is registered to vote or not.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
1
2
3
Points
Possible
Instructions
Start Excel. Download and open the workbook named:
Describing_a_Categorical_Relationship_Start.
0
In cells C8-F13, insert a pivot table putting political party affiliation on the rows and values
areas and registered to vote on the columns area.
Insert PivotTable
Go to the
Voting Data worksheet. Select the PivotTable in the Tables group of the Insert tab of the
Ribbon.
Selecting Data Series
Choose Select a table or range and select columns
A-F on the Voting Data worksheet. Select Existing Worksheet and choose cell H2 on the
Voting Data worksheet as the location for the pivot table. Do not check any additional boxes
in the Create PivotTable dialog.
Edit PivotTable
In the PivotTable Fields list, drag-and-drop the Registered field into the columns area and
Party field into the rows and values areas. In the Fields list, open the drop-down menu to the
right of the Regis
tered field and uncheck the (blank) box. Then open the drop-down menu for the Party field
and uncheck the (blank) box. Select design Pivot Style Light 20 in the PivotTable Styles group
of the Design tab of the Ribbon. Set Times New Roman, size 14 pt. font to the text in the
pivot table in the Home tab of the Ribbon. Change the name of the pivot table to Table1 in
the PivotTable group of the Analyze tab on the Ribbon.
Moving PivotTable
Select the pivot table. Then choose Move PivotTable in the Actions group
of the Analyze tab on the Ribbon. In the Move PivotTable dialog, select cells C8-F13 on the
Problem worksheet.
Note: Filters should be set to both the Registered and Party fields. Other options will not be
graded.
In cells C17-F22, insert a pivot table putting political party affiliation on the rows and values
areas and registered to vote on the columns area and showing the values as ‘% of Grand
Total’.
Insert PivotTable
Go to the
Voting Data worksheet. Select the PivotTable in the Tables group of the Insert tab of the
Ribbon.
Selecting Data Series
Updated: 05/20/2018
1
2
2
Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions
Step
Excel Project
Points
Possible
Instructions
Choose Select a table or range and select columns
A-F on the Voting Data worksheet. Select Existing Worksheet and choose cell H9 on the
Voting Data worksheet as the location for the pivot table. Do not check any additional boxes
in the Create PivotTable dialog.
Edit PivotTable
In the PivotTable Fields list, drag-and-drop the Registered field into the columns area and
Party field into the rows and values areas. In the Fields list, open the drop-down
menu to the right of the Registered field and uncheck the (blank) box. Then open the dropdown menu for the Party field and uncheck the (blank) box. In the Values area, open the
drop-down list to the right of the field name and select the Value Field Settings option. Choose
% of Grand Total in the Show Values As tab. Click on Number Format button and set
percentage format that displays two decimal places. Select design Pivot Style Light 20 in the
PivotTable Styles group of the Design tab of the Ribbon. Set to the text in the pivot table
Times New Roman, size 14 pt. font in the Home tab of the Ribbon. Change the name of the
pivot table to Table2 in the PivotTable group of the Analyze tab on the Ribbon.
Moving PivotTable
Select the pivot table. Then choose M
ove PivotTable in the Actions group of the Analyze tab on the Ribbon. In the Move PivotTable
dialog, select cells C17-F22 on the Problem worksheet.
4
Note: Filters should be set to both the Registered and Party fields. Other options will not be
graded.
In cells C26-F31, insert a pivot table putting political party affiliation on the rows and values
areas and registered to vote on the columns area and showing the values as ‘% of Row
Total’. Use columns A-F on the Voting Data worksheet. Choose cell H16 on the Voting
Data worksheet as the location for the pivot table. In the PivotTable Fields list, drag-and-drop
the Registered and Party fields into appropriate areas. Select to show all values except the
blanks for the Registered and Party fields. Choose % of Row Total and set percentage format
that displays two decimal places in the Show Values As tab of the Value Field Settings. Select
design Pivot Style Light 20. Set to the text in the pivot table Times New Roman, size 14 pt.
font. Change the name of the pivot table to Table3. Move the pivot table in cells C26-F31 on
the Problem worksheet.
2
Note: Filters should be set to both the Registered and Party fields. Other options will not be
graded.
5
In cell J35, identify the probability that the business student is a registered voter.
1
6
In cell J36, choose the type of probability in step 5) from the drop-down menu.
1
7
In cell J37, identify the probability that the business student is registered and a Republican.
1
8
In cell J38, choose the type of probability in step 7) from the drop-down menu.
1
9
In cell J39, identify the probability that the business student is registered to vote given they
are Republicans.
1
Updated: 05/20/2018
2
Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions
Step
Excel Project
Points
Possible
Instructions
10
In cell J40, choose the type of probability in step 9) from the drop-down menu.
1
11
In cell J41, identify the probability that the business student is registered to vote if they are a
Democrat.
1
12
In cell J43, identify the probability that the business student is not registered to vote and not
affiliated with either the Democratic or the Republican party.
1
In cells C47-G47 insert a Clustered Column Chart to show the distribution of the registered
(Yes/No) across the three political parties.
Inserting Chart
Select the Column Chart and then the Clustered Column Chart from the provided chart options
in the Charts group of the Insert tab of the Ribbon.
13
14
Selecting Data Series
Choose Select Data in the Design t
ab on the Ribbon. Delete any series created automatically using the Remove button and add
new series using Add button. Add a new series for the distribution of those not registered to
vote across the three political parties using cells
D28-D30 as the Series values. Use cell D27 to set the series name.Add new series for the
distribution of the registered to vote across the three political parties using cells
E28-E30 as the Series values. Use cell E27 to set the series name.Edit Category Labels using
cells
C28-C30 as the Axis label range.
Edit Chart Elements
Select design Style 1 in the Design tab of the Ribbon. Then go to the Add Chart Elements
drop-down list. Add the legend and choose the Right option. Add the data labels and choose
the Outside End opti
on.
Chart Size and Position
Go to the Format tab on the Ribbon. Set the chart height and width so the entire chart fits
within cells
C47-G47.
In cells C51-G51 insert a Stacked Column Chart to show the distribution of the registered
Yes/No across the three political parties.
Inserting Chart
Select the Column Chart and then the Stacked Column Chart from the provided chart options
in the Charts group of the Inser
t tab of the Ribbon.
Selecting Data Series
Choose Select Data in the Design tab on the Ribbon. Delete any series created automatically
using the Remove button and add new series using Add button.
Add a new series for the distribution of those not registe
red to vote across the three political parties using cells D28-D30 as the Series values. Use
cell D27 to set the series name.Add new series for the distribution of the registered to vote
across the three political parties using cells
E28-E30 as the Series values. Use cell E27 to set the series name.Edit Category Labels using
cells
C28-C30 as the Axis label range.
2
2
Edit Chart ElementsSelect design Style 1 in the Design tab of the Ribbon. Then go to the Add
Chart Elements drop-down list. Add the legend an
Updated: 05/20/2018
3
Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions
Step
Excel Project
Points
Possible
Instructions
d choose the Right option. Add the data labels and choose the Center option.
Chart Size and Position
Go to the Format tab on the Ribbon. Set the chart height and width so the entire chart fits
within cells
C51-G51.
15
In cell C60, based on steps 13-14, identify whether the distribution of being registered to vote
or not appears to differ between the three party affiliations. Choose from the drop-down menu
the letter from A to D corresponding to one of the options listed in cells C55-I58.
1
16
Identify whether the analysis supports that being registered to vote is independent of party
affiliation. Choose the correct answer from the drop-down menu in cell C64.
1
17
Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0
Total Points
Updated: 05/20/2018
4
20
Current_Instruction.docx
Purchase answer to see full
attachment