Answer:
Following are the solution to this question:
Explanation:
Some of the data is missing in the question, which is defined in the attached file. Please find it.
Follows are the formula which is used in the question:
- EmployeeAnalysis Worksheet IF(C5>49,"Certified","Not Certified")
- Transactions Worksheet IF(F10="No","",0.07)
In the first condition, it checks "C5" is greater than 49 if the condition is true, it will give "Certified" otherwise, it will give "Not Certified".
In the second condition, it checks "F10" is equal to "No" if the condition is true, it will give a blank or space otherwise, it will give "0.07".
Answer:
Each variable has a name, a value, and a type. The value might change over time, and that's why its “variable.” Many variables store numbers and strings, like the ones above. Variables can also store other types of data, like lists, dictionaries, and Boolean values
Explanation:
Answer:
yes oo you want to play with me
Answer:
Sensitivity analysis is the method in which it basically predict the final outcome of the decision. It analysis each variable individually and identify the dependency of the output value on the particular value of the input.
The advantage of the sensitivity analysis is that it reduce the overall risk of the particular strategy and also impact of the system.
It basically work on the basic principle that firstly changed the structure and model and then observe the particular behavior of the model.
