read prompt and compose a paper

Assignment: Visual Aid and Data Summary

Prompt: Choose a table from the ProQuest Statistical Abstract of the U.S. 2017 Online Edition. Here are a few suggested tables from Section 30: International Statistics.

– Table 1355: Health Expenditures by Country: 1990 to 2016 [Selected Years]

– Table 1369: Household Tax Burden by Country: 2016

– Table 1386: Net Electricity Generation by Energy Source and Country: 2014

The above tables are only suggestions. Feel free to choose any table you are interested in from the Statistical Abstract.

There are two parts to this assignment.

1) Use words to summarize (in 1-2 double-spaced pages) the data displayed in your table. Your audience is a business executive or policy maker who wants to know about patterns, relationships, or trends in the data, but does not have the time to examine the table herself.

Members of a group can either work independently or examine the same table as others in their group. While you may brainstorm and discuss any possible patterns you identify with your group, every student must turn in their own work. All writing must be individually completed. If your group discovers a pattern together, each of you must write about this pattern in your own words. If your group decides to collaborate during the “thinking” phase of this exercise, each student in the group must indicate this and the names of collaborating group members on the work she turns in.

Example: “Lucas Kim, Discussed in class with Randall Christopher, Susane Lee, and Dan Sisti.”

 2) Use the “Download” button on the top right corner of the table’s webpage to download a spreadsheet with the raw numbers from the table. Create a chart demonstrating a pattern, relationship, or trend from the table you are describing. Your audience is a policymaker or business executive to whom you would like to explain the fact. This person does not have time to dissect the table, or read the written summary of the table you prepared in Part 1) of the assignment.

Your chart should be easy to understand and be able to stand alone as a visual aid object. A stranger who happens to come across the chart (with no supplemental text) should be able to understand the fact your chart demonstrates with no further explanation. Be sure to cite the source of the data.

Current

:

to

PS means Federal Information Processing Standard]

Country

2000

2016 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016

25.66 25.61

23.64

23.36

23.07 23.51 23.94 23.88 24.22 23.98 23.36 22.55

23.10 23.36 24.08 24.32

31.39

41.99

30.52

31.83

19.02

19.07

7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00

22.49 22.49

23.75

23.64

22.89

23.10

5.76 6.48

41.91

FI

30.84

30.59

33.88 32.62 32.07 31.51 30.84 31.05 30.59 30.41 30.36 29.27 29.42 29.37 29.38 30.14 30.59

27.85

29.10

22.06

42.66

22.00

22.39

22.49

20.75

20.75

21.09

22.03 20.95 22.29

23.09 24.42

25.19

36.49

31.39

34.50 34.50

30.87

35.24 38.81 38.26 37.76 31.39

27.25

28.63

19.54

16.26

13.87

19.80 20.20

19.25

7.71 7.13 6.68

8.16

11.92

27.25

17.01

26.10 27.25 27.04 23.37 22.08 21.25 20.28 21.22 19.28 17.71 17.01 17.05 16.64 16.37 17.01 17.32 17.80

29.05

28.87

29.19

30.79

31.12

23.51

21.48

21.54

22.69

24.17

24.03

24.24

19.80

21.03 21.34

22.11 22.20

16.04

20.05

8.95

9.27

8.65

9.76

27.88

28.87

26.61

30.73 30.82

29.05

22.60 23.57

24.91

20.79 19.91

23.25

23.98

26.24

28.12 29.53

30.84 30.96

11.55 11.55

17.32

17.46

19.28

3.09

4.78

4.67 5.03 6.04

5.45 6.13 9.25

10.14

2.48 3.09 4.30 4.78 5.28 4.67 5.03 6.04 5.18 5.45 6.13 9.25 9.56 9.84 10.14 10.44 10.84

30.65

32.49 32.47

30.36

27.93 25.46

25.61

26.60

27.85

33.08

28.01

19.71

19.37 19.36 19.42 19.46 19.71 20.03 20.44 21.08 20.51 18.45 16.99 15.87 16.39 16.89 17.25 17.56 17.89

