Statistical Data StudyMy math lessons are based on a spreadsheet with information about cars. I will study the data and answer the following questions:- · In general, does the age of used cars affect the price? · Does the mileage of used cars affect the price? · The engine size of used cars cars affect price? · The average cost of Vauxhall cars compared to Ford cars. In general, does the age of used cars affect the price? PlanI'm going to find out if the age of used cars affects the price.I'm going to use all the data in the spreadsheet because there are only about a hundred of them. This will make my results as accurate as possible. First, I'm going to separate the age and price columns from the rest of the spreadsheet. Then I will sort the data by age groups and take the average of each group. The averages for each age group will then be placed in a table and on a line of best fit. I'm going to use averages because that's the best way to display the data. All data from each category (car brand) will be used to establish the averages, as there is not enough data in each category to take a sample. Collection, processing and representation I collected the required data and sorted it into tables. All 1 year old cars are shown below. I calculated the average; it will be used in the final table which will compare all ages.AgePrice17999Total1109999883216795Average1750098831750017995114999113995