C/F/81. A statistical survey on the variety and the pricing of the second hand cars sold by the local car dealers

A statistical survey on the variety and the pricing of the second hand cars sold by the local car dealers is performed. Data is acquired from the autotrader.co.uk internet database. A set of 75 cars of 3 brands, not older than 5 years, is analyzed using the MS Excel. Descriptive statistical values are calculated and interpreted; some frequency distributions and statistical observations on the car colour, engine size, and CD-player accessory are presented. A question is formulated concerning the difference in the average price of cars sold by different dealers. A simple investigation is undertaken to show that the price difference is defined by the choice of cars but not by the pricing policy of the traders. A critical appraisal of the survey is performed. MS Excel file with the pivot table and a variety of graphs and histograms is attached.