Link to download the data as an Excel file since I cannot attach the Excel file myself - or please let me know if there is an easier way to provide this Excel file -

https://www.kaggle.com/datasets/aungpyaeap/supermarket-sales?resource=download

Use SPSS to conduct a descriptive analysis using the columns: Customer Type and Total.

In a Word document, respond to the following:

• How many customers in the sample dataset used their member card? What percentage of all customers do they constitute?
• What's the average shopping basket size (Total)? What's the standard deviation of the shopping basket size?
• Paste a screenshot of your SPSS output of the descriptive analysis.

The following dataset on supermarket sales is obtained from Kaggle. It contains a sample dataset from the internal database of a supermarket from three different branches for three months.

The detailed description of the columns are as follows:

• Invoice id: Computer generated sales slip invoice identification number
• Branch: Branch of supercenter (3 branches are available identified by A, B and C).
• City: Location of supercenters
• Customer type: Type of customers, recorded by Members for customers using member card and Normal for without member card.
• Gender: Gender type of customer
• Product line: General item categorization groups - Electronic accessories, Fashion accessories, Food and beverages, Health and beauty, Home and lifestyle, Sports and travel
• Unit price: Price of each product in $
• Quantity: Number of products purchased by customer
• Tax: 5% tax fee for customer buying
• Total: Total price including tax. This indicates the size of total shopping basket.
• Date: Date of purchase (Record available from January 2019 to March 2019)
• Time: Purchase time (10am to 9pm)
• Payment: Payment used by customer for purchase (3 methods are available - Cash, Credit card and Ewallet)
• COGS: Cost of goods sold
• Gross margin percentage: Gross margin percentage
• Gross income: Gross income
• Rating: Customer stratification rating on their overall shopping experience (On a scale of 1 to 10)

Use the following data set for this assignment.Note - For sav files - Launch SPSS from the portal. Download the sav file and use the open data set function in SPSS.

• Modules 1, 2 SupermarketDownload Modules 1, 2 Supermarket

Data set retrieved from: https://www.kaggle.com/aungpyaeap/supermarket-sales

For this data analysis activity, we will analyze the internal sales data.

First, review the SPSS Tutorial.