EXAM QUESTIONS:
For full credit you must
screenshot and then paste your excel work into this document
You must include your name and titles for the graphs to prove that you did the charts yourself.
Question 1: You are asked by a fast food restaurant Henrietta's Chicken Shack to give some summary statistics on customer wait times and then present that data in a table.
Use excel to input the following wait times
[5, 8, 6, 7, 4, 10, 2, 9, 3, 7, 6, 8, 1, 4, 3, 2, 5, 7, 9, 10, 4, 6, 8, 3, 5, 7, 1, 2, 9, 4]
(1) Calculate the summary statistics of time spent waiting
Min Wait Time
Max Wait Time
Mean Wait Time
Median Wait Time
Standard Deviation
Variance
(2) Screen shot your work and answers from excel here
(3) Input your data into Datawrapper and create a Table with (A) an appropriate Title and (B) Your full name in the data source
Paste the table here and also provide the direct link to the chart
Question 2: Go to the website of the US Federal Reserve and download the data for the annual percentage change of inflation from 1914 to 2022.
(1) Create a dataset of the annual CPI index and the CPI rate of change
Like this:
Date / CPI Index / CPI Rate of Change
1914 / 10.0 / 1.3%
1915 / ….Etc …. Etc…
Paste your excel work creating the dataset here:
(2) Create a chart that shows both data series using two different Y axis using excel
Be sure to include both (A) an appropriate Title and (B) Your full name as the creator of the chart and cite the Federal Reserve as the source of the data.
Paste that chart here.
Question 3: We want to visualize the incidence rate, which is the total observations per 100,000 people to see the “Rate” of Crime per 100,000 people in the year 2019
(1) Download the data file for the global distribution of homicides here https://ourworldindata.org/homicides
Simply download the full data (CSV) file and paste a screenshot of that dataset here.
(2) Use datawrapper to create a “heat map” aka Choropleth map to visualize this data
Simply create a new chart, choose Choropleth and input the data for at least 50 countries
Be sure to include both (A) an appropriate Title and (B) Your full name as the creator
Question 4: We want to know if there is a correlation between Housing Starts and National Unemployment Rate
You can find the data sets here. https://www.macrotrends.net/charts/economy
(1) Create a dataset showing Date / Housing Starts / Unemployment Rate
Screenshot and paste the dataset here
(2) Do a scatter plot of the data and screenshot and paste it here. Be sure to include (A) A tile and your name in the chart (B) the trendline and (C) The equation and R squared value in the chart.
(3) Explain in at least 4 sentences what your observation is of that data
2
www.euruni.edu
image1.png