Question: 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,

1. Create a macro to carry out linear interpolation using the formula

 

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!