$1.$ Excel Workbooks

Your report should contain four substantive observations. $($Described later.$)$

o Each observation should be created using at least three pivot tables to dig progressively deeper into your data. $($Thus$,$ your Excel workbooks should contain at least $12$ pivot tables in total.$)$

Save all of your pivot table$/$chart work. Thus, you will create and save each pivot table so that you can show your work in your Excel workbook for each observation that you reference in your paper. Number each pivot table$/$chart and create a reference to the pivot table$/$chart in your write$-$up$.($Most students create one worksheet per observation. Thus, their workbook would have four worksheets each containing $3+$ related pivot tables$/$charts for the observation being analyzed.$)$

$2.$ Report

Your report should include:

$1.$ An Executive Summary for your report containing a summary of overall findings and recommendations from your four observations. $($About half to three$-$fourths of a page.$)$

$2.$ An introduction to your report

$3.$ Four substantive observations. Each observation should be created using at least three pivot tables to dig progressively deeper into your data and include findings from the analyses along with recommendations going forward. $($Thus$,$ your Excel workbooks should contain at least $12$ pivot tables in total.$)$

Thus, the content of each of your four observations will:

$$ analyze the data,

$$ interpret what the pivot results tell you,

$$ provide recommendations and explanations for what to do going forward based upon your findings.

$$ As you write the content of your observations, support your statements using numeric findings from your pivot tables. I will have several reports to grade, so include your supporting numbers in your report. The Pivot table workbook is for analyzing the data, showing your work, and clarification when I have questions. $($I cannot go back and forth between your report and the Excel workbooks to find the data.$)$

$$ Include references to the associated pivot tables in the worksheet $($e$.$g$.,$ if a student was analyzing the data for Center Category Health and Hospitals, the student might reference the first pivot table by using $($HH$\_$p$1)-$ where $$H$$ represents the Center Category examined and P$1$ refers to the first pivot table that you created in a series of three regarding those agencies. Subsequent pivot tables would be: $($HH$\_$p$2,$ HH$\_$p$3)$

$$ Do not copy your pivot tables into your report. I can refer to your workbooks when I want to see your pivot tables.