Question

Problem 3: During 2001, the Campbell Soup Foundation provided the following amounts in grants: Camden, N.L.. $1,336,700: plant communities, $341,500; Dollars for Doers, 179,600; other projects. $64.100. Source: The Campbell Sowp Foundation, 2002 anal Report, p. 16. Transfer the data on an Excel sheet (create a column for the Grants categories and one column for the Grant Contribution and construct a pie chart to summarize these contributions. Problem 4: For a sample of 100 cmployees, a personnel director has collected data on x = the number of years an employee has been with the firm and y= the number of shares of company stock the employee owns. The data are in file xr02044. a. Generate a scatter diagram that includes the best-fit linear equation for these data. b. Does there appear to be any relationship between the variables? If so, is the relationship direct or inverse? Problem 5: For a sample of eight apartment buildings in Chicago, the percentage-occupancy rates during a recent month were as shown below: 50.0% 68.1 79.1 70.0 61.3 72.5 43.9 66.3 Transfer the sample date on Excel and determine: a. The mean, and median. b. The standard deviation and variance.

Answer 1

Problem 3:

Grants Categories	Grant Contributions
Camden, N.J.	$13,36,700.00
Plant communities	$34,500.00
Dollars for Doers	$1,79,600.00
Other Projects	$64,100.00
Total	$16,14,900.00

GRANT CONTRIBUTIONS OF DIFFERENT GRANT CATEGORIES I Dollars for Doers ICamden, N.J. Plant communities 1Other Projects 4% 11% 2% 83%

The pie chart calculation for each grant is done using

$\frac{Particular Grants Category Contribution}{Total Grant Contributions}* 100$

For example, for Camden N.J. = $\frac{1336700}{1614900}* 100$ = 82.7% $\approx$ 83%

Summarization of Grants

The pie chart shows that the maximum grant contribution is done by Camden N.J. contributing the highest grants as 83% of the total grants. Followed by Dollars for Doers, where the pie chart has 11% of total grants and the least contribution is made by Other Projects comprising 2% of total grants. Whereas, 4% contribution is made by Plant Communities from the total grants.