Write out the steps
We have the income (NZ.Stat) and the CPI (Infoshare) data
(
(We did this yesterday)
Start a new
Start a new tab using an existing tab
Join to the other tab
Ohoh not ready yet
Columns need to match
Turn the year into a number without formatting
Remove Q2 from years
Convert to number without formatting
Rename to Year
Hooray
Oh Index is text
Calculation time
Divide through by year’s index
Multiple by index now
Tidy up
Look charts
Does that look right?
Write a short pitch for a data-supported or data-driven article based on police data.
Write the data-supported or data-driven article.
Christmas assaults
Rise in serious assaults
Burglarly town vs town
You don’t need to interview people
But do say who you would interview and why
Final article should be 400 to 600 words
Office hours
Reach out to me if you have questions like: