The dataset has details of 1000 users from different backgrounds of people who bought or didn’t buy a bike. I chose to use Excel to show this visualization

Data Cleaning This is one of the most important thing to do before jumping at visualization. The first thing i did was to filter and look through each columns.

• Afterwards, I removed 26 duplicated values.
• To help readers understand the dashboards, I cleaned up the abbreviated words for each of these columns ‘Marital Status’ and ‘Gender’ column
• ‘M’ and ‘S’ to ‘Married’ and ‘Single’, using control F, to search by column Marital Status and replace
• ‘M’ and ‘F’ to ‘Male’ and ‘Female’, using control F, to search by column Gender and replace.
• Created a new column with name ‘Age Range’. Here, i used a Nested IF statement to group the ages according to a certain range. 👇🏼

**=IF(L2>54,”Old”, IF(L2>=31,”Middle Age”, IF(L2<1,”Adolescent”, “Invalid”)))**