I’m working on a Excel question and need guidance to help me study.
In sheet “Data table & scenario manager”, create a two-input data table as a sensitivity analysis. We want to explore how purchasing price and tax rate together affect after-tax income.
Show After-tax income as a function of purchasing price ($5, $6, …$13) and tax rate (30%, 32%, …40%).
Submit only 1 sheet, instead of the entire file. Please use the rubric below to guide the development of your assignment.
| Successfully created ranges for 2 input variables | 1 pt |
|---|---|
| Successfully linked the result cell | 0.5 pt |
| Successfully completed the data table | 3 pts |
| Formatted and labeled cells appropriately | 0.5 pt |
| Total | 5 pts |
Rubric
M1A1
| Criteria | Ratings | Pts |
|---|---|---|
| This criterion is linked to a Learning OutcomeSuccessfully created ranges for 2 input variables | 1.0 ptsFull Marks0.0 ptsNo Marks | 1.0 pts |
| This criterion is linked to a Learning OutcomeSuccessfully linked the result cell | 0.5 ptsFull Marks0.0 ptsNo Marks | 0.5 pts |
| This criterion is linked to a Learning OutcomeSuccessfully completed the data table | 3.0 ptsFull Marks0.0 ptsNo Marks | 3.0 pts |
| This criterion is linked to a Learning OutcomeFormatted and labeled cells appropriately | 0.5 ptsFull Marks0.0 ptsNo Marks | 0.5 pts |
| Total Points: 5.0 |
0 comments