Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Performing a Cluster Analysis This assignment is using a data set and unsupervised method of determining derived information for a client heavily engaged in charity
Performing a Cluster Analysis This assignment is using a data set and unsupervised method of determining derived information for a client heavily engaged in charity contributions. The client is wanting to determine if there are clear segregation points in terms of amounts contributed over a period of time (ex: one time or every x months) and actual dollar amounts contributed. The client believes this information will help them determine better methods and efficiencies for their marketing campaigns. As the business analyst, you need to provide information from the PVA (contributions) dataset in SAS that will help your client understand this problem/concern. This Word document will be the basis for your responses to the client. Be sure all questions are answered completely and professionally. Do not use abbreviated or incomplete sentences when responding. This is a professional report back to the client. No band written responses will be accepted. Please address each question or sets of questions below in detail. Also, provide objective evidence (OE) of each as requested (the graphs that you create with the SAS tool). 1. Perform a cluster analysis for all the variables that begin with "Gift" (as these variables provide the primary context for this analysis). a. Provide a Parallel coordinates plot diagram. b. How many clusters were generated? Why? C. Which cluster ID had the largest variability? What does this tell the client? d. Which two of the cluster centroids are closest? What does this tell the client? 2. Change the model to three-clusters. Examine the parallel coordinates plot for the three-cluster solution. e. Provide the parallel coordinates plot for the three-cluster model. f. Which cluster gave the most money per donation? What analysis can you provide the client relative to this result? E- Which cluster donated most frequently? What analysis can you provide the client relative to this result? 3. For the three-cluster solution, replace the variable Gift Amount Last with the variable Gender. h. In the new model, are the three clusters identified Male, Female, or Unknown? Why do you think this result is the case? Provide the cluster diagram for this model. Be sure and save the SAS Project file (export). Be sure and post the SAS file as OE along with each image file generated for the above noted graphs. These must all be posted as OE along with the responses In this Word document
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started