The accompanying data for the S&P 500 provides open, high, low, and close values for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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 23 (representing May 23, 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? A В E 1 S&P 500 Data Day Database 2 23 3 Day (May 2013) =MATCH(G2,A4:A23,0) High 1597.55 1597.55 1581.28 1582.70 1582.77 1598.60 1582.77 1597.59 1597.60 1618.46 1597.60 1614.42 Оpen Low Close row 4 1 6. Using this MATCH function in cell G3, day 23 returns the row 17. b. Write an INDEX function in cell G4 that finds the closing value on this day using your answer to part a. Click to select vour answer(s) and then click Check Answer. A В C E 1 S&P 500 Data Day Open High Low Close (May 2013) 4 1 1597.55 1597.55 1581.28 1582.70 1582.77 1598.60 1582.77 1597.59 1597.60 1618.46 1597.60 1614.42 1614.40 1619.77 1614.21 1617.50 1617.55 1626.03 1616.64 1625.96 1625.95 1632.78 1622.70 1632.69 1632.69 1635.01 1623.09 1626.67 1626.69 1633.70 1623.711633.70 1632.10 1636.00 1626.74 1633.77 6. 3 7 6. 8. 7 9 8 10 9. 11 10 12 13 14 1633.75 1651.10 1633.75 1650.34 14 15 1649.13 1661.49 1646.68 1658.78 1658.07 1660.51 1648.60 1650.47 1652.45 1667.47 1652.45 1667.47 1665.71 1672.84 1663.52 1666.29 15 16 16 17 17 20 N 34 L O7 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 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 23 (representing May 23, 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? A В E 1 S&P 500 Data Day Database 2 23 3 Day (May 2013) =MATCH(G2,A4:A23,0) High 1597.55 1597.55 1581.28 1582.70 1582.77 1598.60 1582.77 1597.59 1597.60 1618.46 1597.60 1614.42 Оpen Low Close row 4 1 6. Using this MATCH function in cell G3, day 23 returns the row 17. b. Write an INDEX function in cell G4 that finds the closing value on this day using your answer to part a. Click to select vour answer(s) and then click Check Answer. A В C E 1 S&P 500 Data Day Open High Low Close (May 2013) 4 1 1597.55 1597.55 1581.28 1582.70 1582.77 1598.60 1582.77 1597.59 1597.60 1618.46 1597.60 1614.42 1614.40 1619.77 1614.21 1617.50 1617.55 1626.03 1616.64 1625.96 1625.95 1632.78 1622.70 1632.69 1632.69 1635.01 1623.09 1626.67 1626.69 1633.70 1623.711633.70 1632.10 1636.00 1626.74 1633.77 6. 3 7 6. 8. 7 9 8 10 9. 11 10 12 13 14 1633.75 1651.10 1633.75 1650.34 14 15 1649.13 1661.49 1646.68 1658.78 1658.07 1660.51 1648.60 1650.47 1652.45 1667.47 1652.45 1667.47 1665.71 1672.84 1663.52 1666.29 15 16 16 17 17 20 N 34 L O7
Expert Answer:
Answer rating: 100% (QA)
The answer is Using the MATCH Function in cell G3 day 20 returns ... View the full answer
Related Book For
Statistics for the Life Sciences
ISBN: 978-0321989581
5th edition
Authors: Myra Samuels, Jeffrey Witmer, Andrew Schaffner
Posted Date:
Students also viewed these general management questions
-
What socket type should be used to implement an inter computer file-transfer program? What type should be used for a program that periodically tests to see whether another computer is up on the...
-
What socket type should be used to implement an inter computer file transfer program? What type should be used for a program that periodically tests to see whether another computer is up on the...
-
What decision criterion should be used to choose investment projects for a firm with unlimited funds available at a weighted-average cost of 10 percent (after tax)? Can the firm use the same decision...
-
What are the "two main lines" of distortion of the view of Marx and what does Lenin think the proper view?
-
Use the graph of the rate of change to sketch a graph of the function, starting from the given initial condition. Start from y(0) = -1. 0.5 6 8 10 -0.5 Time
-
The graphs in Fig. P.4.98 are the reflection spectra for several roses seen in white light. The flowers were white, yellow, light pink, dark pink, blue, orange, and red. Associate each graph with a...
-
Define business roles and give three examples for a bank.
-
Tovar Co. is a U.S. firm that has been asked to provide consulting services to help Grecia Company (in Greece) improve its performance. Tovar would need to spend $300,000 today on expenses related to...
-
Figure 1 of 1 EXECUTE Part E Write the equation for the x-coordinate of the ball as a function of time t. Express your answer in terms of the variables vo, 0, 0, t, and the acceleration due to...
-
Peyton Smith enjoys listening to all types of music and owns countless CDs. Over the years, Peyton has gained a local reputation for knowledge of music from classical to rap and the ability to put...
-
Billy works for Harley Davidson. In June he was injured while assembling a motorcycle. He received $25,000 of worker's compensation payments, in addition to $130,000 salary in the current year. What...
-
Debit implies increase and credit implies decrease. Do you agree with the statement? Explain your answer.
-
Depreciation is a non-cash expense. Still it is an integral part of cash flows. Explain.
-
While interest payment is an expense, dividend payment, in contrast, is not reckoned expense. Explain.
-
Capital expenditures and deferred revenue expenditures need to be apportioned to determine true income. Explain. Give 3 examples of each.
-
State the rules of debit and credit as applied to (a) expense accounts, (b) asset accounts (c) capital account.
-
An international company has the following profitability analysis of its three divisions: Division A Division B Division C Revenues $ 5,000,000 $ 10,000,000 $ 3,000,000 Commissions (1,000,000 )...
-
Suppose the government bond described in problem 1 above is held for five years and then the savings institution acquiring the bond decides to sell it at a price of $940. Can you figure out the...
-
A scatterplot and fitted regression line of the data from Exercise 12.S.6 follow. The individual birds are labeled in the plot. (a) Which bird/point has the largest regression residual? (b) Which...
-
In an experiment with a certain mutation in the fruitfly Drosophila, n individuals were examined; of these, 20% were found to be mutants. Determine the standard error of if (a) n = 100 (20 mutants)....
-
Consider a fictitious population of mice in which each animal's coat is either black (B) or gray (G) in color and is either wavy (W) or smooth (S) in texture (as in Exercise 10.3.1). Suppose a random...
-
The variety of possible methods of foreign currency translation, and the different ways of treating gains arising, show that adequate harmonization for international comparison purposes is a long way...
-
Entity X based in one country (currency $) bought goods from Entity Y in another country (currency :) for :300,000 on 1 May 20X1. The spot rate on that date was $1 = :1. As at 31 December 20X1, the...
-
Under IFRS, unsettled gains on foreign monetary balances in an entitys balance sheet should be: A. Taken to profit or loss immediately. B. Taken to profit or loss when realized. C. Taken to profit or...
Study smarter with the SolutionInn App