Final Project: MS EXCEL Data Analysis Report… 1 answer below »
Final Project: MS EXCEL Data Analysis Report
Spreadsheets are useful for many other things besides financial tasks, such as progress reports and for keeping track of descriptive data. For your final project and presentation in this course, you will create at least two tables and an accompanying graphic that will help you write functions and learn simple programming techniques using advanced Excel features. This assignment gives you the opportunity to demonstrate the knowledge you have gained by using real-world data and applying at least five features of Excel to your dataset.
Similar to the work you completed for your intersession assignments, you will need to locate real-world data. For this assignment, you will need to locate and utilize large datasets Resources for large dataset can be downloaded from several web sites such as http://www.datasciencecentral.com/profiles/blogs/big-data-sets-available-for-free.
In an 8-10 page report:
- Provide an introduction to your overall project
- Give a rationale and explanation for the datasets you have chosen
- Include at least two tables demonstrating your data and analysis
- Create at least one graphic to visualize the data and your analysis
- Explain how you have analyzed the data uzing at least 5 Excel functions
- Give a thorough analysis of the data and it’s implications not only for the organization but also the industry in which the organization operates.
- Offer any closing thoughts about the data and the overall project
Your report should be 8-10 pages, not including cover and reference pages. Provide at least 5 outside references and use APA format.
Points Possible: 150
Intersession Activities Top of Form Bottom of Form Intersession Activities Overview Intersession Week Reading Topic Activities and Assignments 1 Chapter 6 Text Functions Complete your Intersession 1 Case Assignment and share it in the appropriate discussion forum. 2 Chapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions Complete your Intersession 2 Case Assignment and share it in the appropriate discussion forum. 3 Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions Complete your Intersession 3 Case Assignment and share it in the appropriate discussion forum. 4 Chapter 22 The OFFSET Function Complete your Intersession 4 Case Assignment and share it in the appropriate discussion forum. 5 Chapter 41 Summarizing Data by Using Histograms and Pareto Charts Complete your Intersession 5 Case Assignment and share it in the appropriate discussion forum. 6 Chapter 50 Consolidating Data Complete your Intersession 6 Case Assignment and share it in the appropriate discussion forum. 7 Chapter 52 Charting Tricks Complete your Intersession 7 Case Assignment and share it in the appropriate discussion forum. Intersession Discussion and Case Assignments Complete the following assignment for each intersession week. Many companies and placement agencies require candidates to have knowledge about Excel as part of their recruitment process. Knowledge of Excel is useful in several fields in various industries, especially data analysis. Read the assigned chapter for the week. Come up with a use case for the concepts covered using real-world data for a business or organization. In the discussion forum, post a brief explanation of your data, the business or organization, and the use case in the appropriate forum of the message board. You cannot use the same business or dataset as one of your peers. If you are uncertain of the data or organization to use for this assignment, use the discussion forum to brainstorm with your peers. Once you have…