DELTA TP DELTA_T*P % ROUNDING ERROR 3.21. a. Write VBA code similar to that of #3.20 but in an actual VBA module. Also, within the argument list for the function in the first line, write DELTA_T As Single" instead of just "DELTA_T". Also, choose a different name for the function, and adjust the code accordingly. Then, use "click and drag" and relative cell addresses to complete the 3rd column in the table at the right. Complete the fourth column by comparing the result in the third column with the exactly correct values. 0.4 0.4 0.4 0.4 1000000 2000000 3000000 4000000 5000000 6000000 7000000 8000000 9000000 10000000 0.4 0.4 0.4 0.4 0.4 0.4 b. Create an adequately labeled grayscale chart in Excel in which "% ROUNDING ERROR" is plotted against P for DELTA_T = 0.4 and for DELTA_T = 0.6. Clearly distinguish between the two curves with a legend. c. In general, what happens to the magnitude of the % rounding error as the number of operations increases? 0.5 0.5 5000000 10000000 d. Why is the % rounding error O for DELTA_T = 0.5? e. In this exercise, many operations are executed, but the operation is always addition and with the same number. How easy do you think it would be to predict the sign and magnitude of the rounding error when there are many diverse operations involving a variety of numbers? 0.6 0.6 0.6 0.6 0.6 0.6 0.6 0.6 0.6 0.6 1000000 2000000 3000000 4000000 5000000 6000000 7000000 8000000 9000000 10000000 f. Suppose P* DELTA_T were to be the input for a function having a condition number of 24. If p*DELTA_T has the % error shown in the lower right corner of your table, what would be the percent error in the function