Bike Sales with Excel

My goals for this project were to get a wider scope for average customer needs and potential variables that are driving profit.

Some questions/thoughts I had were:

• What is the average income per customer?
• What is the average age bracket we serve? (I used IF statements in the dataset to create age brackets, then put the data into a pivot table.)
• Next, I was curious about commuting averages and bike purchases. I used the 'commuting distance' and 'purchased bike' columns in a pivot table to see what the average commute is for customers who've purchased a bike.