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 |
M1A1
Criteria | Ratings | Pts | ||
---|---|---|---|---|
This criterion is linked to a Learning OutcomeSuccessfully created ranges for 2 input variables |
|
1.0 pts |
||
This criterion is linked to a Learning OutcomeSuccessfully linked the result cell |
|
0.5 pts |
||
This criterion is linked to a Learning OutcomeSuccessfully completed the data table |
|
3.0 pts |
||
This criterion is linked to a Learning OutcomeFormatted and labeled cells appropriately |
|
0.5 pts |
||
Total Points: 5.0 |