Question: PLEASE HELP TO SOLVE PROBLEM IN EXCEL THANK YOU. Maverick numbers are named after a famous student who studied Financial Modeling at the University of

PLEASE HELP TO SOLVE PROBLEM IN EXCEL THANK YOU.

PLEASE HELP TO SOLVE PROBLEM IN EXCEL THANK YOU. Maverick numbers are

Maverick numbers are named after a famous student who studied Financial Modeling at the University of Texas at Arlington in the 21st century. Maverick numbers are defined as follows. M(0)=0M(1)=1+M(0)M(2)=2+M(1)M(3)=3+M(2)M(n)=n+M(n1) (a) Write a function that computes the Maverick number for a user-provided n. You must use recursion in this function. Name this function "Maverick" and use it to compute Maverick numbers for n= 1,2,3,4,10,75, and 100 . (b) Now rewrite the function but you must use Do While in the function. Name this function "Maverick2" and use it to compute Maverick numbers for n= 1,2,3,4,10,75, and 100 . PROBLEM II Write a macro that uses the Maverick function you have written in Problem I. Name your macro as MaverickCalc. This macro should ask the user to input the number n as follows: Please input the number n : The title of the box that asks for the above input should be: Input for Maverick Number Calculator No default input value should be provided for n. The result should be displayed in a message box that states the following. The Maverick number for n is: (Note that the number n above should be displayed as the actual number provided by the user.) The title of the box that provides the above output should be: Maverick number calculator The above output should be displayed in an information box (i.e., you need to use VbInformation)

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 Finance Questions!