Math Is Fun Forum

missbossyy

Member

Registered: 2008-02-01

Posts: 38

Univariate/Multivariate Analysis

Midterm Exam    Final Exam    Final Project
92    92    100
96    100    100
90    84    100
44    64    100
84    88    100
100    92    100
84    80    100
92    100    100
90    80    100
86    92    100
92    88    100
84    84    100
60    96    100
92    84    100
92    92    100
80    72    100
84    88    100
92    76    100
100    72    100
92    80    100
92    88    100
96    84    100
96    88    100
92    88    100
100    88    100
100    88    100
96    84    100
88    80    100
92    84    100
88    80    100
96    96    100
96    84    100
96    88    100
88    76    100
88    80    100
76    92    100
96    96    100
96    76    100
68    80    100
68    60    100
92    84    100
92    84    100
80    88    100
100    84    100
92    88    100
92    92    100
96    88    100
84    80    100
100    92    100
68    72    100
96    92    100
60    80    100
100    96    100
72    92    95
84    88    92
84    88    90
92    84    90
84    84    90
80    84    90
100    88    85
84    88    85
92    92    85
76    72    85
92    76    85
80    84    85
76    84    85
60    68    80
88    88    80
60    68    80
64    72    80
88    80    80
92    92    80
92    92    80
76    64    80
84    68    80
80    80    75
68    60    75
76    68    75
100    96    75
80    80    75
88    72    75
92    92    75
76    44    75
52    76    75
80    64    75
88    84    75
100    76    75
84    80    75
84    68    75
96    80    75
92    100    75
68    76    75
72    92    70
48    72    70
72    80    65
64    80    65
80    60    60
92    92    60
76    64    60
56    56    60
62    60    50

What is the standard deviation of the midterm exam?
What is the standard deviation of the final exam?
What is the standard deviation of the final project?
What percentage of scores are within 1 standard deviation from the mean of the midterm exam?
What percentage of scores are within 2 standard deviations from the mean of the midterm exam?
What percentage of scores are within 1 standard deviation from the mean of the final exam?
What percentage of scores are within 2 standard deviations from the mean of the final exam?
What percentage of scores are within 1 standard deviation from the mean of the final project?
What percentage of scores are within 2 standard deviations from the mean of the final project?
What is the correlation between the midterm exam and the final exam?
What is the correlation between the midterm exam and the final project?
What is the correlation between the final exam and the final project?
Place your answers in an Excel document and upload your file to the Class Grades assignment on Oncourse.

John E. Franklin

Member

Registered: 2005-08-29

Posts: 3,588

Re: Univariate/Multivariate Analysis

There are 101 test takers.
To get the average, total and divide by 101.
Subtract average from each grade, and
square that difference, it will go positive
either way, and add all these 101 squared
differences up.  Now you can either
divide this by 101 or 100 depending on the
kind of standard deviation you want,
according to the internet.  Divide by 101,
unless you've been talk to divide by one
less.  Then after that, take the
square root, and you have your standard
deviation.  I have broken your information
into three columns one after another
below so you can cut and paste it better
into a spreadsheet.  I had a super-duper
programming editor called FASM that let
me cut and paste the columns!!

MidTerm
92
96
90
44
84
100
84
92
90
86
92
84
60
92
92
80
84
92
100
92
92
96
96
92
100
100
96
88
92
88
96
96
96
88
88
76
96
96
68
68
92
92
80
100
92
92
96
84
100
68
96
60
100
72
84
84
92
84
80
100
84
92
76
92
80
76
60
88
60
64
88
92
92
76
84
80
68
76
100
80
88
92
76
52
80
88
100
84
84
96
92
68
72
48
72
64
80
92
76
56
62

FinalExam
92
100
84
64
88
92
80
100
80
92
88
84
96
84
92
72
88
76
72
80
88
84
88
88
88
88
84
80
84
80
96
84
88
76
80
92
96
76
80
60
84
84
88
84
88
92
88
80
92
72
92
80
96
92
88
88
84
84
84
88
88
92
72
76
84
84
68
88
68
72
80
92
92
64
68
80
60
68
96
80
72
92
44
76
64
84
76
80
68
80
100
76
92
72
80
80
60
92
64
56
60

FinalProject
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
100
95
92
90
90
90
90
85
85
85
85
85
85
85
80
80
80
80
80
80
80
80
80
75
75
75
75
75
75
75
75
75
75
75
75
75
75
75
75
75
70
70
65
65
60
60
60
60
50

end of data

---

igloo myrtilles fourmis

missbossyy

Member

Registered: 2008-02-01

Posts: 38

Re: Univariate/Multivariate Analysis

thankss!

John E. Franklin

Member

Registered: 2005-08-29

Posts: 3,588

Re: Univariate/Multivariate Analysis

You're welcome twice ::))

---

igloo myrtilles fourmis