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
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 call time?”
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