1. Open the PCE_results en 2010-13 Excel file saved on the topic page.
2. On the Excel spreadsheet, click on the Fiscal Year field down arrow and select 2010
3. Click on the Jurisdiction field and select the following in the same manner:
   1. Ontario
   2. Quebec
   3. Alberta
   4. Manitoba
   5. Canada
4. Click on the Case Mix Group field and select the following:
   1. CMG 163 (Major Cardiothoracic Intervention with Pump)
   2. CMG 164 (Major Cardiothoracic Intervention without Pump)
5. Click on Age Group and select 18 59
6. Sort the data by Case Mix Group and then by Jurisdiction
7. Copy and paste (values and number formats) this data into a new Excel file.
8. Save this file. Name the file CMG 163_164_your name
9. Repeat the above process for Fiscal 2011/12
10. Copy and paste (values and number formats) into a clean worksheet in the file you saved in Step 8.
11. Label each tab with the corresponding fiscal year.

Analyze the 4 provinces:

1. Provide some background information about the 2 CMGS. What does with pump or without pump mean? Provide some detail here.
2. Compare estimated average cost
3. Compare average acute LOS
4. Compare volume of typical cases

Which province has the better utilization and why? Compare to overall for Canada. Create charts or graphs in Excel to show your analysis and provide a Word document describing your analysis. The Excel document should have a README tab that describes the criteria and the source.

Please provide the necessary details/labels in your graphs (titles, axis labels, units, legends, etc.)