Note: Use the Excel. Thank you!

1. Compute for the relative and percent frequency for purchases of small appliances by product category at Company TM.
Product category	Frequency	Relative frequency	Percent frequency
Rice cooker	135
Gas stove	112
Oven toaster	87
Electric kettle	241
Convection oven	58
2. Use a bar and a pie chart to visualize the above dataset.
3. Create the appropriate type of chart to visualize the ff categorical variables.
Type	Rice cooker	Gas stove	Electric kettle
Painted	80	34	51
Stainless steel	55	78	190