Your assignment must be submitted using this template. Feel free to add additional work at the bottom, but the top must remain. There are five tables in this worksheet: two for statistical summary, two for confidence intervals, and one for hypothesis tests. To find a table quickly, press Ctrl+G. Press the Tab key to move to input areas of the table. Note: See the worksheet named "Example" (in the bottom tab) for examples of how to fill in the yellow boxes. Blank row, Table 1 begins in A8. Blank row, Table 1 begins in A8. Statistical Summary: Questions 1-4 Confidence Intervals: Questions 1-4 Sample Question Proportion Sample Size #1 0.482 85 #2 0.541 85 #3 0.424 85 #4 0.588 85 End of Table 1, blank row. Table 2 begins in F8. Question Error Lower Limit Upper Limit #1 0.1083949207 0.3736050793 0.5903949207 #2 0.1080999537 0.4329000463 0.6490999537 #3 0.1072049165 0.3167950835 0.5312049165 #4 0.1067721048 0.4812278952 0.6947721048 End of Table 2, blank row. Table 3 begins in A15. Statistical Summary: Questions 5-6 Confidence Intervals: Questions 5-6 Sample Std Sample Question Sample Mean Dev Size #5 41.859 11.342 85 #6 57127.2 15463.538 85 End of Table 3, blank row. Table 4 begins in F15. Blank row. Table 4 begins in F15. Table 5 begins in F21. Question Error Lower Limit Upper Limit Conclusion #5 2.4604252526 39.398574747 44.3194252526 We are 95% confident the true pop #6 3354.5123778 53772.687622 60481.7123778362 We are 95% confident the true pop End of table, blank row. Table 5 begins in F21. End of table, blank row. Table 5 begins in F21. p = 0.60 p 0.60 p 0.55 p < 0.55 Conclusion We are 95% confident the true pop We are 95% confident the true pop We are 95% confident the true pop We are 95% confident the true pop Hypothesis Tests: Questions 1-6 Question Ho #1 p = 0.40 #2 p 0.6 #3 p 0.3 #4 p = 0.50 #5 39 #6 60000 End of table, blank row. Ha p 0.40 p < 0.6 p > 0.3 p 0.50 > 39 > 60000 Reject Ho When z < -1.96 or z > 1.96 z <- 1.645 z > 1.645 z < -1.96 or z > 1.96 z > 1.645 z < -1.645 Rejection criteria: Left-tailed test (one-sided), reject Ho when z < -1.645. Right-tailed test (one-sided), reject Ho when z > 1.645. Test Statistic 1.5431839381 -1.1103396627 2.4947182301 1.6226398245 2.3239885032 -1.7127973764 IMPORTANT: Be sure you change the popula Test Statistic formula to reflect and Ha. Two-tailed test (two-sided), reject Ho when z < -1.96 or z > 1.96. End of worksheet. IMPORTANT: Be sure you change the popula Test Statistic formula to reflect and Ha. % confident the true population proportion is between 0.374 and 0.649 % confident the true population proportion is between 0.433 and 0.649. % confident the true population proportion is between 0.317 and 0.531. % confident the true population proportion is between 0.481 and 0.695. % confident the true population mean is between 39.40 and 44.32 % confident the true population mean is between 53,772.69 and 60481.71 Decision Do not Reject Ho Do not Reject Ho Reject Ho Do not Reject Ho Do not Reject Ho Reject Ho Summary There is not sufficient statistical evidence to show the population proportion is not 0.4 There is not sufficient statistical evidence to show the population proportion is less than 0.60. There is sufficient statistical evidence to show the populaton proportion is greater than 0.30. There is not sufficient statistical evidence to show the population proportion is 0.5. There is sufficient statistical evidence to show the population mean is greater than 39. There is sufficient statistical evidence to show the population mean is less than 60000. TANT: you change the population statistic in the atistic formula to reflect what you put in Ho . TANT: you change the population statistic in the atistic formula to reflect what you put in Ho . The work below uses made-up data. Remember that the values you use in your hypotheses are up to you. You can compare your population parameters to any value; just remember that the sample statistic must agree with your alternate hypothesis. We always try to reject the null hypothesis; that means we must have evidence (via the sample statistic) that the alternate hypothesis is true. Click in the cell to see the formula used. Blank row, Table 1 begins in A8. Blank row, Table 1 begins in A8. Statistical Summary: Questions 1-4 Confidence Intervals: Questions 1-4 Sample Question Proportion Sample Size #1 0.56 61 #2 0.43 61 #3 0.48 61 #4 0.44 61 End of Table 1, blank row. Table 2 begins in F8. Question Error Lower Limit Upper Limit #1 0.1271116716 0.4328883284 0.6871116716 #2 0.1267759092 0.3032240908 0.5567759092 #3 0.1279344094 0.3520655906 0.6079344094 #4 0.1271116716 0.3128883284 0.5671116716 End of Table 2, blank row. Table 3 begins in A15. Statistical Summary: Questions 5-6 Confidence Intervals: Questions 5-6 Sample Std Sample Question Sample Mean Dev Size #5 3.61 1.43 61 #6 492.03 136.62 61 End of Table 3, blank row. Table 4 begins in F15. Blank row. Table 4 begins in F15.Remember that the values used in the Table 5 begins in F21. hypotheses are whatever you want; just make sure the sample statistic supports Ha. FORMAT HINT: Copy the math notation to another cell using copy, then paste. Right-click in the cell to see these options. Question Error Lower Limit Upper Limit #5 0.3661854766 3.2438145234 3.9761854766 #6 34.984797073 457.04520293 527.0147970729 End of table, blank row. Table 5 begins in F21. End of table, blank row. Table 5 begins in F21. Hypothesis Tests: Questions 1-6 Question Ho #1 p 0.55 #2 p 0.50 #3 p = 0.60 #4 p 0.75 #5 = 17 #6 119 End of table, blank row. Ha p < 0.55 p > 0.50 p 0.60 p < 0.75 17 > 119 Reject Ho When z < -1.645 z > 1.645 z < -1.96 or z > 1.96 z < -1.645 z < -1.96 or z > 1.96 z > 1.645 Rejection criteria: Left-tailed test (one-sided), reject Ho when z < -1.645. Right-tailed test (one-sided), reject Ho when z > 1.645. Two-tailed test (two-sided), reject Ho when z < -1.96 or z > 1.96. End of worksheet. alternate hypothesis. e hypothesis is true. Conclusion We are 95% confident the true population proportion is between 0.293 and 0.547 We are 95% confident the true population proportion is between 0.604 and 0.836. We are 95% confident the true population proportion is between 0.453 and 0.707. We are 95% confident the true population proportion is between 0.527 and 0.773. Conclusion We are 95% confident the true population mean is between 14.72 and 15.92. We are 95% confident the true population mean is between 118.17 and 123.95. Test Statistic Decision 0.1569919254 Reject Ho -1.0934349546 Reject Ho -1.913112647 Do not Reject Ho -5.5914696935 Reject Ho -73.1323378744 Reject Ho 21.3252630406 Do not Reject Ho Summary There is sufficient statistical evidence to show the population proportion is less than 0.55. There is sufficient statistical evidence to show the population proportion is greater than 0.50. There is not sufficient statistical evidence to show the populaton proportion is not 0.60. There is sufficient statistical evidence to show the population proportion is less than 0.75. There is sufficient statistical evidence to show the population mean is not 17. There is not sufficient statistical evidence to show the population mean is greater than 119. IMPORTANT: Be sure you change the population statistic in the Test Statistic formula to reflect what you put in Ho and Ha. IMPORTANT: Be sure you change the population statistic in the Test Statistic formula to reflect what you put in Ho and Ha. al evidence to show the population proportion is less than 0.55. al evidence to show the population proportion is greater than 0.50. stical evidence to show the populaton proportion is not 0.60. al evidence to show the population proportion is less than 0.75. al evidence to show the population mean is not 17. stical evidence to show the population mean is greater than 119. Discussion board Enter your data in this column Mean = Median = Mode = Variance = Standard Deviation Max = Min = Range 1.200 1 1 0.800 0.894 3 0 3 Level of confidence Alpha value Sample size 90% 0.10 18 Z-critical value (1-tail) Z-critical value (2-tail) 1.282 1.645 T-critical value (1-tail) T-critical value (2-tail) 1.333 1.740 Chi Square (Right) Chi Square (Left) 10.085 24.769 1 0 1 2 0 0 1 2 2 2 2 1 1 3 2 0 1 2 0 1 TOPIC: Is the mean number of prime numbers in winning lottery combinations less than or equal to Hypothesis Test Ho: u > Predicted Value Ha: u < Predicted Value Alpha Leval Critical Value Standardized Value Reject / Fail to Reject ? (1Tail / Left Tail) u>2 u<2 t = (x - u)> Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Right Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u > Predicted Value Ha: u < Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Left Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u = Predicted Value Ha: u Predicted Value Alpha Leval Critical Value #1 (left critical) Critical Value #2 (right critical) Standardized Value Reject / Fail to Reject ? (2-Tail Test) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #DIV/0! If your value in Line 8 is greater than the value in Line 7, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #DIV/0! If your value in Line 18 is less than the value in Line 17, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! #DIV/0! You will REJECT if you have either of the following: (a) your value in Line 29 is less than the value in Line 27; or (b) your value in Line 29 is greater than your value in Line 27. Otherwise, you FAIL TO REJECT Enter your data in this column Mean = Median = Mode = 0.500 0.5 1 Variance = Standard Deviation Max = Min = Range 0.255 0.505 1 0 1 Level of confidence Alpha value Sample size 90% 0.10 52 Z-critical value (1-tail) Z-critical value (2-tail) 1.282 1.645 T-critical value (1-tail) T-critical value (2-tail) 1.298 1.675 Chi Square (Right) Chi Square (Left) 38.560 64.295 1 0 0 1 1 1 0 1 0 0 0 0 0 0 1 0 0 0 0 1 1 1 0 1 1 1 1 0 1 1 0 1 1 0 0 1 1 0 0 0 1 0 0 0 1 1 1 1 0 0 1 1 1 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1 0 1 1 1 1 1 1 1 Hypothesis Test Ho: u < Predicted Value Ha: u > Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Right Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u > Predicted Value Ha: u < Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Left Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u = Predicted Value Ha: u Predicted Value Alpha Leval Critical Value #1 (left critical) Critical Value #2 (right critical) Standardized Value Reject / Fail to Reject ? (2-Tail Test) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 8 is greater than the value in Line 7, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 18 is less than the value in Line 17, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! #VALUE! You will REJECT if you have either of the following: (a) your value in Line 29 is less than the value in Line 27; or (b) your value in Line 29 is greater than your value in Line 27. Otherwise, you FAIL TO REJECT Mean = Median = Mode = 0.574 1 1 Variance = Standard Deviation Max = Min = Range 0.249 0.499 1 0 1 Level of confidence Alpha value Sample size 90% 0.10 52 Z-critical value (1-tail) Z-critical value (2-tail) 1.282 1.645 T-critical value (1-tail) T-critical value (2-tail) 1.298 1.675 Chi Square (Right) Chi Square (Left) 38.560 64.295 Enter your data in this column 0 1 0 1 1 0 1 0 0 0 1 0 1 0 1 1 1 0 1 1 1 1 1 0 0 1 1 0 1 1 1 1 0 0 0 0 0 1 0 1 1 0 1 1 1 1 0 0 1 0 1 1 0 1 1 1 0 0 0 1 0 0 1 0 1 0 0 0 0 0 1 0 1 1 1 1 1 0 1 0 0 1 1 1 0 Hypothesis Test Ho: u < Predicted Value Ha: u > Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Right Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u > Predicted Value Ha: u < Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Left Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u = Predicted Value Ha: u Predicted Value Alpha Leval Critical Value #1 (left critical) Critical Value #2 (right critical) Standardized Value Reject / Fail to Reject ? (2-Tail Test) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 8 is greater than the value in Line 7, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 18 is less than the value in Line 17, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! #VALUE! You will REJECT if you have either of the following: (a) your value in Line 29 is less than the value in Line 27; or (b) your value in Line 29 is greater than your value in Line 27. Otherwise, you FAIL TO REJECT Mean = Median = Mode = 0.426 0 0 Variance = Standard Deviation Max = Min = Range 0.249 0.499 1 0 1 Level of confidence Alpha value Sample size 90% 0.10 52 Z-critical value (1-tail) Z-critical value (2-tail) 1.282 1.645 T-critical value (1-tail) T-critical value (2-tail) 1.298 1.675 Chi Square (Right) Chi Square (Left) 38.560 64.295 Enter your data in this column 1 1 1 0 1 1 0 0 1 1 1 0 0 0 0 0 0 1 0 1 1 1 1 1 0 0 1 1 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 1 0 1 1 0 0 0 0 0 1 1 1 0 0 1 0 0 0 1 1 1 0 0 1 1 1 0 0 0 0 0 0 0 1 0 0 1 0 0 1 Hypothesis Test Ho: u < Predicted Value Ha: u > Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Right Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u > Predicted Value Ha: u < Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Left Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u = Predicted Value Ha: u Predicted Value Alpha Leval Critical Value #1 (left critical) Critical Value #2 (right critical) Standardized Value Reject / Fail to Reject ? (2-Tail Test) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 8 is greater than the value in Line 7, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 18 is less than the value in Line 17, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! #VALUE! You will REJECT if you have either of the following: (a) your value in Line 29 is less than the value in Line 27; or (b) your value in Line 29 is greater than your value in Line 27. Otherwise, you FAIL TO REJECT Mean = Median = Mode = 0.593 1 1 Variance = Standard Deviation Max = Min = Range 0.246 0.496 1 0 1 Level of confidence Alpha value Sample size 90% 0.10 52 Z-critical value (1-tail) Z-critical value (2-tail) 1.282 1.645 T-critical value (1-tail) T-critical value (2-tail) 1.298 1.675 Chi Square (Right) Chi Square (Left) 38.560 64.295 Enter your data in this column 1 1 1 1 1 0 1 1 0 1 1 0 0 1 1 1 1 0 1 0 0 0 1 0 0 1 1 1 0 1 1 1 1 1 1 0 0 1 0 0 0 0 1 0 1 1 1 0 1 1 0 1 0 0 1 1 1 1 0 1 1 0 1 1 0 0 0 1 0 1 1 1 1 0 1 0 1 0 1 1 0 1 0 0 0 Hypothesis Test Ho: u < Predicted Value Ha: u > Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Right Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u > Predicted Value Ha: u < Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Left Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u = Predicted Value Ha: u Predicted Value Alpha Leval Critical Value #1 (left critical) Critical Value #2 (right critical) Standardized Value Reject / Fail to Reject ? (2-Tail Test) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 8 is greater than the value in Line 7, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 18 is less than the value in Line 17, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! #VALUE! You will REJECT if you have either of the following: (a) your value in Line 29 is less than the value in Line 27; or (b) your value in Line 29 is greater than your value in Line 27. Otherwise, you FAIL TO REJECT Mean = Median = Mode = 42.444 43 33 Variance = Standard Deviation Max = Min = Range 152.553 12.351 65 21 44 Level of confidence Alpha value Sample size 90% 0.10 52 Z-critical value (1-tail) Z-critical value (2-tail) 1.282 1.645 T-critical value (1-tail) T-critical value (2-tail) 1.298 1.675 Chi Square (Right) Chi Square (Left) 38.560 64.295 Enter your data in this column 21 52 37 54 55 33 48 33 30 43 46 26 24 37 55 39 52 34 59 60 63 65 44 35 31 64 33 25 53 50 50 43 32 44 42 22 25 62 26 45 41 37 49 45 47 60 30 33 56 29 52 54 24 43 57 37 43 44 30 39 33 34 57 31 64 36 30 38 32 39 50 28 57 55 45 42 42 35 32 34 41 47 45 34 35 Hypothesis Test Ho: u < Predicted Value Ha: u > Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Right Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u > Predicted Value Ha: u < Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Left Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u = Predicted Value Ha: u Predicted Value Alpha Leval Critical Value #1 (left critical) Critical Value #2 (right critical) Standardized Value Reject / Fail to Reject ? (2-Tail Test) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 8 is greater than the value in Line 7, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 18 is less than the value in Line 17, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! #VALUE! You will REJECT if you have either of the following: (a) your value in Line 29 is less than the value in Line 27; or (b) your value in Line 29 is greater than your value in Line 27. Otherwise, you FAIL TO REJECT Mean = Median = Mode = 58843.778 58003.5 #VALUE! Variance = Standard Deviation Max = Min = Range 234906266.214 15326.652 103205 30939 72266 Level of confidence Alpha value Sample size 90% 0.10 52 Z-critical value (1-tail) Z-critical value (2-tail) 1.282 1.645 T-critical value (1-tail) T-critical value (2-tail) 1.298 1.675 Chi Square (Right) Chi Square (Left) 38.560 64.295 Enter your data in this column 66055 84412 71656 37002 52531 43384 103205 71616 62495 62265 45168 30939 67215 48875 72768 54676 42795 67809 62967 68186 52948 46562 71791 35042 33424 79445 48301 61789 53129 74688 55045 45993 45302 62685 38382 45756 65701 55618 50113 71472 58609 31464 57398 44941 70638 73569 65596 78976 54074 65709 56955 71131 47122 92177 69096 36178 40473 82117 67560 67613 44310 82892 39803 62348 32533 58056 47618 82585 39549 44814 74441 53348 43074 36618 75567 38400 32447 59598 38832 59161 49339 46922 50761 61265 60930 Hypothesis Test Ho: u < Predicted Value Ha: u > Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Right Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u > Predicted Value Ha: u < Predicted Value Alpha Leval Critical Value Standardized Value (1Tail / Left Tail) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Reject / Fail to Reject ? Hypothesis Test Ho: u = Predicted Value Ha: u Predicted Value Alpha Leval Critical Value #1 (left critical) Critical Value #2 (right critical) Standardized Value Reject / Fail to Reject ? (2-Tail Test) ENTER Null Hypothesis here! ENTER Alternative here! Z = (x - u) / (s / n) Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 8 is greater than the value in Line 7, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! If your value in Line 18 is less than the value in Line 17, then you REJECT. Else, you FAIL TO REJECT Using the Normal Distribution ENTER VALUE FROM HYPOTHESIS HERE! ENTER ALPHA (e.g. 0.1, 0.05, 0.01) #VALUE! #VALUE! #VALUE! You will REJECT if you have either of the following: (a) your value in Line 29 is less than the value in Line 27; or (b) your value in Line 29 is greater than your value in Line 27. Otherwise, you FAIL TO REJECT Design a Focused Survey Template Kris Shanks Date: 29 July 2017 Instructions: Record your responses on the template below each question and submit your completed template to the appropriate assignment. Do not change any of the items on the template except to add or delete space. 1. State the population of your study. You should be able to do this in one to three sentences. Include specific characteristics including age range, gender, location, and any other identifiers that are unique and relevant to your population. The population included in the survey would be federal employees who have been in the same position for at least 5 years and also government employees working for at least 5 years. Choosing employees that have been in the position at least 5 years it will cut down on contractors/government employees used as short-term workers. The purpose of the study is to see if contractors being worked inappropriately are cheaper or more costly due to productivity levels. 2. Describe your sampling strategy. Write at least one paragraph describing your sampling strategy, how you would attempt to conduct your survey, and any potential issues that might affect your survey results. You should use one of the following techniques: random, stratified, cluster, systematic, or convenience. Your choice of strategy should be based on the purpose of your survey and your population. Stratified random sampling method to select a specific number of government contractors, who have been working long-term contracts and an equal number of permanent federal employees to be my sample. An equal number of contractors and federal employees is important to ensure data is accurate and not favoring one specific group 1 Table 1 Question Type Typical Response Minimum Maximum In your department do contract employees and federal employees perform similar jobs Binomial Yes/75% n/a n/a Do you believe you are compensated for the work performed Binary N0/40% n/a n/a Do you have additional duties outside your statement of work? Binary Yes/65% n/a n/a Would benefit of job security increase or decrease your job performance? Binary Yes/55% n/a n/a What is your weekly work hours Quantitative 40 20 65 What is your yearly income Quantitative 60000 25000 120000 Question 2 Sample of Q1 - Q4 Sample Size Proportion of 0's Proportion of 1's 21 0.2380952381 0.7619047619 Sample of Q5 - Q6 Mean = Median = Mode = Variance = Standard Deviation Max = Min = Range 66666.66666667 60000 60000 806666666.6667 28401.87787219 120000 10000 110000 Enter your data in this column 1 1 1 1 0 0 0 1 1 1 0 1 1 1 1 1 0 1 1 1 1 Enter your data in this column (arrange from low to high) 10000 10000 20000 30000 30000 30000 30000 30000 40000 40000 40000 40000 40000 40000 C Proportion of 50000 50000 50000 60000 60000 60000 60000 60000 60000 60000 60000 60000 70000 70000 70000 80000 80000 80000 80000 80000 90000 90000 90000 90000 90000 90000 90000 90000 90000 100000 100000 100000 110000 110000 110000 110000 120000 120000 10 9 8 7 6 5 4 3 2 1 0 Chart Title Proportion of 0's; 24% Proportion of 1's; 76% Salary values Frequency $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 2 1 5 6 3 9 3 5 9 $100,000 $110,000 $120,000 3 4 2 10 9 8 7 6 5 4 3 2 1 0 Column G Sample Size Proportion of 0's Proportion of 1's 85 0.5176470588 0.4823529412 Enter your data in this column 1 0 0 1 1 1 0 1 0 0 0 0 0 0 1 0 0 0 0 1 1 1 0 1 1 1 1 0 1 1 0 1 1 0 0 1 1 0 0 0 1 0 Propor 0 0 1 1 1 1 0 0 1 1 1 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1 0 1 1 1 1 1 1 1 Chart Title Proportion of 1's; 48% Proportion of 0's; 52% Sample Size Proportion of 0's Proportion of 1's 85 0.4588235294 0.5411764706 Enter your data in this column 0 1 0 1 1 0 1 0 0 0 1 0 1 0 1 1 1 0 1 1 1 1 1 0 0 1 1 0 1 1 1 1 0 0 0 0 0 1 0 1 1 0 Prop 1 1 1 1 0 0 1 0 1 1 0 1 1 1 0 0 0 1 0 0 1 0 1 0 0 0 0 0 1 0 1 1 1 1 1 0 1 0 0 1 1 1 0 Chart Title Proportion of 0's; 46% Proportion of 1's; 54% Sample Size Proportion of 0's Proportion of 1's 85 0.5764705882 0.4235294118 Enter your data in this column 1 1 1 0 1 1 0 0 1 1 1 0 0 0 0 0 0 1 0 1 1 1 1 1 0 0 1 1 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 1 0 1 1 0 0 0 0 0 1 1 1 0 0 1 0 0 0 1 1 1 0 0 1 1 1 0 0 0 0 0 0 0 1 0 0 1 0 0 1 Chart Title Proportion of 1's; 42% Proportion of 0's; 58% Sample Size Proportion of 0's Proportion of 1's 85 0.4117647059 0.5882352941 Enter your data in this column 1 1 1 1 1 0 1 1 0 1 1 0 0 1 1 1 1 0 1 0 0 0 1 0 0 1 1 1 0 1 1 1 1 1 1 0 0 1 0 0 0 0 1 0 1 1 1 0 1 1 0 1 0 0 1 1 1 1 0 1 1 0 1 1 0 0 0 1 0 1 1 1 1 0 1 0 1 0 1 1 0 1 0 0 0 Chart Title Proportion of 0's; 41% Proportion of 1's; 59% Mean = Median = Mode = Variance = Standard Deviation Max = Min = Range 41.8588235294 42 33 128.6464985994 11.3422439843 65 21 44 Enter your data in this column 21 52 37 54 55 33 48 33 30 43 46 26 24 37 55 39 52 34 59 60 63 65 44 35 31 64 33 25 53 50 50 43 32 44 42 22 25 62 26 45 41 37 49 45 47 60 30 33 56 29 52 54 24 43 57 37 43 44 30 39 33 34 57 31 64 36 30 38 32 39 50 28 57 55 45 42 42 35 32 34 41 47 45 34 35 Mean = Median = Mode = Variance = Standard Deviation Max = Min = Range 57127.2 56955 #VALUE! 239121008.7095 15463.53803984 103205 30939 72266 Enter your data in this column 66055 84412 71656 37002 52531 43384 103205 71616 62495 62265 45168 30939 67215 48875 72768 54676 42795 67809 62967 68186 52948 46562 71791 35042 33424 79445 48301 61789 53129 74688 55045 45993 45302 62685 38382 45756 65701 55618 50113 71472 58609 31464 57398 44941 70638 73569 65596 78976 54074 65709 56955 71131 47122 92177 69096 36178 40473 82117 67560 67613 44310 82892 39803 62348 32533 58056 47618 82585 39549 44814 74441 53348 43074 36618 75567 38400 32447 59598 38832 59161 49339 46922 50761 61265 60930