30.79

29.02

29.21

28.38 27.93

26.60

26.77

26.91

26.69

27.59

28.38

24.49 24.61

24.76

25.00

25.67

17.83 17.83 17.83 17.83

18.64

19.19

22.45 21.34

22.49

22.69

21.97

22.20

27.17

13.76

15.25

19.92

23.08 23.24

16.64

8.61 9.39

8.18 8.30

11.06

35.44

33.25

26.90 26.83 26.76 26.83

24.12

24.72 24.61

24.91 24.76 24.91

25.09

20.15 20.47

19.80

22.86 22.92

21.38

12.71

12.62

13.94

30.63

31.19

27.60 26.92

25.10 24.39

24.85 33.73 32.39 30.63 31.24 31.52 31.19 30.88 27.60 26.92 25.40 24.77 24.85 24.90 25.10 24.39 24.58 24.85

17.82 17.85 17.83

17.51

17.24

16.99

12.66

30.45

30.36

26.64

27.25

28.73 30.92 30.12 29.77 30.45 30.50 30.36 29.80

24.48 24.76

24.94 25.24

25.64

25.64

26.83

25.24 25.39 25.07

23.34 25.81

24.77

25.05

23.46 24.73 23.97 23.59

22.74

																			Household Tax Burden by	Country		2000		2016
