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.
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?