Average yield of a Long Term Treasure Bill

QUESTION 1

1. Using the following URL, determine the average yield of a Long Term Treasure Bill (LT Composite>10yrs) in 2010:
   https://home.treasury.gov/resource-center/data-chart-center/interest-rates/TextView?type=daily_treasury_real_long_term&field_tdr_date_value=all
   Under the Resource Center, select “Daily Treasury Real Long-Term Rate Averages”
   Select type of Interest Rate Data: Daily Treasury Real Long-Term Rates
   Select Time Period: 2010
   1.72
   1.73
   1.74
   1.75
   1.76
   0.9 points
   QUESTION 2
2. Using the following URL of http://finance.yahoo.com/quote/GOOG/history, determine the average volume for shares of Google in 2020. Use the following parameters:
   Time Period: 12/31/2019- 12/30/2020
   Show: Historical Prices
   Frequency: Weekly
   (Round the answer to whole number)
   ( )
   0.9 points
   QUESTION 3
3. Using the following URL, what was the average population of the countries ranked 51-100 in population size in 1900 (round to the nearest 1000): https://www.bu.edu/adminsc/2021/03/18/list-of-countries-by-population-in-1900/
   ( )
   1.4 points
   QUESTION 4
4. Use the Brewery.xlsx file to answer the following question: What percentage of profit does Lager account for among the three types of beer? (rounded to 2 decimals)
5. 26.13%
   52.00%
   25.68%
   14.25%
   13.76%
   0.9 points
   QUESTION 5
6. Use the Brewery.xlsx file to answer the following question: Which state has the highest total profit?
7. CT
   MA
   TX
   PA
   CA
   0.9 points
   QUESTION 6
8. Use the Brewery.xlsx file to answer the following question: Across all four locations, what percentage of total profit is made in MA?
   75.69%
   81.00%
   45.26%
   74.56%
   84.29%

Sample Solution