Complete the spreadsheet template following Steps 1–10, building a comprehensive workbook of data and analyses that will inform your conclusions in Step 10. Your final spreadsheet should include the following: Tab 1: DATA – completed data sheet (Steps 1–6 above) Tab 2: Excel Summary Stats (Step 7) Tab 3: Graphs – Charts (Step 8) Tab 4: Histogram (Step 8) Tab 5: Sorted Data (Step 9) Format this workbook so that all the spreadsheets can be printed. Now that you have completed your analysis, think about the patterns you’ve seen in the workforce. Write a short 3-4 paragraph summary of your analysis. This is important. While you have done a wonderful job with your analysis, you can never assume that the end-user will be able to interpret the data the way it should be understood. Supporting narrative is helpful (I call this, never simply providing a “raw data” dump – strive to provide information!). The paper sections include – one paragraph narrative summary of your findings; describing patterns of interest – explanation of their potential relevance of such patterns – describe how you will further investigate to determine if your results are “good or bad” for the company Prepare your response in this workbook. Place it at the front on completion
Now that you have completed your analysis, think about the patterns you’ve seen in the workforce.