Excel Functions Homework
Length: 10 pages.
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 homework gives you the opportunity to demonstrate the knowledge you have gained by using real-world data and applying at least 5 Functions (count, countif, sum, sumifs, avergaifs , e.t.c) of Excel to your dataset.
Similar to the work you completed for your homework, you will need to locate real-world data. For this homework, you will need to locate and utilize large datasets.
In an 8 page report:
i. Provide an introduction to your overall project
ii. Give a rationale and explanation for the datasets you have chosen
iii. Include at least two tables demonstrating your data and analysis
iv. Create at least one graphic to visualize the data and your analysis
v. Explain how you have analyzed the data using at least 5 Excel functions
vi. 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.
vii. Offer any closing thoughts about the data and the overall project
Format your homework according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.