Assignment: Data Analytics
Summarizing Data By Using Histograms And Pareto Charts
Complete the following assignment for each intersession.
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 chosen a data set and organization, create an Excel file in which you apply functions to demonstrate the use case. On a separate sheet in the Excel file, write a brief overview and summary in which you:
• Provide an overview of your data, business/organization, and use case
• Analyze the data and give reasoning of why you think it is useful to the business or organization.
• Articulate what Excel functions you have used and apply it to the dataset to demonstrate it.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.