A2 Report: Data Analysis and Visualization Using Excel & SPSS

This report provides a comprehensive analysis of data pre-processing, data analysis, and data visualization using both Excel and SPSS. It begins with an evaluation of data pre-processing techniques in Excel, including the use of filters, SUMIFS function, and pivot tables, to prepare and summarize raw data from a superstore dataset. The analysis then interprets the findings, such as yearly sales, profit trends, and product-wise performance. The report also covers data visualization, presenting graphical representations of sales and profit data. Furthermore, the report transitions to SPSS, demonstrating how to calculate the number of students who prefer vanilla ice cream, the gender distribution of participants, and the mean and median preferences for chocolate and strawberry ice cream. It also outlines the steps for conducting K-mean clustering in SPSS. Finally, the report discusses the advantages and disadvantages of using SPSS and Excel, providing practical examples to illustrate their respective strengths and weaknesses in data analysis.