1. Create a macro to carry out linear interpolation using the formula 32-31 y=y+x (x-x1) x2-x1...

 

Transcribed Image Text:

1. Create a macro to carry out linear interpolation using the formula 32-31 y=y+x (x-x1) x2-x1 Use relative addressing. Give the macro a name, a shortcut key, and a description. This macro should be able to be used on various sets of values, at various locations on your worksheet, without changing the coding in the of the macro itself. Try your macro out with the following set of data, solving for x = 2.03: X 2.0 y 5.5 2.1 7.2 2. Create a macro that will determine the mean, median, mode, min, max and standard deviation of a list of 20 numbers. Come up with a list of numbers to test your macro. 3. Record a macro to format a number so that it displays in red, bold italic, 12-point Arial font, limit the number of decimal points to 3. Record a second macro so that the number displays in blue, Times New Roman 14-point font, limit the number of decimal points to 2. Look at both macros in the VBA editor. What differences do you note? 4. Copy the macro you created in problem 2, rename it and edit it using the VBA editor as follows: Remove the calculation of the min and max Add a calculation of the Variance. Remember, the Variance is the square of the Standard Deviation 1. Create a macro to carry out linear interpolation using the formula 32-31 y=y+x (x-x1) x2-x1 Use relative addressing. Give the macro a name, a shortcut key, and a description. This macro should be able to be used on various sets of values, at various locations on your worksheet, without changing the coding in the of the macro itself. Try your macro out with the following set of data, solving for x = 2.03: X 2.0 y 5.5 2.1 7.2 2. Create a macro that will determine the mean, median, mode, min, max and standard deviation of a list of 20 numbers. Come up with a list of numbers to test your macro. 3. Record a macro to format a number so that it displays in red, bold italic, 12-point Arial font, limit the number of decimal points to 3. Record a second macro so that the number displays in blue, Times New Roman 14-point font, limit the number of decimal points to 2. Look at both macros in the VBA editor. What differences do you note? 4. Copy the macro you created in problem 2, rename it and edit it using the VBA editor as follows: Remove the calculation of the min and max Add a calculation of the Variance. Remember, the Variance is the square of the Standard Deviation