Description

I will upload documents for assignment

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