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 |
Homework Answers
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) |
Add Answer to:
The Assign.xlsx file gives the assignment of workers to four
groups. The suitability of each worker...
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...
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 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...
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
1. Forecast demand for Year 4. a. Explain what technique you utilized to forecast your demand....
1. Forecast demand for Year 4.
a. Explain what technique you utilized to forecast your
demand.
b. Explain why you chose this technique over others.
Year 3 Year 1 Year 2 Actual Actual Actual Forecast Forecast Forecast Demand Demand Demand Week 1 52 57 63 55 66 77 Week 2 49 58 68 69 75 65 Week 3 47 50 58 65 80 74 Week 4 60 53 58 55 78 67 57 Week 5 49 57 64 76 77...
Question 1: Compute the linear regression equation (coefficients) between the “year” variable and the “temperature” variable. In other words, the dependent variable will be the temperature and the ind...
Question 1: Compute the linear regression
equation (coefficients) between the “year” variable and the
“temperature” variable. In other words, the dependent variable will
be the temperature and the independent variable will be “year”
variable. Write down the equation, the correlation coefficient
R and the standard error.
Question 2.
a. Has the annual temperature trend given by
the regression line increased or decreased? Hint: Which of the
regression line coefficients expresses whether the linear
relationship between temperature and time (in years)...
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 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...
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 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
1. Forecast demand for Year 4.
a. Explain what technique you utilized to forecast your
demand.
b. Explain why you chose this technique over others.
Year 3 Year 1 Year 2 Actual Actual Actual Forecast Forecast Forecast Demand Demand Demand Week 1 52 57 63 55 66 77 Week 2 49 58 68 69 75 65 Week 3 47 50 58 65 80 74 Week 4 60 53 58 55 78 67 57 Week 5 49 57 64 76 77...
Question 1: Compute the linear regression
equation (coefficients) between the “year” variable and the
“temperature” variable. In other words, the dependent variable will
be the temperature and the independent variable will be “year”
variable. Write down the equation, the correlation coefficient
R and the standard error.
Question 2.
a. Has the annual temperature trend given by
the regression line increased or decreased? Hint: Which of the
regression line coefficients expresses whether the linear
relationship between temperature and time (in years)...
Most questions answered within 3 hours.
-
Calculate the expected value, the variance, and the standard
deviation of the given random variable X....
asked 55 seconds from now -
Assume that in a hydrogen atom, the electron circles the nucleus
in a circle of radius...
asked 3 minutes ago -
Describe two obstacles that makes fixing atmospheric nitrogen
difficult.
asked 8 minutes ago -
T
F 53) Most differences
between human groups are the result of biology rather than
culture....
asked 12 minutes ago -
A 5.20 mW helium neon laser emits a visible laser beam with a
wavelength of 633...
asked 15 minutes ago -
Assignment:
Your
organization has made a strategic decision
to
outsourcework
currently performed in house. You have...
asked 14 minutes ago -
A hospital performs 100 surgeries per week. The probability that
complications after surgery occur is 10%....
asked 15 minutes ago -
In preparing its cash flow statement for the year ended December
31, 2018, Green Co. gathered...
asked 16 minutes ago -
Donna is 18 years old and full time accounting student.She is
saving for an overseas holiday...
asked 17 minutes ago -
Service-oriented architectures (SOA) provide
object-oriented architectures for web platforms that represent a
collection of services. SOA...
asked 17 minutes ago -
Le Terroir Winery is considering an expansion project to produce
fine wines. The trial expansion will...
asked 26 minutes ago -
The Bahraini public budget experiences deficit in the last
seven years, what are procedures are taken...
asked 33 minutes ago