MAT-144-RS-MA3 Online 2023 5

Competency Analysis Name Difference Data Percentiles Empirical Rule Visualization Bin Table Scores Before Tutoring Scores After Tutoring Difference in Scores Written Responses Frequency Distribution

Histogram Mean Difference in Scores

The Mean Difference in Scores is formatted according to the directions. Subtotals Totals Percentage Score out of 100 You have calculated the mean difference in scores based on the Frequency Distribution table using an Excel formula with cell references. 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.

et Your points Scoring comments 1 4 16 1 16 1 16 1 8 1 8 1 4 1 79 0 12 1 22 22 22 22 22 5 Points possible

22 Rachael Gordon Student Test Scores Student Score Before Tutoring Score After Tutoring Difference in Scores 1 72.35 67.87 2 78.1 76.39 3 79.42 76.53 4 54.18 50.71 5 53.53 48.85 6 85.66 81.58 7 74.83 69.91 8 77.07 71.64 9 73.37 68.85 10 65.7 59.15 11 77.91 74.41 12 57.96 53.02 13 86.24 81.84 14 72.33 69.87 15 60.97 55.77 16 71.99 68.41 17 76.41 72.75 18 65.53 61.32 19 68.91 63.59 20 75.88 71.36 21 68.24 64.87 22 60.43 55.72 23 63.99 61.98 24 58.77 52.01 1 You have decided to volunteer with an existing organization now in order to gain experience. You choose 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 (t after tutoring. Next, you will perform some calculations based on the statistics you found and the empirica 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

25 75.92 71.25 26 68.14 65.55 27 67.04 65.4 28 56.91 53.14 29 60.04 59.72 30 71.13 68.7 31 81.63 78.82 32 82.87 78.09 33 59.91 57.31 34 65.04 61.11 35 56.06 53.33 36 67.86 64.37 37 78.98 74.5 38 55.32 50.88 39 61.42 59.21 40 64.74 60.47 41 72.76 69.37 42 85.21 82.64 43 80.78 75.98 44 76.33 73.59 45 81.51 77.5 46 68.93 63.96 47 81.82 80.06 48 62.19 57.06 49 77.35 73.11 50 67.81 63.78

Answer: 5b What, if anything, do your calculations in part 5a tell you about the effectiveness of tutoring on s are expected to see improvements within this range?) Justify your answer using the lower limit and u

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 stical analysis of their cores both before and seems to be effective tact the ng or

Student Results Student Differences 1 0 2 0 3 0 4 0 5 0 6 0 7 0 8 0 9 0 10 0 Bin Table 11 0 Bin Min 12 0 Bin Max 13 0 Bin Width 14 0 15 0 Frequency Distribution 16 0 Lower Limit Upper Limit Title of Bin Frequency 17 0 18 0 19 0 20 0 21 0 22 0 23 0 24 0 25 0 26 0 27 0 28 0 29 0 30 0 31 0 6 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 i 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 7 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. Form 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 wi 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 mean Difference in Scores using an Excel formula with cell refe in Scores as a Number with 2 decimal places.

32 0 33 0 34 0 35 0 Mean Difference in Scores 36 0 37 0 38 0 39 0 40 0 41 0 42 0 43 0 44 0 45 0 46 0 47 0 48 0 49 0 50 0 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.

histogram and place it below. Title n table. Please include axis labels and