Assignment 2
Assignment 2. Location Visualization & Market Analysis
1. Please find the top 10 U.S. cities according to population and visualize their populations according to location on a map in Excel. Please explain:
a. Your data source
b. Your visualization method/procedure
(Hint: In addition to population data, you need to get city location data. You can use bubble chart, in which x and y axis represent the longitude and latitude, and bubble size represents population. You can also put a US map as the background of the figure.)
2. You work for an education company, who has all the student enrollment data of China.
The data set contains the following information of all students enrolled to universities in the recent 10 years. Please design a market report to help people understand the data and lead to some business insights. Your targeted audiences can be school managers, teachers, students or other parties that are related to the education industry.
(Since you do not have the real data, please use your best rationale and business knowledge to make the design. You can describe the designed analysis in bullet points. You can also sketch some charts that are not easy to verbally describe. You are welcome to discuss the problem on CANVAS. Your contributed online comments will be considered in grading, if relevant and valuable.)
Variable
School Location
School Name
School Type
School Funding Type
Total Area
Building Area
Address
Zip code
School Website
School Email
School Telephone
President name
Student ID
Student Name
Student Phone
National ID
Gender
Birthday
Ethic Group
Minority (Ethic Group)
Hukou Location
Hukou Region
Hukou Type
Enrollment Time
Major
Class No.
Diploma Type
Example
Beijing
AAA U
Research/Teaching/Other
Public school / Private School / Other
10000m2
50000m2
Beijing Haidian XXX XXX
111001
www.aaa.edu.cn aaa@163.com 18500122222
Zhang San
14000046100005
Li Si
18500192222
xxxxxxxxxxxxxxxxxx
Male
1989/11/03
Han
No
Beijing
East/West/Middle
Urban/Suburban/Rural
1. Please find the top 10 U.S. cities according to population and visualize their populations according to location on a map in Excel. Please explain:
a. Your data source
b. Your visualization method/procedure
(Hint: In addition to population data, you need to get city location data. You can use bubble chart, in which x and y axis represent the longitude and latitude, and bubble size represents population. You can also put a US map as the background of the figure.)
2. You work for an education company, who has all the student enrollment data of China.
The data set contains the following information of all students enrolled to universities in the recent 10 years. Please design a market report to help people understand the data and lead to some business insights. Your targeted audiences can be school managers, teachers, students or other parties that are related to the education industry.
(Since you do not have the real data, please use your best rationale and business knowledge to make the design. You can describe the designed analysis in bullet points. You can also sketch some charts that are not easy to verbally describe. You are welcome to discuss the problem on CANVAS. Your contributed online comments will be considered in grading, if relevant and valuable.)
Variable
School Location
School Name
School Type
School Funding Type
Total Area
Building Area
Address
Zip code
School Website
School Email
School Telephone
President name
Student ID
Student Name
Student Phone
National ID
Gender
Birthday
Ethic Group
Minority (Ethic Group)
Hukou Location
Hukou Region
Hukou Type
Enrollment Time
Major
Class No.
Diploma Type
Example
Beijing
AAA U
Research/Teaching/Other
Public school / Private School / Other
10000m2
50000m2
Beijing Haidian XXX XXX
111001
www.aaa.edu.cn aaa@163.com 18500122222
Zhang San
14000046100005
Li Si
18500192222
xxxxxxxxxxxxxxxxxx
Male
1989/11/03
Han
No
Beijing
East/West/Middle
Urban/Suburban/Rural