Finding Z-score, Test stat, Standard Deviation, Scatterplot and pivot table
Instructions for assignment file 3
You need to open file 1 and follow the 4 instructions below
A) For call centre 1
B) For call centre 1 Use excel PivotTable commands to find appropriate sample statistics that let you investigate the relationship between the fields (variables) “Original staff or Replacement staff?” and “Median above 3 minutes?”
C) For call centre 1 Use excel commands to make a graph that lets you investigate the relationship between the fields (variables) “median call time?” and “number of complaints?”
D) Upload the file 1 with the pivot tables and scatterplot to moodle