Excel Assignment 1

Excel Assignment 1 - Mean 15.84 15.71 Variance 119.38 80.19...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Africa S.Asia Mean 137.18 Mean 105.02 Standard Error 11.72 Standard Error 53.41 Median 134 Median 78.04 Mode #N/A Mode #N/A Standard Deviation 52.43 Standard Deviation 106.82 Sample Variance 2748.54 Sample Variance 11411.13 Kurtosis -0.58 Kurtosis 2.56 Skewness -0.38 Skewness 1.38 Range 172.8 Range 250 Minimum 36.2 Minimum 7 Maximum 209 Maximum 257 Sum 2743.5 Sum 420.07 Count 20 Count 4 t-Test: Two-Sample Assuming Unequal Variances Africa S.Asia Mean 137.18 105.02 Variance 2748.54 11411.13 Observations 20 4 Hypothesized Mean Difference 0 df 3 t Stat 0.59 P(T<=t) one-tail 0.3 t Critical one-tail 2.35 P(T<=t) two-tail 0.6 t Critical two-tail 3.18
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
E. Europe M. East Mean 15.84 Mean 15.71 Standard Error 3.86 Standard Error 3.38 Median 13.95 Median 14.9 Mode #N/A Mode #N/A Standard Deviation 10.93 Standard Deviation 8.95 Sample Variance 119.38 Sample Variance 80.19 Kurtosis 4.77 Kurtosis -1.06 Skewness 2.03 Skewness 0.47 Range 34 Range 24.4 Minimum 6.8 Minimum 5 Maximum 40.8 Maximum 29.4 Sum 126.7 Sum 110 Count 8 Count 7 t-Test: Two-Sample Assuming Equal Variances E. Europe M. East
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Mean 15.84 15.71 Variance 119.38 80.19 Observations 8 7 Pooled Variance 101.29 Hypothesized Mean Difference df 13 t Stat 0.02 P(T&lt;=t) one-tail 0.49 t Critical one-tail 2.65 P(T&lt;=t) two-tail 0.98 t Critical two-tail 3.01 SE Asia W. Europe Mean 35.95 Mean 5.78 Standard Error 15.45 Standard Error 1.88 Median 23.1 Median 4.25 Mode #N/A Mode 4.4 Standard Deviation 37.85 Standard Deviation 6.5 Sample Variance 1432.55 Sample Variance 42.27 Kurtosis 1.36 Kurtosis 11.35 Skewness 1.34 Skewness 3.33 Range 100.3 Range 23.7 Minimum 2.7 Minimum 2.5 Maximum 103 Maximum 26.2 Sum 215.7 Sum 69.3 Count 6 Count 12 t-Test: Two-Sample Assuming Unequal Variances SE Asia W. Europe Mean 35.95 5.78 Variance 1432.55 42.27 Observations 6 12 Hypothesized Mean Difference 10 df 5 t Stat 1.3 P(T&lt;=t) one-tail 0.13 t Critical one-tail 2.02 P(T&lt;=t) two-tail 0.25 t Critical two-tail 2.57...
View Full Document

Page1 / 3

Excel Assignment 1 - Mean 15.84 15.71 Variance 119.38 80.19...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online