COMPUTE ALL DESCRIPTIVE STATISTICS using the tool of your choice. If you use the

Question

COMPUTE ALL DESCRIPTIVE STATISTICS using the tool of your choice. If you use the excel tool “descriptive statistics” be sure you complete your solution by given the missing descriptive statistics (inter-quartiles, coefficient of variation). Double check the mode value(s). The excel tool gives only one mode value even if the set is multimode. Show the Excel output.

PROBLEM 4: Quiz scores L (from 0 to 10)

n = 16 students

5     0     9     10     6     10     8     0     0     7     10         0      0    6     7    8

Explanation / Answer

Quiz Score 0 0 0 0 0 5 6 6 7 7 8 8 9 10 10 10 Mean 5.375 Average(D2:D17) Median 6.5 Median(D2:D17) Mode 0 Mode(D2:D17) Range 10 D17-D2 Q1 0 Quartile(D2:D17,1) Q3 8.25 Quartile(D2:D17,3) IQR 8.25 Q3-Q1 Count 16 Count(D2:D17) Sum 86 Sum(D2:D17) Maximum 10 Max(D2:D17) Minimum 0 Min(D2:D17) Skewness -0.45549997 Skew(D2:D17) Kutosis -1.473316185 Kurt(D2:D17) Sample Variance 16.11666667 Var(D2:D17) Standard Deviation 4.014556846 StdDev(D2:D17) Standard Error 1.003639211 S.D/sqrt(Count) CV 74.68942969 S/X*100

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.