Smile Clinic Data Analysis Report: Excel and SPSS Tools

This report analyzes data from the Smile Clinic, focusing on sales and profit trends from 2009 to 2012. It utilizes pivot tables in Excel to interpret sales figures for different delivery methods (truck, express air, regular air) and their corresponding profit margins. The report explores the application of MS Excel for data preprocessing, visualization, and analysis, highlighting functions like VLOOKUP, sorting, filtering, and conditional formatting. Furthermore, it delves into data mining techniques, including clustering frequencies and statistical analysis, to derive meaningful insights for business decision-making. The report also uses frequency tables to analyze customer demographics, specifically gender and eating habits. Finally, the report describes classical data analysis to provide insights on the data.