Question: Develop 3 Macro Functions in excel. Just need the formulas written out for each function, Thanks. (a) Develop a user defined function MyVar that calculates
Develop 3 Macro Functions in excel. Just need the formulas written out for each function, Thanks. (a) Develop a user defined function MyVar that calculates a variance by using the following equation, ET="}(5x7* + 2x} Avg) MyVar 4n - 1 where Avg represents the average of variable x, And, test your own function by using the values given on the sheet P3. Remember that this function must have three arguments (X, Avg, and n)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
