Ashford University MatLab Code

Assignment 2CPS 563 – Data Visualization
Released Date: February 22, 2022
Requirements
In this assignment, you will solve three practical and interesting problems in data visualization. The
problems will gain valuable hands-on experience in data manipulation, data visualization, algorithm
design and implementation.
Problem 1
Given the “Sales by Branch” data below:
Branch
Brighton & Hove
Brighton & Hove
Brighton & Hove
Brighton & Hove
Chichester
Chichester
Chichester
Chichester
Chichester
Chichester
Portsmouth
Portsmouth
Portsmouth
Portsmouth
Portsmouth
Portsmouth
Portsmouth
Southampton
Southampton
Southampton
Southampton
Winchester
Winchester
Winchester
Winchester
Winchester
Winchester
Product Group
Books
Electronics
Hardware
Software
Home & Garden
Health & Beauty
Sports
Software
Electronics
DIY
Books
Home & Garden
Electronics
DIY
Sports
Clothes
Toys & Children
DIY
Hardware
Electronics
Sports
Hardware
Sports
Books
Software
Toys & Children
Electronics
1
Total Revenue
610.00
855.00
998.00
2,020.00
396.00
580.00
613.00
885.00
891.00
1,449.00
268.00
390.00
690.00
834.00
1,008.00
1,016.00
1,201.00
169.00
604.00
757.00
1,567.00
524.00
541.00
806.00
991.00
1,079.00
1,661.00
Sample Output
You are required to:
1. Write Matlab code to create a nested treemap based on the provided data above.
2. Display the final result with your Matlab code.
Problem 2
Normal Daily Mean Temperature
CITIES
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
AKRON, OH
25.2
28.3
37.7
48.1
58.8
67.5
71.8
CLEVELAND, OH
25.7
28.4
37.5
47.6
58.5
67.5
71.9
70.3
63
51.6
41.1
30.7
70.2
63.3
52.2
41.8
31.1
COLUMBUS, OH
28.3
32
42
52
62.6
71.2
75.1
73.5
66.5
54.7
43.7
33.5
DAYTON, OH
26.3
30.3
40.2
50.6
61.2
70.2
74.3
72.3
65.1
53.5
42.2
31.4
MANSFIELD, OH
24.3
27.3
36.7
47.2
TOLEDO, OH
23.9
27
37.2
48.3
58
66.8
71
69.3
62.6
51.5
40.5
29.6
59.6
68.8
73
70.8
63.5
51.8
40.5
29.2
YOUNGSTOWN, OH
24.9
27.7
36.7
47.4
57.6
65.9
69.9
68.4
61.5
50.8
40.7
30.4
JACKSON, KY
33.9
37.9
47.1
56.3
64.1
71.4
75
73.8
67.9
57.5
47.7
38.3
LEXINGTON, KY
32
36.4
LOUISVILLE, KY
33
37.6
45.6
54.6
63.8
72.2
76.1
74.8
68
56.6
45.9
36.3
46.9
56.4
65.8
74.2
78.4
77
70.1
58.5
47.6
37.6
32.9
38.1
47.6
57
65.9
74.5
78.2
76.2
69.1
58
46.8
36.9
31
35.8
45.8
55.5
65.6
74.8
78.6
76.5
69.1
57.3
45.9
35.6
FORT WAYNE, IN
23.6
27.3
38.1
49
60.4
69.7
73.4
71.1
64.1
52.4
40.6
29
INDIANAPOLIS, IN
26.5
31.2
41.7
52
62.6
71.7
75.4
73.5
66.3
54.6
42.9
31.6
SOUTH BEND, IN
23.4
27.3
37.5
48.3
59.6
69
73
71
63.4
52.1
40.1
28.7
PADUCAH KY
EVANSVILLE, IN
2
Given the normal daily mean temperature (oF) of some cities in the Greater Cincinnati Tri-State Area,
Ohio, Kentucky, and Indiana shown in the table above, you are required to:
1. Draw/download a map of the Tri-State Area.
2. Write Matlab code to create a heatmap of the mean temperature for each month (on the map
drawn/downloaded in the task 1 of Problem 2).
Problem 3
You are provided the data file “World Bank CO2.xlsx”. Create seven distinct visualizations for this data
file by using Tableau (https://www.tableau.com/). You also need to describe any patterns you observe
from the seven visualizations.
What to Submit
1. You must submit your program source code that implements all problems in the Assignment 2.
2. A well-written, concise project report. It should include: (a) title and names of group members; (b)
the analysis of each problem; (c) the issues during the implementation; (d) the solutions to overcome the
issues in (c); (e) the contribution of each individual member.
3. The powerpoint slides (maximum 10 slides) used in the Assignment grading.
For each group, you must submit the files above in a single zipped folder named after your student IDs.
Note: If you cannot submit zipped file to isidore, please change the filename extension from .zip to . doc
or .docx or .z1 and then submit it
Submission Due: 11:55pm, March 20, 2022
3