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 -

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
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.

Ask a Question
ADVERTISEMENT