Problem #1

The Local representative of the community is concerned that there is a growing gap in the number and amount of loans given to small business owners among different ethnic groups.

Use the data in the attached Excel file (MINOR_ LOANS) describe the differences in the trend in the number and amount among different ethnic groups

1. In order to resolve the issue raised by the manager, you need to plot a time series chart of the number of loans given to African, Hispanic and Asian small business owners.
2. You should calculate the Average Amount of Loans given to each ethnic group between 1980 and 2005 and plot a chart comparing the trends in the differences in the average amount loans by Ethnicity.
3. Please Attach your recalculated table as Appendix II

U.S. Cattle and Beef Industry, 2002-2005

You have the following data on the US Cattle and Beef Industry.

Enter the data on (1) Beef Consumption (2) Beef Production and (3) Beef Exports below into a spreadsheet and calculate

1. the Percentage of US Beef Export a Percentage of Total Beef Production
2. The Difference between Beef production and Beef Consumption and Explain the difference
3. The Price Per Pound of US Beef Exports
4. Present your Table and
5. Plot a Chart of the Trends in each of your Variables and Describe your results
   1. All calculations must be show on a spreadsheet

• Retail equivalent value of U.S. beef industry:
  2002: $60 billion
  2003: $63 billion
  2004: $70 billion
  2005: $71 billion
  2006: $71 billion
• Total U.S. beef consumption:
  2002: 27.9 billion pounds
  2003: 27.0 billion pounds
  2004: 27.8 billion pounds
  2005: 27.8 billion pounds
  2006: 28.0 billion pounds
• U.S. beef production (commercial carcass weight):
  2002: 27.09 billion pounds
  2003: 26.24 billion pounds
  2004: 24.55 billion pounds
  2005: 24.68 billion pounds
  2006: 24.79 billion pounds
• U.S. beef exports (commercial carcass weight and value):
  2002: 2.45 billion pounds, $2.646 billion
  2003: 2.52 billion pounds, $3.190 billion
  2004: 460 million pounds, $605 million
  2005: 698 million pounds, $976 million
  2006: 1,153 million pounds, $1.63 billion

U.S. beef exports as percent of production:

Price: $14.61

Solution: The downloadable solution consists of 9 pages, 561 words and 5 charts.
Deliverable: Word Document