QNT561 week 4 excel.xlsx - PayTime 10 12 12 13 13 13 14 14...

This preview shows page 1 - 4 out of 7 pages.

PayTime 10 12 Classwork/Without F 12 13 PayTime 13 13 Mean 18.107692 14 Standard Error 0.4913302 14 Median 17 14 Mode 16 14 Standard Deviation 3.9612304 15 Sample Variance 15.691346 1.69 15 Kurtosis 0.0338122 15 Skewness 0.600799 15 Range 19 15 Minimum 10 15 Maximum 29 15 Sum 1177 16 Count 65 16 Confidence Level(95.0%) 0.9815448 16 High end 95% confidence 19.08924 16 Low end 95% confidence 17.12615 16 16 = 99.99018 16 Homework 16 16 Sample mean 18.10769 17 Sample Size 65 17 Standard Deviation 4.2 17 interval half width 1.021 17 Z value 1.96 17 Confidence Level 95% 17 High End 19.1287 17 Low End 17.0867 17 18 Sample mean 18.10769 18 Sample Size 65 18 Standard Deviation 4.2 18 interval half width 1.3419 18 Z value 2.58 18 Confidence Level 99% 19 High End 19.4496
19 Low End 16.7658 19 19 19 20 4) 20 20 21 21 21 21 22 22 22 23 23 24 24 24 25 25 26 27 29
Formula PayTime Mean 18.107692308 Standard Error 0.4913301593 = 100-CL/100 Median 17 Mode 16 1334.014696 Standard Deviation 3.9612303838 0.475 Sample Variance 15.691346154 Kurtosis 0.033812161 Skewness 0.6007990258 Range 19 0.370132729 NORMAL.DIST Minimum 10 σ= 4.2 Maximum 29 Sample Size 65 Sum 1177 Alpha/2= 0.025 Count 65 stdev XBAR= 18.10769 Confidence Level(99.0%) 1.3044100045 n = 0.05 High end 99% confidenc 19.41210231 µ= 19.5 Low end 99% confidence 16.8032823 ALPHA ALPHA/2 CL 90% 0.1 0.05 = 99.9869559 CL 95% 0.05 0.025 CL 98% 0.02 0.01 CL 99% 0.01 0.005 Z table 95% 2.58 z table 99% 1.96 Confidence interval - mean 95% MARGIN 1.344040384 2.6838 95% confidence level HIGH 19.4496 19.5 18.1076923077 mean LOW 16.7658 3.9612303838 std. dev.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture