Survey Question Number Respon dent 1 2 3 4 5 6 7 8 9 10 10 Number 1 5 1 2 4 2 4 3 1 1 1 2 5 1 1 1 4 3 1 2 2 3 3 4 1 1 1 4 2 5 1 5 1 -55 5 5 1 1 4 2 4 4 4 3 4 5 3 3 3 3 6 2 3 5 1 5 5 1 1 1 7 1 5 1 2 3 3 2 2 3 4 8 1 3 2 2 3 1 2 5 3 9 2 1 4 3 4 4 5 5 2 5 10 2 3 3 1 4 3 1 1 2 1 11 2 1 2 3 2 2 4 1 1 1 12 5 2 5 2 4 4 3 2 5 2 13 1 1 1 1 1 5 1 4 1 3 14 2 15 3 16 5 17 2 18 35352 2 3 4 3 4 4 4 3 3 5 4 3 3 3 5 3 3 1 4 2 1 5 3 1 1 3 1 3 1 2 1 5 3 2 5 5 4 5 19 5 5 4 2 1 1 1 4 5 1 20 2 5 1 3 5 1 2 5 5 5 21 5 3 4 4 5 4 5 1 4 4 22 5 3 1 2 3 1 3 5 1 4 23 5 3 4 3 3 4 5 5 24 5 4 1 4 2 2 3 1 3 1 25 4 4 4 1 5 2 2 4 4 Which question has the highest Mean score? 4 106 The lowest mean score per question is? 1.9 2.65 2.71 1.98 Considering that there are still 25 respondents, what would be the mean score for this data set? 2.92 1.98 4.29 3.85 Considering the remaining 17 valid respondents, what would be the mean score for the data set? 2.65 3.24 2.79 2.53 Survey Question Number Respon dent 1 2 3 4 5 60 7 8 9 10 Number 1 5 1 2 5 1 21 4 1 3 4 1 1 4 2 5 5 1 5 1 5 6 2 3 5 7 1 5 1 2 8 1 9 2 1 10 2 3 11 2 1 12 5 2 13 1 1 14 2 3 15 3 5 16 5 3 17 2 5 18 2 -34325-2353- 2 3 1 3 2 1 3 3 1 5 19 5 5 4 2 20 2 5 1 3 21 5 3 4 4 22 5 3 1 2 23 5 3 4 24 5 4 1 4 25 1 4 4 4 24-25-324424-453-3-55332- 4 3 1 1 1 3 1 2 2 3 5 5 1 1 4 4 4 4 3 4 5 3 3 4 3 2 4 5 3 4 1 3 2 1 1 4 1 3 2 5 352-5-43-434-5-25373N 3 3 3 1 1 1 2 3 4 2 5 3 5 2 5 1 2 1 1 1 1 2 5 4 1 4 4 3 3 2 1 3 1 5 4 4 5 5 5 -233 525-50 1 4 4 5 1 4 5 5 1 3 2 4 1 4 Considering all 25 respondents, create a frequency distribution table using the scoring and scale below: Scale Verbal Interpretation 4.51-5.00 Excellent 3.51-4.50 2.51-3.50 1.51-2.50 1.00 -1.50 Very Satisfactory Satisfactory Dissatisfactory Very Dissatisfactory Which would have the highest frequency? Considering all 25 respondents, prepare a summary of the data set with their Mean Scores and Standard Deviation. Use this format for your answer. (2 decimal places) Question Number 1 Mean Standard Deviation 2 3 4 5 6 7 8 9 10 Survey Question Number Respon dent 1 2 3 4 5 6 7 8 9 10 Number 1 5 1 2 4 2 4 3 1 1 1 2 5 1 1 1 4 3 1 2 2 3 3 4 1 1 1 5 5 1 1 4 4 2 5 2 4 4 4 3 4 5 1 5 1 5 5 3 3 3 3 6 2 3 5 1 5 5 1 1 1 7 1 5 1 2 3 3 2 2 3 4 8 1 3 2 2 3 1 2 5 3 9 2 1 4 3 4 4 5 5 2 5 10 2 3 3 1 4 3 1 1 2 1 11 2 1 2 3 2 2 4 1 1 12 5 2 5 2 4 4 3 2 5 13 1 1 1 1 1 5 1 4 1 14 2 3 2 3 4 3 4 4 4 15 3 5 3 5 4 3 3 3 16 5 3 5 3 3 1 4 2 1 17 2 5 3 1 1 3 1 3 1 22222222 18 2 1 5 3 2 5 5 4 19 5 5 4 2 1 1 1 4 5 -233 525- 1 1 20 2 5 1 3 21 5 3 4 4 55 1 2 5 5 5 4 5 1 4 4 5 3 1 2 3 1 3 5 1 4 5 3 4 3 3 4 5 5 24 5 4 1 4 2 2 3 1 3 1 25 1 4 4 4 1 5 2 2 4 4 Considering all of the 25 respondents, prepare a histogram of the mean scores with them having .5 intervals for the bins. Identify the skewness of the data. Here is another data, consider this as set B. Prepare a scatter graph to test whether the data sets have a linear relationship or not. If they do, identify what type of linear relationship they have. Survey Questions Respondents 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 1 2 3 4 4 4 2 3 4 3 4 5 4 3 4 4 5 3 3 2 3 2 4 4 4 4 4 5 4 3 4 1 4 5 5 5 5 5 5 5 1 2 3 4 4 4 4 4 3 4 6 3 3 3 4 4 4 4 4 4 4 7 5 4 5 3 4 5 4 3 4 5 8 2 3 4 3 4 4 4 4 5 4 9 3 4 5 10 3 2 4 13 ENETELE22222222 11 3 4 5 12 1 2 4 3 3 5 14 5 4 5 15 2 3 3 1 17 3 3 18 3 5 1 1 3 4 21 5 3 1 3 3 1 24 5 3 25 2 3 3 042423434324233254 553424 23453M 4 4 2 4 5 2 4 4 4 4 5 3 4 4 4 5 5 4 3 4 4 5 5 3 4 2 2 4 4 4 2 4 3 3 +33 4 3 4 2 3 4 3 3 4 3 4 4 4 5 4545454545 3342423434554 5 1 5 3 5 5 4 1 5 4 5 3 5 3 5 1 4 3 3 3 4 4 3 5 4 3 4 4 5