09 Jul 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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
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.
Chat with us today! We are always waiting to answer all your questions.