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.

Find out the number of Manufacturers in the Car Sales Dataset using Calculated Fields

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)

Assume that Toy-Cars Inc. uses a periodic specific identification inventory system. Its ending inventory consists of 2 cars from beginning inventory, 4 cars from the Jan. 5 purchase, and 10 cars from the Jan. 30 purchase. Calculate the dollar value of its ending inventory, based on the information provided below.  DateActivity Jan 1Beginning Inventory10 cars @ $12Jan 5Purchase10 cars@ $15Jan 30Purchase10 cars@ $18Multiple choice question.$160$264$450$186

The table gives the weekly sales of a car dealer for the first 26 weeks of the sales year.Week Cars Sold1 12 13 44 25 46 107 88 59 910 611 212 513 614 515 716 117 418 619 820 921 222 523 924 525 326 32Select the correct answer.What is the point estimate for the number of cars sold per week for a sample consisting of the following weeks: 1, 3, 5, 7, 10, 13, 14, 17, 19, 21? A. 4.8 B. 5.22 C. 6.38 D. 6.1

Write the explicit formula for the number of cars sold, PN .