Preliminary Analysis: Donation patterns over time- R Studio Assignment Help

By

Added on: 0000-00-00 00:00:00Order Code: Question Task Id: 0

Internal Code: IAH23
R Studio Assignment Help:

Task:

The file HW5.csv contains historical ticket sales and donation data for 30,019 patrons or donors to a festival for over ten years, up to 2015. (I don’t have 2016 data, sorry.) You must do the visualizations in Tableau or R and you must use R for the analytics. The festival organizers would like to understand the following:

1. Preliminary analysis (3 points)
a. Donors (1 points)

i. How many total donors (people who contributed a positive amount any year) are there? What about donors who contributed at least $100? $500? $1000?
ii. How many donors were there each year in the data set? What about donors who contributed at least $100? $500? $1000?
iii. Plot the histograms of donations for the entire time period, for 2014 and for 2015. Comment.
iv. Plot a scatterplot with the donations for 2014 and 2015 (one dot = one row, removing [for this question only] instances with no donation either year). Comment.

b. Ticketholders (1 point)

i. How many total ticketholders are there? (note that some donors may never have bought tickets)
ii. How many ticketholders were there each year in the data set?
iii. Plot the histograms of ticket revenues for the entire time period, for 2014 and for 2015. Comment.
iv. Plot a scatterplot with the ticket purchases for 2014 and 2015 (one dot = one row, removing [for this question only] instances with no ticket purchase either year). Comment.

c. Joint analysis (1 point)
i. Plot total donations and total ticket revenue for each patron on a graph (one dot = one record or row of the data set).
ii. Comment on the general trend in your graph and the outliers.

2. Donation patterns over time (8 points)
a. (3 points) Cluster the donors according to their patterns of donation over time up to 2014.
i. Justify your number of clusters, the method used, and provide a description of each cluster suitable for a manager.
ii. Plot the donation pattern over time for each cluster.

b. (3 points) Create a model to predict donations or donation groups for 2014 using the previous five years of data. You can use the method of your choice (linear regression, logistic regression, classification trees…)
c. (1 point) Test your model on 2015 data. Comment.
d. (1 point) Make predictions for donations in 2016.

3. Ticket sales patterns over time (8 points)

a. (3 points) Cluster the ticketholders according to their patterns of donation over time up to 2014. You can use hierarchical clustering or k-means.
i. Justify your number of clusters, the method used, and provide a description of each cluster suitable for a manager.
ii. Plot the ticket sales pattern over time for each cluster.

b. (3 points) Create a model to predict ticket revenues or ticket revenue groups for 2014 using the previous five years of data. You can use the model of your choice (linear regression, logistic regression, classification trees…)

c. (1 point) Test your model on 2015 data. Comment.

d. (1 point) Make predictions for donations in 2016.

4. Joint analysis (3 points)
a. (2 points) Cluster instances in the data set across both ticket revenue and donations for every year.
i. Justify your number of clusters, the method used, and provide a description of each cluster suitable for a manager.
ii. Provide a visualization of the clusters.

b. (1 point) Adjust your method so that the most recent donations or ticket purchases count more than those further in the past.

5. Conclusions (3 points)
Develop a strategy for the marketing team.
a. (1 point) Who are donors the festival organizers should cultivate for 2016?

i. Donors who did not donate as much as expected in 2015,
ii. Donors who donate a lot and whom the festival can’t afford to lose.

b. (1 point) Who are ticketholders the festival organizers should cultivate for 2016?
i. Ticketholders who underperformed their 2015 estimate,
ii. Ticketholders who play a key role in overall revenue year after year.

c. (1 point) From the aggregate viewpoint of total revenue (ticket purchases + donations), who are the patrons the festival organizers should cultivate for 2016?

Report quality: 2 points
Note: Some large ticket sales are group sales, especially from school districts. As usual, you may want to remove such outliers or treat them separately. The festival has children programming so some patrons or donors may contribute only as long as their children go to the shows. The average patron base is also rather old, so some patrons may stop buying tickets because they passed away.

Uploaded By : jack
Posted on : February 24th, 2018
Downloads : 4

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services