Education Major Assignment 3
MyraliaRose3.
MAT-144-RS-ONL-T6-MA3Fa25Explanation.pptxMajor Assignment 3
Analysis and visualization
Analysis – Part 2
Enter your full name in the blue cell in Part 2 to generate the scores in the columns below.
Analysis – Part 3a
Start by finding the Difference in Scores
Difference in Scores = After - Before
Then find the Mean, Median, Standard Deviation, and Range for the Scores Before Tutoring, Scores After Tutoring, and the Difference in Scores
Mean Function
=AVERAGE()
Median Function
=MEDIAN()
Standard Deviation Function
=STDEV()
Range Formula with Functions
=MAX() – MIN()
See the next slide for resources on how to use the functions.
Analysis – Part 3a cont.
=AVERAGE()
https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6
=MEDIAN()
https://support.microsoft.com/en-us/office/median-function-d0916313-4753-414c-8537-ce85bdd967d2
=STDEV()
https://support.microsoft.com/en-au/office/stdev-function-51fecaaa-231e-4bbb-9230-33650a72c9b0
=MAX() – MIN()
MAX()
https://support.microsoft.com/en-gb/office/max-function-e0012414-9ac8-4b34-9a47-73e662c08098
MIN()
https://support.microsoft.com/en-us/office/min-function-61635d12-920f-4ce2-a70f-96f202dcc152
Analysis – Part 4
Use the =PERCENTILE() function to find the appropriate percentiles.
=PERCENTILE(Difference in Scores, percentile as a decimal)
Analysis – Part 5
Use the Empirical Rule and calculations from part 3a to find the Lower Limit and Upper Limit for which the given percentage of Difference in Scores fall between.
The Empirical Rule
Approximately 68% of the area under the curve lies within one standard deviation of the mean.
Approximately 95% of the area under the curve lies within two standard deviations of the mean.
Approximately 99.7% of the area under the curve lies within three standard deviations of the mean.
Then answer the question in part 5b based on your response in part 5a. Follow any special directions provided by your instructor.
Empirical Rule
Visualization – Part 7
Start by finding the Bin Min, Bin Max, and Bin Width for the Difference in Scores. Include a buffer of 0.1 in the Bin Min and Bin Max for technical reasons.
Bin Min =MIN(Differences) – 0.1
Bin Max =MAX(Differences) + 0.1
Bin Width =(Bin Max – Bin Min)/Number of Bins
Visualization – Part 7 cont.
Lower Limits
The first Lower Limit is the Bin Min
The remaining Lower Limits are the previous Upper Limit
Upper Limits = Lower Limit + Bin Width
Title of Bin = (Upper Limit + Lower Limit)/2
Frequency
=COUNTIFS(Difference in Scores, “>”& Lower Limits, Difference in Scores, “<=“& Upper Limits)
https://support.microsoft.com/en-gb/office/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842
Relative Frequency =Frequency/COUNT(Differences)
Visualization – Part 8
Create a histogram modeling the frequencies with an appropriate title and axis labels. Title each bin using the Title of Bin from part 7.
