# create and calculate the following in excel

You manage the inventory for a car dealership. Your management would like you to review current inventory on the dealership lot.

**Review** the Week 2 Data Set.

You manage the inventory for a car dealership. Your management would like you to review current inventory on the dealership lot.

**Review** the Week 2 Data Set.

**Create** and** ****calculate** the following in Excel^{Â®}:

- Create
- Create
- Create a Frequency Table for classes of MPG, including Frequency and Relative Frequency for the cars in the sample.
- Calculate
- Compare

- Calculate
- Highlight
- Calculate
- Calculate

- Create
- Create
- Create a Frequency Table for classes of MPG, including Frequency and Relative Frequency for the cars in the sample.
- Calculate
- Compare

- Calculate
- Highlight
- Calculate
- Calculate