HomeworkLib
Question

The Assign.xlsx file gives the assignment of workers to four groups. The suitability of each worker...

The Assign.xlsx file gives the assignment of workers to four groups. The suitability of each worker for each group (on a scale from 0 to 10) is also given. Write a formula that gives the suitability of each worker for the group to which the worker is assigned.

Suitability rating
Group 1 Group 2 Group 3 Group 4
Assigned to Worker 1 2 3 4
4 1 9 8 6 8
1 2 10 0 5 6
3 3 5 8 10 5
1 4 4 0 5 2
2 5 9 10 4 5
3 6 5 2 7 3
1 7 8 3 1 2
3 8 2 2 9 2
1 9 8 7 6 3
4 10 7 0 1 8
3 11 8 1 6 6
2 12 0 7 1 2
1 13 9 0 5 4
4 14 9 2 2 7
3 15 1 3 8 4
1 16 9 6 4 5
1 17 8 0 5 0
2 18 6 7 6 3
3 19 3 4 5 4
2 20 3 9 4 4
3 21 1 6 9 1
4 22 5 1 3 7
3 23 8 7 10 2
3 24 3 6 4 4
1 25 7 1 1 0
3 26 0 9 8 1
2 27 3 9 1 5
2 28 2 4 0 1
2 29 1 6 7 3
2 30 2 3 3 0
4 31 3 5 4 8
4 32 1 1 3 7
4 33 5 1 2 6
1 34 8 2 3 3
4 68 4 3 1 7
3 69 4 4 7 2
1 70 9 0 3 4
1 71 3 4 2 2
2 72 2 9 9 7
1 73 2 2 1 2
3 74 5 8 10 0
2 75 5 9 1 2
4 76 9 9 2 7
1 77 2 0 0 0
2 78 7 8 6 5
2 79 2 4 2 3
4 80 0 0 2 7
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Here we can use HLOOKUP to do this activity

The formula looks up the group number and returns the suitability rating as below -

Full table as below -

