Data analytics (Data should be presented in Excel) Summarizing Data by Using Histograms and Pareto Charts

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 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.

Submit your complete Excel file here. Replies and responses to the discussion forum are not a graded component of these assignments, but you are expected to respond to your peers and participate in any brainstorming.

Assignments should be using Histograms and Pareto Charts. Please do not use the data used in sample file. It is just for reference on how to data should be presented. Charts should be provided additional to the data and explain breifly about the functions used