Homework Help Question & Answers

The accompanying data for the S&P 500 provides open, high low, and close values for the...


The accompanying data for the S&P 500 provides open, high low, and close values for the S&P index over a period of time Compl
B С D E F G A 1 S&P 500 Data 2. #N/A 3 Day (May to June 2013) Open High Low Close 1632.69 1635.01 1623.09 1626.67 5 10 1626.6
The accompanying data for the S&P 500 provides open, high low, and close values for the S&P index over a period of time Complete parts a through c below. Click the icon to view the S&P Index a. Enter any day from May to June 2013 within the range of the data in cell G2. Use a MATCH function in cell G3 to find the row in the database that corresponds to this day Day 20 (representing May 20, 2013) has been added to cell G2 What MATCH function should be used in cell G3 to find the row in the database that corresponds to this day? G 20 A B с D E F 1 S&P 500 Data 2 Day 3 Day Database (May to June 2013) Open High Low Close row 4 9 1632.69 1635.011623.09 1626.67 5 10 1626.69 1633.701623.71 1633.70 6 13 1632.101636.00 1626.74 1633.77 =MATCH(G2,A4 A23,0) Using this MATCH function in cell G3, day 20 returns the row Vi vi More Enter your answer in the answer box and then click Check Answer. 3 parts Clear All Check Answer remaining data120200 vlev data-019 2020-9 yisy Show all
B С D E F G A 1 S&P 500 Data 2. #N/A 3 Day (May to June 2013) Open High Low Close 1632.69 1635.01 1623.09 1626.67 5 10 1626.69 1633.7 1623.71 1633.7 6 13 1632.1 1636 1626.74 1633.77 7 14 1633.75 1651.1 1633.75 1650.34 8 15 1649.13 1661.49 1646.68 1658.78 9 16 1658.07 1660.51 1648.6 1650.47 10 17 1652.45 1667.47 1652.45 1667.47 11 20 1665.71 1672.84 1663.52 1666.29 12 21 1666.2 1674.93 1662.67 1669.16 13 22 1669.39 1687.18 1648.86 1655.35 14 23 1651.62 1655.5 1635.53 1650.51 15 24 1646.67 1649.78 1636.88 1649.6 16 28 1652.63 1674.21 1652.63 1660.06 17 29 1656.57 1656.57 1640.05 1648.36 18 30 1649.14 1661.91 1648.61 1654.41 19 31 1652.13 1658.99 1630.74 1630.74 20 3 1631.71 1640.42 1622.72 1640.42 21 4 1640.73 1646.53 1623.62 1631.38 x 22. 5 1629.05 1629.31 1607.09 1608.9 23 6 1609.29 1622.56 1598.23 1622.56 ? 24 25 Ready
0 0
Next > < Previous
ReportAnswer #1

The match function that should be applied is

=MATCH(G2,A4:A23,0)

It will return answer = 8 because day 20 lies at the 8th row from A4(including A4).

The match function is used to get the relative position in an array for a specific lookup value.

Hence, using MATCH function in cell G3, day 20 returns the row 8

