QoL Data Analysis- Test¶
Thank you for applying for the position, QoL Data Analyst. Your next step is to complete a quick test that measures your analysis & presentation skills. As a data analyst, you will often find yourself in situations where you have more questions than answers.. This exactly that kind of a scenario!
Please use your best judgement to make appropriate assumptions throughout the test.
You may use R or Python to code. You may need to clean the data to ensure accurate analysis
The steps to finish the test:
• Step 1: Make a copy of the file to your LionDrive
• Step 2: Work with the copy
• Step 3: Submit the copy to hnt2107@columbia.edu with the email subject ‘QoL Data Analysis Solution- your name’.
Before you submit your test, make sure to re-run your code from the beginning (You can do so by first clicking Runtime/Reset All Runtimes and then click Runtime/Run all).
Make sure to use print() function to print out your numerical results.
Exercise 1¶
Import the data set from the drive location¶
Filename: test_data.xlsx
In [0]:
Exercise 2¶
Visualization Exercise¶
i. Create a histogram of respondents according to their program (M.S, PhD, etc.)
ii. Create a pie-chart representing the percentage of respondents by department
In [0]:
Exercise 3¶
Data Exploration Exercise¶
i. How do the respondents feel about PDL core classes?
ii. Which department would you say is the most satisfied with PDL core classes?
In [0]:
Exercise 4¶
Summary!¶
Make a single visualization that informs us more about events enjoyed by respondents. As a Data Analyst, What recommendations would you give to the Student Council?
i. Add your recommendation(s) here.
In [0]: