Fluent Essays

Descriptive Statistics Analysis Describe the Sun Coast data using the descriptive statistics tools discussed in the unit lesson. Establish whether assumptions are met to use parametric statistical procedures. Repeat the tasks below for each tab in the Sun Coast research study data set. Utilize the  Unit IV Scholarly Activity template . You will utilize the Microsoft Excel ToolPak. The links to the ToolPak are in the  Excel ToolPak Links document . Here are some of the items you will cover. Produce a frequency distribution table and histogram. Generate descriptive statistics table, including measures of central tendency (mean, median, and mode), kurtosis, and skewness. Describe the dependent variable measurement scale as nominal, ordinal, interval, or ratio. Analyze, evaluate, and discuss the above descriptive statistics in relation to assumptions required for parametric testing. Confirm whether the assumptions are met or are not met. The title and reference pages do not count toward the page requirement for this assignment. This assignment should be no less than five pages in length, follow APA-style formatting and guidelines, and use references and citations as necessary. 1 9 Insert Title Here Insert Your Name Here Insert University Here Course Name Here Instructor Name Date Data Analysis: Descriptive Statistics and Assumption Testing Describe the Sun Coast Remediation data using the descriptive statistics tools discussed in the lecture. Establish whether assumptions are met to use parametric statistical procedures. Repeat this for each tab in the Sun Coast Remediation Research Study data set. Delete instructions and examples highlighted in yellow before submitting this assignment. Correlation: Descriptive Statistics and Assumption Testing Frequency Distribution Table Insert frequency distribution table here. Cut and paste from Excel. Histogram Insert histogram here. Cut and paste from Excel. Descriptive Statistics Table Insert table here. Cut and paste from Excel. Measurement Scale Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio). Measure of Central Tendency Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode). Skewness and Kurtosis Discuss skewness and kurtosis and whether they are within acceptable ranges. Evaluation In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met. Simple Regression: Descriptive Statistics and Assumption Testing Frequency Distribution Table Insert frequency distribution table here. Cut and paste from Excel. Histogram Insert histogram here. Cut and paste from Excel. Descriptive Statistics Table Insert table here. Cut and paste from Excel. Measurement Scale Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio). Measure of Central Tendency Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode). Skewness and Kurtosis Discuss skewness and kurtosis and whether they are within acceptable ranges. Evaluation In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met. Multiple Regression: Descriptive Statistics and Assumption Testing Frequency Distribution Table Insert frequency distribution table here. Cut and paste from Excel. Histogram Insert histogram here. Cut and paste from Excel. Descriptive Statistics Table Insert table here. Cut and paste from Excel. Measurement Scale Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio). Measure of Central Tendency Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode). Skewness and Kurtosis Discuss skewness and kurtosis and whether they are within acceptable ranges. Evaluation In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met. Independent Samples t Test: Descriptive Statistics and Assumption Testing Frequency Distribution Table Insert frequency distribution table here. Cut and paste from Excel. Histogram Insert histogram here. Cut and paste from Excel. Descriptive Statistics Table Insert table here. Cut and paste from Excel. Measurement Scale Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio). Measure of Central Tendency Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode). Skewness and Kurtosis Discuss skewness and kurtosis and whether they are within acceptable ranges. Evaluation In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met. Dependent Samples (Paired-Samples) t Test: Descriptive Statistics and Assumption Testing Frequency Distribution Table Insert frequency distribution table here. Cut and paste from Excel. Histogram Insert histogram here. Cut and paste from Excel. Descriptive Statistics Table Insert table here. Cut and paste from Excel. Measurement Scale Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio). Measure of Central Tendency Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode). Skewness and Kurtosis Discuss skewness and kurtosis and whether they are within acceptable ranges. Evaluation In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met. ANOVA: Descriptive Statistics and Assumption Testing Frequency Distribution Table Insert frequency distribution table here. Cut and paste from Excel. Histogram Insert histogram here. Cut and paste from Excel. Descriptive Statistics Table Insert table here. Cut and paste from Excel. Measurement Scale Discuss measurement scale used here (e.g., nominal, ordinal, interval, or ratio). Measure of Central Tendency Discuss measures of central tendency here and the relevance to normality of data (e.g., mean, median, and mode). Skewness and Kurtosis Discuss skewness and kurtosis and whether they are within acceptable ranges. Evaluation In this section, evaluate and discuss the descriptive statistics above. Conclude with an explicit statement about whether the assumptions for parametric statistical testing were met or not met. References Include references here using hanging indentations. Creswell, J. W., & Creswell, J. D. (2018). Research design: Qualitative, quantitative, and mixed methods approaches (5th ed.). SAGE. Correlation Data job site microns mean annual sick days per employee 1 4 11 2 6.5 7 3 8 5 4 8 5 5 4 10 6 7 7 7 2 11 8 5.5 9 9 5 7 10 4 10 11 4.5 8 12 8.5 4 13 7 7 14 5 8 15 9.5 3 16 7 7 17 9.5 5 18 9.5 7 19 5 10 20 6 6 21 8 5 22 7.5 6 23 8.5 5 24 9 4 25 3 7 26 6 7 27 7.5 7 28 7.5 5 29 2.7 7 30 2 9 31 7.5 6 32 9 4 33 6 6 34 3 8 35 8 5 36 1 8 37 8.5 5 38 0.7 8 39 0.5 8 40 8.5 4 41 2 8 42 4.5 9 43 6 7 44 7 7 45 5 10 46 2.5 12 47 5 9 48 4 7 49 8 5 50 5 7 51 3.5 9 52 8 6 53 5 5 54 4.9 10 55 7.5 9 56 2.5 7 57 6.5 7 58 8 6 59 5 6 60 7 6 61 4 9 62 8 5 63 1 8 64 2 8 65 4 10 66 4 9 67 7 7 68 5.2 10 69 5 7 70 6 6 71 8 6 72 6 7 73 6.5 6 74 1.5 8 75 8.5 6 76 2 8 77 8 5 78 10 4 79 10 5 80 8 8 81 1 8 82 7 6 83 10 2 84 7 8 85 7 6 86 6.5 7 87 7.5 6 88 8.5 6 89 3 8 90 0.5 9 91 1 8 92 9 6 93 7 7 94 2 9 95 8.5 7 96 3.5 9 97 3 8 98 7 6 99 5.5 7 100 7.5 7 101 0.2 12 102 4 8 103 5 9 Simple Regression Data contract # safety training expenditure lost time hours 1116 1985.12 10 205 1500.00 30 2146 1126.46 40 1603 1294.10 40 914 1445.56 40 437 1112.47 50 598 1720.81 60 2801 1789.66 60 1420 1837.52 60 682 2000.00 60 714 2271.86 60 2336 1507.97 70 2216 1542.33 70 1327 1544.90 70 1025 1547.16 70 920 1567.55 70 465 1600.00 70 138 1452.69 80 1411 1500.00 80 1439 1500.00 80 2388 1326.60 90 1849 1351.25 90 1740 1380.69 90 1666 1423.57 90 1672 1095.58 100 2455 1132.88 100 403 1134.58 100 856 1163.44 100 2050 1170.92 100 1271 1177.05 100 2429 1188.19 100 812 1323.29 100 405 1051.17 110 1630 1054.03 110 2376 1071.75 110 861 1077.86 110 2436 1080.34 110 36 923.37 120 30 957.17 120 76 964.11 120 1155 976.64 120 1273 982.06 120 1886 985.69 120 630 985.97 120 407 1000.00 120 488 1002.27 120 1971 1035.43 120 62 910.85 130 118 912.35 130 2 912.35 130 42 917.02 130 92 917.02 130 160 922.02 130 149 922.02 130 178 950.00 130 160 804.28 140 56 826.86 140 152 832.87 140 3 836.33 140 196 842.96 140 157 856.99 140 221 883.88 140 62 888.57 140 64 893.36 140 143 900.89 140 139 910.85 140 217 759.86 150 182 767.13 150 162 777.24 150 159 784.22 150 162 785.69 150 145 785.69 150 203 792.35 150 135 799.90 150 158 800.62 150 182 801.58 150 35 746.02 160 163 756.98 160 105 759.52 160 163 700.93 170 131 709.40 170 73 715.68 170 55 724.94 170 181 612.23 180 124 613.70 180 55 624.54 180 136 635.19 180 5 642.79 180 179 644.15 180 150 656.14 180 140 669.81 180 96 669.81 180 157 678.60 180 51 689.55 180 153 526.48 185 137 537.35 185 195 561.96 185 116 564.16 185 196 566.50 185 65 568.95 185 194 574.51 185 113 579.32 185 85 583.63 185 190 601.43 185 148 607.26 185 54 611.48 185 183 393.77 190 100 405.91 190 92 406.81 190 157 426.78 190 40 429.50 190 217 450.56 190 137 456.90 190 91 471.81 190 96 474.76 190 203 500.92 190 205 503.17 190 188 507.64 190 29 507.77 190 189 509.43 190 34 513.69 190 56 514.07 190 49 526.14 190 145 336.51 200 11 344.39 200 75 345.69 200 155 365.99 200 132 377.93 200 168 385.05 200 65 391.75 200 38 264.00 210 186 264.00 210 9 264.00 210 146 265.40 210 123 268.60 210 108 275.70 210 221 283.16 210 201 288.00 210 25 288.00 210 72 295.84 210 213 300.00 210 129 305.27 210 195 313.36 210 141 244.00 220 75 250.57 220 33 255.12 220 119 256.89 220 205 263.27 220 120 263.60 220 110 223.64 230 208 226.65 230 19 230.00 230 211 230.00 230 221 231.52 230 23 233.29 230 133 234.00 230 19 234.00 230 84 234.00 230 167 234.00 230 96 234.00 230 200 234.57 230 171 236.60 230 18 236.91 230 107 237.70 230 152 243.24 230 120 244.00 230 143 218.00 235 24 205.00 240 104 206.97 240 170 215.37 240 115 215.69 240 159 215.99 240 125 217.99 240 128 218.00 240 105 205.00 245 209 169.58 250 190 174.09 250 199 179.06 250 110 179.78 250 151 192.61 250 219 196.65 250 33 201.36 250 156 202.71 250 161 204.57 250 133 205.00 250 131 135.99 260 54 145.59 260 24 152.61 260 48 125.63 270 212 128.00 270 91 128.00 270 4 45.30 280 187 45.69 280 134 50.00 280 24 51.23 280 6 56.89 280 135 68.95 280 132 102.57 280 101 102.57 280 34 102.64 280 27 103.57 280 86 125.18 280 184 731.36 285 35 70.92 290 140 75.90 290 173 97.97 290 131 100.00 290 42 100.00 290 95 100.03 290 17 102.56 290 68 102.57 290 197 56.90 300 59 56.90 300 2 68.09 300 119 68.59 300 19 42.57 320 28 45.69 320 65 30.43 330 18 35.99 330 95 25.69 340 201 26.60 340 40 26.90 340 199 20.46 360 Multiple Regression Data contract # Frequency (Hz) Angle in Degrees Chord Length Velocity (Meters per Second) Displacement Decibel 1420 800 0 0.1809 71.3 0.00266337 126.201 682 1000 0 0.0893 71.3 0.00266337 125.201 714 1250 0 0.0313 71.3 0.00266337 125.951 2336 1600 0 0.1867 71.3 0.00266337 127.591 2216 2000 0 0.0705 71.3 0.00266337 127.461 1327 2500 0 0.1281 71.3 0.00266337 125.571 1025 3150 0 0.1966 71.3 0.00266337 125.201 920 4000 0 0.1353 71.3 0.00266337 123.061 465 5000 0 0.1688 71.3 0.00266337 121.301 138 6300 0 0.1578 71.3 0.00266337 119.541 1411 8000 0 0.0558 71.3 0.00266337 117.151 1439 10000 0 0.1513 71.3 0.00266337 115.391 2388 12500 0 0.1238 71.3 0.00266337 112.241 1849 16000 0 0.1276 71.3 0.00266337 108.721 1740 500 0 0.1666 55.5 0.00283081 126.416 1666 630 0 0.1515 55.5 0.00283081 127.696 1672 800 0 0.1229 55.5 0.00283081 128.086 2455 1000 0 0.0985 55.5 0.00283081 126.966 403 1250 0 0.1724 55.5 0.00283081 126.086 856 1600 0 0.1127 55.5 0.00283081 126.986 2050 2000 0 0.0705 55.5 0.00283081 126.616 1271 2500 0 0.1988 55.5 0.00283081 124.106 2429 3150 0 0.1159 55.5 0.00283081 123.236 812 4000 0 0.0332 55.5 0.00283081 121.106 405 5000 0 0.0364 55.5 0.00283081 119.606 1630 6300 0 0.1231 55.5 0.00283081 117.976 2376 8000 0 0.0657 55.5 0.00283081 116.476 861 10000 0 0.1365 55.5 0.00283081 113.076 2436 12500 0 0.1178 55.5 0.00283081 111.076 36 200 0 0.1752 39.6 0.00310138 118.129 30 250 0 0.1886 39.6 0.00310138 119.319 76 315 0 0.0328 39.6 0.00310138 122.779 1155 400 0 0.042 39.6 0.00310138 124.809 1273 500 0 0.1188 39.6 0.00310138 126.959 1886 630 0 0.1409 39.6 0.00310138 128.629 630 800 0 0.1953 39.6 0.00310138 129.099 407 1000 0 0.095 39.6 0.00310138 127.899 488 1250 0 0.1033 39.6 0.00310138 125.499 1971 1600 0 0.1205 39.6 0.00310138 124.049 62 2000 0 0.0792 39.6 0.00310138 123.689 118 2500 0 0.1538 39.6 0.00310138 121.399 2 3150 0 0.1122 39.6 0.00310138 120.319 42 4000 0 0.1113 39.6 0.00310138 119.229 92 5000 0 0.0395 39.6 0.00310138 117.789 160 6300 0 0.1158 39.6 0.00310138 116.229 149 8000 0 0.1531 39.6 0.00310138 114.779 178 10000 0 0.0536 39.6 0.00310138 112.139 160 12500 0 0.0614 39.6 0.00310138 109.619 56 200 0 0.1989 31.7 0.00331266 117.195 152 250 0 0.148 31.7 0.00331266 118.595 3 315 0 0.1894 31.7 0.00331266 122.765 196 400 0 0.1004 31.7 0.00331266 125.045 157 500 0 0.1402 31.7 0.00331266 127.315 221 630 0 0.0914 31.7 0.00331266 129.095 62 800 0 0.0443 31.7 0.00331266 129.235 64 1000 0 0.0917 31.7 0.00331266 127.365 143 1250 0 0.0738 31.7 0.00331266 124.355 139 1600 0 0.1069 31.7 0.00331266 122.365 217 2000 0 0.0592 31.7 0.00331266 122.375 182 2500 0 0.1304 31.7 0.00331266 120.755 162 3150 0 0.1722 31.7 0.00331266 119.135 159 4000 0 0.14 31.7 0.00331266 118.145 162 5000 0 0.0533 31.7 0.00331266 115.645 145 6300 0 0.0386 31.7 0.00331266 113.775 203 8000 0 0.0611 31.7 0.00331266 110.515 135 10000 0 0.0512 31.7 0.00331266 108.265 158 800 1.5 0.0525 71.3 0.00336729 127.122 182 1000 1.5 0.119 71.3 0.00336729 125.992 35 1250 1.5 0.0502 71.3 0.00336729 125.872 163 1600 1.5 0.1675 71.3 0.00336729 126.632 105 2000 1.5 0.0769 71.3 0.00336729 126.642 163 2500 1.5 0.1848 71.3 0.00336729 124.512 131 3150 1.5 0.0301 71.3 0.00336729 123.392 73 4000 1.5 0.1086 71.3 0.00336729 121.762 55 5000 1.5 0.0336 71.3 0.00336729 119.632 181 6300 1.5 0.1414 71.3 0.00336729 118.122 124 8000 1.5 0.0908 71.3 0.00336729 115.372 55 10000 1.5 0.1899 71.3 0.00336729 113.492 136 12500 1.5 0.0411 71.3 0.00336729 109.222 5 16000 1.5 0.1952 71.3 0.00336729 106.582 179 315 1.5 0.1854 39.6 0.00392107 121.851 150 400 1.5 0.1594 39.6 0.00392107 124.001 140 500 1.5 0.0694 39.6 0.00392107 126.661 96 630 1.5 0.119 39.6 0.00392107 128.311 157 800 1.5 0.0992 39.6 0.00392107 128.831 51 1000 1.5 0.1617 39.6 0.00392107 127.581 153 1250 1.5 0.0352 39.6 0.00392107 125.211 137 1600 1.5 0.1558 39.6 0.00392107 122.211 195 2000 1.5 0.1929 39.6 0.00392107 122.101 116 2500 1.5 0.1106 39.6 0.00392107 120.981 196 3150 1.5 0.0372 39.6 0.00392107 119.111 65 4000 1.5 0.0788 39.6 0.00392107 117.741 194 5000 1.5 0.1443 39.6 0.00392107 116.241 113 6300 1.5 0.145 39.6 0.00392107 114.751 85 8000 1.5 0.1235 39.6 0.00392107 112.251 190 10000 1.5 0.0939 39.6 0.00392107 108.991 148 12500 1.5 0.1307 39.6 0.00392107 106.111 54 400 3 0.1365 71.3 0.00425727 127.564 183 500 3 0.1578 71.3 0.00425727 128.454 100 630 3 0.1453 71.3 0.00425727 129.354 92 800 3 0.1711 71.3 0.00425727 129.494 157 1000 3 0.1049 71.3 0.00425727 129.004 40 1250 3 0.1201 71.3 0.00425727 127.634 217 1600 3 0.1069 71.3 0.00425727 126.514 137 2000 3 0.1415 71.3 0.00425727 125.524 91 2500 3 0.1371 71.3 0.00425727 124.024 96 3150 3 0.0396 71.3 0.00425727 121.514 203 4000 3 0.1809 71.3 0.00425727 120.264 205 5000 3 0.1359 71.3 0.00425727 118.134 188 6300 3 0.0862 71.3 0.00425727 116.134 29 8000 3 0.1713 71.3 0.00425727 114.634 189 10000 3 0.0617 71.3 0.00425727 110.224 34 400 3 0.0351 55.5 0.00452492 126.159 56 500 3 0.0869 55.5 0.00452492 128.179 49 630 3 0.092 55.5 0.00452492 129.569 145 800 3 0.0463 55.5 0.00452492 129.949 11 1000 3 0.0912 55.5 0.00452492 129.329 75 1250 3 0.1189 55.5 0.00452492 127.329 155 1600 3 0.0728 55.5 0.00452492 124.439 132 2000 3 0.0974 55.5 0.00452492 123.069 168 2500 3 0.1719 55.5 0.00452492 122.439 65 3150 3 0.1601 55.5 0.00452492 120.189 38 4000 3 0.1365 55.5 0.00452492 118.689 186 5000 3 0.1769 55.5 0.00452492 117.309 9 6300 3 0.1207 55.5 0.00452492 115.679 146 8000 3 0.0464 55.5 0.00452492 113.799 123 10000 3 0.054 55.5 0.00452492 112.169 108 315 3 0.1325 39.6 0.00495741 123.312 221 400 3 0.1342 39.6 0.00495741 125.472 201 500 3 0.0755 39.6 0.00495741 127.632 25 630 3 0.1299 39.6 0.00495741 129.292 72 800 3 0.0932 39.6 0.00495741 129.552 213 1000 3 0.0514 39.6 0.00495741 128.312 129 1250 3 0.1089 39.6 0.00495741 125.802 195 1600 3 0.0886 39.6 0.00495741 122.782 141 2000 3 0.0375 39.6 0.00495741 120.532 75 2500 3 0.1367 39.6 0.00495741 120.162 33 3150 3 0.0878 39.6 0.00495741 118.922 119 4000 3 0.0527 39.6 0.00495741 116.792 205 5000 3 0.0804 39.6 0.00495741 115.792 120 6300 3 0.1046 39.6 0.00495741 114.042 110 8000 3 0.0376 39.6 0.00495741 110.652 208 315 3 0.0866 31.7 0.00529514 123.118 19 400 3 0.1706 31.7 0.00529514 125.398 211 500 3 0.0415 31.7 0.00529514 127.548 221 630 3 0.1478 31.7 0.00529514 128.698 23 800 3 0.1076 31.7 0.00529514 128.708 133 1000 3 0.1267 31.7 0.00529514 126.838 19 1250 3 0.05 31.7 0.00529514 124.838 84 1600 3 0.1347 31.7 0.00529514 122.088 167 2000 3 0.1087 31.7 0.00529514 120.088 96 2500 3 0.1435 31.7 0.00529514 119.598 200 3150 3 0.1973 31.7 0.00529514 118.108 171 4000 3 0.1044 31.7 0.00529514 115.608 18 5000 3 0.0841 31.7 0.00529514 113.858 107 6300 3 0.1838 31.7 0.00529514 109.718 152 250 4 0.093 71.3 0.00497773 126.395 120 315 4 0.1697 71.3 0.00497773 128.175 143 400 4 0.0768 71.3 0.00497773 129.575 24 500 4 0.1091 71.3 0.00497773 130.715 104 630 4 0.0793 71.3 0.00497773 131.615 170 800 4 0.1529 71.3 0.00497773 131.755 115 1000 4 0.098 71.3 0.00497773 131.015 159 1250 4 0.1105 71.3 0.00497773 129.395 125 1600 4 0.0622 71.3 0.00497773 126.645 128 2000 4 0.1327 71.3 0.00497773 124.395 105 2500 4 0.0372 71.3 0.00497773 123.775 209 3150 4 0.1477 71.3 0.00497773 121.775 190 4000 4 0.1161 71.3 0.00497773 119.535 199 5000 4 0.1541 71.3 0.00497773 117.785 110 6300 4 0.0489 71.3 0.00497773 116.165 151 8000 4 0.0591 71.3 0.00497773 113.665 219 10000 4 0.179 71.3 0.00497773 110.905 33 12500 4 0.1765 71.3 0.00497773 107.405 156 250 4 0.1491 39.6 0.00579636 123.543 161 315 4 0.0971 39.6 0.00579636 126.843 133 400 4 0.154 39.6 0.00579636 128.633 131 500 4 0.1933 39.6 0.00579636 130.173 54 630 4 0.1458 39.6 0.00579636 131.073 24 800 4 0.1364 39.6 0.00579636 130.723 48 1000 4 0.1705 39.6 0.00579636 128.723 212 1250 4 0.1915 39.6 0.00579636 126.343 91 1600 4 0.0907 39.6 0.00579636 123.213 4 2000 4 0.1071 39.6 0.00579636 120.963 187 2500 4 0.0701 39.6 0.00579636 120.233 134 3150 4 0.0824 39.6 0.00579636 118.743 24 4000 4 0.0889 39.6 0.00579636 115.863 6 5000 4 0.1509 39.6 0.00579636 113.733 135 1250 0 0.1841 71.3 0.00214345 128.144 132 1600 0 0.0952 71.3 0.00214345 129.134 101 2000 0 0.1142 71.3 0.00214345 128.244 34 2500 0 0.0788 71.3 0.00214345 128.354 27 3150 0 0.1754 71.3 0.00214345 127.834 86 4000 0 0.0478 71.3 0.00214345 125.824 184 5000 0 0.1279 71.3 0.00214345 124.304 35 6300 0 0.1299 71.3 0.00214345 122.044 140 8000 0 0.1322 71.3 0.00214345 118.024 173 10000 0 0.1343 71.3 0.00214345 118.134 131 12500 0 0.1186 71.3 0.00214345 117.624 42 16000 0 0.0951 71.3 0.00214345 114.984 95 20000 0 0.1286 71.3 0.00214345 114.474 17 315 0 0.0852 55.5 0.00229336 119.54 68 400 0 0.0318 55.5 0.00229336 121.66 197 500 0 0.069 55.5 0.00229336 123.78 59 630 0 0.1949 55.5 0.00229336 126.16 2 800 0 0.0807 55.5 0.00229336 127.53 119 1000 0 0.194 55.5 0.00229336 128.29 19 1250 0 0.083 55.5 0.00229336 127.91 28 1600 0 0.1852 55.5 0.00229336 126.79 65 2000 0 0.0719 55.5 0.00229336 126.54 18 2500 0 0.0748 55.5 0.00229336 126.54 95 3150 0 0.0907 55.5 0.00229336 125.16 201 4000 0 0.1268 55.5 0.00229336 123.41 40 5000 0 0.125 55.5 0.00229336 122.41 199 6300 0 0.0859 55.5 0.00229336 118.41 1116 315 0 0.1641 39.6 0.00253511 121.055 205 400 0 0.0708 39.6 0.00253511 123.565 2146 500 0 0.0366 39.6 0.00253511 126.195 1603 630 0 0.1473 39.6 0.00253511 128.705 914 800 0 0.1221 39.6 0.00253511 130.205 437 1000 0 0.0533 39.6 0.00253511 130.435 598 1250 0 0.0359 39.6 0.00253511 129.395 2801 1600 0 0.0752 39.6 0.00253511 127.095 1420 2000 0 0.0322 39.6 0.00253511 125.305 682 2500 0 0.0525 39.6 0.00253511 125.025 714 3150 0 0.0813 39.6 0.00253511 124.625 2336 4000 0 0.049 39.6 0.00253511 123.465 2216 5000 0 0.1688 39.6 0.00253511 122.175 1327 6300 0 0.1373 39.6 0.00253511 117.465 1025 315 0 0.0339 31.7 0.0027238 120.595 920 400 0 0.1574 31.7 0.0027238 123.635 465 500 0 0.1644 31.7 0.0027238 126.675 138 630 0 0.1619 31.7 0.0027238 129.465 1411 800 0 0.1495 31.7 0.0027238 130.725 1439 1000 0 0.193 31.7 0.0027238 130.595 2388 1250 0 0.0561 31.7 0.0027238 128.805 1849 1600 0 0.0376 31.7 0.0027238 125.625 1740 2000 0 0.1064 31.7 0.0027238 123.455 1666 2500 0 0.0659 31.7 0.0027238 123.445 1672 3150 0 0.1844 31.7 0.0027238 123.445 2455 4000 0 0.1684 31.7 0.0027238 122.035 403 5000 0 0.1146 31.7 0.0027238 120.505 856 6300 0 0.0364 31.7 0.0027238 116.815 2050 400 2 0.0805 71.3 0.00293031 125.116 1271 500 2 0.0517 71.3 0.00293031 126.486 2429 630 2 0.0455 71.3 0.00293031 127.356 812 800 2 0.038 71.3 0.00293031 128.216 405 1000 2 0.0501 71.3 0.00293031 128.956 1630 1250 2 0.1657 71.3 0.00293031 128.816 2376 1600 2 0.1825 71.3 0.00293031 127.796 861 2000 2 0.0534 71.3 0.00293031 126.896 2436 2500 2 0.0635 71.3 0.00293031 127.006 36 3150 2 0.0456 71.3 0.00293031 126.116 30 4000 2 0.1794 71.3 0.00293031 124.086 76 5000 2 0.1096 71.3 0.00293031 122.816 1155 6300 2 0.0676 71.3 0.00293031 120.786 1273 8000 2 0.1175 71.3 0.00293031 115.996 1886 10000 2 0.0453 71.3 0.00293031 113.086 630 400 2 0.0742 55.5 0.00313525 122.292 407 500 2 0.1016 55.5 0.00313525 124.692 488 630 2 0.0394 55.5 0.00313525 126.842 1971 800 2 0.1108 55.5 0.00313525 128.492 62 1000 2 0.0814 55.5 0.00313525 129.002 118 1250 2 0.0745 55.5 0.00313525 128.762 2 1600 2 0.1318 55.5 0.00313525 126.752 42 2000 2 0.1922 55.5 0.00313525 124.612 92 2500 2 0.0548 55.5 0.00313525 123.862 160 3150 2 0.0828 55.5 0.00313525 123.742 149 4000 2 0.1896 55.5 0.00313525 122.232 178 5000 2 0.1276 55.5 0.00313525 120.472 160 6300 2 0.1103 55.5 0.00313525 118.712 56 315 2 0.0942 39.6 0.00346574 120.137 152 400 2 0.1995 39.6 0.00346574 122.147 3 500 2 0.1147 39.6 0.00346574 125.157 196 630 2 0.1567 39.6 0.00346574 127.417 157 800 2 0.1067 39.6 0.00346574 129.037 221 1000 2 0.1645 39.6 0.00346574 129.147 62 1250 2 0.1467 39.6 0.00346574 128.257 64 1600 2 0.0301 39.6 0.00346574 125.837 143 2000 2 0.0798 39.6 0.00346574 122.797 139 2500 2 0.0923 39.6 0.00346574 121.397 217 3150 2 0.0477 39.6 0.00346574 121.627 182 4000 2 0.0802 39.6 0.00346574 120.227 162 5000 2 0.0675 39.6 0.00346574 118.827 159 6300 2 0.1538 39.6 0.00346574 116.417 162 315 2 0.1486 31.7 0.00372371 120.147 145 400 2 0.0325 31.7 0.00372371 123.417 203 500 2 0.117 31.7 0.00372371 126.677 135 630 2 0.0887 31.7 0.00372371 129.057 158 800 2 0.0327 31.7 0.00372371 130.307 182 1000 2 0.0536 31.7 0.00372371 130.307 35 1250 2 0.1725 31.7 0.00372371 128.677 163 1600 2 0.091 31.7 0.00372371 125.797 105 2000 2 0.1721 31.7 0.00372371 123.037 163 2500 2 0.1074 31.7 0.00372371 121.407 131 3150 2 0.1918 31.7 0.00372371 121.527 73 4000 2 0.0361 31.7 0.00372371 120.527 55 5000 2 0.1984 31.7 0.00372371 118.267 181 6300 2 0.0896 31.7 0.00372371 115.137 124 500 4 0.1623 71.3 0.00400603 126.758 55 630 4 0.0439 71.3 0.00400603 129.038 136 800 4 0.1536 71.3 0.00400603 130.688 5 1000 4 0.0749 71.3 0.00400603 131.708 179 1250 4 0.1219 71.3 0.00400603 131.718 150 1600 4 0.048 71.3 0.00400603 129.468 140 2000 4 0.1898 71.3 0.00400603 126.218 96 2500 4 0.127 71.3 0.00400603 124.338 157 3150 4 0.1729 71.3 0.00400603 124.108 51 4000 4 0.1425 71.3 0.00400603 121.728 153 5000 4 0.1271 71.3 0.00400603 121.118 137 6300 4 0.1662 71.3 0.00400603 118.618 195 8000 4 0.1995 71.3 0.00400603 112.848 116 10000 4 0.1164 71.3 0.00400603 113.108 196 12500 4 0.1326 71.3 0.00400603 114.258 65 16000 4 0.1547 71.3 0.00400603 112.768 194 20000 4 0.0709 71.3 0.00400603 109.638 113 400 4 0.1782 55.5 0.0042862 123.274 85 500 4 0.1706 55.5 0.0042862 127.314 190 630 4 0.0701 55.5 0.0042862 129.964 148 800 4 0.157 55.5 0.0042862 131.864 54 1000 4 0.1777 55.5 0.0042862 132.134 183 1250 4 0.1184 55.5 0.0042862 131.264 100 1600 4 0.0584 55.5 0.0042862 128.264 92 2000 4 0.0534 55.5 0.0042862 124.254 157 2500 4 0.0624 55.5 0.0042862 122.384 40 3150 4 0.0428 55.5 0.0042862 122.394 217 4000 4 0.095 55.5 0.0042862 120.654 137 5000 4 0.0363 55.5 0.0042862 120.034 91 6300 4 0.1145 55.5 0.0042862 117.154 96 8000 4 0.048 55.5 0.0042862 112.524 203 315 4 0.1222 39.6 0.00473801 122.229 205 400 4 0.1704 39.6 0.00473801 123.879 188 500 4 0.0623 39.6 0.00473801 127.039 29 630 4 0.1377 39.6 0.00473801 129.579 189 800 4 0.0335 39.6 0.00473801 130.469 34 1000 4 0.1969 39.6 0.00473801 129.969 56 1250 4 0.0379 39.6 0.00473801 128.339 49 1600 4 0.1838 39.6 0.00473801 125.319 145 2000 4 0.193 39.6 0.00473801 121.659 11 2500 4 0.1185 39.6 0.00473801 119.649 75 3150 4 0.1241 39.6 0.00473801 120.419 155 4000 4 0.1732 39.6 0.00473801 119.159 132 5000 4 0.1443 39.6 0.00473801 117.649 168 6300 4 0.142 39.6 0.00473801 114.249 65 8000 4 0.0592 39.6 0.00473801 113.129 38 250 4 0.0925 31.7 0.00509068 120.189 186 315 4 0.0455 31.7 0.00509068 123.609 9 400 4 0.1765 31.7 0.00509068 126.149 146 500 4 0.0984 31.7 0.00509068 128.939 123 630 4 0.1504 31.7 0.00509068 130.349 108 800 4 0.0345 31.7 0.00509068 130.869 221 1000 4 0.0748 31.7 0.00509068 129.869 201 1250 4 0.1032 31.7 0.00509068 128.119 25 1600 4 0.1888 31.7 0.00509068 125.229 72 2000 4 0.1106 31.7 0.00509068 122.089 213 2500 4 0.189 31.7 0.00509068 120.209 129 3150 4 0.0976 31.7 0.00509068 120.229 195 4000 4 0.1902 31.7 0.00509068 118.859 141 5000 4 0.1052 31.7 0.00509068 115.969 75 6300 4 0.0964 31.7 0.00509068 112.699 33 400 5.3 0.0446 71.3 0.0051942 127.7 119 500 5.3 0.0885 71.3 0.0051942 129.88 205 630 5.3 0.067 71.3 0.0051942 131.8 120 800 5.3 0.1447 71.3 0.0051942 133.48 110 1000 5.3 0.0712 71.3 0.0051942 134 208 1250 5.3 0.0713 71.3 0.0051942 133.38 19 1600 5.3 0.1366 71.3 0.0051942 130.46 211 2000 5.3 0.1805 71.3 0.0051942 125.89 221 2500 5.3 0.0766 71.3 0.0051942 123.74 23 3150 5.3 0.0808 71.3 0.0051942 123.12 133 4000 5.3 0.0833 71.3 0.0051942 120.33 19 5000 5.3 0.1205 71.3 0.0051942 118.05 84 6300 5.3 0.1224 71.3 0.0051942 116.92 167 8000 5.3 0.1564 71.3 0.0051942 114.9 96 10000 5.3 0.161 71.3 0.0051942 111.35 200 250 5.3 0.1585 39.6 0.00614329 127.011 171 315 5.3 0.1404 39.6 0.00614329 129.691 18 400 5.3 0.1186 39.6 0.00614329 131.221 107 500 5.3 0.071 39.6 0.00614329 132.251 152 630 5.3 0.1136 39.6 0.00614329 132.011 120 800 5.3 0.1649 39.6 0.00614329 129.491 143 1000 5.3 0.113 39.6 0.00614329 125.581 24 1250 5.3 0.1463 39.6 0.00614329 125.721 104 1600 5.3 0.195 39.6 0.00614329 123.081 170 2000 5.3 0.1662 39.6 0.00614329 117.911 115 2500 5.3 0.1253 39.6 0.00614329 116.151 159 3150 5.3 0.1555 39.6 0.00614329 118.441 125 4000 5.3 0.1458 39.6 0.00614329 115.801 128 5000 5.3 0.1178 39.6 0.00614329 115.311 105 6300 5.3 0.1735 39.6 0.00614329 112.541 209 200 7.3 0.0672 71.3 0.0104404 138.758 190 250 7.3 0.1531 71.3 0.0104404 139.918 199 315 7.3 0.0377 71.3 0.0104404 139.808 110 400 7.3 0.0423 71.3 0.0104404 139.438 151 500 7.3 0.1841 71.3 0.0104404 136.798 219 630 7.3 0.1148 71.3 0.0104404 133.768 33 800 7.3 0.1198 71.3 0.0104404 130.748 156 1000 7.3 0.1975 71.3 0.0104404 126.838 161 1250 7.3 0.03 71.3 0.0104404 127.358 133 1600 7.3 0.1233 71.3 0.0104404 125.728 131 2000 7.3 0.0612 71.3 0.0104404 122.708 54 2500 7.3 0.1212 71.3 0.0104404 122.088 24 3150 7.3 0.0916 71.3 0.0104404 120.458 48 4000 7.3 0.1682 71.3 0.0104404 119.208 212 5000 7.3 0.1487 71.3 0.0104404 115.298 91 6300 7.3 0.1532 71.3 0.0104404 115.818 4 200 7.3 0.0614 55.5 0.0111706 135.234 187 250 7.3 0.1704 55.5 0.0111706 136.384 134 315 7.3 0.0971 55.5 0.0111706 136.284 24 400 7.3 0.086 55.5 0.0111706 135.924 6 500 7.3 0.0525 55.5 0.0111706 133.174 135 630 7.3 0.0591 55.5 0.0111706 130.934 132 800 7.3 0.0859 55.5 0.0111706 128.444 101 1000 7.3 0.1339 55.5 0.0111706 125.194 34 1250 7.3 0.1198 55.5 0.0111706 125.724 27 1600 7.3 0.1176 55.5 0.0111706 123.354 86 2000 7.3 0.1709 55.5 0.0111706 120.354 184 2500 7.3 0.0665 55.5 0.0111706 118.994 35 3150 7.3 0.031 55.5 0.0111706 117.134 140 4000 7.3 0.0928 55.5 0.0111706 117.284 173 5000 7.3 0.0987 55.5 0.0111706 113.144 131 6300 7.3 0.1365 55.5 0.0111706 111.534 42 200 7.3 0.1005 39.6 0.0123481 130.989 95 250 7.3 0.0607 39.6 0.0123481 131.889 17 315 7.3 0.1462 39.6 0.0123481 132.149 68 400 7.3 0.0727 39.6 0.0123481 132.039 197 500 7.3 0.1168 39.6 0.0123481 130.299 59 630 7.3 0.1222 39.6 0.0123481 128.929 2 800 7.3 0.1723 39.6 0.0123481 126.299 119 1000 7.3 0.0925 39.6 0.0123481 122.539 19 1250 7.3 0.0416 39.6 0.0123481 123.189 28 1600 7.3 0.155 39.6 0.0123481 121.059 65 2000 7.3 0.1197 39.6 0.0123481 117.809 18 2500 7.3 0.164 39.6 0.0123481 116.559 95 3150 7.3 0.0881 39.6 0.0123481 114.309 201 4000 7.3 0.1652 39.6 0.0123481 114.079 40 5000 7.3 0.1552 39.6 0.0123481 111.959 199 6300 7.3 0.1983 39.6 0.0123481 110.839 1420 200 7.3 0.1091 31.7 0.0132672 128.679 682 250 7.3 0.0897 31.7 0.0132672 130.089 714 315 7.3 0.0985 31.7 0.0132672 130.239 2336 400 7.3 0.1453 31.7 0.0132672 130.269 2216 500 7.3 0.1233 31.7 0.0132672 128.169 1327 630 7.3 0.1422 31.7 0.0132672 126.189 1025 800 7.3 0.057 31.7 0.0132672 123.209 920 1000 7.3 0.1765 31.7 0.0132672 119.099 465 1250 7.3 0.1266 31.7 0.0132672 120.509 138 1600 7.3 0.1887 31.7 0.0132672 119.039 1411 2000 7.3 0.0446 31.7 0.0132672 115.309 1439 2500 7.3 0.1447 31.7 0.0132672 114.709 2388 3150 7.3 0.092 31.7 0.0132672 113.229 1849 4000 7.3 0.0992 31.7 0.0132672 112.639 1740 5000 7.3 0.0451 31.7 0.0132672 111.029 1666 6300 7.3 0.148 31.7 0.0132672 110.689 1672 800 0 0.0691 71.3 0.0015988 125.817 2455 1000 0 0.1088 71.3 0.0015988 127.307 403 1250 0 0.0695 71.3 0.0015988 128.927 856 1600 0 0.1997 71.3 0.0015988 129.667 2050 2000 0 0.1567 71.3 0.0015988 128.647 1271 2500 0 0.0585 71.3 0.0015988 128.127 2429 3150 0 0.1333 71.3 0.0015988 129.377 812 4000 0 0.0615 71.3 0.0015988 128.857 405 5000 0 0.1455 71.3 0.0015988 126.457 1630 6300 0 0.1136 71.3 0.0015988 125.427 2376 8000 0 0.0916 71.3 0.0015988 122.527 861 10000 0 0.0971 71.3 0.0015988 120.247 2436 12500 0 0.1024 71.3 0.0015988 117.087 36 16000 0 0.0863 71.3 0.0015988 113.297 30 500 0 0.0558 55.5 0.00172668 120.573 76 630 0 0.162 55.5 0.00172668 123.583 1155 800 0 0.0664 55.5 0.00172668 126.713 1273 1000 0 0.1184 55.5 0.00172668 128.583 1886 1250 0 0.1217 55.5 0.00172668 129.953 630 1600 0 0.1748 55.5 0.00172668 130.183 407 2000 0 0.1667 55.5 0.00172668 129.673 488 2500 0 0.168 55.5 0.00172668 127.763 1971 3150 0 0.0743 55.5 0.00172668 127.753 62 4000 0 0.1061 55.5 0.00172668 127.233 118 5000 0 0.1639 55.5 0.00172668 125.203 2 6300 0 0.1745 55.5 0.00172668 123.303 42 8000 0 0.0321 55.5 0.00172668 121.903 92 10000 0 0.192 55.5 0.00172668 119.253 160 12500 0 0.0688 55.5 0.00172668 117.093 149 16000 0 0.0828 55.5 0.00172668 112.803 178 500 0 0.1623 39.6 0.00193287 119.513 160 630 0 0.1434 39.6 0.00193287 124.403 56 800 0 0.1827 39.6 0.00193287 127.903 152 1000 0 0.1276 39.6 0.00193287 130.033 3 1250 0 0.047 39.6 0.00193287 131.023 196 1600 0 0.1314 39.6 0.00193287 131.013 157 2000 0 0.1189 39.6 0.00193287 129.633 221 2500 0 0.0807 39.6 0.00193287 126.863 62 3150 0 0.0632 39.6 0.00193287 125.603 64 4000 0 0.1954 39.6 0.00193287 125.343 143 5000 0 0.0708 39.6 0.00193287 123.453 139 6300 0 0.0378 39.6 0.00193287 121.313 217 8000 0 0.1008 39.6 0.00193287 120.553 182 10000 0 0.1331 39.6 0.00193287 115.413 162 500 0 0.1141 31.7 0.00209405 121.617 159 630 0 0.1143 31.7 0.00209405 125.997 162 800 0 0.1747 31.7 0.00209405 129.117 145 1000 0 0.1891 31.7 0.00209405 130.987 203 1250 0 0.1123 31.7 0.00209405 131.467 135 1600 0 0.0582 31.7 0.00209405 130.817 158 2000 0 0.1392 31.7 0.00209405 128.907 182 2500 0 0.0468 31.7 0.00209405 125.867 35 3150 0 0.0668 31.7 0.00209405 124.207 163 4000 0 0.1647 31.7 0.00209405 123.807 105 5000 0 0.0863 31.7 0.00209405 122.397 163 6300 0 0.197 31.7 0.00209405 119.737 131 8000 0 0.1763 31.7 0.00209405 117.957 73 630 2.7 0.1604 71.3 0.00243851 127.404 55 800 2.7 0.1884 71.3 0.00243851 127.394 181 1000 2.7 0.1811 71.3 0.00243851 128.774 124 1250 2.7 0.159 71.3 0.00243851 130.144 55 1600 2.7 0.166 71.3 0.00243851 130.644 136 2000 2.7 0.0357 71.3 0.00243851 130.114 5 2500 2.7 0.0372 71.3 0.00243851 128.334 179 3150 2.7 0.1995 71.3 0.00243851 127.054 150 4000 2.7 0.1531 71.3 0.00243851 126.534 140 5000 2.7 0.0621 71.3 0.00243851 124.364 96 6300 2.7 0.1189 71.3 0.00243851 121.944 157 8000 2.7 0.0816 71.3 0.00243851 120.534 51 10000 2.7 0.131 71.3 0.00243851 116.724 153 12500 2.7 0.1329 71.3 0.00243851 113.034 137 16000 2.7 0.0737 71.3 0.00243851 110.364 195 500 2.7 0.0991 39.6 0.00294804 121.009 116 630 2.7 0.1866 39.6 0.00294804 125.809 196 800 2.7 0.1844 39.6 0.00294804 128.829 65 1000 2.7 0.1909 39.6 0.00294804 130.589 194 1250 2.7 0.1947 39.6 0.00294804 130.829 113 1600 2.7 0.0871 39.6 0.00294804 130.049 85 2000 2.7 0.1031 39.6 0.00294804 128.139 190 2500 2.7 0.1153 39.6 0.00294804 125.589 148 3150 2.7 0.1607 39.6 0.00294804 122.919 54 4000 2.7 0.1309 39.6 0.00294804 121.889 183 5000 2.7 0.1927 39.6 0.00294804 121.499 100 6300 2.7 0.1764 39.6 0.00294804 119.209 92 8000 2.7 0.1993 39.6 0.00294804 116.659 157 10000 2.7 0.082 39.6 0.00294804 112.589 40 12500 2.7 0.092 39.6 0.00294804 108.649 217 400 5.4 0.1588 71.3 0.00401199 124.121 137 500 5.4 0.0816 71.3 0.00401199 126.291 91 630 5.4 0.1401 71.3 0.00401199 128.971 96 800 5.4 0.1794 71.3 0.00401199 131.281 203 1000 5.4 0.0404 71.3 0.00401199 133.201 205 1250 5.4 0.082 71.3 0.00401199 134.111 188 1600 5.4 0.0727 71.3 0.00401199 133.241 29 2000 5.4 0.1866 71.3 0.00401199 131.111 189 2500 5.4 0.1039 71.3 0.00401199 127.591 34 3150 5.4 0.0392 71.3 0.00401199 123.311 56 4000 5.4 0.1664 71.3 0.00401199 121.431 49 5000 5.4 0.0658 71.3 0.00401199 120.061 145 6300 5.4 0.072 71.3 0.00401199 116.411 11 400 5.4 0.04 55.5 0.00433288 126.807 75 500 5.4 0.1413 55.5 0.00433288 129.367 155 630 5.4 0.122 55.5 0.00433288 131.807 132 800 5.4 0.1599 55.5 0.00433288 133.097 168 1000 5.4 0.1921 55.5 0.00433288 132.127 65 1250 5.4 0.0677 55.5 0.00433288 130.777 38 1600 5.4 0.1042 55.5 0.00433288 130.567 186 2000 5.4 0.1666 55.5 0.00433288 128.707 9 2500 5.4 0.1698 55.5 0.00433288 124.077 146 3150 5.4 0.0764 55.5 0.00433288 121.587 123 4000 5.4 0.087 55.5 0.00433288 119.737 108 5000 5.4 0.1416 55.5 0.00433288 118.757 221 6300 5.4 0.1945 55.5 0.00433288 117.287 201 8000 5.4 0.159 55.5 0.00433288 114.927 25 315 5.4 0.1978 39.6 0.00485029 125.347 72 400 5.4 … INSERT TITLE HERE 12 Statistical Tools You will conduct the data analysis using Microsoft Excel Toolpak. See the links below for more information. https://support.office.com/en-us/article/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4 https://www.excel-easy.com/data-analysis/analysis-toolpak.html