All tasks must be typed in excel please see the instructions posted in canvas for online task submission grading scale proper file name 5 points proper submission 5 points questions answer the questions according to the data set given in the table below 122 2 124 2 124 3 125 6 126 3 126 5 126 5 127 2 127 3 127 5 127 9 128 6 128 8 129 0 129 2 129 4 129 6 130 2 130 4 130 8 131 3 131 4 131 4 131 5 131 6 131 6 131 8 131 8 132 3 132 4 132 4 132 5 132 5 132 5 132 5 132 6 132 7 132 9 133 0 133 1 133 1 133 1 133 1 133 2 133 2 133 2 133 3 133 3 133 5 133 5 133 5 133 8 133 9 134 0 134 0 134 0 134 0 134 1 134 2 134 3 134 4 134 4 134 6 134 7 134 7 134 7 134 8 134 8 134 8 134 9 134 9 135 2 135 2 135 2 135 3 135 3 135 4 135 5 135 5 135 6 135 6 135 7 135 8 135 8 135 8 135 8 135 8 135 9 135 9 135 9 135 9 136 0 136 0 136 1 136 2 136 2 136 3 136 4 136 4 136 6 136 8 136 9 136 9 137 0 137 1 137 2 137 6 137 6 137 8 137 8 137 8 137 9 137 9 138 2 138 2 138 3 138 3 138 4 138 4 138 4 138 5 138 5 138 6 138 7 138 7 139 0 139 1 139 5 139 6 139 8 139 8 140 0 140 0 140 7 140 7 140 9 140 9 141 2 141 4 141 5 141 6 142 9 143 4 143 5 143 6 143 8 143 8 143 9 144 1 144 5 144 5 147 7 147 7 1 find the sample average of the data set (5 pts) 2 calculate the sample median, mode, and mean of the data briefly explain how these three measures of location describe different features of the data (15 pts) 3 calculate and interpret the sample variance and sample standard deviation (10 pts) 4 calculate the quartiles of these data (10 pts) 5 find the sample range and interquartile range of data (10 pts) 6 construct a stem and leaf display of the data (10 pts) 7 construct a histogram for these data comment on the shape of the histogram does it convey the same information as the stem and leaf display do the data look normally distributed (20 pts) 8 would you describe any observation as being far from the rest of the data (an outlier) (10 pts) additional notes tips please see the excel analysis tool tutorial file on canvas use excel when creating your charts, because it has built in functions (shown below) that will speed up your calculations sample excel commands that will make your data analyze easier are standard deviation stdev(data points) mean average(data points)

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 28, 2022

All tasks must be typed in excel. please see the instructions posted in canvas for online task submission. grading scale: proper file name: 5 points

All tasks must be typed in excel. please see the instructions posted in canvas for online task submission. grading scale: proper file name: 5 points proper submission: 5 points questions answer the questions according to the data set given in the table below 122.2 124.2 124.3 125.6 126.3 126.5 126.5 127.2 127.3 127.5 127.9 128.6 128.8 129.0 129.2 129.4 129.6 130.2 130.4 130.8 131.3 131.4 131.4 131.5 131.6 131.6 131.8 131.8 132.3 132.4 132.4 132.5 132.5 132.5 132.5 132.6 132.7 132.9 133.0 133.1 133.1 133.1 133.1 133.2 133.2 133.2 133.3 133.3 133.5 133.5 133.5 133.8 133.9 134.0 134.0 134.0 134.0 134.1 134.2 134.3 134.4 134.4 134.6 134.7 134.7 134.7 134.8 134.8 134.8 134.9 134.9 135.2 135.2 135.2 135.3 135.3 135.4 135.5 135.5 135.6 135.6 135.7 135.8 135.8 135.8 135.8 135.8 135.9 135.9 135.9 135.9 136.0 136.0 136.1 136.2 136.2 136.3 136.4 136.4 136.6 136.8 136.9 136.9 137.0 137.1 137.2 137.6 137.6 137.8 137.8 137.8 137.9 137.9 138.2 138.2 138.3 138.3 138.4 138.4 138.4 138.5 138.5 138.6 138.7 138.7 139.0 139.1 139.5 139.6 139.8 139.8 140.0 140.0 140.7 140.7 140.9 140.9 141.2 141.4 141.5 141.6 142.9 143.4 143.5 143.6 143.8 143.8 143.9 144.1 144.5 144.5 147.7 147.7 1. find the sample average of the data set. (5 pts) 2. calculate the sample median, mode, and mean of the data. briefly explain how these three measures of location describe different features of the data. (15 pts) 3. calculate and interpret the sample variance and sample standard deviation. (10 pts) 4. calculate the quartiles of these data. (10 pts) 5. find the sample range and interquartile range of data. (10 pts) 6. construct a stem-and-leaf display of the data. (10 pts) 7. construct a histogram for these data. comment on the shape of the histogram. does it convey the same information as the stem-and-leaf display? do the data look normally distributed? (20 pts) 8. would you describe any observation as being far from the rest of the data (an outlier)? (10 pts) additional notes/tips • please see the excel analysis tool tutorial file on canvas. • use excel when creating your charts, because it has built-in functions (shown below) that will speed up your calculations. • sample excel commands that will make your data analyze easier are: standard deviation: =stdev(data points) mean: =average(data points)