1) Use Table to create a Pivot Table 2) Why it's meaningful information 3) Bar graph

ghaz, I am going to leave this thread open (for now) but we frown on people asking us to do their homework assignments for them. Although this is not school, the principle is the same--you are asking us to do work for you that you will present as your own.

Even if we get past the ethics issue, I have to wonder how would succeed in a job that you don't know how to do. The question you are trying to answer is not an Excel question at all. It's a question to see how well you can analyze a data set to extract useful information from it. We could probably give you our opinion about this specific case but that type of analysis is a skill that is learned through lots of experience, not a single thread in a forum.

Please give some thought as to how to think through this and learn something. I think some high-level discussion and hints might be OK but if I see someone hand you an answer on a silver platter this thread will be closed.

I have to agree (as do other seniors) that we should not be doing your work for you. By all means, we can help guide you, but YOU need to do the work, and YOU need to show you understand what is being done.

Failing that, I will have to close this thread. So, lets see what you can do so far?

It would seem from post #3 that you are able to manage the mechanics of creating a pivot table. We really can't advise you on the interpretation of the data: that, more than anything else, has to come from you and you alone, as it seems to be the key point of the task. As for the creation of the bar graph: the help available in Excel 2016 itself should be enough to guide you.

I feel very strongly that no help should be offered here - sorry.