Question
RATING 5 4 3 2 1 Extremely Meaningful Very Meaningful Moderately Meaningful Slightly Meaningful Not at...
| RATING | |||||||
| 5 | 4 | 3 | 2 | 1 | |||
| Extremely Meaningful | Very Meaningful | Moderately Meaningful | Slightly Meaningful | Not at all meaningful | |||
| Extremely Challenging | Very Challenging | Moderately Challenging | Slightly Challenging | Not at all challening | |||
| Extemely Often | Very Often | Moderately Often | Slightly Often | Not at all stressed | |||
| Extremely Well | Very Well | Moderately Well | Slightly Well | Not at all well | |||
| Extremely Realistic | Very Realistic | Moderately Realistic | Slightly Realistic | Not at all realistic | |||
| Extremely Satisfied | Very Satisfied | Moderately Satisfied | Slightly Dissatisfied | Not at all satisfied | |||
| Extremely Likely | Very Likely | Moderately Likely | Slightly Likely | Not at all likely | |||
| Dept ID | Meaningful Work | Challenging Work | Job Stress | Pay | Realistic Expectation | Job Satisfaction | Look for job |
| HR | 5 | 5 | 4 | 2 | 4 | 3 | 1 |
| OPS | 4 | 2 | 2 | 2 | 3 | 4 | 5 |
| FIN | 4 | 5 | 2 | 4 | 3 | 3 | 4 |
| PAY | 4 | 3 | 5 | 5 | 3 | 3 | 1 |
| OPS | 1 | 3 | 3 | 4 | 4 | 2 | 5 |
| OPS | 2 | 5 | 2 | 3 | 1 | 5 | 1 |
| MKT | 4 | 5 | 5 | 2 | 2 | 2 | 5 |
| OPS | 4 | 2 | 1 | 1 | 5 | 3 | 3 |
| OPS | 2 | 2 | 3 | 1 | 4 | 2 | 4 |
| OPS | 4 | 5 | 2 | 1 | 1 | 4 | 1 |
| OPS | 4 | 5 | 1 | 1 | 1 | 1 | 5 |
| HR | 4 | 4 | 3 | 4 | 3 | 3 | 2 |
| MKT | 4 | 5 | 3 | 2 | 3 | 2 | 5 |
| MKT | 2 | 5 | 5 | 3 | 2 | 3 | 4 |
| OPS | 5 | 1 | 3 | 5 | 4 | 1 | 2 |
| MKT | 4 | 4 | 5 | 3 | 2 | 3 | 4 |
| OPS | 5 | 4 | 1 | 4 | 4 | 4 | 2 |
| PAY | 5 | 4 | 4 | 3 | 3 | 2 | 2 |
| OPS | 1 | 5 | 3 | 5 | 1 | 1 | 4 |
| MKT | 4 | 4 | 5 | 2 | 1 | 3 | 5 |
| OPS | 4 | 5 | 3 | 2 | 1 | 3 | 5 |
| OPS | 3 | 5 | 1 | 3 | 3 | 4 | 3 |
| OPS | 1 | 3 | 2 | 4 | 2 | 2 | 4 |
| OPS | 5 | 2 | 2 | 1 | 4 | 3 | 4 |
| PROC | 1 | 2 | 2 | 5 | 5 | 2 | 5 |
| OPS | 5 | 2 | 2 | 1 | 5 | 4 | 5 |
| MKT | 3 | 4 | 4 | 2 | 3 | 3 | 5 |
| OPS | 2 | 4 | 2 | 4 | 1 | 1 | 1 |
| PAY | 3 | 5 | 5 | 5 | 5 | 4 | 2 |
| OPS | 1 | 4 | 3 | 1 | 3 | 4 | 2 |
| OPS | 3 | 3 | 4 | 2 | 5 | 2 | 5 |
| PROC | 1 | 2 | 2 | 4 | 5 | 2 | 4 |
| FIN | 1 | 3 | 4 | 3 | 3 | 1 | 5 |
| PROC | 3 | 1 | 2 | 5 | 2 | 4 | 5 |
| OPS | 2 | 5 | 3 | 5 | 2 | 5 | 3 |
| OPS | 4 | 4 | 4 | 1 | 2 | 1 | 4 |
| OPS | 3 | 4 | 1 | 1 | 3 | 1 | 1 |
| OPS | 1 | 5 | 3 | 3 | 5 | 5 | 5 |
| MKT | 4 | 4 | 5 | 3 | 2 | 3 | 5 |
| OPS | 2 | 5 | 4 | 1 | 2 | 2 | 3 |
| OPS | 4 | 5 | 5 | 2 | 3 | 1 | 2 |
| OPS | 3 | 3 | 4 | 2 | 1 | 2 | 1 |
| OPS | 3 | 5 | 1 | 2 | 1 | 5 | 1 |
| HR | 4 | 4 | 4 | 4 | 4 | 5 | 1 |
| OPS | 1 | 1 | 2 | 3 | 5 | 1 | 1 |
| OPS | 2 | 2 | 4 | 2 | 4 | 1 | 3 |
| HR | 5 | 5 | 3 | 3 | 3 | 4 | 2 |
| HR | 3 | 4 | 3 | 3 | 5 | 4 | 1 |
| OPS | 1 | 1 | 4 | 3 | 4 | 4 | 1 |
| PAY | 4 | 4 | 4 | 4 | 3 | 3 | 2 |
| PAY | 4 | 4 | 5 | 4 | 5 | 2 | 3 |
| HR | 5 | 4 | 4 | 4 | 5 | 4 | 1 |
| MKT | 3 | 3 | 4 | 3 | 2 | 3 | 4 |
| HR | 4 | 4 | 3 | 3 | 4 | 5 | 2 |
| OPS | 3 | 1 | 2 | 3 | 1 | 5 | 2 |
| MKT | 3 | 5 | 4 | 3 | 3 | 2 | 3 |
| PROC | 1 | 3 | 2 | 2 | 4 | 2 | 5 |
| PROC | 2 | 2 | 1 | 4 | 4 | 5 | 4 |
| OPS | 5 | 5 | 4 | 4 | 2 | 1 | 4 |
| OPS | 5 | 1 | 3 | 4 | 4 | 4 | 3 |
| OPS | 4 | 1 | 1 | 2 | 5 | 2 | 2 |
| OPS | 4 | 5 | 3 | 4 | 1 | 4 | 2 |
| OPS | 3 | 2 | 1 | 2 | 2 | 5 | 4 |
| HR | 3 | 5 | 3 | 3 | 4 | 4 | 3 |
| PROC | 2 | 3 | 1 | 2 | 5 | 4 | 4 |
| FIN | 3 | 4 | 5 | 3 | 5 | 2 | 4 |
| HR | 5 | 4 | 4 | 3 | 3 | 5 | 2 |
| OPS | 5 | 1 | 2 | 1 | 1 | 3 | 3 |
| OPS | 1 | 3 | 3 | 2 | 2 | 5 | 1 |
| MKT | 2 | 4 | 5 | 3 | 1 | 3 | 5 |
| OPS | 3 | 3 | 2 | 2 | 2 | 2 | 1 |
| OPS | 2 | 1 | 3 | 4 | 2 | 2 | 1 |
| FIN | 3 | 5 | 5 | 3 | 2 | 5 | 5 |
| OPS | 5 | 3 | 2 | 5 | 4 | 3 | 5 |
| OPS | 3 | 4 | 1 | 5 | 5 | 4 | 1 |
| PROC | 2 | 1 | 2 | 4 | 3 | 2 | 5 |
| OPS | 4 | 4 | 1 | 4 | 5 | 2 | 2 |
| MKT | 3 | 5 | 4 | 4 | 3 | 2 | 5 |
| OPS | 2 | 1 | 3 | 5 | 4 | 1 | 3 |
| OPS | 3 | 1 | 1 | 2 | 1 | 3 | 4 |
| OPS | 3 | 3 | 1 | 5 | 5 | 4 | 4 |
| OPS | 3 | 3 | 1 | 3 | 2 | 5 | 5 |
| FIN | 2 | 5 | 3 | 2 | 4 | 2 | 5 |
| OPS | 1 | 5 | 1 | 1 | 3 | 4 | 5 |
| OPS | 3 | 5 | 1 | 5 | 2 | 5 | 5 |
| OPS | 1 | 1 | 1 | 2 | 5 | 1 | 5 |
| MKT | 3 | 3 | 5 | 3 | 3 | 2 | 5 |
| OPS | 5 | 3 | 2 | 3 | 5 | 2 | 2 |
| OPS | 4 | 4 | 5 | 2 | 1 | 1 | 4 |
| OPS | 4 | 3 | 5 | 1 | 5 | 3 | 4 |
| OPS | 4 | 2 | 2 | 5 | 3 | 4 | 4 |
| OPS | 5 | 5 | 3 | 3 | 3 | 1 | 4 |
| FIN | 3 | 3 | 4 | 3 | 5 | 1 | 1 |
| OPS | 2 | 1 | 2 | 5 | 4 | 4 | 2 |
| MKT | 3 | 4 | 5 | 4 | 2 | 2 | 4 |
| OPS | 4 | 5 | 1 | 3 | 3 | 5 | 2 |
| HR | 3 | 5 | 3 | 5 | 5 | 3 | 2 |
| FIN | 3 | 2 | 1 | 3 | 1 | 2 | 3 |
| PROC | 1 | 3 | 1 | 5 | 4 | 1 | 4 |
| OPS | 5 | 3 | 1 | 1 | 5 | 5 | 5 |
Use Excel:
1) Using the data range, insert a pivot table to display the average rating by Dept ID for Q7 of the survey. The average ratings must be converted to 2 decimal places. Make sure to rename the column headings appropriately.
2) Based on this pivot table, insert a Pivot Column Chart. On the chart, locate a column (vertical bar of the column chart), that signifies positive response to this question and change the color of that vertical bar to Green shade. On the chart, locate a column (vertical bar of the column chart), that signifies negative response to this question and change the color of that vertical bar to Red shade. All other vertical bars should be in blue color.
* Please provide steps on how I could complete this in Excel also. Thank You.
Homework Answers
Answer #1
Answer:
To insert a pivot table in excel, Click on Insert tab and then Click on PivotTable. Select the location on sheet where you want the pivot table.
1) Put Dept ID in Rows of Pivot Table Builder, "look for job" (Q7) in Values. Change Sum to Average in the Values section of the Pivot Table Builder.
2) Select the pivot table, click on insert and select on Clustered Column chart. You will get the below chart
Now click on the column chart
and click on the column "MKT" which has the highest rating. Click
again so that only MKT is selected and no other column is selected.
Then click on Format tab in the top most ribbon, select shape fill
and select Green color. The chart will look like below -
Now click on HR bar with lowest
rating and do the same again. Your final chart will look as below
-
Not the answer you're looking for?
Similar Questions
Collapse Overall Rating: 1 2 3 4 5 Your Rating: 1 2 3 4 5 Please...
Collapse
Overall Rating:
1
2
3
4
5
Your Rating:
1
2
3
4
5
Please review the
youtube video covering the tax law changes for corporations and
compare these changes with the current tax laws covered this week.
Identify at least one tax law change you think will have
significant impact on current corporate tax compliance and explain
why.
Tax Reform Update -
Changes for Businesses 2018
https://www.youtube.com/watch?time_continue=5&v=80wtgE3JtSg
Let lst1 = '(a b c d e), lst2 = '(1 2 3 4 5). The...
Let lst1 = '(a b c d e),
lst2 = '(1 2 3 4 5). The
proc function takes a list as input and
returns the middle element of the list. What will be the following
expression evaluate to:
(append (cons (first lst1) '())
(cons (cdddr lst1) '())
(cons (proc lst1) '())
(cons (proc lst2) '())
(cons (fifth lst1) '())
)
a.
'(a d e c 3 e)
b.
'(a d e c 3 d)
c.
'(a (d e)...
. Given the matrix A = 1 1 3 -2 2 5 4 3 −1 2...
. Given the matrix A =
1 1 3 -2
2 5 4 3
−1 2 1 3
(a) Find a basis for the row space of A
(b) Find a basis for the column space of A
(c) Find the nullity of A
n/Obs 1 2 3 4 μ Range 1 30.1 29.0 28.1 27.0 28.700 2.0 2 31.4...
n/Obs
1
2
3
4
μ
Range
1
30.1
29.0
28.1
27.0
28.700
2.0
2
31.4
30.7
32.7
29.7
31.020
3.1
3
28.2
29.5
30.6
30.9
29.777
2.5
(a) find ucl for r chart
(b) find lcl for r chart
(c) is it in control?
(d) find ucl for x bar chart
(e) find lcl for x bar chart
(f) is it in control
The following data were used in a regression study. Observation 1 2 3 4 5 6...
The following data were used in a regression study.
Observation
1
2
3
4
5
6
7
8
9
xi
2
3
4
5
7
7
7
8
9
yi
3
5
4
7
4
6
9
4
11
(a)
Develop an estimated regression equation for these data. (Round
your numerical values to two decimal places.)
ŷ =
(b)
Construct a plot of the residuals.
A residual plot has 9 points plotted on it. The horizontal axis
ranges from 0...
The following data were used in a regression study. Observation 1 2 3 4 5 6...
The following data were used in a regression study.
Observation
1
2
3
4
5
6
7
8
9
xi
2
3
4
5
7
7
7
8
9
yi
3
5
4
7
4
6
9
5
11
a) Develop an estimated regression equation for these data.
(Round your numerical values to two decimal places.)
ŷ =
b) Do the assumptions about the error term seem to be
satisfied?
a) The plot suggests a generally horizontal band of residual...
1 | 0,1,5,5,5,7 2|1,5,6,6,7,8 3| 0,0,2,2,3,4,8,8,9 4| 1,2,2,2,3,8 5|2,2,3,8,9 6|1,5,5 what is the mean - 37.42...
1 | 0,1,5,5,5,7
2|1,5,6,6,7,8
3| 0,0,2,2,3,4,8,8,9
4| 1,2,2,2,3,8
5|2,2,3,8,9
6|1,5,5
what is the mean - 37.42 36.61 34 38
what is the median - 37.42 36.61 34 38
what is the IQR - 38 42 35 or 24
is the data left or right skewed or relatively symmetric
what method of presenting data is this
stem leaf plot
inverted histogram
horizontal bar chart
histogram
Given the following initial simplex tableau: x y z u v w P 2 4 3...
Given the following initial simplex tableau:
x y z u v w P
2 4 3 1 0 0 0 4
6 7 1 0 1 0 0 8
6 6 5 0 0 1 0 18
-8 -11 -4 0 0 0 1 0
The pivot element that would be selected if you follow the standard
convention taught in this course is the entry in row ,
column .
Now, use this pivot element and complete ONE STEP
using the simplex...
Let G = 〈(1 2 3 4 5 6), (1 6)(2 5)(3 4)〉. Let H1 :=...
Let G = 〈(1 2 3 4 5 6), (1 6)(2 5)(3 4)〉. Let H1 :=
〈(1 4)(2 5)(3 6)〉 and H2 := 〈(1 6)(2 5)(3 4)〉. Determine
if the subgroups H1 and H2 are normal
subgroups of G.
QUESTION 17 If A = { 1, 2, 3, 4 } B = { 3, 4, 5...
QUESTION 17
If A = { 1, 2, 3, 4 } B = { 3, 4, 5
} C = { 5, 7, 8, 9 }
then A ∩ C U B equals
{ 3, 5 }
{ 3, 4, 5 }
{ 4, 5 }
None of the above
QUESTION 19
What is the Cartesian product A x B given A = {1, 2}
and B = {a, b}?
{ (1, a), (1, b), (2, a), (b, b) (a, a)}
{ (1, 1), (2, 2),...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 1 minute ago
asked 5 minutes ago
asked 10 minutes ago
asked 13 minutes ago
asked 15 minutes ago
asked 16 minutes ago
asked 32 minutes ago
asked 47 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago