Statistical Analysis Report
Quantitative Analysis
James D. Thornton
June 16, 2019
QSO-510-X4406
Milestone I
Instructor: Roland Sparks
Introduction
Since 1946, the Paralyzed Veterans of America (PVA) has been a dedicated service organization for veterans based out of Washington, D.C. The PVA was founded by brave service members who came home from World War II (WWII) with spinal cord injuries, who endured few solutions to the major recovery challenges they faced. PVA's mission is to develop unique expertise on a wide variety of issues involving the special needs of veterans of the U.S. armed forces who have experienced spinal cord injury or dysfunction. PVA’s single-minded mission is to “empower these brave men and women to regain what they fought for: their freedom and independence (PVA, n.d). Additionally, the organization is heavily involved with promoting and protecting the civil rights of disabled veterans.
PVA delivers holistic recovery and transitions for its severely disabled veteran service members with integrative programs and services that fulfill the desired needs. The organizations offer programs such as Paving Access for Veterans Employment, medical services, advocating for health policy’s, research education, government advocacy and legislation, counseling and treatment services, and recreational sports.
The PVA utilizes many ways to raise money to fund their services, but a majority of their funding comes from direct mail campaign soliciting. They send free address labels or greeting cards to potential donors on their mailing list to solicit donations for receiving the labels and cards as gifts. Their mailing list includes more than four million donors. In 2016, PVA invested $40 million dollars in postage, administrative, and gift expenses that resulted in $100 million in donations. Most of the money was spent on mailings to people who never respond. Typically, the PVA receive responses from more than a few percents of the people contacted for donations. Solicitations from commercial companies are so low they often measure the responses on basis points and not percentage points (Sharpe, Veaux, & Velleman, 2015). In efforts to raise more money with fewer investments, the PVA must figure out other means of soliciting that is least cost-effective such as social media.
The PVA estimates that it takes 4% of their funds to secure about $100 million in donations. However, the PVA understands that each year its efforts to raise $100 million with their investment is not maximizing its potential donations. This is due to the access of address labels and gifts being sent to the people they contact that do not respond. To better manage the mailing list the PVA can analyze its soliciting data to develop a more efficient mailing list of patrons to contact.
Problem Statement
The purpose of this study is to determine how PVA can maximize its donations by mailing its address labels and gifts to contributors that have a higher probability to donate.
First, PVA will need to identify quantifiable factors which are affecting their response contact mailing list. These quantifiable factors will provide information and insight about PVA’s mailing list of the response and non-response contacts to make them more probable. Factors that affect PVA's mailing list are the mean and median of the gift amount (GIFTAMT) contributed by the responders.
An evaluation of PVA’s summary statistics (figure 1) can assist PVA in determining the demographics of “Who” to contact through the mail that will give the highest probability of receiving a contribution. The data of 26 variables gathered from 3648 responses indicates the mean for the data set is 15.72 and median is 14. The difference between the mean and median is 1.72. The histogram (figure 3) of the data set indicates that most of their contributors donate smaller amounts between $1 and $30. Donations greater than $30 significantly decreases. This indicates why the mean for the data set is $15.72. PVA can infer that they can raise more money from smaller donations. According to the data set, it would be wise for PVA to determine how to engage more people that will contribute smaller donations in efforts to raise more money.
The first quantifiable factors that affect the contributors that can be analyzed is the contributors employed by the local government. The scatter plot (figure 9) displays the relationship of those local government employees and the greater chance of them contributing a larger donation than the mean or median.
Another quantifiable factor is the number of times donor has responded to mail order offer other than PVA’s (HIT). This scatter plot (figure 5) indicates that many of the contributors respond to mail order offers from organizations other than PVA’s.
To improve PVA’s donations from contributors through the mail a variety of statistical tools need to be utilized to better predict future needs. These methods will organize the data to help management in making future decisions regarding who to mail address labels or gifts. Lastly, PVA will have the ability to develop an accurate model for predicting its contributors.
References
Paralyzed Veterans of America (PVA). (n.d)., How We Serve. Retrieved from https://pva.org/about-us/how-we-serve/
Sharpe, N., Veaux, R. & Velleman, P. (2015) Business Statistics. Pearson.
Appendix
Figure 1:
Summary statistics for GIFTAMNT:
Figure 2: Group by: GIFTAMNT
GIFTAMNT
n
Mean
Variance
Std. dev.
Std. err.
Median
Range
Min
Max
Q1
Q3
0 to 50
3566
14.504554
61.059083
7.8140312
0.13085324
13
46
1
47
10
20
50 to 100
61
53.42623
65.081967
8.0673395
1.032917
50
25
50
75
50
50
100 to 150
18
100.11111
0.22222222
0.47140452
0.11111111
100
2
100
102
100
100
150 to 200
1
150
NaN
NaN
NaN
150
0
150
150
150
150
200 to 250
2
200
0
0
0
200
0
200
200
200
200
Figure 3:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\65FF7B45.tmp
Figure 4:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\D8508D3D.tmp
Figure 5:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\20608F53.tmp
Figure 6:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\E281D7D9.tmp
Figure 7:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\E7DAE04F.tmp
Figure 8:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\E27BDE35.tmp
Figure 9:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\6652230B.tmp
Figure 10:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\B8527C51.tmp
Figure 11:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\CBF29387.tmp
Figure 12:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\36C94E2D.tmp
Figure 13:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\A7EE2DC3.tmp
Figure 14:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\FC6FAFC9.tmp
Figure 15:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\4BF8ADBF.tmp
Figure 16:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\B07CBD25.tmp
Figure 17:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\9838F7B.tmp
Figure 18:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\FF6B5241.tmp
Figure 19:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\4BA0EF7.tmp
Figure 20:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\73560B1D.tmp
Figure 21:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\193D2833.tmp
Figure 22:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\41343B9.tmp
Figure 23:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\C9F972F.tmp
Figure 24:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\FB111815.tmp
Figure 25:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\AA1D7EB.tmp
Figure 26:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\86F16431.tmp
Figure 27:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\272E2667.tmp
Figure 28:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\1AE5C40D.tmp
Figure 29:
C:\Users\ThorntJD\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\62147EA3.tmp