{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}
UK: +44 748 007-0908, USA: +1 917 810-5386 [email protected]

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 

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?