ABCDEFGHIJKLMNOPQRSTU
1
PRACTICE QUESTION (with some hidden data cleaning)
2
3
Create a chart for the data below that emphasizes both change over time AND the sum of each part toward the total for each year.
4
In other words, show both total expenses each year, and how each part of the total changed over time, in one chart.
5
6
Include a chart title with meaningful labels and source credits, and follow good design principles.
7
8
In your response, EXPLAIN the type of chart you created and why, and then PASTE a link to your chart (using either a shared Google Sheet or a published Datawrapper chart).
9
10
HINT: You may need to clean up and/or reformat the data before you visualize it.
11
12
Annual undergraduate expenses at Trinity College
13
Academic Year2002201020202024
14
Tuition$25,880$38,900$56,380$64,430
15
Required Fees$906$1,940$2,670$2,990
16
Room$4,524$6,860$9,960$11,640
17
Meal Plan$2,990$3,700$5,340$6,350
18
Sources: Trinity College Fact Book - present (https://www.trincoll.edu/asic/factbook/) and archived (https://web.archive.org/web/20100527215124/http://www.trincoll.edu/orgs/planning/publicdata/Expenses.html)
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100