1. (4 marks) A certain magazine would like to know, among Accord, Camry, F-Series, Ram, and Silverado, which is most popular. The research worker from that magazine has drawn a sample of 50 of these five vehicles recently sold and the data set AutoData.xlsx can be found in BRIGHTSPACE. (Parts a, b, and c, use Excel) Construct a frequency distribution to summarize the data. Develop a relative frequency (or percent) distribution. Construct a bar chart, and label the axes with the context of the problem. Make an inference about vehicle sold and answer the request of that magazine