Reference no: EM132870519

1. Copy the worksheet from the college file to your workbook. This worksheet contains the query result from Alita University's database. Rename the worksheet q1. Alita's management would like subtotals inserted in the list displaying the average financial aid amount by major, and then under each major the number of students by city.

2. At the end of last year, there were 415,000 elephants left in the world. Each year 3.8% die of natural causes and 6% from poaching. The annual birth rate averages to 6.1%. Suppose these rates continue, use goal seek to determine in how many years, elephants will become extinct. Hint: use the formula: population*(1+br-dr-p)^n, where br is the annual birth rate, dr is the annual natural death rate, p is the annual poaching rate and n is the number of years. Conservation initiatives are bringing awareness to the plight of elephant population and, in turn, impacting consumer sentiments towards poached products. Suppose you want to analyze elephant population further at the extinction year determined above, build a sensitivity analysis using Excel's one-variable table tool to show elephant population given varying poaching rates (from 0% to 20% at 1% intervals)