Toggle navigation
J298 Data Journalism
Name
Email
1. Identify the categorical variables from this list: a) month of the year; b) height (meters); c) identifies as conservative or liberal; d) speed (mph); e) weight (lbs); f) speed (high, medium, low).
2. List three possible summary statistics (aggregate measures) for a continuous variable, with a one-sentence explanation of each. For example, sum is the result of adding together the values for all records in the dataset. (Do not repeat this example!)
3. What should be the delimiter in a text file of data with the extension
.csv
?
4. An agency’s budget was $21 million in 2017. It is $24.5 million in 2018. What was the percentage increase, rounded to one decimal place?
5. There were 15,000 violent crimes in 2017 in city A, which had a population of 350,000. There were 9,000 violent crimes in City B, which had a population of 500,000. Complete the following sentence with a number rounded to one decimal place: “City A’s violent crime rate was ... times that of city B.”
6. When writing a spreadsheet formula, what is the first character that you should type?
7. Donald Trump’s approval rating is estimatated at 40% in a new poll. The margin of error is 3.5 percentage points. If this poll had been repeated 100 times, what is the range of values within which his approval rating would fall within 95% of the time?
8. Why are variables containing text values often put within quote marks in a CSV file?
9. What type of chart is this?
10.
This story
made page A1 of
The New York Times
, but is seriously flawed as a work of data journalism. In no more than two paragraphs, explain what was wrong. Hint: Think “compared to what?” and explain what would need to be measured and calculated, to really know whether Yankees caps tend to be worn by criminals. (There are no marks here for simply saying the story was vague!)
Submit