Finding Z-score, Test stat, Standard Deviation, Scatterplot and pivot table

profileart08
datasets.xlsx
Home>Mathematics homework help>Statistics homework help>Finding Z-score, Test stat, Standard Deviation, Scatterplot and pivot table

Sheet1

student number which sample Median call time? number of complaints? Original staff or replacement staff? median above 3 minutes? _ Median call time? number of complaints? Original staff or replacement staff? median above 3 minutes?
11801587 373 2.71 25 original no 3.35 35 replacement yes
11801587 373 3.64 34 original yes 3.2 30 original yes
11801587 373 3.34 32 original yes 2.42 24 replacement no
11801587 373 3.25 34 original yes 3.11 31 replacement yes
11801587 373 3.14 33 replacement yes 2.84 26 replacement no
11801587 373 2.75 31 original no 3.59 32 original yes
11801587 373 3.08 29 original yes 3.58 36 original yes
11801587 373 2.68 28 replacement no 3.23 28 replacement yes
11801587 373 2.79 31 original no 2.79 30 original no
11801587 373 3 31 original no 3.43 30 original yes
11801587 373 2.69 30 replacement no 3.33 34 original yes
11801587 373 2.84 27 replacement no 2.78 31 original no
11801587 373 2.75 31 original no 3.22 28 replacement yes
11801587 373 2.7 25 replacement no 3.49 37 original yes
11801587 373 2.88 27 original no 2.78 26 replacement no
11801587 373 3.51 35 original yes 2.54 25 replacement no
11801587 373 2.55 24 replacement no 3.22 35 original yes
11801587 373 3.51 37 original yes 3.16 35 original yes
11801587 373 3.33 34 replacement yes 2.76 32 replacement no
11801587 373 3.2 33 replacement yes 3.9 42 original yes
11801587 373 3.46 38 original yes 3.13 34 original yes
11801587 373 2.4 21 replacement no 3.15 29 original yes
11801587 373 3.5 33 original yes 2.77 31 original no
11801587 373 2.95 29 replacement no 3.12 27 original yes
11801587 373 3.47 35 original yes 3.17 36 original yes
11801587 373 3.44 33 original yes 2.64 27 replacement no
11801587 373 3.43 34 replacement yes 3.32 32 replacement yes
11801587 373 3.24 31 original yes 3.87 38 original yes
11801587 373 2.72 30 replacement no 3.62 33 original yes
11801587 373 2.98 31 replacement no 2.43 28 replacement no
11801587 373 3.22 33 original yes 3.78 38 original yes
11801587 373 3.22 29 replacement yes 3.63 35 original yes
11801587 373 3.85 39 original yes 3.91 41 original yes
11801587 373 3.17 29 replacement yes 3.01 29 original yes
11801587 373 3.49 36 replacement yes 2.66 25 replacement no
11801587 373 3.47 37 original yes 2.99 32 original no
11801587 373 2.93 27 replacement no 3.04 28 original yes
11801587 373 3.28 30 original yes 3.32 32 replacement yes
11801587 373 2.99 33 original no 2.82 26 replacement no
11801587 373 2.78 26 original no 3.24 36 original yes
11801587 373 3.77 35 original yes 2.84 25 replacement no
11801587 373 3.45 33 original yes 3.42 33 original yes
11801587 373 3.07 33 original yes 2.34 24 replacement no
11801587 373 2.76 29 original no 3.27 32 original yes
11801587 373 2.83 30 original no 2.88 32 original no
11801587 373 3.45 33 replacement yes 2.54 21 replacement no
11801587 373 2.98 31 replacement no 3.14 31 original yes
11801587 373 2.95 33 original no 3.33 34 replacement yes
11801587 373 2.95 33 replacement no 3.04 33 replacement yes
11801587 373 3.74 39 original yes 2.55 23 replacement no
11801587 373 3.19 33 replacement yes 2.89 31 replacement no
11801587 373 2.52 25 replacement no 3.33 31 replacement yes
11801587 373 2.73 29 replacement no 3.39 35 replacement yes
11801587 373 3.3 31 replacement yes 3.01 28 original yes
11801587 373 2.85 28 replacement no 3.37 38 replacement yes
11801587 373 2.49 28 replacement no 2.89 32 original no
11801587 373 2.4 22 replacement no 3.27 32 replacement yes
11801587 373 3.06 34 replacement yes 3.4 35 original yes
11801587 373 2.71 26 original no 3.24 32 original yes
11801587 373 3.86 41 original yes 3.41 38 original yes
11801587 373 3.12 29 replacement yes 2.78 30 original no
11801587 373 3.31 36 replacement yes 3.16 34 original yes
11801587 373 3.42 31 replacement yes 2.45 28 replacement no
11801587 373 3.47 34 original yes 3.04 32 original yes
11801587 373 3.42 34 replacement yes 3.38 37 replacement yes
11801587 373 3.44 35 replacement yes 3.53 34 original yes
11801587 373 3.1 31 original yes 3.85 41 original yes
11801587 373 2.84 30 replacement no 3.18 35 original yes
11801587 373 3.07 34 replacement yes 2.52 29 replacement no
11801587 373 3.67 34 original yes 3.17 35 original yes
11801587 373 2.92 26 replacement no 3.63 32 original yes
11801587 373 2.96 30 original no 2.95 26 replacement no
11801587 373 3.31 34 original yes 2.54 28 replacement no
11801587 373 2.77 29 original no 3.34 36 original yes
11801587 373 2.49 23 replacement no 3.08 29 replacement yes
11801587 373 2.73 30 original no 3.3 35 replacement yes
11801587 373 2.81 31 replacement no 2.87 26 replacement no
11801587 373 3.11 29 replacement yes 2.34 26 replacement no
11801587 373 3.36 31 original yes 3.21 34 replacement yes
11801587 373 3.45 36 original yes 3.23 32 replacement yes
11801587 373 2.63 23 replacement no 2.88 29 original no
11801587 373 2.49 24 replacement no 3.19 35 original yes
11801587 373 3.84 40 original yes 3.09 27 replacement yes
11801587 373 2.83 30 replacement no 2.71 27 original no
11801587 373 2.84 26 replacement no 2.76 25 original no
11801587 373 3.27 31 replacement yes 3.03 26 original yes
11801587 373 3.78 35 original yes 2.58 25 replacement no
11801587 373 2.87 28 replacement no 2.58 26 replacement no
11801587 373 3.55 33 original yes 3.56 35 original yes
11801587 373 3.83 40 original yes 3.05 30 original yes
11801587 373 2.45 26 replacement no 3.33 32 replacement yes
11801587 373 2.94 27 replacement no 2.53 21 replacement no
11801587 373 2.77 26 replacement no 3.63 38 original yes
11801587 373 3.7 38 original yes 3.24 30 original yes
11801587 373 3.4 31 original yes 2.76 32 replacement no
11801587 373 2.82 26 original no 2.5 24 replacement no
11801587 373 3.31 31 original yes 3.55 37 original yes
11801587 373 2.97 27 replacement no 3.36 37 replacement yes
11801587 373 2.57 29 replacement no 3.39 37 original yes
11801587 373 3.37 34 replacement yes 2.87 33 replacement no
11801587 373 2.56 28 replacement no 3.71 38 original yes
11801587 373 3.05 29 replacement yes 2.31 24 replacement no
11801587 373 2.72 24 replacement no 3.52 36 original yes
11801587 373 2.35 26 replacement no 2.96 32 replacement no
11801587 373 3.78 39 original yes 2.59 23 replacement no
11801587 373 3.58 33 original yes 3.24 35 replacement yes
11801587 373 3.39 32 original yes 2.65 26 replacement no
11801587 373 3.7 36 original yes 2.58 27 replacement no
11801587 373 3.39 35 original yes 3.25 36 replacement yes
11801587 373 3.79 37 original yes 3.13 30 original yes
11801587 373 3.69 39 original yes 2.46 25 replacement no
11801587 373 2.81 31 replacement no 3.92 40 original yes
11801587 373 2.55 29 replacement no 3.95 40 original yes
11801587 373 3.56 38 original yes 2.53 21 replacement no
11801587 373 3.34 32 replacement yes 2.9 30 replacement no
11801587 373 3.46 37 replacement yes 3.83 36 original yes
11801587 373 3.23 35 original yes 3.18 32 original yes
11801587 373 3.67 38 original yes 3.01 30 replacement yes
11801587 373 3.02 27 replacement yes 2.7 31 original no
11801587 373 2.38 22 replacement no 2.91 30 replacement no
11801587 373 2.32 21 replacement no 3.48 33 original yes
11801587 373 3.62 36 original yes 3.42 38 original yes
11801587 373 2.42 26 replacement no 3 31 replacement no
11801587 373 2.76 26 replacement no 2.88 32 original no
11801587 373 3.46 34 original yes 3.33 29 original yes
11801587 373 3.35 35 replacement yes 2.71 29 original no
11801587 373 2.96 32 replacement no 3.05 31 replacement yes
11801587 373 3.36 33 replacement yes 3.2 32 replacement yes
11801587 373 3.23 31 replacement yes 2.97 26 original no
11801587 373 3.31 30 original yes 2.47 26 replacement no
11801587 373 3.91 37 original yes 3.12 31 replacement yes
11801587 373 2.94 26 original no 3.11 31 original yes
11801587 373 3.25 35 original yes 3.15 33 original yes
11801587 373 2.53 23 replacement no 3.51 37 original yes
11801587 373 3.11 34 replacement yes 2.89 33 original no
11801587 373 3.15 29 replacement yes 2.76 29 replacement no
11801587 373 3.35 35 replacement yes 2.96 29 original no
11801587 373 3.51 38 original yes 3.07 35 replacement yes
11801587 373 2.69 30 replacement no 3.26 31 original yes
11801587 373 2.8 31 original no 3.37 36 replacement yes
11801587 373 3.52 37 original yes 3.12 30 original yes
11801587 373 3.64 39 original yes 2.96 32 original no
11801587 373 2.86 31 replacement no 3.16 34 original yes
11801587 373 3.43 33 replacement yes 3.2 32 original yes
11801587 373 2.77 29 replacement no 3.08 27 replacement yes
11801587 373 3.58 36 original yes 3.03 31 original yes
11801587 373 3.24 34 original yes 3.26 31 replacement yes
11801587 373 3.23 34 original yes 2.92 27 replacement no
11801587 373 3.27 30 original yes 3.38 34 replacement yes
11801587 373 3.99 41 original yes 3.28 33 original yes
11801587 373 3.88 40 original yes 3.34 35 replacement yes
11801587 373 3.96 43 original yes 3.61 37 original yes
11801587 373 2.98 30 replacement no 2.51 21 replacement no
11801587 373 3 28 original no 2.82 26 original no
11801587 373 3.42 31 replacement yes 3.64 33 original yes
11801587 373 3.19 35 original yes 2.53 23 replacement no
11801587 373 3.44 37 original yes 3.79 36 original yes
11801587 373 2.56 29 replacement no 3.23 31 original yes
11801587 373 3.48 38 original yes 3.14 27 replacement yes
11801587 373 3.47 36 replacement yes 3.12 28 replacement yes
11801587 373 2.81 28 original no 3.39 30 replacement yes
11801587 373 2.98 33 replacement no 2.41 21 replacement no
11801587 373 3.01 33 replacement yes 3.28 30 original yes
11801587 373 3.71 38 original yes 2.78 27 original no
11801587 373 3.23 30 original yes 3.89 40 original yes
11801587 373 3.4 31 replacement yes 2.76 24 original no
11801587 373 3.22 35 replacement yes 3.19 30 replacement yes
11801587 373 2.79 31 replacement no 3.09 27 replacement yes
11801587 373 2.52 26 replacement no 2.98 34 original no
11801587 373 2.63 29 replacement no 3.11 27 original yes
11801587 373 3.39 37 original yes 2.87 29 replacement no
11801587 373 3.15 34 original yes 3.39 36 original yes
11801587 373 2.9 31 replacement no 3.95 43 original yes
11801587 373 2.96 31 replacement no 3.31 34 replacement yes
11801587 373 2.66 25 replacement no 2.75 29 replacement no
11801587 373 3.35 34 original yes 2.62 26 replacement no
11801587 373 3.16 31 replacement yes 2.98 32 replacement no
11801587 373 3.66 34 original yes 2.85 30 replacement no
11801587 373 2.39 25 replacement no 3.29 33 original yes
11801587 373 3.21 30 original yes 3.94 37 original yes
11801587 373 2.71 30 original no 2.91 31 replacement no
11801587 373 2.95 33 original no 3.36 33 replacement yes
11801587 373 3.49 38 replacement yes 2.72 27 replacement no
11801587 373 2.59 25 replacement no 3.66 38 original yes
11801587 373 2.73 30 replacement no 2.5 22 replacement no
11801587 373 2.72 30 original no 3.42 35 original yes
11801587 373 3.72 40 original yes 3.72 36 original yes
11801587 373 2.67 26 replacement no 2.72 26 original no
11801587 373 3.93 41 original yes 3.66 39 original yes
11801587 373 2.36 22 replacement no 3.49 37 original yes
11801587 373 3.75 35 original yes 3.19 33 replacement yes
11801587 373 3.1 33 replacement yes 3.38 36 replacement yes
11801587 373 2.91 26 original no 3.87 43 original yes
11801587 373 3.72 35 original yes 2.71 30 replacement no
11801587 373 3.53 35 original yes 3.54 38 original yes
11801587 373 2.48 23 replacement no 2.44 20 replacement no

Sheet2

Sheet3