Sorting data into ranges and comparing it to different options

[AAT]

Hi all,

I have travel household surveys and am sorting it for an assignment. The idea is sort out the data based on how many vehicles households own dependent on their income. An example of the data is shown in the first image (Capture), keep in mind, this is a made up sample, the actual data goes on forever. The table below is what I want the data to look like, with the values representing the average number of cars per household in that income range.

And finally the graph attached (capture 2) is what I would like to end up having.

I have used pivot tables for a previous assignment questions, but for examples that differed slightly, when I tried using it for this example, I just couldn't make sense of it. I can do them all individually, example, income versus number of cars owned, and then a separate one for income versus number of trucks owned. But grouping the income ranges each time is becoming tedious, especially since I am sure excel can do this and I am just wasting time.

If you could help or link me to any tutorials dealing with similar situations, I would be glad.

If you can think of a better tool to use, I am also happy to try it.

Thank you!