For the following problem, you are to create a Macro using the Record Macro functionality. Assuming that your computer allows Macros, you may have to turn this feature on by using "Customize Ribbon" to add the "Developer" tab. Customize Ribbon might be found under "Options" from a File or Home screen in Excel.

NOTE FOR MAC USERS

Make

:For' the following problem, you are to create :1 Macro using the Record Macro functionality. Assuming that your computer allows Macros, you may have to turn this feature on by using "Customize Ribbon" to add the \"Developer" tab. lL'I'ustornice Ribbon might be found under \"Up-ions\" from a File or Home screen in Excel. NOTE FOR hL'tC USERS Creme an Excel sheet 1with the following headings: .1 .IL I 1: Et- E F E II I 1 limit! 1 DIII'HI'I' "Full THII'II'm-UI I Ill! eta-you Inlrr I I 5 111": Thl'll'l'h''l m Tillil arm-m i D Wrm-t? m \"WHEN\" T III! \"instillat- I am tot-mam I'M 3 t1! alum-moo 5- '3 DJ"; WINNIN' 5 10 l \"HIM-ITEM? 5 mo: 11 1.2"! detention-:- I - 12 You areto start 1|iI.I'ithaniniti.al depositofil. Your Total will earn interesteach quarter atarate thatwill appear incell {3.Atthe endcfeaeh year,youwill put inanadditional deposit of: - $1Msttheendoftherstyear - Watme-dcfthesemnd ...andsoonuntllyoudeposit - WMMtheendofyeari' The\"Totalaer2'llyears"inoell G3 willhesetequaltotl'recellatthebortomot'thetablethatoontainstheTotal immediately after you deposited that last trams. The quarterly compounding interest rate that you 1will earn 1I'll-ill be a random number chosen by Excel in cell {3. In C3 you are to enter: :1 33% + 3%'rand The function "rand" selects a random number from a uniform distribution behvlrll {t and 1. If you press \"recalculate" a few times [F9 on PCs}, you should see different possible outcomes appear in cell {33 depending on the quarterly interest rate that the investment realized over those 20 years. You are to create a macro to record SCH] random outcomes from cell G3, and save them in a column of cells beginning at GE and going down. Instructions for creating the Macro are here. When you have the SCI] outcomes in column G, have excel compute the maximum of those no numbers, the minimuml and the median. (3} What is the maximum value that you achievedill lb} What is the minimum value that you achieved? (e) What is the median value that you achieved