Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4. In the columns below, use VLOOKUP to find the appropriate IBM returns and prices where indicated as of the specific date. Set up VLOOKUP
4. In the columns below, use VLOOKUP to find the appropriate IBM returns and prices where indicated as of the specific date. Set up VLOOKUP so that only exact matches are found. Format prices to two decimal places and returns as percentages to two decimal places. (20 points) IBM Return IBM Price 1/15/2013 2/15/2013 3/15/2013 4/15/2013 5/15/2013 6/14/2013 7/15/2013 8/15/2013 9/16/2013 10/15/2013 11/15/2013 12/16/2013 IBM Prices and Returns Date Price Return 2-Jan-13 196.35 3-Jan-13 195.27 -0.0055 4-Jan-13 193.99 -0.00656 7-Jan-13 193.14 -0.00438 8-Jan-13 192.87 -0.0014 9-Jan-13 192.32 -0.00285 10-Jan-13 192.88 0.002912 11-Jan-13 194.45 0.00814 14-Jan-13 192.62 -0.00941 15-Jan-13 192.5 -0.00062 16-Jan-13 192.59 0.000468 17-Jan-13 193.65 0.005504 18-Jan-13 194.47 0.004234 22-Jan-13 196.08 0.008279 23-Jan-13 204.72 0.044064 24-Jan-13 204.42 -0.00147 25-Jan-13 204.97 0.002691 28-Jan-13 204.93 -0.0002 29-Jan-13 203.9 -0.00503 30-Jan-13 203.52 -0.00186 31-Jan-13 203.07 -0.00221 1-Feb-13 205.18 0.010391 4-Feb-13 203.79 -0.00677 5-Feb-13 202.79 -0.00491 6-Feb-13 201.02 -0.00873 7-Feb-13 199.74 -0.00637 8-Feb-13 201.68 0.009713 11-Feb-13 200.16 -0.00754 12-Feb-13 200.04 -0.0006 13-Feb-13 200.09 0.00025 14-Feb-13 199.65 -0.0022 4. In the columns below, use VLOOKUP to find the appropriate IBM returns and prices where indicated as of the specific date. Set up VLOOKUP so that only exact matches are found. Format prices to two decimal places and returns as percentages to two decimal places. (20 points) IBM Return IBM Price 1/15/2013 2/15/2013 3/15/2013 4/15/2013 5/15/2013 6/14/2013 7/15/2013 8/15/2013 9/16/2013 10/15/2013 11/15/2013 12/16/2013 IBM Prices and Returns Date Price Return 2-Jan-13 196.35 3-Jan-13 195.27 -0.0055 4-Jan-13 193.99 -0.00656 7-Jan-13 193.14 -0.00438 8-Jan-13 192.87 -0.0014 9-Jan-13 192.32 -0.00285 10-Jan-13 192.88 0.002912 11-Jan-13 194.45 0.00814 14-Jan-13 192.62 -0.00941 15-Jan-13 192.5 -0.00062 16-Jan-13 192.59 0.000468 17-Jan-13 193.65 0.005504 18-Jan-13 194.47 0.004234 22-Jan-13 196.08 0.008279 23-Jan-13 204.72 0.044064 24-Jan-13 204.42 -0.00147 25-Jan-13 204.97 0.002691 28-Jan-13 204.93 -0.0002 29-Jan-13 203.9 -0.00503 30-Jan-13 203.52 -0.00186 31-Jan-13 203.07 -0.00221 1-Feb-13 205.18 0.010391 4-Feb-13 203.79 -0.00677 5-Feb-13 202.79 -0.00491 6-Feb-13 201.02 -0.00873 7-Feb-13 199.74 -0.00637 8-Feb-13 201.68 0.009713 11-Feb-13 200.16 -0.00754 12-Feb-13 200.04 -0.0006 13-Feb-13 200.09 0.00025 14-Feb-13 199.65 -0.0022
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