statistics project part 3
October 15, 2021
please answer one of the following dq s please provide the questions that is being answered as the heading
October 15, 2021

sensitivity analysis 2

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.

M1 Assignment – Sensitivity Analysis Rubric
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 pts

Full Marks

0.0 pts

No Marks

1.0 pts

This criterion is linked to a Learning OutcomeSuccessfully linked the result cell

0.5 pts

Full Marks

0.0 pts

No Marks

0.5 pts

This criterion is linked to a Learning OutcomeSuccessfully completed the data table

3.0 pts

Full Marks

0.0 pts

No Marks

3.0 pts

This criterion is linked to a Learning OutcomeFormatted and labeled cells appropriately

0.5 pts

Full Marks

0.0 pts

No Marks

0.5 pts

Total Points: 5.0

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.