XL1A: Graph Nominal Frequency Data Using Excel2013 3/10/2017 V0E - - PDF document

▶
xl1a graph nominal frequency data using excel2013 3 10
SMART_READER_LITE
LIVE PREVIEW

XL1A: Graph Nominal Frequency Data Using Excel2013 3/10/2017 V0E - - PDF document

Dec 23, 2022 466 likes •622 views

XL1A: Graph Nominal Frequency Data Using Excel2013 3/10/2017 V0E XL1A: V0E XL1A: V0E Graph Categorical Count Data using Excel2013 1 Graph Categorical Count Data using Excel2013 2 Graph Nominal Frequency Goal: Graph Data using Excel 2013

slide-1
SLIDE 1

XL1A: Graph Nominal Frequency Data Using Excel2013 3/10/2017 V0E Excel2013-Graph-Nominal0-Slides.pdf

1

Graph Categorical Count Data using Excel2013 XL1A: V0E

1

by Milo Schield

Elected Member: International Statistical Institute (ISI) US Rep: International Statistical Literacy Project (ISLP) Vice President: National Numeracy Network (NNN) Director, W. M. Keck Statistical Literacy Project

Related materials at www.StatLit.org/pdf/ Excel2013-Graph-Nominal0-Slides.pdf Excel2013-Graph-Nominal0-Demo-output.pdf

Graph Nominal Frequency Data using Excel 2013

Graph Categorical Count Data using Excel2013 XL1A: V0E

2

Goal: Graph Nominal Frequency Data

Assignment: Create six charts (pie, column and bar)

  • Three for count data as shown on slides 5, 8 and 9.
  • Three for percent data as shown on slide 10.

Creating enhanced charts (c.f., slide 12) is not required.

Data is from the 2014 Pew Survey on Religion in the US.

www.pewforum.org/2015/05/12/americas-changing-religious-landscape/

Data for this assignment is available at:

www.StatLit.org/XLS/Excel2013-Graph-Nominal0-Data-Input.xlsx

Graph Categorical Count Data using Excel2013 XL1A: V0E

First time:

  • 1. Select B5:C8.
  • 2. Insert/Chart.

Do not include TOTAL row!

Subsequent times:

  • 1a. Re-select same data
  • 1b. Insert chart

Since all graphs use B5:C8,

  • 2a. Copy/paste the last graph
  • 2b. Select part of new graph,
  • 2c. Right mouse and select

“Change chart type”

  • 2d. Change type as needed.

3

Two ways: Select Data

  • r Copy/Paste/Modify Chart
Graph Categorical Count Data using Excel2013 XL1A: V0E

4

Insert Pie Chart: 2-Dimension

Never use a 3-D pie chart. Areas are distorted!

Graph Categorical Count Data using Excel2013 XL1A: V0E

5

#1: Pie Chart of Counts

.

Graph Categorical Count Data using Excel2013 XL1A: V0E

6

Copy/paste last chart or Select data; Insert column chart

.

slide-2
SLIDE 2

XL1A: Graph Nominal Frequency Data Using Excel2013 3/10/2017 V0E Excel2013-Graph-Nominal0-Slides.pdf

2

Graph Categorical Count Data using Excel2013 XL1A: V0E

7

#2: Column Chart of Counts

.

Graph Categorical Count Data using Excel2013 XL1A: V0E

8

#3: Create bar row chart [Note: Order is reversed]

.

Graph Categorical Count Data using Excel2013 XL1A: V0E

9

On Percent Worksheet: Create Pie, Col. & Row Graphs

0% 10% 20% 30% 40% 50% 60% 70% 80% Christian Religious, non‐Christian Unaffiliated/None

Distribution of US Adults

0% 10% 20% 30% 40% 50% 60% 70% 80% Christian Religious, non‐Christian Unaffiliated/None

Distribution of US Adults

Required: Modify titles

  • n all percentage

graphs

Graph Categorical Count Data using Excel2013 XL1A: V0E

10

Appendix: Optional No extra points!

Making charts suitable for high-level presentations

Graph Categorical Count Data using Excel2013 XL1A: V0E

11

Not Required Enhanced Bar Chart (%)

Creating these charts is easy – when given summary data. For a professional presentation, select and enhance:

  • 1. Select the percent charts. If the sample is representative

then the sample percentages also apply to the population.

  • 2. Enhance the charts so they are more readable
  • Increase font size and bold. Change color from grey to black.
  • 3. Enhance the charts so they are self-documenting
  • Add some indication of the data source.
  • 4. Optional: Add data labels – depending on the audience
