Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ex. 2.3.3 Answer: 1. Create the following worksheet. 2: Enter years from 1986 thru 2016 (I hide the columns in between (Format, Hide column.). 3:
Ex. 2.3.3 Answer: 1. Create the following worksheet. 2: Enter years from 1986 thru 2016 (I hide the columns in between (Format, Hide column.). 3: Enter DJ index of 1986 in B3. 4: Select an arbitrary % increase in B2 ( enter 1+% increase). 5: Enter formula "= to the left" in C2" and "=left up" in C3.6: Copy the formula in C2:C3 to cells to the right all the way to year 2016. 7: Try different values of % increase in B2 until the number in AG3 become 18454. Ans. 7.93%. A AB AE AF AG 1 year 1986 1987 1988 2014 2015 2016 2 Avg. % increase 1.05 =B2 =C2 =AE2 =AF2 3 DJ index 1870 I=B3*C2 =C3D2 =AD3AE2AE3"AF2=AF3 AG2 B D =AD2
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