Q

hello Please download and complete Excel portion of midterm please and thank you. You can contact me anytime with questions.

 

 

TAKEHOME PORTION of TEST - DUE Feb 28 in Blackboard prior to mid
Instruction
BACKGROUND At MISINC, the Human Recourses department has become enamored with the Decision Style Inventory process. They would like to have the scaling pro
They have asked you to create a spreadsheet that can help the head of the HR department determine the decision styles. 1. The decision style scores for each individual employee (ID 1-10) are presented in the "Employee Data" sheet. Using the MASON/MITROFF
the strength of each style for each employee and place the appropriate strength in the analysis box. Use "least preferred", "backup", "domin
your strengths (like example below) - 20 pts.
Employee ID
Scores
Analysis
Directive
Analytical
Conceptual
Behavioral
Directive
Analytical
1
62
67
113
58 LEAST PREFERRED LEAST PREFERRED
Note: You can use any of excel functions (VLOOKUP, HLOOKUP, LOOKUP, INDEX, IF, Nested IFs, etc.) or any combination thereof. Howev
you must use formulas for the analysis and complete the table (just typing in the results will half the points you get). You will have to set up t
data sheet/table from the guidlines below. 2. Calculate (using formulas in the Excel) following (5 pts each):
a. All employee Averages and Standard Diviations for each score (B15:E16)
b. The average Conceptual Score of those employees with a "dominant" or "very dominant" conceptual style (D17)
c. Number of times Dominant or Very Dominant occurs for each style (F19: I19). What is the most popular decision style? (Highlight the cel
d. How many employees have at least one "very dominant" style (J15) 3. Type in title of the sheet as "MISINC Analysis of Decision Styles by your name" (use your real name for "your name" part). Save the file as "
(again, use your real Last name for yourLastName part). 10 pts. Submit the file in Blackboard.
MASON & MITROFF Guidelines (Note: this is a picture - you have to recreate this in a way you want to use). Employee ID Scores
Analytical
Conceptual Behavioral
69
86
78
48
108
101
74
85
91
65
116
65
69
82
57
63
113
73
55
97
63
95
83
67
69
106
66
68
73
65 Directive
1
2
3
4
5
6
7
8
9
10
Average
Standard Deviation
Average conceptual score for dominant style Directive
67
43
50
54
92
51
85
55
59
94 Number of times Dominant or Very Dominant Analysis
Analytical Conceptual Behavioral

• 1493452341-exceldoc.xlsx

ComputerScienceExpert

(11)

Status NEW Posted 29 Apr 2017 07:04 AM My Price 9.00

-----------

Attachments

file 1493452344-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer