Excel Spreadsheet (Accounting)
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →Assignment 6
Parts:
A. You have an upcoming job interview with ACMEAccounting and Finance. ACME makes hiring decisions based on the results of aninterview and a skills exam.
a. The interview is scored on a scale of 1-5.
b. The skills exam is scored on a scale of 1-12.
c. The job offer is determined by the sum of theinterview and skills exam scores.
i. If the combined score is 16 or 17, then theapplicant is offered a manager job.
ii. If the combined score is 14 or 15, then theapplicant is offered an assistant manager job.
iii. If the combined score is 10-13, then theapplicant is offered an entry level job.
iv. If the combined score is 9 or less, then theapplicant is not offered any job.
Required: Create yoursolution on a worksheet named Interview.
Predict your scores on the interview and skillsexam using RANDBETWEEN functions.
o Your two scores are independent of each other.
Use the IFS function to determine the job offerthat you will receive based on your predicted scores.
B. AUM wants to predict the outcome of the nextsoccer game. The coach figures that the probabilities for the number of goalsscored are as follows:
|
Probability |
AUM Goals Scored |
Probability |
Troy Goals Scored |
|
10% |
0 |
30% |
0 |
|
15% |
1 |
25% |
1 |
|
20% |
2 |
20% |
2 |
|
25% |
3 |
15% |
3 |
|
30% |
4 |
10% |
4 |
The goals scored by each team areindependent of the goals scored by the other team.
Required: Create yoursolution on a worksheet named Soccer.
Predict the score of the game.
o Use RAND and VLOOKUP functions to predict thegoals scored by AUM and Troy.
Do notnest the functions, the RAND must be in a different cell than the VLOOKUP.
Use the IF function to state the winner of thegame.
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!
Remember to follow all items in the Excel Requirementsdocument.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds