Data Analysis
TTT12
week_6_discussions_chapter__6.xlsxHome Loan - Student
| Input Area | One-Variable Data Table: APR | Two-Variable Data Table: APR and Cost of Home | |||||||
| Cost of home | $ 160,000.00 | Calculated Results for Each APR | Monthly Payment by Cost/APR | ||||||
| Down Payment | $ 10,000.00 | ||||||||
| APR | 4.00% | ||||||||
| No. Years for Loan | 30 | ||||||||
| Payments Per Year | 12 | ||||||||
| Output Area | |||||||||
| Amount of Loan | $ 150,000.00 | ||||||||
| Periodic Rate | 0.33% | ||||||||
| No. Payment Periods | 360 | ||||||||
| Monthly Payment | $ 716.12 | ||||||||
| Total to Repay Loan | $ 257,804.26 | ||||||||
| Total Interest Paid | $ 107,804.26 | ||||||||
Range Name
| Notice when you click in cell B9 it no longer shows B9 in the Name Box. It shows Amount of Loan. B10, B11 and B12 will now show the name from column A. | |||||||||||||||||
| After you edit/delete the range names and click in cell B12 it no longer shows the name in the Name Box. |
Formula and List
| Notice when you click in cell B12 the range names are now used in the formula shown in the Formula Bar. |
One-Variable Data Table
Two-Variable Data Table
Goal Seek
Solver Add-In
| Once you load the Solver Add-In, click on the Data tab. | |||||||||||||||||
| To the far right of the menu bar you will see Solver has now been added. |
