1. You have an upcoming job interview with ACME Accounting and Finance. ACME makes hiring decisions...

    

Transcribed Image Text:

1. You have an upcoming job interview with ACME Accounting and Finance. ACME makes hiring decisions based on the results of an interview and a skills exam. a. The interview is scored on a scale of 1-7. b. The skills exam is scored on a scale of l1-10. c. The job offer is determined by the sum of the interview and skills exam scores. i. If the combined score is 16 or 17, then the applicant is offered a manager job. 11. If the combined score is 13-15, then the applicant is offered an assistant manager job. iii. If the combined score is 10-12, then the applicant is offered a team member job. iv. If the combines score is 0-9, then the applicant is not offered any job. Required: Create your solution on a worksheet named Interview. • Predict your scores on the interview and skills exam using RANDBETWEEN functions. o Your two scores are independent of each other. • Use an IFS function to determine the job offer that you will receive based on your predicted scores. 2. AUM wants to predict the outcome of the next soccer game. The coach figures that the probabilities for the number of goals scored are as follows: Probability AUM Goals Scored Probability Troy Goals Scored 10% 12% 15% 1 15% 1 20% 22% 2 25% 3 25% 3 30% 4 26% 4 The goals scored by each team is independent of the goals scored by the other team. Required: Create your solution on a worksheet named Soccer. • Predict the score of the game. o Use RAND and VLOOKUP functions to predict the goals scored by AUM and TROY. • Do not nest any functions for this part! • Use an IF function to state the winner of the game. o If AUM wins, then say: AUM WINS!!! o If Troy wins, then say: Troy won. o If it is a tie, then say: AUM and Troy Tied! 1. You have an upcoming job interview with ACME Accounting and Finance. ACME makes hiring decisions based on the results of an interview and a skills exam. a. The interview is scored on a scale of 1-7. b. The skills exam is scored on a scale of l1-10. c. The job offer is determined by the sum of the interview and skills exam scores. i. If the combined score is 16 or 17, then the applicant is offered a manager job. 11. If the combined score is 13-15, then the applicant is offered an assistant manager job. iii. If the combined score is 10-12, then the applicant is offered a team member job. iv. If the combines score is 0-9, then the applicant is not offered any job. Required: Create your solution on a worksheet named Interview. • Predict your scores on the interview and skills exam using RANDBETWEEN functions. o Your two scores are independent of each other. • Use an IFS function to determine the job offer that you will receive based on your predicted scores. 2. AUM wants to predict the outcome of the next soccer game. The coach figures that the probabilities for the number of goals scored are as follows: Probability AUM Goals Scored Probability Troy Goals Scored 10% 12% 15% 1 15% 1 20% 22% 2 25% 3 25% 3 30% 4 26% 4 The goals scored by each team is independent of the goals scored by the other team. Required: Create your solution on a worksheet named Soccer. • Predict the score of the game. o Use RAND and VLOOKUP functions to predict the goals scored by AUM and TROY. • Do not nest any functions for this part! • Use an IF function to state the winner of the game. o If AUM wins, then say: AUM WINS!!! o If Troy wins, then say: Troy won. o If it is a tie, then say: AUM and Troy Tied!

Answer rating: 100% (QA)

We can use Excel to resolve this question below The Randbetween function helps ... View the full answer