We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Loyalty Program and File Import Node

The whole doc is available only for registered users

A limited time offer! Get a custom sample essay written according to your requirements urgent 3h delivery guaranteed

Order Now

* 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 set are shown below with the appropriate roles and levels.

Define the data set ORGANICS as a data source for the project. Use basic option in metadata advisor options. c. Check the model role and measurement level for each variable in step5 of Metadata with the model roles and measurement levels of the table printed above. Point out any mismatch in your answer. (1 Point) d. Fix as needed (by clicking on role or level) any mismatch in the roles or measurement levels of variables in the above step. e. Continue with adding data source. Do not use decision processing step in the data source wizard. In the final step use data set role as Raw. f. Right-click on the data in the project panel and select Explore. Make sure you set sampling method to random and sample size to Max in sample properties. Scroll and take a look at the first 26 observations. Which variables seem to have missing values in the first 26 observations? Also, show a screenshot of at least first 26 observations. (1 Point) g. Instead of exploring data from the project panel, you will now do it from the diagram.

Make sure you set sampling method to random and sample size to Max. in the options > preferences. Drag the data to the diagram. Then, right-click on the data source in the diagram. Choose edit variables. In the pop-up box, select any variable you want to explore and then click on the Explore button. 1) Select TargetBuy. Create a frequency histogram for the variable TargetBuy. Make sure the vertical axis is percentages and you display the percentage values in the histogram (hint: right-click on the graph…). Turn-in a copy of the histogram as a part of your deliverable. (1.5 Points) 2) Create a frequency histogram for the variable DemGender. Comment on what you see in this histogram and turn-in a copy of the histogram as deliverable. (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 mentioned on the cover page of this document. Create a running header or footer with your name so it is there on every page and page number that is on every page. Show Screen shot (s) of relevant information and/or answer to each of the questions as appropriate. Upload this document in the appropriate drop box by the deadline mentioned in the appropriate drop box. Use 5% level of significance, unless stated otherwise in a problem.

Related Topics

We can write a custom essay

According to Your Specific Requirements

Order an essay
Materials Daily
100,000+ Subjects
2000+ Topics
Free Plagiarism
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access

Your Answer Is Very Helpful For Us
Thank You A Lot!


Emma Taylor


Hi there!
Would you like to get such a paper?
How about getting a customized one?

Can't find What you were Looking for?

Get access to our huge, continuously updated knowledge base

The next update will be in:
14 : 59 : 59