1. Create a macro to carry out linear interpolation using the formula 32-31 y=y+x (x-x1) x2-x1...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Posted Date:
Students also viewed these programming questions
-
answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Match each of the following energy band structures with the type of material it represents. Show Work A B C Empty conduction band Band gap Filled valence band Empty conduction band Band gap Filled...
-
OptiSystems manufactures an optical switch that it uses in its final product. OptiSystems incurred the following manufacturing costs when it produced 72,000 units last year: Direct materials . . . ....
-
In order to raise revenue to meet the increasing costs of government, a province and a territory each imposed a new tax on e-cigarettes. The legislation that the province enacted states: "Any person...
-
The W250 28 A-36 steel column is fixed at its base. Its top is constrained to rotate about the \(y-y\) axis and free to move along the \(y-y\) axis. If \(e=350 \mathrm{~mm}\), determine the allowable...
-
Record each of the following transactions in general journal form and then show the effect of the transaction in a horizontal statements model. The first transaction is shown as an example. a....
-
Create business rule for this ERD diagram: Example: Each CONCESSIONAIRE can be assigned to operate to at least one PARK Each PARK is assigned to one and only one CONCESSIONAIRE
-
This chapter discusses the data dictionary views for Oracle 12c. Research another RDBMS, such as Microsoft SQL Server, and report on its data dictionary facility and how it compares with Oracle.
-
An 8-pole trapezoidal BLDCM is driven round at a speed of 1000 rpm and the measured open-circuit line voltage is 20 V. The phase resistance is 1 Ohm and the rated motor current is 5A. The motor is...
-
2. The relationship between the mass and the volume of the materials are given in the table below a. b. Volume(cm) C. 180.4 120.3 75.5 39.6 24.1 11.2 6.8 Mass (g) 68 47 29 15 9.2 4.2 2.4 Graph (M vs...
-
1. Carbon dioxide with pressure 10 bar(g) and temperature 150 C flowarte is 100 kg/second flow Through duct with diameter 3 centimeters. Find stagnation temperature. 2. Ammonia refrigeration cycle in...
-
The compensatory actions of a continuous control system occur following a disturbance in the process. Propose a control system in which compensatory actions take place prior to the process...
-
A specification for a brushed DC (Direct Current) motor is given by Back EMF (Electromotive Force) constant: 0.1 [V/(rad/s)] The Motor internal resistance: 0.02 [2] The input voltage to the motor...
-
The popularity of non-dairy or plant-based milk among health-conscious people has been rising over recent years, due to several factors including that it consists of much less sugar compared to...
-
Compare a new venture to an existing company and explain why existing companies can obtain bank funding and new ventures cannot In replies to peers, review the criteria needed for financing and...
-
The sales department of P. Gillen Manufacturing Company has forecast sales in March to be 20,000 units. Additional information follows: Finished goods inventory, March 1 . . . . . . . . . . . . . . ....
-
In the example given in Fig. 1-17, the library procedure is called read and the system call itself is called read. Is it essential that both of these have the same name? If not, which one is more...
-
Migrating virtual machines may be easier than migrating processes, but migration can still be difficult. What problems can arise when migrating a virtual machine? Discuss.
-
When a process unmaps a clean stack page, it makes the transition (5) in Fig. 11-34. Where does a dirty stack page go when unmapped? Why is there no transition to the modified list when a dirty stack...
-
What kinds of qualifications might a statute place on someone who is in a dating relationship? What problems might these qualifications pose?
-
What kinds of relationships would qualify for a protective order in an inclusive state?
-
In brief, what is a civil order of protection?
Study smarter with the SolutionInn App