Know the answer?
Add Answer to:
The accompanying data for the S&P 500 provides open, high low, and close values for the...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Futures Contracts Contract Open High o Low Worldoc 12000 s par 12 50 122 Domesticocs-12000 sper...

    Futures Contracts Contract Open High o Low Worldoc 12000 s par 12 50 122 Domesticocs-12000 sper Open Og Hont Sttle Metal & Petroleum Futures Contract High to Low 1242 1254 1264 1235 1254 Open Og test 1263 Opm Copper Hgh (0-25000 per 23760 2975 2040 3.0240 Gold c-100 troya.Spertroyo Settle May July March May 29760 2995 0.030 29775 30 00305 150261 - 12 24 35 24 Cotton C--50000bsntspart 277 7.92 Orange Juice 0uS15000 Bsantspert 13810 135 25.05 2542 March Apr...

  • Consider historical data showing that the average annual rate of return on the S&P 500 portfolio...

    Consider historical data showing that the average annual rate of return on the S&P 500 portfolio over the past 90 years has averaged roughly 8% more than the Treasury bill return and that the S&P 500 standard deviation has been about 20% per year. Assume these values are representative of investors' expectations for future performance and that the current T-bill rate is 5%. Calculate the utility levels of each portfolio for an investor with A = 2. Assume the utility...

  • 1) Use the following corn futures quotes:     Corn 5,000 bushels   Contract Month Open High Low Settle Chg Open Int...

    1) Use the following corn futures quotes:     Corn 5,000 bushels   Contract Month Open High Low Settle Chg Open Int   Mar 455.125 457.000 451.750 452.000 −2.750 597,913     May 467.000 468.000 463.000 463.250 −2.750 137,547     July 477.000 477.500 472.500 473.000 −2.000 153,164     Sep 475.000 475.500 471.750 472.250 −2.000 29,258      Suppose you buy 20 of the September corn futures contracts at the last price of the day. One month from now, the futures price of this contract is 462.75, and you close out...

  • TABLE 3-1 Stock Market Quote, July 22016 (1) 6) (6) Close (9) Vol Symbol Open High Low ao Low AAR Corp. Aaron's, I...

    TABLE 3-1 Stock Market Quote, July 22016 (1) 6) (6) Close (9) Vol Symbol Open High Low ao Low AAR Corp. Aaron's, Inc AIR AAN 22.98 22.86 40.83 18.08 23.15 22.50 22.72 29.55 22.70 415740.80 41.36 18.39 18.05 18.22 10.45 10.16 10:20 62,85 61.7561.92 Boos Abbott Laboratories Abercrombie & Fitch ACCO Brands EI. DuPont de Nemours Eli Lilly El Paso Electric MeDonald's -0.15 -0.66 79.163 -0.14 -0.61 667,029 0.531230122196,628 0.13 0.7 1,878,642 -0.06 425,836 0.07 0.113.994,283 (1) 52 Week High...

  • Og revest Futures Contracts Metal & Petroleum Futures Contract Open Hgh to low Settle Copperh onco...

    Og revest Futures Contracts Metal & Petroleum Futures Contract Open Hgh to low Settle Copperh onco 25.000s.Sperti 2700 275 297 22915 2004 20 2.072S LOS Gold D-100 ty pertroyer - U TISKO TON TON 1922 1100 15 TO WO 1150 115 17. 1150.00 DL 1100 DM UM noms-Strypto EI EGÉSes S&S ESSE Contact Open Hy belo Se Og Het Sugar-World 112000 sparta May 1242 123 1235 1294 2 993 120 22 129 J Sugar-Domesticos-us-112000 h.cosper 245 245 246 25 -...

  • 1)The TARP program allocated $500 million to individuals who defaulted on their mortgages. provided $25 billion...

    1)The TARP program allocated $500 million to individuals who defaulted on their mortgages. provided $25 billion of debt relief to citizens who owed federal taxes. provided low-interest-rate loans for students attending college. provided low-interest-rate loans for new homeowners. allocated $700 billion to keep banks from failing. Question 12 The interest rate of a bond is computed as a(n) difference. sum. absolute value. multiplication. growth rate Question 13 If the interest rate of a one-year bond is 15 percent and its...

  • Write a C++ program that will input data from a Comma-separated values (.csv) file and output som...

    Write a C++ program that will input data from a Comma-separated values (.csv) file and output some information about it. This program uses a csv file from Yahoo Finance (.csv) filename : SBUX.csv 1. Output the name of the ticker to the console screen (without the “.csv”) 2. Output the start date and end date that was found in the file 3. Output how many trading day(s) existed in the file 4. Prompt the use to input a number of...

  • 1. Analyze a mixed cost using the high-low method. 2. Prepare an income statement for a...

    1. Analyze a mixed cost using the high-low method. 2. Prepare an income statement for a merchandising company using the contribution format. Excel Assignment 2 Chapters 4 - 6) Saved Calori LI Paste BIU- " AA A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells 2 Clipboard Font A1 v f Jay Corporation has decided to prepare contribution income statements for v A с E F G 8.33 points Jay Corporation has decided to prepare contribution Income...

  • Write a program that demonstrates use of programmer - defined data structures. Please provide code! Thank...

    Write a program that demonstrates use of programmer - defined data structures. Please provide code! Thank you. Here are the temps given: January 47 36 February 51 37 March 57 39 April 62 43 May 69 48 June 73 52 July 81 56 August 83 57 September 81 52 October 64 46 November 52 41 December 45 35 Janual line Iranin Note: This program is similar to another recently assigned program, except that it uses struct and an array of...

  • S&P Enterprises has provided data from the first three months of the year. The Controller has...

    S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell on the Budget...

Free Homework App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.