Chapter 8 Assignment

.xlsx

School

Northeast Community College *

*We aren’t endorsed by this school

Course

218

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

16

Uploaded by KidInternet8738

Report
Chapter 8 Assignment: Complete the following problems from the textbook.  All assignments will be grad credit as long as they are complete, turned in on time, and include use of Excel fun where appropriate. This includes following any prompts added to the problems in Assignments turned in late, incomplete, or without work shown will receive partia Chapter 8 Problems: 3, 9, 15, 18, 25, 27, 35, 39, and 54
ded at full nctions Excel. al credit.
a) 80 15 n = 60 MANUAL 1.9364917 1.959964 MOE = 3.7954539 Interval: EXCEL MOE = 3.7954539 Interval: 76.204546 83.795454 0.05 0.025 a) 80 15 n = 120 MANUAL 1.3693064 1.959964 MOE = 2.6837912 Interval: EXCEL MOE = 2.6837912 Interval: 77.316209 82.683791 0.05 0.025 c) a more precise interval estimate The larger sample size lowers the standard error of the mean which decreases the ma ̅ 7x = σ = σ x7 = z = ± ≤ x̄ ≤ ̅ 7x = σ = σ x7 = z = ± ≤ x̄ ≤
76.204546 83.795454 77.316209 82.683791 argin of error and the width of the confidence interval. ≤ x̄ ≤ ≤ x̄ ≤
Smoke and Fire Cost 19100 3027 n = 17748 MANUAL 408.1606 1.959964 MOE = 18429 EXCEL MOE = 799.98007 Interval: 18300.02 17312 0.05 0.025 17622 23149 18340 23669 23006 18378 14160 21653 18060 20043 13859 22401 14970 15111 22320 21159 15628 19082 13832 20124 17819 16860 19042 16812 14610 16496 21287 17721 20229 23942 18937 21697 15098 18611 22137 19223 20527 16830 ̅ 7x = σ = σ x7 = z = ± ≤ x̄ ≤ We are 95% sure the damage caused in the case of care considerably higher than the 11389 given as the damage more damage on average t
19854 20499 22607 13561 22031 22128 23200 23221 15096 15978 20768 22036 17678 23910
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