Graph Categorical Count Data using Excel2013 XL1A: V0E

12

Not Required: Enhanced Bar Chart

73% 5% 22%

0% 20% 40% 60% 80% Christian Religious, non‐Christian Unaffiliated/None

Distribution of US Adults by Religious Group

Pew 2014 Religious Survey

slide-3
SLIDE 3

Graph Categorical Count Data using Excel2013 XL1A: V0E

1

by Milo Schield

Elected Member: International Statistical Institute (ISI) US Rep: International Statistical Literacy Project (ISLP) Vice President: National Numeracy Network (NNN) Director, W. M. Keck Statistical Literacy Project

Related materials at www.StatLit.org/pdf/ Excel2013-Graph-Nominal0-Slides.pdf Excel2013-Graph-Nominal0-Demo-output.pdf

Graph Nominal Frequency Data using Excel 2013

slide-4
SLIDE 4

Graph Categorical Count Data using Excel2013 XL1A: V0E

2

Goal: Graph Nominal Frequency Data

Assignment: Create six charts (pie, column and bar)

  • Three for count data as shown on slides 5, 8 and 9.
  • Three for percent data as shown on slide 10.

Creating enhanced charts (c.f., slide 12) is not required.

Data is from the 2014 Pew Survey on Religion in the US.

www.pewforum.org/2015/05/12/americas-changing-religious-landscape/

Data for this assignment is available at:

www.StatLit.org/XLS/Excel2013-Graph-Nominal0-Data-Input.xlsx

slide-5
SLIDE 5

Graph Categorical Count Data using Excel2013 XL1A: V0E

First time:

  • 1. Select B5:C8.
  • 2. Insert/Chart.

Do not include TOTAL row!

Subsequent times:

  • 1a. Re-select same data
  • 1b. Insert chart

Since all graphs use B5:C8,

  • 2a. Copy/paste the last graph
  • 2b. Select part of new graph,
  • 2c. Right mouse and select

“Change chart type”

  • 2d. Change type as needed.

3

Two ways: Select Data

  • r Copy/Paste/Modify Chart
slide-6
SLIDE 6

Graph Categorical Count Data using Excel2013 XL1A: V0E

4

Insert Pie Chart: 2-Dimension

Never use a 3-D pie chart. Areas are distorted!

slide-7
SLIDE 7

Graph Categorical Count Data using Excel2013 XL1A: V0E

5

#1: Pie Chart of Counts

.

slide-8
SLIDE 8

Graph Categorical Count Data using Excel2013 XL1A: V0E

6

Copy/paste last chart or Select data; Insert column chart

.

slide-9
SLIDE 9

Graph Categorical Count Data using Excel2013 XL1A: V0E

7

#2: Column Chart of Counts

.

slide-10
SLIDE 10

Graph Categorical Count Data using Excel2013 XL1A: V0E

8

#3: Create bar row chart [Note: Order is reversed]

.

slide-11
SLIDE 11

Graph Categorical Count Data using Excel2013 XL1A: V0E

9

On Percent Worksheet: Create Pie, Col. & Row Graphs

0% 10% 20% 30% 40% 50% 60% 70% 80% Christian Religious, non-Christian Unaffiliated/None

Distribution of US Adults

0% 10% 20% 30% 40% 50% 60% 70% 80% Christian Religious, non-Christian Unaffiliated/None

Distribution of US Adults

Required: Modify titles

  • n all percentage

graphs

slide-12
SLIDE 12

Graph Categorical Count Data using Excel2013 XL1A: V0E

10

Appendix: Optional No extra points!

Making charts suitable for high-level presentations

slide-13
SLIDE 13

Graph Categorical Count Data using Excel2013 XL1A: V0E

11

Not Required Enhanced Bar Chart (%)

Creating these charts is easy – when given summary data. For a professional presentation, select and enhance:

  • 1. Select the percent charts. If the sample is representative

then the sample percentages also apply to the population.

  • 2. Enhance the charts so they are more readable
  • Increase font size and bold. Change color from grey to black.
  • 3. Enhance the charts so they are self-documenting
  • Add some indication of the data source.
  • 4. Optional: Add data labels – depending on the audience
slide-14
SLIDE 14

Graph Categorical Count Data using Excel2013 XL1A: V0E

12

Not Required: Enhanced Bar Chart

73% 5% 22%

0% 20% 40% 60% 80%

Christian Religious, non-Christian Unaffiliated/None

Distribution of US Adults by Religious Group

Pew 2014 Religious Survey