QUESTION 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 - 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 - 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 - 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)
- 26.13%
52.00%
25.68%
14.25%
13.76%
0.9 points
QUESTION 5 - Use the Brewery.xlsx file to answer the following question: Which state has the highest total profit?
- CT
MA
TX
PA
CA
0.9 points
QUESTION 6 - 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