Create a decision tree and build a nested if statement

Assignment Help Basic Computer Science

Reference no: EM132844000

Learning Objectives

Use Excel to compare and analyze sets of data.
Understand and apply Boolean logic.
Build formulas with relational operators.
Write IF functions to evaluate TRUE and FALSE values and perform calculations.

Assignment

Instructions:

"IF" statements are useful in the decision-making process; however they can also become confusing and complicated. Nesting IF statements allow you to ask a question. If the answer is true or yes, you can ask another question. If it is false or now, you would ask a different 2nd question. Each subsequent question depends on the outcome of the last question.

For this assignment, you will create a decision tree and build a nested if statement for the following scenario: You are setting up a raise percentage for your bakers based on experience using the W3 Baker spreadsheet.

Employee	Hourly Wage	Years Experience	New Hourly Wage
Grace	11.00	0
Katherine	12.00	5
Marvin	17.50	9
Gene	13.75	2
Sandra	23.50	15

Years of Emploment	Raise %
0-4	2
5-9	3
10-13	4
14-17	5

Create a decision tree diagram using the information above. (See Figure 4.32 in the text.)

You may use the cells below, SmartArt, or the draw tools to create your diagram on the Excel Worksheet.

Then create a nested IF statement to compute the new hourly wage for your employees.

Insert the formula into the "New Hourly Wage" column and format as Currency with 2 decimal points.

Attachment:- Decision-making process.rar

Reference no: EM132844000

Questions Cloud

What is the project mirr at r equals to seven percent : What is the project's MIRR at r = 7%? The Ulmer Uranium Company is deciding whether or not to open a strip mine whose net cost is $4.4 million.

Calculate the TDSR : You pay $1100/month in rent. Calculate your TDSR given the above-mentioned assumptions and including the new loan payment you just calculated

What is the probability that she will get the job : Given that she does receive the offer, how certain should she be that she received a strong recommendation?

Define how the advanced practice nurse can play a role : Describe how the advanced practice nurse can play a role in improving the health of young adults through preventive screening and intervention.

Create a decision tree and build a nested if statement : Create a decision tree and build a nested if statement for the following scenario: You are setting up a raise percentage for your bakers based on experience

What category and at what value would cole report the asset : Cole Co. decides to invest excess cash of $17,400. What category and at what value would Cole report the asset on the December? 31, 2024?, balance? sheet?

Develop a system to support efforts : Imagine that job hunting has been going so well that you need to develop a system to support your efforts. The system should allow you to input information

Compare the physical assessments among school-aged children : Compare the physical assessments among school-aged children. Describe how you would modify assessment techniques to match the age and developmental.

Determine the total amount paid for each of the three option : The down payment required on the used car is $1750. Determine the total amount paid for each of three options, including principal, interest, and down payment

User Account

All Pages