{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Assignment 1

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

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

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

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

View Full Document
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
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<=t) one-tail 0.49 t Critical one-tail 2.65 P(T<=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<=t) one-tail 0.13 t Critical one-tail 2.02 P(T<=t) two-tail 0.25 t Critical two-tail 2.57...
View Full Document

{[ snackBarMessage ]}