IN EXCEL SPREADSHEET ATTACHED

Cluster the records in the Excel file Ten Year Survey. Create up to five clusters and analyze the results to draw conclusions about the survey.

10.12 Survey Sample 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Customer Employee Job Satisfaction with Training and skill satisfaction satisfaction satisfaction supervisor improvement 2.97 3.51 3.92 3.06 3.48 3.71 3.58 4.13 3.06 2.57 3.29 3.43 3.62 4.42 3.06 2.05 3.81 4.12 4.31 3.17 4.56 4.17 4.25 4.14 4.15 4.28 4.13 4.13 4.57 3.61 2.17 2.42 4.19 2.53 2.72 3.01 2.95 3.95 3.25 2.56 3.61 3.09 3.56 3.91 3.24 1.55 3.01 3.96 3.53 2.04 2.41 1.90 2.66 2.44 2.32 4.33 3.19 3.17 4.44 3.16 4.26 3.48 3.66 4.25 3.73 2.83 3.28 4.21 3.23 3.19 4.09 4.41 4.67 4.50 3.76 4.05 2.53 3.11 3.32 2.91 3.66 2.83 3.10 2.96 1.53 3.27 2.29 2.74 3.34 2.67 3.13 3.30 3.90 3.60 3.14 3.01 4.05 4.32 4.80 3.78 3.16 1.50 2.34 2.21 1.88 3.54 3.24 3.69 3.72 2.93 4.05 3.66 4.08 3.56 3.54 3.19 3.94 4.13 4.42 3.19 3.44 3.33 3.97 3.12 3.27 4.17 3.81 4.20 4.23 3.89 3.41 3.41 4.07 3.84 2.88 4.14 3.57 3.69 4.35 2.86 2.11 3.91 4.39 4.25 3.04 3.75 4.01 4.12 4.12 2.94 1.96 2.52 3.47 2.83 2.00 4.21 4.30 4.49 4.40 4.33 2.80 2.53 3.74 2.70 2.88 3.48 4.26 4.18 4.50 4.06 3.39 4.23 4.26 4.77 3.86 2.89 2.32 2.95 3.01 2.13 2.41 1.32 2.34 1.55 1.27 2.69 3.67 3.83 4.70 3.61 1.37 2.04 3.81 2.07 2.47 3.99 4.41 4.26 4.45 3.88 Ten Year Survey Survey Sample 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Average Customer satisfaction Employee satisfaction Job satisfaction 2.97 3.51 3.92 3.71 3.58 4.13 3.29 3.43 3.62 2.05 3.81 4.12 4.56 4.17 4.25 4.28 4.13 4.13 2.17 2.42 4.19 3.01 2.95 3.95 3.61 3.09 3.56 1.55 3.01 3.96 2.41 1.90 2.66 4.33 3.19 3.17 4.26 3.48 3.66 2.83 3.28 4.21 4.09 4.41 4.67 4.05 2.53 3.11 3.66 2.83 3.10 3.27 2.29 2.74 3.13 3.30 3.90 3.01 4.05 4.32 3.16 1.50 2.34 3.54 3.24 3.69 4.05 3.66 4.08 3.19 3.94 4.13 3.44 3.33 3.97 4.17 3.81 4.20 3.41 3.41 4.07 4.14 3.57 3.69 2.11 3.91 4.39 3.75 4.01 4.12 1.96 2.52 3.47 4.21 4.30 4.49 2.80 2.53 3.74 3.48 4.26 4.18 3.39 4.23 4.26 2.89 2.32 2.95 2.41 1.32 2.34 2.69 3.67 3.83 1.37 2.04 3.81 3.99 4.41 4.26 3.26 3.28 3.78 Satisfaction with supervisor 3.06 3.06 4.42 4.31 4.14 4.57 2.53 3.25 3.91 3.53 2.44 4.44 4.25 3.23 4.50 3.32 2.96 3.34 3.60 4.80 2.21 3.72 3.56 4.42 3.12 4.23 3.84 4.35 4.25 4.12 2.83 4.40 2.70 4.50 4.77 3.01 1.55 4.70 2.07 4.45 3.66 Training and skill improvement 3.48 2.57 3.06 3.17 4.15 3.61 2.72 2.56 3.24 2.04 2.32 3.16 3.73 3.19 3.76 2.91 1.53 2.67 3.14 3.78 1.88 2.93 3.54 3.19 3.27 3.89 2.88 2.86 3.04 2.94 2.00 4.33 2.88 4.06 3.86 2.13 1.27 3.61 2.47 3.88 3.04 Customer satisfaction Customer satisfaction Employee satisfaction Job satisfaction Satisfaction with supervisor Training and skill improvement 1 0.4933453955 0.1516935437 0.495977225 0.5323077559 Employee satisfaction 1 0.8404441481 0.8813245808 0.8286578836 Job satisfaction 1 0.6067961655 0.7106249729 Satisfaction with supervisor 1 0.7697004245 Training and skill improvement 1