I am confused as to which formula I have to use to fill out the chart and how to

Question

I am confused as to which formula I have to use to fill out the chart and how to answer 4 question at bottom

Scores Analysis Directive Analytica 86 108 85 116 82 113 97 83 106 73 113 78 101 91 65 57 58 LEAST PREFERRED LEAST PREFERRED VERY DOMINANT BACKUP 67 43 50 54 92 51 85 69 #N/A 74 65 69 63 10 13 14 15 16 17 18 1. The strensth of each style for each employee and place the appropriate strength in the analysis box 19Use "least prefer 20 2 How many emplovees have at least one "very dominant' style 21 3. The average Conceptual Score of those employees with a "dominant" or "very dominant" conceptual style 22 4. What is the most popular decision style: the style with the most number of times Dominant or Very Dominant occurs. 95 69 67 59 94 65 Using the MASON/MITROFF guidelines below, determine the answers to the following 4 Questions red", "backup, "dominant", and "very dominant" as your strengths 24 | You can use any combination of Excel functions (MATCH, VLOOKUP, H LOOKUP ? NESTE DIF) that you wish. However, you must use formulas for the 25analvsis and to answer questions 1-4 above. You will have to set up the data from the guidlines how you want MASON & MITROFF Guidelines Style et Eadap Domnart Vey Directive 20-6768-81 82-89 ”-160 Analytal 20-82 8395 97-104 105-160 Conoeptual 20-72 73-86 87-94 95-160 Behavical 20-47 48-61 62-69 70-160 28 Answer #2 29 Dominant 31 Answer #3 32 34 Answer#4 35 36 37 38 39 40

Explanation / Answer

I am assuming that the "Employee ID" column is labeled 'A' in excel sheet.

Answer 1 :

    Put the following formulas in indicated cells

    F5 : =IF(B5<68,"least preferred",IF(B5<82,"backup",IF(B5<90,"dominant","very dominant")))
    G5 : =IF(C5<83,"least preferred",IF(C5<97,"backup",IF(C5<105,"dominant","very dominant")))
    H5 : =IF(D5<73,"least preferred",IF(D5<87,"backup",IF(D5<95,"dominant","very dominant")))
    I5 : =IF(E5<48,"least preferred",IF(E5<62,"backup",IF(E5<70,"dominant","very dominant")))

    Now select all four cells mentioned above and drag down the right lower corner(where pointer turns to '+' to span a total of 10 rows, ie. a 10X4 table.

Answer 2 :
On cell J5, put this formula :
    =COUNTIF(F5:I5,"very dominant")

Now, drag the cell down to span all rows as done before. This gives the count of string "very dominant" in each line. Now in cell where Answer2 has to be presented, write :
    =COUNTIF(J5:J15,">0")

Answer 3:

In cell where Answer 3 has to be presented, write :
    =AVERAGEIF(D5:D15,">87")

Answer 4 :

Put the following formulas in 4 horizontly consecutive cells

    =COUNTIF(B5:B15,">81")

    =COUNTIF(C5:C15,">96")

    =COUNTIF(D5:D15,">86")

    =COUNTIF(E5:E15,">61")

    Assuming you have chosen J28:M28 as the consecutive cells,

In cell where Answer 4 has to be presented, write :
    =INDIRECT(ADDRESS(4,MATCH(MAX(J28:M28),J28:M28)))

NOTE: I have assumed that the column name starts from A (because they are not visible in the picture)
             Please change code accordingly if the assumption is wrong.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.