USE EXCEL FOR THIS PLEASE

Referring to the Problem above, select the column of 500 outcomes, and from the Style portion of the Home tab, select Conditional Formatting and choose a Color Scale with a 3 colour gradient. Take a screen shot that shows a portion of your colourful column, paste it into an application (like Paint), and save it as a (.png) file. Upload your screenshot

Problem #4: 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 Create an Excel sheet with the following headings: B D E F G dt 0.25 Randomized Quarterly interest rate Total after 20 years S Total with interest NONE Total C6+D6 C7+D7 Random outcomes for total after 20 years for different random rates Time 0 0.25 0.5 0.75 1 1.25 $ $ $ $ 1,000.00 $ 10 11 12 You are to start with an initial deposit of $15,000. Your Total will earn interest each quarter at a rate that will appear in cell C3. At the end of each year, you will put in an additional deposit of: $1000 at the end of the first year - $2000 at the end of the second ... and so on until you deposit - $20,000 at the end of year 20 The "Total after 20 years" in cell G3 will be set equal to the cell at the bottom of the table that contains the Total immediately after you deposited that last $20,000. The quarterly compounding interest rate that you will earn will be a random number chosen by Excel in cell C3. In C3 you are to enter: =3.95% + 3%*rand() The function "rand()" selects a random number from a uniform distribution between 0 and 1. If you press "recalculate a few times (F9 on PCs), you should see different possible outcomes appear in cell G3 depending on the quarterly interest rate that the investment realized over those 20 years. You are to create a macro to record 500 random outcomes from cell G3, and save them in a column of cells beginning at G8 and going down. Instructions for creating the Macro are here. When you have the 500 outcomes in column G, have excel compute the maximum of those 500 numbers, the minimum, and the median. (a) What is the maximum value that you achieved? (b) What is the minimum value that you achieved? (c) What is the median value that you achieved? Problem #4(a): Answer correct to 2 decimals Problem #4(b): Answer correct to 2 decimals Problem #4(c): Answer correct to 2 decimals Problem #4: 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 Create an Excel sheet with the following headings: B D E F G dt 0.25 Randomized Quarterly interest rate Total after 20 years S Total with interest NONE Total C6+D6 C7+D7 Random outcomes for total after 20 years for different random rates Time 0 0.25 0.5 0.75 1 1.25 $ $ $ $ 1,000.00 $ 10 11 12 You are to start with an initial deposit of $15,000. Your Total will earn interest each quarter at a rate that will appear in cell C3. At the end of each year, you will put in an additional deposit of: $1000 at the end of the first year - $2000 at the end of the second ... and so on until you deposit - $20,000 at the end of year 20 The "Total after 20 years" in cell G3 will be set equal to the cell at the bottom of the table that contains the Total immediately after you deposited that last $20,000. The quarterly compounding interest rate that you will earn will be a random number chosen by Excel in cell C3. In C3 you are to enter: =3.95% + 3%*rand() The function "rand()" selects a random number from a uniform distribution between 0 and 1. If you press "recalculate a few times (F9 on PCs), you should see different possible outcomes appear in cell G3 depending on the quarterly interest rate that the investment realized over those 20 years. You are to create a macro to record 500 random outcomes from cell G3, and save them in a column of cells beginning at G8 and going down. Instructions for creating the Macro are here. When you have the 500 outcomes in column G, have excel compute the maximum of those 500 numbers, the minimum, and the median. (a) What is the maximum value that you achieved? (b) What is the minimum value that you achieved? (c) What is the median value that you achieved? Problem #4(a): Answer correct to 2 decimals Problem #4(b): Answer correct to 2 decimals Problem #4(c): Answer correct to 2 decimals