Loyalty Program and File Import Node

892 words 4 pages
Individual Exercise 1 (10 Points) – You must do it alone (it is not a group activity)
Data set is on D2L with the exercise
Exercise Description:
Initial Data Exploration * A supermarket is offering a new line of organic products. The supermarket’s management wants to determine which customers are likely to purchase these products. * The supermarket has a customer loyalty program. As an initial buyer incentive plan, the supermarket provided coupons for the organic products to all of their loyalty program participants and collected data that includes whether or not these customers purchased any of the organic products. * The ORGANICS data set has 13 variables and over 22,000 observations. The variables in the data
…show more content…

(1 Point) 3) Create a frequency histogram for the variable DemAge. Comment on what you see in this histogram and turn-in a copy of the histogram as deliverable. (1 Point) 4) Create a frequency histogram for the variable PromSpend (make sure you change number of bins to 30). Is this variable right or left skewed? Does that make sense based on the variable’s description? Turn-in a copy of the histogram as deliverable. (1.5 Points)
This part is a stand-alone exercise using file import node. First, use the file import node to import the Excel data file Smalldata. Run the file import node and then answer following questions. h. Does any variable have a role of rejected? If yes, can you guess why it is rejected? (1 point) i. There are several variables that SAS EM may have assigned a measurement level of Interval. But, these should really be binary. Which are these variables and why should they have binary measurement level? Fix their levels to binary before answering the next question. (1 point) j. Attach a StatExplore node to the File Import node and run the Stat Explore node. Report the class variable summary statistics and the Interval variable summary statistics from the output window of the StatExplore node. (1 point)

Deliverables (please follow these instructions): * Create a single MS word document (please make sure your name, CWID and section number are