1. Import NFL into Excel
2. Scatterplot: Income ($mil) to Revenue ($mil)
3. Insert Scatterplot
4. Move chart to new sheet
5. Add Series
6. Add Series Name: Income to Revenue
7. X values are Revenue, Y values are Income
8. Change Title: Income (y) to Revenue (x) (millions of dollars)
9. Save your workbook as Excel Lab 3- Describing Data II

1. Copy and paste your work to final Lab 3 document to submit.

Paste work here:

Revenue to Income (millions of dollars)

Time Series

1. Import BPOIL into Excel
2. Time Series: BBL (Barrel of Crude Oil) in May
3. Insert 2D Line Chart
4. Select data> remove CumBBL
5. Move chart to new sheet
6. Change Title: BBL (Barrel of Crude Oil) in May
7. Save your workbook as Excel Lab 3- Describing Data II

1. Copy and paste your work to final Lab 3 document to submit.

Paste work here:

BBL (Barrel of Crude Oil) in May