KellyBlueBookData.xlsx

please see the above data set for information

What is the make and model of the most expensive car? What is the make and model of the cheapest car? (Hint: By far the easiest way is to sort the price column and examine the first row and last row. However, for practice, I suggest you use the max and min function in combination with a VLookup. This will be good practice for the exam.)

Run the descriptive statistics on the price variable and report the results. This is through the Data Analysis Tool Pack.

Is the mean and median close to one another? If not, what does that tell us? Display the histogram (using bins of your choosing). Use the histogram and the term skewness and kurtosis to provide evidence in your answer.

What is the correlation between car price and mileage? Is this high or low correlation? What does the correlation tell us in terms of the data?

Should you run correlation between leather and price? If yes, what is the correlation and explain the correlation in terms of the data. If you cannot run the correlation, tell me why.