Analyze XYZ Company’s data to address the objectives given in the assignment description.

Deliverable: Write a report for the client that summarizes the results of your analyses and provides recommendations for targeting. Provide both a statistical and financial analysis of these methods. The report should be a double-spaced nine (9) page, maximum paper, all inclusive.  Note that you need not use all nine pages.

Formatting:
Submit to this link: Paper with statistical graphics in Adobe Acrobat pdf.  Make sure your last name is at the beginning of the file name, and that “solo-3” is included in the name.

Note: Late submissions of this assignment will not be accepted, i.e. an assignment submitted late will not be worth any points towards your course grade.

You would need the following files for Solo 3:

Project Description File: Predict450Solo3ProjectDescription.pdfPreview the document

Experian Data Dicionary (pdf): Experian Data Dictionary.pdfPreview the document

Data Dictionary (Excel): XYZ_Data Dictionaries.xlsPreview the document

Data Dictionary (PDF): XYZ_Data Dictionaries.pdfPreview the document

Data File – Complete Customer Profile Data: XYZ_complete_customer_data_frame.RData

Mock-up of XYZ company Web site: 01 Handout Mock-up (S2) PREDICT 450(1).pdfPreview the document

Brief on the XYZ company background and history including products sold, locations, and channels: 02 Handout Company Brief (S2) PREDICT 450.pdfPreview the document

Handout: Models_for_Targeting.pdfPreview the document

Financial Model: Valuing_Targeting_Model.xlsxPreview the document

————————————————————————————————————————————

Optional Files are given below, for your reference – You will learn a lot about the data if you review Miller’s R code for data integration:

‘Read data’ R file (Optional): XYZ_read_data.r

R code for data integration – Code to integrate the 3 files (item, mail, customer) given below, to create the complete customer file: miller_xyz_data_integration.r

XYZ Customer Data: XYZ_customer_data(1).RData

XYZ item data: XYZ_item_data(1).RData

XYZ mail data: XYZ_mail_data(1).RData

Customer frame csv file:  solo3.csvPreview the document