Year
	2018	2019	2020	2021
Total Revenue ($ million)	1.20	1.10	1.25	1.356
Total Costs ($ million)	0.95	0.9	1.0	1.1
Total Rides ('000)	60	55	75	74

Table 1: Summary data of Quber per financial year

1. (5 marks) Calculate the ratios of Revenue to Costs for each year 2018-2021 from the data (Table 1) in Excel. In addition, make a clustered column chart of these two variables and label accordingly. Show your calculations for the years of 2018 to 2021 in Excel and make a column chart.

You should set up an Excel spreadsheet as explained below:

EXCEL Instructions:

1. In Excel, set up a new spreadsheet and copy the data from Table 1 into the spreadsheet.

Unsure how to perform the calculations? The Week 0 notes include examples and on page 11 in the Excel Booklet which will show you how to perform a division so you can calculate the requested ratios to 4 decimal places.

1. Select the data corresponding to Table 1 and create a clustered column chart.

I did the ratios but don't understand how to make the graph with both variables