All tasks must be typed in excel. please see the instructions posted in canvas for online task
Fantastic news! We've Found the answer you've been seeking!
Question:
- 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)
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: