Excel Spreadsheet (Accounting)
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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
