Batch | Crack | Impurities |
31658 | 0 | 625 |
34167 | 0 | 427 |
16397 | 0 | 637 |
49875 | 0 | 496 |
43030 | 0 | 513 |
15862 | 0 | 549 |
28080 | 0 | 531 |
4233 | 0 | 454 |
44784 | 1 | 517 |
41753 | 0 | 466 |
22957 | 0 | 446 |
48107 | 1 | 539 |
29448 | 1 | 530 |
17654 | 0 | 514 |
47312 | 1 | 527 |
8266 | 1 | 489 |
7541 | 1 | 568 |
15386 | 0 | 609 |
12647 | 0 | 512 |
16511 | 1 | 466 |
28311 | 0 | 592 |
38526 | 0 | 494 |
27327 | 0 | 493 |
34671 | 0 | 527 |
6105 | 0 | 581 |
On the Excel file "Test3Data.xlsx", you are given 25 samples of ingots (gold bars) selected random from various batches. Historical data suggests that the average number of impurities in an ingot is EXACTLY 505. Assuming that the number of impurities follows a normal distribution, what is the value of the p-value?
A
0.048
B
0.095
C
0.952
D
0.100
Batch Crack Impurities 31658 0 625 34167 0 427 16397 0 637 49875 0 496 43030...
Batch Crack Impurities 31658 0 625 34167 0 427 16397 0 637 49875 0 496 43030 0 513 15862 0 549 28080 0 531 4233 0 454 44784 1 517 41753 0 466 22957 0 446 48107 1 539 29448 1 530 17654 0 514 47312 1 527 8266 1 489 7541 1 568 15386 0 609 12647 0 512 16511 1 466 28311 0 592 38526 0 494 27327 0 493 34671 0 527 6105 0 581 In the...