Scribd Logo
Upload

Welcome to Scribd!

  • 86 views

    Business Statistics: Correlation Study Alumni Giving Case

    Uploaded by

    Shivanshu Gupta
    The document analyzes the correlation between student/faculty ratios (SFR) and alumni giving rates (AGR) for 48 universities. It finds a strong negative correlation, with higher SFRs associated with lower AGRs. Specifically, there is a fairly perfect negative correlation of -0.74 between SFR and AGR. 55% of the variation in AGR is explained by changes in SFR. However, correlation does not prove causation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Business Statistics: Correlation Study Alumni Giving Case

    Uploaded by

    Shivanshu Gupta
    86 views4 pages
    The document analyzes the correlation between student/faculty ratios (SFR) and alumni giving rates (AGR) for 48 universities. It finds a strong negative correlation, with higher SFRs associated with lower AGRs. Specifically, there is a fairly perfect negative correlation of -0.74 between SFR and AGR. 55% of the variation in AGR is explained by changes in SFR. However, correlation does not prove causation.

    Original Title

    Alumini_Giving_Assignment.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document analyzes the correlation between student/faculty ratios (SFR) and alumni giving rates (AGR) for 48 universities. It finds a strong negative correlation, with higher SFRs associated with lower AGRs. Specifically, there is a fairly perfect negative correlation of -0.74 between SFR and AGR. 55% of the variation in AGR is explained by changes in SFR. However, correlation does not prove causation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    86 views4 pages

    Business Statistics: Correlation Study Alumni Giving Case

    Uploaded by

    Shivanshu Gupta
    The document analyzes the correlation between student/faculty ratios (SFR) and alumni giving rates (AGR) for 48 universities. It finds a strong negative correlation, with higher SFRs associated with lower AGRs. Specifically, there is a fairly perfect negative correlation of -0.74 between SFR and AGR. 55% of the variation in AGR is explained by changes in SFR. However, correlation does not prove causation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 4

    Business Statistics

    Correlation Study
    On

    Alumni Giving Case

    Submitted To: Submitted By:


    Dr. Pooja Soni Shivanshu Gupta
    (MBA-B Sem I)
    Below is the given data for 48 universities:

    Graduation % of Classes Student/Faculty Alumni Giving


    University Name State Rate Under 20 Ratio (SFR) Rate (AGR)
    Boston College MA 85 39 13 25
    Brandies University MA 79 68 8 33
    Brown University RI 93 60 8 40
    California Institute of
    Technology CA 85 65 3 46
    Carnegie Mellon
    University PA 75 67 10 28
    Case Western Reserve
    Univ. OH 72 52 8 31
    College of William and
    Mary VA 89 45 12 27
    Columbia University NY 90 69 7 31
    Cornell University NY 91 72 13 35
    Dartmouth College NH 94 61 10 53
    Duke University NC 92 68 8 45
    Emory University GA 84 65 7 37
    Georgetown University DC 91 54 10 29
    Harvard University MA 97 73 8 46
    Johns Hopkins
    University MD 89 64 9 27
    Lehigh University PA 81 55 11 40
    Massachusetts Institute
    of Technology MA 92 65 6 44
    New York University NY 72 63 13 13
    Northwestern
    University IL 90 66 8 30
    Pennsylvania State
    Univ. PA 80 32 19 21
    Priceton University NJ 95 68 5 67
    Rice University TX 92 62 8 40
    Stanford University CA 92 69 7 34
    Tufts University MA 87 67 9 29
    Tulane University LA 72 56 12 17
    University of California-
    Berkeley CA 83 58 17 18
    University of California-
    Davis CA 74 32 19 7
    University of California-
    Irvine CA 74 42 20 9
    University of California-
    Los Angeles CA 78 41 18 13
    University of California-
    San Diego CA 80 48 19 8
    Graduation % of Classes Student/Faculty Alumni Giving
    University Name State Rate Under 20 Ratio (SFR) Rate (AGR)
    University of California-
    Santa Barbara CA 70 45 20 12
    University of Chicago IL 84 65 4 36
    University of Florida FL 67 31 23 19
    University of Illinois-
    Urbana Champaign IL 77 29 15 23
    University of Michigan-
    Ann Arbor MI 83 51 15 13
    University of North
    Carolina-Chapel Hill NC 82 40 16 26
    University of Notre
    Dame IN 94 53 13 49
    University of
    Pennsylvania PA 90 65 7 41
    University of Rochester NY 76 63 10 23
    University of Southern
    California CA 70 53 13 22
    University of Texas-
    Austin TX 66 39 21 13
    University of Virginia VA 92 44 13 28
    University of
    Washington WA 70 37 12 12
    University of Wisconsin-
    Madison WI 73 37 13 13
    Vanderbilt University TN 82 68 9 31
    Wake Forest University NC 82 59 11 38
    Washington University-
    St. Louis MO 86 73 7 33
    Yale University CT 94 77 7 50
    Coefficient of Correlation:

    Student/Faculty Alumni Giving


    Ratio Rate
    Student/Faculty 1
    Ratio
    Alumni Giving Rate -0.742397463 1

    Descriptive Statistics:

    Student/Faculty Alumni Giving


    Ratio Rate

    Mean 11.54166667 29.27083333


    Standard Error 0.700150904 1.940091114
    Median 10.5 29
    Mode 13 13
    Standard Deviation 4.850787755 13.44134552
    Sample Variance 23.53014184 180.6697695
    Kurtosis -0.440337538 -0.071942009
    Skewness 0.581838493 0.370106739
    Range 20 60
    Minimum 3 7
    Maximum 23 67
    Sum 554 1405
    Count 48 48

    Interpretations:

    1. There is a negative correlation between Student/Faculty Ratio (SFR) and Alumni Giving Rate
    (AGR) which means that with increase in SFR the AGR tends to decrease and with decrease
    in the SFR the AGR tends to increase.
    2. The trend or pattern can be understood by the value of the coefficient of correlation (r)
    which comes out to be 0.74 in magnitude with a negative sign. This value lies in the range of
    perfect negative correlation. So, it can be said that there is a fairly strong inverse correlation
    between SFR and AGR where SFR is an independent variable and AGR is a dependent
    variable.
    3. The value of coefficient of determination (r2) comes out to be 0.55. This tells us that 55
    percent of the variation in AGR is explained by SFR.
    4. As correlation does not gives us the cause behind the relation, we can’t say the anything
    about the actual cause of increase or decrease in AGR with decrease or increase in SFR from
    the above coefficients.

    You might also like