Major Assignment 3 upload

0 student Student Test Scores Student Score Before Tutoring Score After Tutoring Difference in Scores 1 66.26 65.03 -1.23 2 49.92 47.47 -2.45 3 60.97 58.22 -2.75 4 64.58 63.06 -1.52 5 100 94.9 -5.09999999999999 6 70.14 67.1 -3.04000000000001 7 75.27 75.84 0.570000000000007 8 62.48 60.22 -2.26 9 53.24 53.12 -0.120000000000005 10 82.24 80.64 -1.59999999999999 11 92.88 91.33 -1.55 12 49.73 46.97 -2.76 13 54.34 51.72 -2.62 14 86.38 82.12 -4.25999999999999 15 80.37 76.7 -3.67 16 65.44 66.26 0.820000000000007 1 Since your service project is 5 years in the future, you decide to volunteer with an existing organ high school students in math. They have tasked you to do some statistical analysis of their program Below, you will compare students' test scores for their math class before and after they received tut standard deviation of their scores both before and after tutoring. Next, you will perform some calcu questions based on your findings to demonstrate whether the tutoring program seems to be effectiv 2 Enter your full name in the cell to the right. Assignment Advisory : (This is provided free by GCU; contact the Help of Excel or a different spreadsheet program m temp

17 93.43 91.73 -1.7 18 100 99 -1 19 47.42 42.06 -5.36 20 74.48 72.85 -1.63000000000001 21 57.86 56.21 -1.65 22 92.94 91.45 -1.49 23 86.34 84.95 -1.39 24 50.95 50.55 -0.400000000000006 25 35.13 29.79 -5.34 26 46.07 44.57 -1.5 27 76.58 73.3 -3.28 28 80.36 77.7 -2.66 29 68.75 69.74 0.989999999999995 30 66.98 60.84 -6.14 31 88.57 84.84 -3.72999999999999 32 88.81 85.3 -3.51000000000001 33 73.07 76.34 3.27000000000001 34 96.38 92.2 -4.17999999999999 35 55.21 51.67 -3.54 36 92.39 92.36 -0.030000000000001 37 73.86 72.66 -1.2 38 84.1 82.42 -1.67999999999999 39 35.32 37.44 2.12 40 66.78 62.64 -4.14 41 83.29 84.04 0.75 42 48.92 47.97 -0.950000000000003 43 80.47 78.39 -2.08 44 87.59 86.08 -1.51000000000001 45 79.2 76.76 -2.44 46 66.4 65.77 -0.63000000000001 47 72.35 70.39 -1.95999999999999 48 60.2 57.36 -2.84 49 91.87 87.39 -4.48 50 71.8 68.26 -3.53999999999999

