Solved by verified expert:The questions on the PDF and the data on the excel fdasffffffffffffffffffffffffffffff fdsadsaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
alumnigiving__1_.pdf
alumnigiving.xlsx
Unformatted Attachment Preview
Cose
case
Problem
197
Problem Alumni Giving
Alumni Giving
If adminAlumni donations are an important source of revenue for colleges and universities.
alumni
of
percentage
the
in
increases
to
lead
could
that
could determine the factors
isffators
lead to increased
who make a donation, they might be able to implement policies that could
with teachers
contact
their
with
satisfied
more
are
who
revenues. Research shows that students
lower stuand
sizes
class
smaller
that
suspect
might
one
are more Likely to graduate. As a result,
might
in
tum
which
graduates,
of
satisfied
percentage
dent/faculty ratios-might lead to a higher
shows
table
following
The
donation.
a
make
who
alumni
lead to incieases in the percentage of
percentage of students who
data for 4g national universities. The Graduation Rate column is the
20 column shows the
Under
Classes
%
of
The
graduated.
initially enrolled at the university and
Ratio column
The
Student/Faculty
students.
20
than
p”r””rrug”, of classes offered with fewer
the Alumni
Finally,
faculty’
of
number
total
the
by
L the number of students enrolled divided
universify’
the
to
a
donation
made
who
alumni
of
Giving Rate column is the percentage
State
, , i%:of, ”Studenfl
Grailuation,’ Classes’ ”l Faculty
. Ratel
Under20,” , .Ratio I
Afupqi
Gjving
Rate
85
39
t3
7g’
‘8
-1J
8
.3r.
40
46
25
Brandeis UniversitY
MA
MA
Brown Universiry
Catifomia Institute of
RI
CA
93
B5
68
60
65
PA
OH
is
6l:
10
28
72
89
s2,
8
31
12
90
45
69
27
31
9t
‘/2
13
NH
94
6i
10
35
53
NC
GA
92
68
8
45
84
6)
7
3i7
29
8
46
BostonCollege.
Technology
Camegie Mellon UniversitY
Case Western Reserve Univ.
College ol William and MarY
VA
NY
NY
Columbia UniversitY
Cornell Universiry
Dartmouth College
Duke UniversitY
Emory University
.
‘1
Georgetown UniversitY
Harvard UniversitY
Johns Hopkins Uni versitY
DC.
91.
MA
MB
9′,7
54
73
10
89
64
9
Lehigh University
Massachusetts lnstitute
PA
81
t5
11
MA
92
65,
NY
72
63
.66’
I
30
PA
90
80
32
2t
NJ
95
68
19
5
TX
92
I
40
CA
62
69
7
34
6:1
9
,29
56
12
17
18
7
of
Technology
New York Universiry
Northwestem UniversitY
L
Pennsylvania State Univ.
Princeton UniversitY
Rice University
6
13
Stanford UniversitY
Tufts University
MA
Tulane UniversitY
LA
92
87
72
Universiry of Califomia-
CA
83
58
t7
CA
74
32
CA
CA
74
42
19
20
4L
l8
48
19.8
Berkeiey
University of Calilornia-Davi
s
University of California-Irvine
Universiry of Califomi aLos Angeles
U niversity of Californi aSan Diego
78
u
40
44
13
6’t
9
13
(continued)
Chopter
Univsr-r.i1y
4
Lineor Regression
_
State
Rate
cA704520|2
ol Crli lornia_
Santa Barbara
University of Chicago
University of Floricla
University of Illinois_
L84
FL
L77
Urbana Charnpaign
University of Michigan_
Ann Arbor
Universiry ol Nonh Carolina_
Hill
Chapel
Graduation
University of Notre Dame
University of pennsylvania
University o1, Rochester
University of Southem
Califomia
University of Texas_Austin
University of Virginia
University of Washington
University of Wisconsin_
Madison
Vanderbilt University
‘Riit,r,
FIGURE
t,Xffi,
Rate
65
4
Jf)
31
ti
19
29
i5
23
67
MI
83
51
l-5
l3
NC
82
40
t6
)A
53
13
49
65
7
1t
IN
PA
NY
cA
ol
90
76
70
63
l0
23
53
13
22
lz
39
21
13
l,
WA
66
92
10
13
28
WI
41
37
12
13
12
37
6
13
13
7
68
9
59
ll
l
38
IO
33
7
50
1t
TX
VA
Wake Forest Univers:ity
Washington University-St. Louis
Yale University
,,!f?r:[:
U”a”. ZO
tJ*.#y
TN
82
NC
82
MO
86
CT
t3
94
77
1. Use methods of descriptive statistics to
summarize
2. Develop fln eslinrared simple lir”u;,;;;;:ion
the data.
rnor-lel rhar r.an be used ro pretlicr
rhe
alumni givinr rate. giren rhe graduar
ion rare. Dircur,
lour finding:.
Derctop an.rri*rria
m.urripr-e
the alumni giving rare using
ihe
4’
t
rir;;,:;;e;rrion moder rhar courjbe ured
ro precricr
c.rarutri, Rare, 7o of crasr., u;;; 20,,.ndStudent/
Faculty Ratio as independent variables.
Discuss your findings.
Based on the results in parh
2 and 3, do
more appropriate
?
y”, .,.ri”* urotrr”.-.f.”ssion
–‘ model may be
Estimate this moder, and <.liscuss
yor.
..rurt?--
derive r,-om your analysis? what
Hi;J,il[:]:]':TH,11,:':o,,,.nou,io,JJ",.ro,
expected,gi,.n*"r"Eiffi:?'ff [:,il:ir:r,:i:Tr1:ffi jJf
,,,lH,H::lrr
a
Ratio? whar universfties are achieuing
u'r.,ur,";;;,;r;oi,.".;;#lgiving
rare rhan
would
be expected, given their Graduafion
Faculty Ratio ? what other independent
nr,", z, of Classes untter 20, and Student/
coul
Purchase answer to see full
attachment
