Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

For this project, you will analyze trends in motor vehicle sales in Canada, by fuel type of the vehicle. Part of this project is exploratory data analysis; a plot hasn't been published to show the...

1 answer below »
For this project, you will analyze trends in motor vehicle sales in Canada, by fuel type of the vehicle. Part of this project is exploratory data analysis; a plot hasn't been published to show the trends, so you might create a number of different versions to find a compelling way to visualize the data.

Statistics Canada publishes these data; the most recent release with some analysis can be found here:
[New motor vehicle registrations, second quarter 2021](https://www150.statcan.gc.ca/n1/daily-quotidien/211019/dq211019a-eng.htm)

Part of your project will create two tables: one is the Canadian totals, and it will look something like this table that was published in 2019: (Note that the multi-row header is possible in R, but don't worry if you can't get it perfectly):

![_New motor vehicle registrations, Canada_](new_motor_vehicle_registrations.jpg){width=100%}
For this project, you will also create a second table that is identical to the one above, but with British Columbia numbers.

Note that the table above shows the years from 2014–2018. The data in the folder covers a larger range than what is shown in the table; Statistics Canada's publications tend to summarize the available data to save space. For many applications (including this course) you will want to review as much data as is available! More data points will give you a clearer sense of what the trends might be.

The second part is to create a plot or plots that demonstrate an interesting aspect of the data. This could be:

* change over time, including using the quarterly data series (the table in the file " XXXXXXXXXXcsv"). Does the quarterly data show the impact of the COVID-19 pandemic on vehicle sales?

* comparisons by fuel type, or

* comparisons of the Canadian total to British Columbia,

or some other element you find in the data.


### Data source {#vehicles-data}

The data for this project are in the "data" folder.

The data were sourced from:

Annual data: [Statistics Canada. Table XXXXXXXXXXNew motor vehicle registrations](https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid= XXXXXXXXXX)

Quarterly data: [Statistics Canada. Table XXXXXXXXXXNew motor vehicle registrations](https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid= XXXXXXXXXX)
Answered 2 days After Feb 12, 2023

Solution

Subhanbasha answered on Feb 13 2023
34 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here