Question

The following chart represents the total registrations of plug in hybrid and all electric vehicles in world for the given years

Year: 2016 2017 2018 2019 2020 2021
Sales in thousands: 792 1263 2082 2264 3240 6400

Use Excel to draw a well labelled Scatter diagram of this data using YEARS SINCE 2016 on the x axis and total vehicle sales on the y-axis

Answer 1

To create a scatter diagram using Excel, organize the data into two columns: Years since 2016 and Total Vehicle Sales. Then, select the data and choose the scatter chart type, labeling the axes and including a title.

Step-by-step explanation:

Scatter Diagram of Total Registrations of Plug-in Hybrid and Electric Vehicles:

To create a scatter diagram using Excel, you will first need to organize the given data into two columns: Years since 2016 and Total Vehicle Sales. Then, follow these steps:

1. Open Excel and enter the years since 2016 in one column and the corresponding total vehicle sales in another column.
2. Select the two columns of data.
3. Click on the 'Insert' tab and then choose the 'Scatter' chart type.
4. Select a scatter plot chart with markers only.
5. Click 'OK' to create the scatter diagram.
6. Label the x-axis as 'Years since 2016' and the y-axis as 'Total Vehicle Sales'.
7. Include a title for the chart.