General statistics using PostgreSQL
Budget: $10 – $30 USD
I will provide the link to download the database and then you should do what is described below and send me print screws of the results.
Task 1:
1) Create a view that calculates the standard deviation of the annual registration of private vehicles per make.
Create a view that determines if there is any correlation between Toyota Corollas and Suzuki Swifts over the past 10 years.
2) Amend the above view to include and determine the covariance of the Toyota Corollas and Suzuki Swifts registrations over the past 10 years to see if there is any relationship.
3) Test and graph the above views and results in Excel.
Task 2:
1. Back story Motor Vehicle Register (MVR)
Currently, we know the open data vehicle register provides a point-in-time snapshot of all vehicles registered in New Zealand and is updated monthly. This data relates to vehicles, not people. However, we can use this data alongside other data, to analyse people’s vehicle purchasing choices.
One way to examine this theory would be to investigate the price of fuel over the last 30-40 years.
The idea is based on fuel prices determining whether people have changed purchasing behaviour, perhaps affecting larger engine size/capacity sales ie when fuel increases in price go for a more economical vehicle
Another idea is the state of the economy: particular events over the last 30-40 years may have caused people to rethink their vehicle purchasing choices.
2. Investigation
Perform an investigation in periods over the last 30-40 years into the economic state of NZ – good years vs depressions.
Do another investigation into the fuel prices over the same period.
Curate the above two datasets in such a way that we analyse them alongside the vehicle registration data.
Determine if there is any relationship between the three datasets
Task 1:
1) Create a view that calculates the standard deviation of the annual registration of private vehicles per make.
Create a view that determines if there is any correlation between Toyota Corollas and Suzuki Swifts over the past 10 years.
2) Amend the above view to include and determine the covariance of the Toyota Corollas and Suzuki Swifts registrations over the past 10 years to see if there is any relationship.
3) Test and graph the above views and results in Excel.
Task 2:
1. Back story Motor Vehicle Register (MVR)
Currently, we know the open data vehicle register provides a point-in-time snapshot of all vehicles registered in New Zealand and is updated monthly. This data relates to vehicles, not people. However, we can use this data alongside other data, to analyse people’s vehicle purchasing choices.
One way to examine this theory would be to investigate the price of fuel over the last 30-40 years.
The idea is based on fuel prices determining whether people have changed purchasing behaviour, perhaps affecting larger engine size/capacity sales ie when fuel increases in price go for a more economical vehicle
Another idea is the state of the economy: particular events over the last 30-40 years may have caused people to rethink their vehicle purchasing choices.
2. Investigation
Perform an investigation in periods over the last 30-40 years into the economic state of NZ – good years vs depressions.
Do another investigation into the fuel prices over the same period.
Curate the above two datasets in such a way that we analyse them alongside the vehicle registration data.
Determine if there is any relationship between the three datasets