using excel VBA

1) The Taylor Series expansion for cosine is given by the following relation 2 6 cos(x) = 1 2!4!6! Use this relation to calculate the cosine of x to a user specified tolerance. For your program, use the following interface 3.1 0.001 Calculate tolerance 6 cosine(3.1)-0.999138520493791 7 terations cosine tolerance 4.805 0.04300417 3.84800417 1.1896398 1.232644 5 -0.9781093 0.21153052 6 -1.0006961 0.02258676 7-0.9990517 0.00164438 80.9991385 8.6827E-05 10 2 3.805 12 13 15 16 The user inputs the value ofx in radians (2 radians in a circle) and the tolerance into the worksheet. These cells are shaded in the figure. In this problem, the tolerance is defined the absolute value of the current term to be added in the series. For instance, in the above figure the tolerance is set at 0.001 so the program will terminate when the absolute value of the current term is less than 0.001 meaning that any additional terms will only change the series by less than 0.001. For each iteration, list the iteration number, calculated value of cosine at that iteration, and the current calculated tolerance a) Create a flowchart algorithm for this program b) Write the program 1) The Taylor Series expansion for cosine is given by the following relation 2 6 cos(x) = 1 2!4!6! Use this relation to calculate the cosine of x to a user specified tolerance. For your program, use the following interface 3.1 0.001 Calculate tolerance 6 cosine(3.1)-0.999138520493791 7 terations cosine tolerance 4.805 0.04300417 3.84800417 1.1896398 1.232644 5 -0.9781093 0.21153052 6 -1.0006961 0.02258676 7-0.9990517 0.00164438 80.9991385 8.6827E-05 10 2 3.805 12 13 15 16 The user inputs the value ofx in radians (2 radians in a circle) and the tolerance into the worksheet. These cells are shaded in the figure. In this problem, the tolerance is defined the absolute value of the current term to be added in the series. For instance, in the above figure the tolerance is set at 0.001 so the program will terminate when the absolute value of the current term is less than 0.001 meaning that any additional terms will only change the series by less than 0.001. For each iteration, list the iteration number, calculated value of cosine at that iteration, and the current calculated tolerance a) Create a flowchart algorithm for this program b) Write the program