Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions