Instructions:
I. The project is a group work project, it is the group's responsibility to share the load equally and the achievement of each member is determined by group achievement.
II. Work only on the data assigned to your group. (E.g., Group 1 data = for Group one only)
III. When submitting the assignment only one member of the group needs to submit the work. Make sure to write down all the group member's names and IDs in the SAS footnotes and submission message box,
IV. When submitting your group works, please submit a confirmation word stating that “All the group members have shared equal load.” In case one or more of your group members failed to share the load of work, declare only the names of those who have worked. Objective: This project intended to assess your ability to clean data, read data, manipulate data, and generate descriptive reports. Case: A food company wants to produce the highest profit for the next direct marketing campaign, scheduled for the next month. A pilot campaign involving 1400-2400 customers was carried out, and customers who bought the offer were properly labeled. The followings are the variables' name and their respective label. Variable Name Description Customer_Days Days of customer enrollment Income Customers annual income Age Customer age Education Customer Level of education 0 = Basic Education 1= Graduate 2 = Postgraduate 3= PHD MntWines Amount spent on Wine the past year MntFruits Amount spent on Fruits the past year MntMeatProducts Amount spent on Meat products the past year MntFishProducts Amount spent on Fish products the past year MntSweetProducts Amount spent on Sweet products the past year MntTotal Amount spent in total the past year AcceptedCmpOverall Campaign acceptance overall 0 = Not accepted 1 = Accepted Excel
Tasks. 1. Use excel and clean the data: Filter the data to eliminate the incomplete information of all customers. Make sure that there are no missing values, especially on Income, Age, and Acceptance of the campaign overall. (1pt) (Note: If the data is not cleaned properly your results for the analysis will be affected) 2. Using Excel: Based on age classify the customers into three generations using nested If and name the new field ‘Generation Type’.
(Nested If must be used) (3pts.) Bloomers: >=59 Generation X: >=43 Millennials: >=27 SAS Tasks 3. Open a project in SAS, create Library, and Import the clean classified project data to the SAS. Using data set tribute answer the following. (2pts.)
a) Number of Observations:___________ b) Number of Variables: _____________
4. Using data characterizations discuss the demography of the customers. (Age, education level, Generation type, and Income). Use charts and tables to show your insights and add descriptions to them. (4pts) ( Make sure the header is changed to the appropriate title, and the footnote is replaced with the group members name)
5. Generate summary statistics of MntWines, MntFruits, MntMeatProducts, MntFishProducts, and MntSweetProducts. Use Generation Type as Classification Variable. Answer the following based on your results: (4Pts) a) Bloomers Wine Purchase Mean: ______________________
b) Millennial’s Meat product purchase upper quartile: _______________ c) Generation X least purchased product:___________________ d) Provide below a screenshot of your results. ( Make sure the title is changed to the appropriate title, and the footnote is replaced with the group members name) 6. The “Acceptance of campaign overall” variable is coded as a binary where: 0= indicates “Did not accept the campaign” 1= indicates “Accepted the campaign” (6Pts) a) Analyze the relationship between education level and acceptance of the Campaign. (Use appropriate chart to prove your point)
b) Analyze the relationship between the generation type and acceptance of the Campaign. (Use a chart or table to show your point) c) Analyze the relationship between income and acceptance of the Campaign. Answer the following questions in your analysis:
I) The average income of those who rejected the campaign.__________________ II) The average income of those who accepted the campaign.__________________
III) Min and Max Income of those who accepted the campaign.______________
d) Based on your overall findings which customers should be your main target customers: Generation type:________________________ Education:______________________ Income: >=_____________________ Submit the following files.
1. Analysis report using doc. or pdf. 2. Excel file (filtered and classified data) 3. SAS file (the SAS environment is 8.3)
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
