Using the pivot table tool, create a crosstabulation of type of customer (regular or promotional) versus net sales. Place this pivot table in a new worksheet labeled “Pivot Table.” Use good formatting practices when constructing this table as shown in class.
Computer Assignment # 1
The data for this problem is located in the Excel file on Isidore under Computer Assignment #1 and it corresponds to Case Problem 1 (Pelican Stores) on p. 102 -103 in your text.
Please answer the following questions within your Excel file. Please label your work so that it may be easily found within your file.
- Using the pivot table tool, create a crosstabulation of type of customer (regular or promotional) versus net sales. Place this pivot table in a new worksheet labeled “Pivot Table.” Use good formatting practices when constructing this table as shown in class.
-
Based upon the summarized information from the pivot table you created in question 1, which type of customer tends to spend larger amounts on their purchases?
-
Based upon the summarized information from the pivot table you created in question 1, which type of customer comprises most of the sales for this sample?
-
Create a scatter diagram to explore the relationship between net sales and customer age. Put this scatter diagram in a new worksheet labeled “Scatter Diagram.” Before creating your scatter diagram, carefully consider which variable is most appropriate to put on the y-axis of your graph. Be sure to label your axes appropriately and create a meaningful title for your graph.
-
Based upon your scatter diagram from question 4, does there appear to be a relationship between the customer’s age and the net sales?
attachment