Question

Construct an 80% confidence interval for the difference between two population means Sample 1 Sample 2 364 367 403 466 415 312 332 359 404 461 384 421 319 275 412 335 350 414 418 457 295 358 435 395 The 80% confidence interval is (s(14-H2)s (Round to two decimal places as needed.)

Answer 1

AutoSave OFF Book1 Home Insert Draw Page Layout Formulas Data Review View XLSTAT Tell me TV Connections Properties Edit Links 21 T 7 Clear Reapply Advanced EI 1 E Eu E- Stocks Geogra... Sort Z Filter Refresh All Consolidate Text to Flash-fill Columns Remove Data Duplicates Validation W Ar From From New Database HTML Text Query C519 X fxx C D E F G - H к Sample 1 364 404 350 Sample 2 415 319 295 312 275 358 332 367 412 461 414 403 384 418 466 421 457 t-Test: Two-Sample Assuming Equal Variances 435 Input 359 335 395 OK Variable 1 Range: $C$505:$C$517 Cancel Variable 2 Range: $D$505:$D$517 t-Test: Two-Sample Assuming Equal variances Hypothesized Mean Difference: ✓ Labels Sample 2 353.5 2629.181818 12 Alpha: 0.2 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 Sample 1 409.0833333 1496.628788 12 2062.905303 0 22 2.997647535 0.003315333 0.858266052 0.006630667 1.321236742 Mean Variance Observations Pooled Variance Hypothesized Mean Differ df t Stat P(T<=t) one-tail t Critical one-tail PITcat) two-tail t Critical two-tail Output options $C$519 Output Range: New Worksheet Ply: New Workbook S.E. = sqrt {pooled V (1/121/12) sqrt(2062.905*0.1666667) sqrt(343.81755) 18.54231783 80% confidence interval (Mean 1 - Mean2)+/ t critical "S.E. 55.583333+/- 1.321236.18.5423 55.583333+/- 24.49879159 LB- UB- 31.08454174 80.08212492 549

LB = 31.08

UB = 80.08