Description
I will post assignment and instructions in attachments Please use name Justin if asked
Unformatted Attachment Preview
Major Assignment Video Resources
*No major formulas are shown in the videos. The videos focus on what should be completed in each
part and the expectations.
Major Assignment 3
–
General Information: https://youtu.be/iK-jz4k07KI
Analysis: https://youtu.be/Wg6rdxTGCSM
Visualization: https://youtu.be/gs8l_8ndmE0
Major Assignment 3
ANALYSIS AND VISUALIZATION
Analysis – Part 2
1. Enter your full
name in the blue
cell in Part 2 to
generate the
scores in the
columns below.
Analysis – Part 3a
1.
Start by finding the Difference in Scores
2.
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
Median Function
=STDEV()
Range Formula with Functions
3.
=MEDIAN()
Standard Deviation Function
=AVERAGE()
=MAX() – MIN()
See the next slide for resources on how to
use the functions.
Analysis – Part 3a
cont.
=AVERAGE()
=MEDIAN()
https://support.microsoft.com/en-us/office/median-function-d0916313-4753-414c-8537-ce85bdd967d2
=STDEV()
https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6
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)
https://support.microsoft.com
/en-gb/office/percentilefunction-91b43a53-543c-470893ded626debdddca#:~:text=Retur
ns%20the%20k%2Dth%20perc
entile,score%20above%20the
%2090th%20percentile.
Analysis –
Part 5
1.
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.
2.
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
1.
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.
2.
Lower Limits
The first Lower Limit is the Bin Min
The remaining Lower Limits are the
previous Upper Limit
3.
Upper Limits = Lower Limit + Bin Width
4.
Title of Bin = (Upper Limit + Lower Limit)/2
5.
Frequency
6.
=COUNTIFS(Difference in Scores, “>”&
Lower Limits, Difference in Scores,
“
Purchase answer to see full
attachment