Suitability Rating
Group 1 Group 2 Group 3 Group 4
Assigned to Worker 1 2 3 4 Suitability Formula
1 9 8 6 8 8 =HLOOKUP(A4,$C$3:$F$50,ROW(B4)-2,0)
1 2 10 0 5 6 10 =HLOOKUP(A5,$C$3:$F$50,ROW(B5)-2,0)
3 3 5 8 10 5 10 =HLOOKUP(A6,$C$3:$F$50,ROW(B6)-2,0)
1 4 4 0 5 2 4 =HLOOKUP(A7,$C$3:$F$50,ROW(B7)-2,0)
2 5 9 10 4 5 10 =HLOOKUP(A8,$C$3:$F$50,ROW(B8)-2,0)
3 6 5 2 7 3 7 =HLOOKUP(A9,$C$3:$F$50,ROW(B9)-2,0)
1 7 8 3 1 2 8 =HLOOKUP(A10,$C$3:$F$50,ROW(B10)-2,0)
3 8 2 2 9 2 9 =HLOOKUP(A11,$C$3:$F$50,ROW(B11)-2,0)
1 9 8 7 6 3 8 =HLOOKUP(A12,$C$3:$F$50,ROW(B12)-2,0)
4 10 7 0 1 8 8 =HLOOKUP(A13,$C$3:$F$50,ROW(B13)-2,0)
3 11 8 1 6 6 6 =HLOOKUP(A14,$C$3:$F$50,ROW(B14)-2,0)
2 12 0 7 1 2 7 =HLOOKUP(A15,$C$3:$F$50,ROW(B15)-2,0)
1 13 9 0 5 4 9 =HLOOKUP(A16,$C$3:$F$50,ROW(B16)-2,0)
4 14 9 2 2 7 7 =HLOOKUP(A17,$C$3:$F$50,ROW(B17)-2,0)
3 15 1 3 8 4 8 =HLOOKUP(A18,$C$3:$F$50,ROW(B18)-2,0)
1 16 9 6 4 5 9 =HLOOKUP(A19,$C$3:$F$50,ROW(B19)-2,0)
1 17 8 0 5 0 8 =HLOOKUP(A20,$C$3:$F$50,ROW(B20)-2,0)
2 18 6 7 6 3 7 =HLOOKUP(A21,$C$3:$F$50,ROW(B21)-2,0)
3 19 3 4 5 4 5 =HLOOKUP(A22,$C$3:$F$50,ROW(B22)-2,0)
2 20 3 9 4 4 9 =HLOOKUP(A23,$C$3:$F$50,ROW(B23)-2,0)
3 21 1 6 9 1 9 =HLOOKUP(A24,$C$3:$F$50,ROW(B24)-2,0)
4 22 5 1 3 7 7 =HLOOKUP(A25,$C$3:$F$50,ROW(B25)-2,0)
3 23 8 7 10 2 10 =HLOOKUP(A26,$C$3:$F$50,ROW(B26)-2,0)
3 24 3 6 4 4 4 =HLOOKUP(A27,$C$3:$F$50,ROW(B27)-2,0)
1 25 7 1 1 0 7 =HLOOKUP(A28,$C$3:$F$50,ROW(B28)-2,0)
3 26 0 9 8 1 8 =HLOOKUP(A29,$C$3:$F$50,ROW(B29)-2,0)
2 27 3 9 1 5 9 =HLOOKUP(A30,$C$3:$F$50,ROW(B30)-2,0)
2 28 2 4 0 1 4 =HLOOKUP(A31,$C$3:$F$50,ROW(B31)-2,0)
2 29 1 6 7 3 6 =HLOOKUP(A32,$C$3:$F$50,ROW(B32)-2,0)
2 30 2 3 3 0 3 =HLOOKUP(A33,$C$3:$F$50,ROW(B33)-2,0)
4 31 3 5 4 8 8 =HLOOKUP(A34,$C$3:$F$50,ROW(B34)-2,0)
4 32 1 1 3 7 7 =HLOOKUP(A35,$C$3:$F$50,ROW(B35)-2,0)
4 33 5 1 2 6 6 =HLOOKUP(A36,$C$3:$F$50,ROW(B36)-2,0)
1 34 8 2 3 3 8 =HLOOKUP(A37,$C$3:$F$50,ROW(B37)-2,0)
4 68 4 3 1 7 7 =HLOOKUP(A38,$C$3:$F$50,ROW(B38)-2,0)
3 69 4 4 7 2 7 =HLOOKUP(A39,$C$3:$F$50,ROW(B39)-2,0)
1 70 9 0 3 4 9 =HLOOKUP(A40,$C$3:$F$50,ROW(B40)-2,0)
1 71 3 4 2 2 3 =HLOOKUP(A41,$C$3:$F$50,ROW(B41)-2,0)
2 72 2 9 9 7 9 =HLOOKUP(A42,$C$3:$F$50,ROW(B42)-2,0)
1 73 2 2 1 2 2 =HLOOKUP(A43,$C$3:$F$50,ROW(B43)-2,0)
3 74 5 8 10 0 10 =HLOOKUP(A44,$C$3:$F$50,ROW(B44)-2,0)
2 75 5 9 1 2 9 =HLOOKUP(A45,$C$3:$F$50,ROW(B45)-2,0)
4 76 9 9 2 7 7 =HLOOKUP(A46,$C$3:$F$50,ROW(B46)-2,0)
1 77 2 0 0 0 2 =HLOOKUP(A47,$C$3:$F$50,ROW(B47)-2,0)
2 78 7 8 6 5 8 =HLOOKUP(A48,$C$3:$F$50,ROW(B48)-2,0)
2 79 2 4 2 3 4 =HLOOKUP(A49,$C$3:$F$50,ROW(B49)-2,0)
4 80 0 0 2 7 7 =HLOOKUP(A50,$C$3:$F$50,ROW(B50)-2,0)
0 0
Add a comment
Know the answer?
Add Answer to:
The Assign.xlsx file gives the assignment of workers to four groups. The suitability of each worker...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Loan Processing times are being monitored at a local company. Samples of ten observations each have...

    Loan Processing times are being monitored at a local company. Samples of ten observations each have been taken, and the results are listed. Using Factors from Table 10.2, determine lower and upper control limits for a a Range chart I don't have the Table, please just determine the upper and lower control limits. Sample Number 1         2         3 -------------       79       74       80 -------------       77       76       80 -------------       75       75       79 -------------       65       73       76 -------------       79       79       73 -------------       73      ...

  • Use this set of 40 exam scores as the POPULATION for this activity: (put them into...

    Use this set of 40 exam scores as the POPULATION for this activity: (put them into List 1 in your calculator) 67 90 74 66 76 79 77 53 86 86 68 81 72 57 79 78 50 66 77 66 81 79 80 73 71 56 81 86 62 69 81 78 77 80 88 62 67 62 74 94 Use this set of 40 exam scores as the POPULATION for this activity: (put them into List 1 in...

  • Consider the below matrixA, which you can copy and paste directly into Matlab.

    Problem #1: Consider the below matrix A, which you can copy and paste directly into Matlab. The matrix contains 3 columns. The first column consists of Test #1 marks, the second column is Test # 2 marks, and the third column is final exam marks for a large linear algebra course. Each row represents a particular student.A = [36 45 75 81 59 73 77 73 73 65 72 78 65 55 83 73 57 78 84 31 60 83...

  • Consider the following list of ages 71, 58, 79, 78, 81, 33, 80, 62, 74, 54,...

    Consider the following list of ages 71, 58, 79, 78, 81, 33, 80, 62, 74, 54, 91, 76, 70, 99, 93, 92, 81, 54, 72, 82, 84, 74, 90, 77, 51, 75, 62, 74, 62, 79, 90 (a) Create a stemplot for the ages using each 10s value twice instead of once on the stem. (Enter numbers from smallest to largest separated by spaces. Enter NONE for stems with no values.) stem leaf 3 3 الما none 4 none 4...

  • 7. (a) (15 pts.) With Figure 1 below showing shifts A and B, fill in the blank Table 1 showing the computation of the...

    7. (a) (15 pts.) With Figure 1 below showing shifts A and B, fill in the blank Table 1 showing the computation of the fraction of Bin Hours in each shift for the different time groups. VI V IV Group 1 A 9-12 13-16 17-20 21-24 Sunday Monday Tuesday Wednesday B B Thursday Friday Saturday Figure 1 Table 1 Computation of Fraction of Bin Hours in Each Shift Days Total in Shift A Fraction in Each Shift B Fraction in...

  • Use the Grouped Distribution method for the following exercise (see Self-Test 2-4 for detailed instructions), rounding...

    Use the Grouped Distribution method for the following exercise (see Self-Test 2-4 for detailed instructions), rounding each answer to the nearest whole number. Using the frequency distribution below (scores on a statistics exam taken by 80 students), determine:ion 1 of the preliminary test (scores on a statistics exam taken by 80 students), determine: 68 84 75 82 68 90 62 88 76 93 73 79 88 73 60 93 71 59 85 75 61 65 75 87 74 62 95...

  • Use the Grouped Distribution method for the following exercise (see Self-Test 2-4 for detailed instructions), rounding...

    Use the Grouped Distribution method for the following exercise (see Self-Test 2-4 for detailed instructions), rounding each answer to the nearest whole number. Using the frequency distribution below (scores on a statistics exam taken by 80 students), determine:ion 1 of the preliminary test (scores on a statistics exam taken by 80 students), determine: 68 84 75 82 68 90 62 88 76 93 73 79 88 73 60 93 71 59 85 75 61 65 75 87 74 62 95...

  • Write a C program to assign natural numbers 1 to 100 into a one-dimensional integer array....

    Write a C program to assign natural numbers 1 to 100 into a one-dimensional integer array. Display all the values in the array on the screen. For each number in the array, determine if the number contains digit 7 or is divisible by 7. Display all those numbers on the screen. Original array: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27...

  • questions of a & b 3 4 5 2 Hull Company's record of transactions concerning part...

    questions of a & b 3 4 5 2 Hull Company's record of transactions concerning part X for the month of April was as follows. 3 Purchases Sales 4 Quantity: Unit Cost: Quantity: 5 (Balance on hand) 110 $9.00 Apr 5 290 6 420 9.20 Apr 12 200 7 280 9.30 Apr 27 300 210 9.40 Apr 1 Apr 4 Apr 11 Apr 18 7 8 9 10 Instructions: 11 (a) Compute the inventory at April 30 and the cost...

  • Find the mean of the data summarized in the given frequency distribution: 55) The heights of...

    Find the mean of the data summarized in the given frequency distribution: 55) The heights of a group of professional basketball players are summarized in the frequency distribution below. Find the mean height. Round your answer to one decimal place. Height (in.) Frequency 70 - 71 72-73 74 - 75 76 - 77 78 - 79 80 - 81 82-83 2 5 9 13 8 4 2

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT