MAT-144-RS-MA3-Ground 2023,Aden Holt

11 Aden Holt Student Test Scores Student Score Before Tutoring Score After Tutoring Difference in Scores 1 56.64 53.81 -2.83 2 78.18 77.93 -0.25 3 74.01 73.41 -0.600000000000009 4 57.47 56.71 -0.759999999999998 5 67.75 65.55 -2.2 6 72.79 71.43 -1.36 7 53.38 52.84 -0.539999999999999 8 84.58 81.13 -3.45 9 78.53 75.86 -2.67 10 70.25 66.57 -3.68000000000001 11 75.77 72.7 -3.06999999999999 12 80.68 79.89 -0.790000000000006 13 68.8 65.17 -3.63 14 94.26 91.18 -3.08 15 75.02 73.03 -1.99 16 62.77 61.25 -1.52 17 61.16 58.6 -2.56 18 63.76 61.08 -2.68 19 70.59 67.24 -3.35000000000001 20 91.99 89.24 -2.75 21 67.1 61.1 -5.99999999999999 22 66.97 67.34 0.370000000000005 23 78.89 77.85 -1.04000000000001 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. Assignment Advisory : You must us Help Desk for more information and help inst corrupted template e

24 77.87 75.29 -2.58 25 69.77 67.39 -2.38 26 60.08 54.95 -5.13 27 67.25 64.39 -2.86 28 85.18 85.87 0.689999999999998 29 57.83 54.89 -2.94 30 81.55 79.43 -2.11999999999999 31 64.56 60.62 -3.94 32 78.34 77.27 -1.07000000000001 33 59.04 58.37 -0.670000000000002 34 69.67 66.79 -2.88 35 54.76 52.17 -2.59 36 64.27 61.17 -3.09999999999999 37 66 63.04 -2.96 38 69.31 67.1 -2.21000000000001 39 58.06 55.19 -2.87 40 60.23 57.94 -2.29 41 51.26 46.26 -5 42 64.62 63.95 -0.670000000000002 43 62.21 58.92 -3.29 44 76 77.27 1.27 45 79.67 76.61 -3.06 46 62.27 58.5 -3.77 47 77.72 76.37 -1.34999999999999 48 86.63 85.43 -1.19999999999999 49 63.51 59.89 -3.62 50 64 59.03 -4.97

scores. The range suggests that between 0.80 and 3.86 points after tutoring.

Legend If a cell is shaded You should Blue Enter a text response Green Enter a number Gold Enter an Excel formula Any other color Make no changes tistical analysis of their scores both before gram seems to be tact the ng or n student test scores? (How many students mit and upper limit found in part 4a. gative effect on the student's test

57 50 83 33

Student Results Student Differences 1 -2.83 2 -0.25 3 -0.6 4 -0.76 5 -2.2 6 -1.36 7 -0.54 8 -3.45 9 -2.67 10 -3.68 Bin Table 11 -3.07 Bin Min -6 12 -0.79 Bin Max 1.27 13 -3.63 Bin Width 0.66 14 -3.08 15 -1.99 Frequency Distribution 16 -1.52 Lower Limit Upper Limit Title of Bin Frequency 17 -2.56 -6.00 -5.34 -5.67 1 18 -2.68 -5.34 -4.68 -5.01 3 19 -3.35 -4.68 -4.02 -4.35 0 20 -2.75 -4.02 -3.36 -3.69 6 21 -6 -3.36 -2.70 -3.03 13 22 0.37 -2.70 -2.03 -2.37 10 23 -1.04 -2.03 -1.37 -1.70 2 24 -2.58 -1.37 -0.71 -1.04 7 25 -2.38 -0.71 -0.05 -0.38 5 26 -5.13 -0.05 0.61 0.28 1 27 -2.86 0.61 1.27 0.94 1 28 0.69 29 -2.94 30 -2.12 5 Now that you have finished your analysis of score data for students receiving tutoring, the organization h to present the data to a group of potential donors who are interested in seeing how effective the program histogram so they can easily visualize the students' results. Below are the test score differences you calculated in part 1 of this assignment. First, use the data to create 6 Create a frequency distribution of the test score differences First, find the Bin Min, Bin Max, and Bin Width using Excel form references and Excel built-in functions where appropriate. For Max, and Bin Width as Numbers with 2 decimal places. Next, find the lower limit and upper limit of each class using th below, and then find the frequency for each of those classes. A frequency for each class. The title of the bin should reflect the and upper limits. Excel formulas with cell references should be calculations. Format all lower and upper limits, and bin titles as Numbers w Format all frequencies as Numbers with 0 decimal places and f frequencies as Percentages with 0 decimal places. 8 Based on the frequency distribution above, using the Title o

31 -3.94 32 -1.07 33 -0.67 34 -2.88 35 -2.59 Mean Difference in Scores -2.34 36 -3.1 37 -2.96 38 -2.21 39 -2.87 40 -2.29 41 -5 42 -0.67 43 -3.29 44 1.27 45 -3.06 46 -3.77 47 -1.35 48 -1.2 49 -3.62 50 -4.97 8 Based on the frequency distribution above, using the Title o mean Difference in Scores using an Excel formula with cell refe in Scores as a Number with 2 decimal places. 9 Based on your Frequency Distribution from Part 8, create a h each bin using the Title of Bin from the Frequency Distribution an appropriate chart title. -5.67 -5.01 -4.35 -3.69 -3.03 -2.37 -1.70 -1.04 0 2 4 6 8 10 12 14 Score Data Score Frequency

histogram and place it below. Title n table. Please include axis labels and -0.38 0.28 0.94

Competency Analysis Name Difference Data Empirical Rule Scores Before Tutoring Scores After Tutoring Difference in Scores Written Responses

Major Assignment 3 Grading Sh Requirements for full credit You have entered your full name in the field provided. (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 data using Excel functions and appropriate cell references. All cells are explicitly formatted as Numbers with two decimal places. You have calculated the mean, median, standard deviation, and range for the after data using Excel functions and appropriate cell references. All cells are explicitly formatted as Numbers with two decimal places. You have calculated the mean, median, standard deviation, and range for the difference in scores data using Excel functions and appropriate cell references. All cells are explicitly formatted as Numbers with two decimal places. You have calculated the upper and lower limits of the difference in scores using appropriate cell references. All cells are explicitly formatted as Numbers with two decimal places. You have responded to question 4b and have included a discussion of your lower and upper limit from the difference in scores data. Your written responses use complete sentences, proper grammar and punctuation.

Subtotals All cells are explicitly formatted as directed. Subtotals Totals Percentage You have calculated a bin min and max, and bin width using the difference data and appropriate cell references. The Bin Min, Bin Max, and Bin Width are formatted according to the directions. You have calculated lower limits of each class for the frequency distribution using the difference data and appropriate cell references. You have calculated upper limits for each class of the frequency distribution using the difference data and appropriate cell references. You have calculated the midpoint for each class of the frequency distribution using the appropriate cell references. You have calculated the frequency for each class of the frequency distribution using the difference data and appropriate cell references. You have calculated the relative frequency for each class of the frequency distribution using the difference data and appropriate cell references. You have calculated the mean difference in scores based on the Frequency Distribution table using an Excel formula with cell references. The Mean Difference in Scores is formatted according to the directions. You have created a histogram reflecting your frequency distribution with appropriate formatting, including bin titles, chart title, and titles for the x and y axes. Score out of 100

73 0 12 1 22 22 22 22 22 5 8 1 6 143 0 216 0 100.00% 0.00% 125.00 0.00