Question: 3 . Write a formula in cell 'Cumulative Responses'!C 3 , to calculate the number of poor responses for Question 1 based on the responses

3. Write a formula in cell 'Cumulative Responses'!C3, to calculate the number of "poor" responses for Question 1 based on the responses in the 'Individual Responses' worksheet. Copy this formula over and down to calculate the "fair", "good", and "excellent" responses for Question 1-11, respectively. (You only need one formula to accomplish this task.)(Make sure you use $ to anchor the cell references when necessary.) Que 3 Rating Scale: Poor: 4 Fair: 3 Good: 2 Excellent: 12 Emelovest Department Salary Question Que 24251535031+ Soon Service 235500 Human Resources 51402345709 Techno 52.25011746520 Winderwing $75.69914856714 Accounting 56673931533 Accounting 5700211056601 Accounting S1876131541 Rources 53001121618 Account 5713231153170 Information Techno $170331145214 $351001+151125. Comer Service 55458313103012 underwriting $57,0993 IT 45701 Comer Service S6942138163 information Tech $7043 SOLD Underweg 546.44712203545 Maman Bertes 557332132595 Customer Service 57215422254123chste Seni 566713431231421 Questions Question to 7 Os Ques 2 Q10441211124212.1222311131123332323111242.2321121122+11313223111.11342331123221.+22+3+>+1+14213231 Question 1112.2+344111121.*3111111412331412+222152. Category: Orientation and Training Q1. Availability of a clear job description Q2. Feedback about your job performance Q3. Sufficient training opportunities Q4. Availability of follow-up training Category: Supervision Q5. Availability of a supervisor to answer your questions Q6. Feedback and evaluation regarding your performance Q7. Recognition by your supervisor for your accomplishments Q8. Fairness in supervision and employment opportunities Q9. Relationship with your supervisor Category: Compensation and Benefits Q10. Your rate of pay for your work Q11. Paid time off you receive Q12. Benefits you receive 8 P Response D H Cues Ques Ques 4 Ques Availability Feedback Availability Feedback sufficient of a and Availability Recognition by of a clow about job training of follow-up supervisor valuation your servisi description performance opportunities training to niwer regarding your accomplishment performance 4 M N Quest De Questo Oull que 12 Farin supervision to ship Your rate Pald timebant Jand with your otpartor oft you wmployment or your wore receive receive portunities or Poor Fair 5 Good Excellent 21101112114151710192021222324252527 Individual Responses Cumulative Responses Average Fating by Department Salary Averages by

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!