Assignment 3 BA 301 PDF

Preview

Summary

Mandatory assignment. These never change....

Description

Cody Layton BA 301-004 Assignment 3-Fun with Excel

1.

Regression Statistics 0.64434599 Multiple R 5 0.41518176 R Square 1 Adjusted R 0.40976677 Square 8 357870.546 Standard Error 3 Observations 110 ANOVA df Regression Residual Total

SS 1

9.81958E+12

108 109

1.38317E+13 2.36513E+13

MS 9.81958E+1 2 1.28071E+1 1

F 76.6727630 4

Significance F 3.08202E-14

From looking at the above data, a correlation between giving and years can be proven. This means that giving amounts tend to increase as years of involvement with the organization increase. The data supporting this claim is the Significance F value of 3.08202E-14 which expanded in full decimal form is 0.0000000000000308202. In the analysis of any regression, when a Significance F value is lower than .05 it is unlikely for the results to have happened by chance, thus a correlation is likely. With a Significance F of 3.08202E-14, a strong positive correlation is found between giving amount and amount of time with the organization. The second number proving the correlation is the R Square value. In statistics R Squared shows the degree of relationship between two variables. With the strongest R Square value possible being1.0; the R Square value of .415181761 shows a decently strong variable correlation.

2. Listed below are the average years of giving and giving amounts for corporations, foundations, and volunteers.

3. Below is a chart identifying who the large (>=$50,000) and very large (>=500,000) donors in the DC region, who are also insect enthusiasts are.

‘

4. Below is a pivot chart and table showing the Southern regions most supported interests in both corporate

and foundation donor types.

1,400,000 1,200,000 1,000,000 Anthropology Atlantic Mang. Research-Belize Biodiversity Endowment Forensic Anthropology GGM

800,000 600,000 400,000 200,000 Corporation

Foundation

In the Southern region, the two most heavily supported interests by corporate donors are Endowment at $234,334 and Anthropology at $170,000. This evidence is displayed in both the above pivot chart and table....