Please complete the following activities using Excel and the workbook you created in Part I of this Course Project $($add a worksheet to the workbook titled Part III$)$:

Using the measures of central tendency $($mean$,$ median, and mode$)$ and dispersion $($standard deviation$),$ explain the association between all the variables in this project.

What do you notice?

How are they related?

What do they tell you about the data?

Calculate the probability a car on the list will have a price less than $$30,000.$ Calculate the probability a car on the list will have a price greater than or equal to $$30,000.$

Use the normal distribution probability formula.

What are the upper and lower limits for Car Purchase Price with a $95\%$ confidence interval estimate? Be sure to format in currency.

See the Excel steps on page $415$ of the textbook for assistance.

What are the upper and lower limits for the Cost per Mile with a $95\%$ confidence interval.

See the Excel steps on page $415$ of the textbook for assistance.

Criteria for Success: Your responses should address the topics presented as thoroughly as possible. College$-$level writing mechanics are required including spelling, sentence structure, capitalization, and punctuation.

This assessment requires the use of Excel and the submission of an Excel file. Please place all your answers in the Excel workbook and clearly mark all your answers. You should use Excel formulas where appropriate and show your work where formulas are not used.