[As percent of gross wage earnings of the average worker. The tax burden reflects income tax plus employee social security contributions less cash benefits.	FI
FIPS code	Single person without children (percent of gross wage earnings)	One-earner family with two children (percent of gross wage earnings)
	2001		2002		2003		2004		2005		2006		2007		2008		2009		2010		2011		2012		2013		2014		2015
OECD average \1	26.05	25.71	25.62	25.48		25.66	25.51	25.57			25.61		25.19	2		4.67	24.74			25.24	25.35		25.67	25.52	21.20	20.80	20.78	20.60		20.47		20.20	20.31	20.18	19.61		19.02	19.13		19.54	19.78	20.06		20.05	20.11	19.93
United States	US				24.91	24.83	24.66		24.42	24.37	24.27	24.41	24.84	25.32		24.17			24.61			23.64	2		5.45	25.60	25.78	25.98	14.41	13.83	13.82	10.81	10.89	10.94	11.36	12.13		12.62	10.13	11.22	11.21	11.42	13.33	13.60		13.87	14.10
Australia	AS			26.60		23.07			23.51		23.94		23.88		24.22			23.98				23.36		22.55		22.06	22.28	22.27	22.95			23.10		24.08		24.32	25.63	20.88	21.11	21.14	21.85
Austria	AU		30.96				31.39	31.60	32.00	33.22	33.04	33.44	33.84	34.26	32.79	33.07	33.55	33.94	34.38	34.68	35.04	31.87	29.74	30.19	30.43		30.87			31.19	31.07	31.54	31.99		32.47		30.52				30.84		31.83	32.33	32.67		33.08	29.67
Belgium	BE	43.01	42.96		42.66		41.99		41.91	41.92	42.07	42.49	42.29	42.72	42.83	42.71	42.40	42.36	42.01	40.75	32.82	3		3.09	32.97	31.91	30.38	30.44	30.64	31.27	30.97	31.68	31.67	31.18	31.06		30.65		29.10
Canada	CA			25.10	23.63	23.62	23.82	23.78	23.85		23.75	23.29	23.38					22.49		22.39	22.54		22.60	22.68	23.35		23.25		23.08	20.91		19.19	18.89		19.07		1		9.25	16.80	17.08	15.52	1	5.76	16.01	16.09	16.20	1	6.48	17.66	18.26
Chile	CI																																		7.00
Czech Republic	EZ	23.02		23.34		24.03	22.41		22.89		22.29		22.45		23.09	22.87	23.32		23.57	16.49	16.42	17.06		17.46	17.67	13.45	9.90	10.79	6.69	5.90	5.73	6.82	5.81	6.38	6.84
Denmark	DA	41.08	39.97	39.96	3	8.61	38.49	38.59	38.77	38.58	37.19	36.29	36.42		36.49	36.12	35.96	3		6.13	36.19	35.31	34.79	33.97	33.96	33.47	33.36	33.45	33.63	33.37	32.76	32.11	32.36		32.49	32.20	32.01	32.15	32.25
Estonia	EN	21.94		21.48			22.69	23.00	21.86				19.80	18.73	18.69	17.87	18.56	19.48			19.71		19.91	19.49	19.64		18.45	18.29	17.88	16.96		18.64	19.26	16.98	14.83		9.27	11.14	7.04	10.93	12.02		12.71	13.32	13.30		13.76	12.78	12.59
Finland		33.88		32.62		32.07		31.51		31.05				30.59		30.41					30.36		29.27		29.42		29.37		29.38		30.14	30.89			30.79		30.82		30.73
France \2	FR	29.16	28.84	28.44	28.54		28.63			28.87	2	7.71	27.76	27.78			27.85			27.93		28.12	28.26	28.62	28.88			20.75	20.62	20.74		21.09	20.94	21.44		21.54	21.74	21.59		21.97		22.00	22.10			22.20	21.66	21.91	22.16
Germany	GM	43.20	42.03	43.37	42.28	42.21	42.51	42.16	41.85	41.21	39.20	39.75	39.77	39.43	39.47	39.60	39.66		21.38	21.39	21.47		22.03	22.59	22.56	20.61	19.60		21.03		20.95	21.29
Greece	GR	23.05		25.00				24.76	26.07	25.80		25.09	24.81		23.24	26.96		26.61	25.55		25.05		24.24		25.39		24.12	2		4.78	26.55	26.36	27.89	26.20		25.46	25.15	23.70	28.22		27.88		26.91	26.43	25.92
Hungary	HU	35.73	38.34	32.96	34.40	33.65		35.24		38.81		38.26		37.76	35.10	35.13			34.50	33.50	30.72	29.75	26.79	28.74	28.36	26.03	2	6.68	26.32		26.64	26.93	24.44
Iceland	IC	25.44			25.64					27.25		27.59	28.03	2	8.16	27.81				26.83		26.24			27.60			28.38	28.66			29.05	29.33		29.19	16.28	16.48		17.82	18.01	18.87	19.95	20.23	19.23	19.75		16.26		17.51	1	8.95	20.32		19.92			21.34	21.83
Ireland	EI	20.34	17.00	16.27	15.90		15.25	14.69		13.94	16.65		17.85	17.84	19.08	19.52			10.14	8.05		7.13	7.64	5.75	5.56	9.40	10.22	11.17		11.92	12.15	10.80
Israel \3	IS		26.10		27.04		23.37		22.08		21.25		20.28		21.22			19.28		17.71				17.01		17.05			16.64		16.37			17.32		17.80
Italy	IT	28.47	28.10	28.51		28.01	28.75		29.53	29.72	30.23	30.95	31.11	31.03		31.12	24.79		22.11	22.07	20.64	21.63	22.32	23.44		24.49	24.06	24.23
Japan	JA	19.74	19.98	18.22	18.23	18.50	19.44		20.15	20.24	20.04	20.63	21.52	21.84	15.79	15.86		1		6.04	14.17	15.10	15.37	16.35	16.45	16.24	16.86	18.28	19.89	20.40	20.69		20.79
Korea, South	KS	9.17	8.91		9.76	9.88	10.62	12.06	12.14	11.69	12.29	12.49	13.02	13.48	13.65	13.97	14.14		8.18	8.43	8.31		8.65	8.67	9.11	9.59	9.04	9.73	9.79	10.26	10.82		11.06	11.47	11.70
Latvia	LG	28.14	28.35	28.70		29.02	29.41	2	8.30	27.18	30.53	30.13	29.55	28.93	20.14	20.92	21.56		24.72		23.46		22.86	22.90	22.70	18.86	19.43	19.55
Luxembourg	LU	28.67	27.16	24.57	2		5.03	25.89	26.57	27.70	27.39		26.77	28.41	30.00	13.92	12.40			11.55	11.94	12.46	13.42	16.40	16.70	17.96	18.17	18.48	19.21
Mexico	MX		2.48		4.30		5.28		5.18		9.56		9.84		10.44		10.84
Netherlands	NL	33.62			30.63	31.13	32.55	32.51	32.84	31.79	31.66	31.70	32.14	35.79	33.39			30.45	25.31	26.86	26.74	26.80	27.77	27.58	28.27	28.98	30.86	28.39
New Zealand	NZ		19.37		19.36		19.42		19.46		20.03		20.44		21.08		20.51	18.07			16.99		15.87		16.39		16.89		17.25		17.56		17.89
Norway	NO	30.70	31.44	30.16	30.09	29.09	29.54	29.60	29.28	29.26	2	9.39		29.21	28.69	25.95	27.41	27.47		27.17	27.14	26.49	27.08	27.15		26.76		26.69	27.53	27.21	26.84
Poland	PL	27.80	27.66	27.84	28.08	28.71	27.79	25.04			24.39	24.69	24.88		24.94	25.91	25.54	25.84	26.12	26.48		26.90	21.01						17.83	18.08	18.92
Portugal	PO		22.74	22.53	21.79	22.44	21.46	23.28	22.78	27.45	28.31	27.57	17.16	14.90	15.91	15.71	15.72	14.65	15.30	14.70	14.25	14.31	14.38	14.89	17.29	17.14	18.30
Slovak Republic	LO	19.77	20.67	20.55	21.81	21.76	22.13	22.31	22.81	21.40	21.65	22.80	22.79	22.76		22.92	16.76	17.62	16.32	7.92	8.02	10.63	10.68	10.65	10.57	11.48	11.91
Slovenia	SI	35.56		35.44	35.33	35.59	34.72	34.84	32.85	33.05	32.94	33.29	33.41		33.25	33.09	33.33	33.43			26.92	24.31	24.52	24.95		25.07	24.99
Spain	SP	19.85	19.79	20.09	20.29	20.48	20.59	19.30	21.73	22.04	22.99	21.27	11.52	12.10	11.99	12.54	12.96	13.34	11.54	12.19	14.23	14.66	15.22	15.31	15.43	14.07
Sweden	SW		33.73		32.39		31.24		31.52		30.88		25.40			24.77				24.85		24.90		24.58
Switzerland	SZ	17.54	17.50	17.40	17.68	17.13		17.24	17.38	17.49	17.33	16.92	16.88	12.74	12.85	12.94	12.73		12.66	12.08	12.34	11.87	11.79	11.93	11.63	11.20	10.78	10.54	10.47	10.42
Turkey	TU		28.73		30.92		30.12		29.77		30.50		29.80	26.31	26.30	26.58	26.75	27.02	27.37	27.26		24.48	24.82	25.50	25.25
United Kingdom	UK		25.81	25.53	26.72	26.85	26.89	27.01	25.59		24.73		23.97		23.59	23.41	23.52	23.66	24.96	25.14	25.37	23.95	23.60	23.79	22.82
FOOTNOTES:
\1 As of 2016, the Organisation for Economic Co-operation and Development (OECD) is comprised of the 35 member countries shown below.
\2 The figures correspond to the tax calculations that are based on the tax legislation relating to the income earned in the selected year.
\3 The statistical data for Israel are supplied by and under the responsibility of the relevant Israeli authorities. The use of such data by the OECD is without prejudice to the status of the Golan Heights, East Jerusalem and Israeli settlements in the West Bank under the terms of international law.
Source: Organisation for Economic Co-operation and Development (OECD), 2017, “Taxing Wages: Comparative tables”, OECD Tax Statistics (database) ©, , accessed July 2017.