Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Operating Systems

Authors: Andrew S. Tanenbaum, Herbert Bos

4th edition

013359162X, 978-0133591620

More Books

Students also viewed these Programming questions