Do some Excel Work

Putting It All Together Understand the Need for Data Analysis | Organize the Data | Analyze the Data | Draw Conclusions | Present the Evidence | Wrapping Up This week, you will be performing an independent data analysis activity. The Excel project for this week is designed to meet the requirements of TCO 9 and bring together all that you have learned in Week 1 through Week 5. The focus of the TCO is: Given data in a database application, perform an analysis of the data in a spreadsheet program and prepare a Memo, which summarizes the analysis and makes a recommendation to management. You will be provided with the data, and then required to analyze the data in three different methods. You will then be required to provide a Memo with your summary and recommendations. In past weeks, you have been provided with step-by-step instructions as we have worked through the labs; now, you will have the opportunity to take data exported from a company database, format it professionally as a spreadsheet, and then perform data analysis. In this lecture, we will look at the steps that professionals follow as they face an open-ended data-analysis problem, and then walk you through the process of completing the analysis. More info available when ready to start the project.