Range 9.41 68% of Differences Lower Limit -3.97 Upper Limit -0.12 shows little im the the same 4.71. There is the tutoring b 4 Use the calculations above and the Empirical Rule to calculate the upper and lower limits which 68% (~68.27%) of the differences in scores fall between. Use Excel formulas with cell references and format each value to Number with two decimal places. 5c What, if a test scores? (H using the lowe Based on the scores after tu of tutoring is

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 e questions below based on the statistics you found in part 3 and 4. appear the tutoring has made a difference? Include a discussion of the means and m the before, after, and difference data to justify your answer. tutoring has made a slight difference in the student's test scores. Though, the difference in y slight. The difference in the mean between the two scores is 0.88. The difference in the ween the two scores is 0.61. The average score is still in the 60's. Nobody improved over 5% and ts' scores went down from their original score the standard deviations and ranges of the before, after, and difference data tell us test scores? Justify your answer using the values of standard deviation you r each data set. standard deviations in the before tutoring vs after tutoring and fairly close. After tutoring has a dard deviation but only barely. The standard deviation after the difference is a 1.09. Which mprovement in the before and after. The ranges of the before tutoring and after tutoring lead

Student Results Student Differences 1 -1.23 2 -2.45 3 -2.75 4 -1.52 5 -5.1 6 -3.04 7 0.57 Bin Table 8 -2.26 Bin Min -6.14 9 -0.12 Bin Max 3.27 10 -1.6 Bin Width 0.86 11 -1.55 12 -2.76 Frequency Distribution 13 -2.62 Lower Limit Upper Limit Title of Bin Frequency 14 -4.26 -6.14 -5.28 -5.71 3 15 -3.67 -5.28 -4.42 -4.85 2 16 0.82 -4.42 -3.56 -3.99 5 17 -1.7 -3.56 -2.70 -3.13 8 18 -1 -2.70 -1.84 -2.27 7 19 -5.36 -1.84 -0.98 -1.41 14 20 -1.63 -0.98 -0.12 -0.55 4 21 -1.65 -0.12 0.74 0.31 2 22 -1.49 0.74 1.60 1.17 3 23 -1.39 1.60 2.46 2.03 1 24 -0.4 2.46 3.27 2.87 1 25 -5.34 26 -1.5 27 -3.28 28 -2.66 29 0.99 30 -6.14 31 -3.73 32 -3.51 6 Now that you have finished your analysis of score data for students receiving tutoring, the organ to a group of potential donors who are interested in seeing how effective the program is before they results. Below are the test score differences you calculated in part 1 of this assignment. First, use the data t regarding what patterns you can see from the frequency distribution and histogram. 7 Create a frequency distribution of the test score differen 50 students. Find the lower limit and upper limit of each c the Bin Table values below, and then find the frequency f those classes. The title of the bin should reflect the midpo lower and upper limit. Excel formulas with cell reference used for all calculations. All lower and upper limits, and b should be formatted to number with 2 decimal places. All should be formatted to number with no decimal places. 8 Based on your frequency distribution from part 7, creat histogram and place it here. Be sure to include the bin titl appropriate titles for the chart and the x and y axes.

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 nization has given you a task - demonstrating the tutoring program is working. The organization wou y contribute any money. You have decided to create a frequency distribution and histogram so they c to create a frequency distribution. Next, create a histogram based on your frequency distibution. Fin nces for the class using for each of oint of the es should be bin titles l Frequencies 9 What patterns do you see in the frequency distribution and histogram? on just these two visualizations, that the tutoring is making a difference? There is evidence based on both the Histogram and the table that th impove test scores. That the score improvement or the score going d how effective tutoring is, rather it may reflect on the individual stud improvemnt is low, and based on the histogram, we see that more st earning more in their retakes. The conclusion that can be drawn is, than good, if it makes any difference at all. te a les as well as 0 2 4 6 8 10 12 14 16 Improvement Frequency Student

-5.71 -4.85 -3.99 -3.13 -2.27 -1.41 -0.55 0.31 1.17 2 0 Differences

2.03 2.87

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

Major Assignment 3 Grading S Requirements for full credit You have entered your full name in the field provided. All cells are explicitly formatted to two decimal places. All cells are explicitly formatted to two decimal places. All cells are explicitly formatted to two decimal places. All cells are explicitly formatted to two decimal places. Subtotals (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. You have calculated the mean, median, standard deviation, and range for the after data using Excel functions and appropriate cell references. You have calculated the mean, median, standard deviation, and range for the difference in scores data using Excel functions and appropriate cell references. You have calculated the upper and lower limits of the difference in scores using appropriate cell references. You have responded to question 5a and have included a discussion of your means and medians from all three data sets. You have responded to question 5b and have included a discussion of your standard deviations and ranges from all three data sets. You have responded to question 5c 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.

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. 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 created a histogram reflecting your frequency distribution with appropriate formatting, including bin titles, chart title, and titles for the x and y axes. You have responded to question 9 and have included a discussion of your frequency distribution and histogram in your response. Your written response uses complete sentences, proper grammar and punctuation. Scaled out of 125