Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me with these short steps, I will leave a Like! The accompanying data for the S&P 500 provides open, high, low, and close
please help me with these short steps, I will leave a Like!
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 April to 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 10 (representing May 10, 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 B D E G 1 S&P 500 Data Day 10 Database 3 Day (April to May 2013) Open High Low Close row 4 16 1552 361575 35 1552 36 1574 57 15 17 1574 57 1574 571543 69 1552 01 6 18 1552 03 1554 38 1536 03 1541 61 Using this MATCH function in cell G3, day 10 returns the row b. Write an INDEX function in cell G4 that finds the closing value on this day using your answer to part a O What INDEX function should be used in coll G4 to find the closing value on this day used for the answer in part a? A B C 1 S&P 500 Data 2 3 Day (April Open High 4 16 5 17 1574.57 6 18 1552.03 7 19 1541.61 22 1555.25 23 1562.5 24 1578.78 25 1578.93 26 1585.16 29 1582.34 30 1593.58 1 1597.55 2 1582.77 3 1597.6 6 1614.4 7 1617.55 8 1625.95 9 1632.69 10 1626.69 13 1632.1 8 9 10 11 12 13 14 15 16 17 18 19 a 20 21 22 23 d D Low 1552.36 1575.35 1552.36 1574.57 1543.69 1554.38 1536.03 1555.89 1539.4 1565.55 1548.19 1579.58 1562.5 1583 1575.8 1592.64 1578.93 1585.78 1577.56 1596.65 1582.34 1597.57 1586.5 1597.55 1581.28 1598.6 1582.77 1618.46 1597.6 1619.77 1614.21 1626.03 1616.64 1632.78 1622.7 1635.01 1623.09 1633.7 1623.71 1636 1626.74 E Close 1574.57 1552.01 1541.61 1555.25 1562.5 1578.78 1578.79 1585.16 1582.24 1593.61 1597.57 1582.7 1597.59 1614.42 1617.5 1625.96 1632.69 1626.67 1633.7 1633.77 b. Write an INDEX function in cell G4 that finds the closing value on this day using your answer to part a What INDEX function should be used in cell G4 to find the closing value on this day used for the answer in part a? A B C D E F G 1 S&P 500 Data 10 Day Database Day (April to May 2013) Open High Low Close row 4 16 1552.36 1575.35 1552.36 1574.57 5 17 1574.57 1574.57 1543.69 1552.01 1552.03 1554.38 1536.03 1541.61 18 Using this INDEX function in cell G4, the closing value on the day in part a is (Type an integer or a decimal. Do not round.) 123 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 Click the icon to view the S&P Index. IV TUVETVE TUVE UVIVITVE 17 1574.57 1574.57 1543.69 1552.01 1552.03 1554.38 1536.03 1541.61 18 Using this INDEX function in cell G4, the closing value on the day in part a is (Type an integer or a decimal. Do not round.) c. Combine the MATCH and INDEX functions in parts a and b into one function that displays the closing value in cell G5. What combination of the MATCH and INDEX functions displays the closing value in cell G5? A B C D E F 1 S&P 500 Data 2 10 Day Database: Day (April to May 2013) 16 Low Open High Close row 1552 36 1575.351552.36 1574.57 1574.571574.57 1543.69 1552.01 17 18 1552 031554 38 1536.03 1541.61 5655 3 4 5 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 April to 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 10 (representing May 10, 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 B D E G 1 S&P 500 Data Day 10 Database 3 Day (April to May 2013) Open High Low Close row 4 16 1552 361575 35 1552 36 1574 57 15 17 1574 57 1574 571543 69 1552 01 6 18 1552 03 1554 38 1536 03 1541 61 Using this MATCH function in cell G3, day 10 returns the row b. Write an INDEX function in cell G4 that finds the closing value on this day using your answer to part a O What INDEX function should be used in coll G4 to find the closing value on this day used for the answer in part a? A B C 1 S&P 500 Data 2 3 Day (April Open High 4 16 5 17 1574.57 6 18 1552.03 7 19 1541.61 22 1555.25 23 1562.5 24 1578.78 25 1578.93 26 1585.16 29 1582.34 30 1593.58 1 1597.55 2 1582.77 3 1597.6 6 1614.4 7 1617.55 8 1625.95 9 1632.69 10 1626.69 13 1632.1 8 9 10 11 12 13 14 15 16 17 18 19 a 20 21 22 23 d D Low 1552.36 1575.35 1552.36 1574.57 1543.69 1554.38 1536.03 1555.89 1539.4 1565.55 1548.19 1579.58 1562.5 1583 1575.8 1592.64 1578.93 1585.78 1577.56 1596.65 1582.34 1597.57 1586.5 1597.55 1581.28 1598.6 1582.77 1618.46 1597.6 1619.77 1614.21 1626.03 1616.64 1632.78 1622.7 1635.01 1623.09 1633.7 1623.71 1636 1626.74 E Close 1574.57 1552.01 1541.61 1555.25 1562.5 1578.78 1578.79 1585.16 1582.24 1593.61 1597.57 1582.7 1597.59 1614.42 1617.5 1625.96 1632.69 1626.67 1633.7 1633.77 b. Write an INDEX function in cell G4 that finds the closing value on this day using your answer to part a What INDEX function should be used in cell G4 to find the closing value on this day used for the answer in part a? A B C D E F G 1 S&P 500 Data 10 Day Database Day (April to May 2013) Open High Low Close row 4 16 1552.36 1575.35 1552.36 1574.57 5 17 1574.57 1574.57 1543.69 1552.01 1552.03 1554.38 1536.03 1541.61 18 Using this INDEX function in cell G4, the closing value on the day in part a is (Type an integer or a decimal. Do not round.) 123 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 Click the icon to view the S&P Index. IV TUVETVE TUVE UVIVITVE 17 1574.57 1574.57 1543.69 1552.01 1552.03 1554.38 1536.03 1541.61 18 Using this INDEX function in cell G4, the closing value on the day in part a is (Type an integer or a decimal. Do not round.) c. Combine the MATCH and INDEX functions in parts a and b into one function that displays the closing value in cell G5. What combination of the MATCH and INDEX functions displays the closing value in cell G5? A B C D E F 1 S&P 500 Data 2 10 Day Database: Day (April to May 2013) 16 Low Open High Close row 1552 36 1575.351552.36 1574.57 1574.571574.57 1543.69 1552.01 17 18 1552 031554 38 1536.03 1541.61 5655 3 4 5 6 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started