MAT-144-RS-Online-MA3_Excel_20240111 (1)

Competency Analysis Name Difference Data Statistics Percentiles Empirical Rule Written Analysis Formatting Visualization Bin Table Histogram Formatting Frequency Distribution

Major Assignment 3 Grading Sheet (01/11/2024) Requirements for full credit You have entered your full name in the field provided. You have formatted all cells as discussed in the instructions. Subtotals Subtotals Totals Percentage Score out of 100 (optional for student use) Did you meet the requirements? You have calculated the differences for each test score as (After-Before) using appropriate cell references. You have calculated the mean, median, standard deviation, and range for the before, after, and difference data using Excel functions and appropriate cell references. (2 points each) You have calculated the percentiles of the difference in scores using appropriate Excel formulas. (3 points each) You have calculated the upper and lower limits of the difference in scores using appropriate cell references. (3 points each) In your response in section 5b, you correctly indicate whether or not there was improvement (2 points) and appropriately interpret the lower and upper limits from section 5a as part of your response (2 points). In your response, you use correct grammar, punctuation, and spelling (1 point). Your bin minimum, maximum, and width formulas are correct and use appropriate cell references. (2 points each) Your Lower Limit and Upper Limit formulas are correct and use appropriate cell references. (6 points each) Your Title of Bin, Frequency, and Relative Frequency formulas are correct and use appropriate cell references. (6 points each) You have added a histogram using the "bar chart" option in Excel, using the Frequency column values as bar heights and the Title of Bin column entries as bar labels (3 points), and you have updated the chart title and added horizontal and vertical axis titles (3 points). You have formatted all cells in the Bin Table and Frequency Distribution table as discussed in the instructions.

Your points Scoring comments 1 6 24 6 6 5 6 54 0 6 12 18 6 4 46 0 100 0 100.00% 0.00% 100.00 0.00 Points possible

1 Dena Moran Student Test Scores Student Score Before Tutoring Score After Tutoring Difference in Scores 1 52.29 67.49 15.2 2 83.01 100 16.99 3 73.96 87.26 13.3 4 76.96 87.86 10.9 5 77.79 100 22.21 6 76.82 90.3 13.48 7 88.62 100 11.38 8 67.53 79.61 12.08 9 64.84 82.18 17.34 10 81.14 90.36 9.22 11 82.54 91.28 8.74 12 74.36 80.55 6.19 13 49.73 66.47 16.74 14 72.84 83.79 10.95 15 83.49 96.22 12.73 16 57.26 74.85 17.59 17 71.12 88.13 17.01 18 97.93 100 2.06999999999999 19 82.32 96.6 14.28 20 100 100 0 21 60.62 75.07 14.45 22 95.37 100 4.63 1 You have decided to volunteer with an existing organization now in order to gain experience. You choos program to see whether or not it is effective. Below, you will compare students' test scores for their math class before and after they received tutoring ( and after tutoring. Next, you will perform some calculations based on the statistics you found and the emp effective or not. 2 Enter your full name in the cell to the right. If your full name is less than 5 letters long, add additional letters 'X' at the end until you reach length 5. Assignment Advisory : You must us Help Desk for more information and help inst corrupted template e

23 73.01 88.45 15.44 24 79.09 95.71 16.62 25 69.58 88.49 18.91 26 67.19 79.58 12.39 27 89.74 98.22 8.48 28 82.71 97.47 14.76 29 67.69 84.77 17.08 30 67.49 83.1 15.61 31 76.2 85.06 8.86 32 99.55 100 0.450000000000003 33 88.41 100 11.59 34 66.91 83.46 16.55 35 78.68 93.68 15 36 65.26 81.78 16.52 37 78.1 94.63 16.53 38 91.46 100 8.54000000000001 39 81.03 94.08 13.05 40 77.14 91.82 14.68 41 87.93 100 12.07 42 66.78 81.24 14.46 43 71.6 81.02 9.42 44 88.4 100 11.6 45 95.32 100 4.68000000000001 46 72.19 88.19 16 47 66.44 80.29 13.85 48 73.27 87.59 14.32 49 92.99 100 7.01000000000001 50 83.8 100 16.2