KGarmon_MATFPX2001_Assessment4

xlsx

School

Capella University *

*We aren’t endorsed by this school

Course

2001

Subject

Statistics

Date

Apr 3, 2024

Type

xlsx

Pages

10

Report

Uploaded by SargentSeahorse7843

Your assessment 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. Confidence Intervals: Questions 1–4 Question Sample Size Question Error Lower Limit Upper Limit #1 0.45 55 #1 0.1341640786 0.3158359214 0.584164078649987 #2 0.47 55 #2 0.1345970417 0.3354029583 0.604597041707326 #3 0.51 55 #3 0.1348130018 0.3751869982 0.644813001800811 #4 0.49 55 #4 0.1348130018 0.3551869982 0.624813001800811 End of Table 1, blank row. Table 2 begins in F8. End of Table 2, blank row. Table 3 begins in A15. Statistical Summary: Questions 5–6 Confidence Intervals: Questions 5–6 Question Sample Mean Question Error Lower Limit Upper Limit #5 40186.11 14110.94 55 #5 3805.4375229 36380.672477 43991.5475228908 #6 24.4 6.24 55 #6 1.6828028567 22.717197143 26.0828028567083 End of Table 3, blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21. Blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21. Table 5 begins in F21. Hypothesis Tests: Questions 1–6 Question Ho Ha Reject Ho When #1 p=0.5 p≠0.5 z < -1.96 or z > 1.96 #2 p=0.5 p≠0.5 z < -1.96 or z > 1.96 #3 p=0.5 p≠0.5 z < -1.96 or z > 1.96 #4 p=0.5 p≠0.5 z < -1.96 or z > 1.96 #5 μ=40000 μ≠40000 z < -1.96 or z > 1.96 #6 μ=23 μ≠23 z < -1.96 or z > 1.96 End of table, blank row. Rejection criteria: Left-tailed test, reject Ho when z < -1.645. Right-tailed test, reject Ho when z > 1.645. Statistical Summary: Questions 1–4 Sample Proportion Sample Std Dev Sample Size
Two-tailed test, reject Ho when z < -1.96 or z > 1.96. End of worksheet.
Conclusion We are 95% confident the true population proportion is between 0.316 and 0.584. We are 95% confident the true population proportion is between 0.335 and 0.605. We are 95% confident the true population proportion is between 0.375 and 0.645. We are 95% confident the true population proportion is between 0.355 and 0.625. Conclusion We are 95% confident the true population proportion is between 36380.672 and 43 We are 95% confident the true population proportion is between 22.717 and 26.083 Test Statistic Decision Summary -0.741619848709566 Do not Reject Ho There is not sufficient statistical eviden -0.444971909225739 Do not Reject Ho There is not sufficient statistical eviden 0.148323969741913 Do not Reject Ho There is not sufficient statistical eviden -0.148323969741913 Do not Reject Ho There is not sufficient statistical eviden 0.097812668782759 Do not Reject Ho There is not sufficient statistical eviden 1.66389068620736 Do not Reject Ho There is not sufficient statistical eviden and Ha. IMPORTANT: Be sure you change the population statistic in the Test Statistic formula to reflect what you put in Ho and Ha.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
and Ha.
3991.548. 3. ence to show the population proportion is different from 0.5. ence to show the population proportion is different from 0.5. ence to show the population proportion is different from 0.5. ence to show the population proportion is different from 0.5. ence to show the population proportion is different from 40000. ence to show the population proportion is different from 23.
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 h We always try to reject the null hypothesis; that means we must have evidence (via the sample statistic) that the alternate hypothes Click in the cell to see the formula used. Blank row, Table 1 begins in A8. Blank row, Table 1 begins in A8. Confidence Intervals: Questions 1–4 Question Sample Size Question Error Lower Limit Upper Limit #1 0.56 322 #1 0.055325126 0.504674874 0.61532512598465 #2 0.43 322 #2 0.055178986 0.374821014 0.485178986008212 #3 0.48 61 #3 0.1279344094 0.3520655906 0.607934409424338 #4 0.852 61 #4 0.0909317885 0.7610682115 0.942931788522686 End of Table 1, blank row. Table 2 begins in F8. End of Table 2, blank row. Table 3 begins in A15. Statistical Summary: Questions 5–6 Confidence Intervals: Questions 5–6 Question Sample Mean Question Error Lower Limit Upper Limit #5 18.7 1.5 322 #5 0.1671834638 18.532816536 18.8671834637726 #6 492.03 136.62 61 #6 34.984797073 457.04520293 527.014797072865 End of Table 3, blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21. Blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21. Table 5 begins in F21. Hypothesis Tests: Questions 1–6 Question Ho Ha Reject Ho When #1 p ≥ 0.55 p < 0.55 z < -1.645 #2 p ≤ 0.50 p > 0.50 z > 1.645 #3 p = 0.60 p ≠ 0.60 z < -1.96 or z > 1.96 #4 p ≥ 0.75 p < 0.75 z < -1.645 #5 μ = 17 μ ≠ 17 z < -1.96 or z > 1.96 #6 μ ≤ 119 μ > 119 z > 1.645 End of table, blank row. Rejection criteria: Left-tailed test, reject Ho when z < -1.645. Right-tailed test, reject Ho when z > 1.645. Statistical Summary: Questions 1–4 Sample Proportion Sample Std Dev Sample Size supports Ha. Remember that the values used in the hypotheses are whatever you want; just make sure the sample statistic supports Ha. these options. FORMAT HINT: Copy the math notation to another cell using copy , then paste . Right-click in the cell to see these options.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Two-tailed test, reject Ho when z < -1.96 or z > 1.96. End of worksheet.
hypothesis. sis is true. Conclusion We are 95% confident the true population proportion is between 0.505 and 0.615. We are 95% confident the true population proportion is between 0.375 and 0.485. We are 95% confident the true population proportion is between 0.352 and 0.608. We are 95% confident the true population proportion is between 0.761 and 0.943. Conclusion We are 95% confident the true population proportion is between 18.533 and 18.867 We are 95% confident the true population proportion is between 457.045 and 527.0 Test Statistic Decision Summary 2.15332301339117 Do not Reject Ho There is not sufficient statistical eviden 3.00972781800307 Do not Reject Ho There is not sufficient statistical eviden -1.9131126469709 Do not Reject Ho There is not sufficient statistical eviden 1.83977389915174 Reject Ho There is sufficient statistical evidence 8.37403394096563 Reject Ho There is sufficient statistical evidence 21.3252630405757 Reject Ho There is sufficient statistical evidence and Ha. IMPORTANT: Be sure you change the population statistic in the Test Statistic formula to reflect what you put in Ho and Ha.
and Ha.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
7. 015. ence to show the population proportion is less than 0.55. ence to show the population proportion is greater than 0.50. ence to show the populaton proportion is not 0.60. to show the population proportion is less than 0.75. to show the population mean is not 17. to show the population mean is greater than 119.