The scatter graph shows the age and the value of each of ten cars of the same make and model.11 00010 0009000800070006000500040003000200010000 11109876543210Age (years)Value of car(£)(a) Describe the relationship between the value of a car and the age of the car.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................(1)(b) Draw a line of best fit on the scatter graph.(1)It may not be reliable to use the line of best fit to predict the value of a car that is10 years old.(c) Give a reason why.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................(1)(Total for Question 2 is 3 marks)

A new car worth $30,000$30,000 loses 22%22% of its value every year. What does the graph of the value of this car look like?

This data base belongs to a used car dealer. This has data about 24 cars having unique field (column) named "Sales Tag" and also 7 more mentioned fields (columns). Use the relevant excel operations and formulas to solve the following:Calculate the age of every car in the inventory in weeks.The column "Selling Price" is empty. There's been given Profit %age value. Find the Selling Price of every car given that Selling Price = Cost Price + (Profit %age* Cost Price).On the basis of the "Mileage", determine the car is old or new. Use "O" for old and "N" for new. Car with mileage greater than 85000 is old and rest are new.After solving Q3, find the number of old and new cars. Also highlight the old cars with light brown and new cars with light grey color. (Highlight "O" and "N" values.)After calculating the values in Q2, highlight the Top 5 "Selling Price" figures with green color and bottom 3 with red color.At the end of the dataset, there are few cars mentioned with their sales tag. Use a suitable function to find all the details of those cars using their "Sales Tag " value that has been provided to you.

A survey was conducted to study the relationship between a college student’s age and the value of the car they drive. Data were collected from a random sample of 300 students from a certain college. The values of the students’ cars were found using Kelley Blue Book.Which of the following would be a meaningful display of the data from this study? A histogram Side-by-side boxplots A pie chart A two-way table A scatterplot

Alex bought a new car for his daughter.  He knows the value of the car will decrease at a constant rate.  After 3 years, the value of the car is $15,000.  After 5 years, the value of the car of $11,000.  Write and solve a linear equation to find the value of the car after 8 years.

A car was valued at $35 000 at the time of purchase. The reducing balance of the carwas 18% per year. The depreciating value of the car can be modelled by the recurrencerelation:𝑉0 = 35 000, 𝑉𝑛+1 = 0.92𝑉𝑛Use the recurrence relation to find the value of the car after 10 years.