Session Project $-$ Cyber Security Data.xIsx

Session Project $-$ Sales and Demographics Data.xlsx

Session Project $-$ Sport Management Data.xlsx

Session Project $-$ Stock Market Data.xlsx

Part I Descriptive Statistics $(100$ points$)$

You need to prepare a single workbook that summarizes and charts data you feel is relevant to understanding the characteristics of your data set. This is an intentionally open$-$ended assignment similar to what you might receive in industry. This is real world data that has not been cleansed. Therefore, it may be necessary to remove observations $($rows$)$ that seem inappropriate or modify your data structure for analysis. Document any data elements your removed and note why by cutting and pasting them below the original data table. Then add a comment after the item summarizing your justification for removing the data.

Create a new worksheet called D$1.$ Summarize a single quantitative characteristic and use any descriptive statistic that you feel is useful in presenting the data, including summary measures, pivot table reports, and charts. Add a text box to describe the contents $($why did you select this characteristic, why it is important$)$ and the conclusions $($what did the data show?$).$

Create a new worksheet called D$2.$ Summarize a single qualitative characteristic and use any descriptive statistic that you feel is useful in presenting the data, including summary measures, pivot table reports, and charts. Add a text box to describe the contents $($why did you select this characteristic, why it is important$)$ and the conclusions $($what did the data show?$).$

Create a new worksheet called D$3.$ Summarize a single quantitative or qualitative characteristic and use any descriptive statistic that you feel is useful in presenting the data, including summary measures, pivot table reports, and charts. Add a text box to describe the contents $($why did you select this characteristic, why it is important$)$ and the conclusions $($what did the data show?$).$

Make sure to format the sheets and contents appropriately $($remember to label the tabs$)$ and consistently to communicate your summary to your audience. You are summarizing, so avoid too much information.

Submit your sheets and summary to your instructor here.