In the midst of labor–management negotiations, the president of a company argues that the company’s blue-collar workers, who are paid an average of $30,000 per year, are well paid because the mean annual income of all blue-collar workers in the country is less than $30,000. That figure is disputed by the union, which does not believe that the mean blue-collar income is less than $30,000. To test the company president’s belief, an arbitrator draws a random sample of 350 blue-collar workers from across the country and asks each to report his or her annual income. If the arbitrator assumes that the blue-collar incomes are normally distributed with a standard deviation of $8,000, can it be inferred at the 5% significance level that the company president is correct? ONLY USE EXCEL AND PLEASE SHOW ALL STEPS AND EXCEL COMMANDS.
In the midst of labor–management negotiations, the president of a company argues that the company’s blue-collar workers, who are paid an average of $30,000 per year, are well paid because the mean annual income of all blue-collar workers in the country is less than $30,000. That figure is disputed by the union, which does not believe that the mean blue-collar income is less than $30,000. To test the company president’s belief, an arbitrator draws a random sample of 350 blue-collar workers from across the country and asks each to report his or her annual income. If the arbitrator assumes that the blue-collar incomes are normally distributed with a standard deviation of $8,000, can it be inferred at the 5% significance level that the company president is correct? ONLY USE EXCEL AND PLEASE SHOW ALL STEPS AND EXCEL COMMANDS.
A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
Related questions
Question
In the midst of labor–management negotiations, the president of a company argues that the company’s blue-collar workers, who are paid an average of $30,000 per year, are well paid because the mean annual income of all blue-collar workers in the country is less than $30,000. That figure is disputed by the union, which does not believe that the mean blue-collar income is less than $30,000. To test the company president’s belief, an arbitrator draws a random sample of 350 blue-collar workers from across the country and asks each to report his or her annual income. If the arbitrator assumes that the blue-collar incomes are
| Incomes |
| 29109 |
| 21546 |
| 30417 |
| 10104 |
| 19279 |
| 27578 |
| 23581 |
| 26949 |
| 35423 |
| 12971 |
| 37895 |
| 31308 |
| 28256 |
| 31494 |
| 31552 |
| 34440 |
| 33347 |
| 26768 |
| 25225 |
| 29250 |
| 23437 |
| 31921 |
| 19869 |
| 31693 |
| 38974 |
| 34767 |
| 33131 |
| 23815 |
| 26714 |
| 36735 |
| 33136 |
| 34007 |
| 39674 |
| 22759 |
| 27323 |
| 28875 |
| 37991 |
| 23100 |
| 29289 |
| 21065 |
| 20760 |
| 25332 |
| 28665 |
| 21338 |
| 33246 |
| 27501 |
| 1327 |
| 39562 |
| 30752 |
| 21887 |
| 32228 |
| 10133 |
| 25943 |
| 38223 |
| 38362 |
| 27569 |
| 38213 |
| 25181 |
| 29607 |
| 29690 |
| 27114 |
| 27497 |
| 36364 |
| 35330 |
| 45575 |
| 33222 |
| 15717 |
| 21607 |
| 28861 |
| 22407 |
| 11334 |
| 18836 |
| 13190 |
| 26210 |
| 14940 |
| 48983 |
| 21182 |
| 29351 |
| 27038 |
| 19260 |
| 32626 |
| 31240 |
| 13790 |
| 23167 |
| 19559 |
| 53556 |
| 21745 |
| 24758 |
| 20145 |
| 37975 |
| 22640 |
| 28622 |
| 24653 |
| 25567 |
| 19951 |
| 11195 |
| 30646 |
| 25490 |
| 17034 |
| 31027 |
| 32939 |
| 26919 |
| 27831 |
| 23640 |
| 20727 |
| 23450 |
| 17718 |
| 37815 |
| 27443 |
| 26913 |
| 27273 |
| 34833 |
| 27059 |
| 36773 |
| 10541 |
| 36607 |
| 22582 |
| 24738 |
| 31808 |
| 45441 |
| 36924 |
| 17833 |
| 24812 |
| 27882 |
| 37357 |
| 27177 |
| 25161 |
| 25976 |
| 31626 |
| 33644 |
| 24163 |
| 41845 |
| 36000 |
| 41866 |
| 21561 |
| 36483 |
| 38562 |
| 38257 |
| 32205 |
| 26054 |
| 32774 |
| 15059 |
| 38706 |
| 31978 |
| 16295 |
| 8113 |
| 29631 |
| 25330 |
| 34295 |
| 33129 |
| 33399 |
| 30039 |
| 25912 |
| 26605 |
| 10286 |
| 40673 |
| 40759 |
| 41675 |
| 26489 |
| 25183 |
| 21902 |
| 24217 |
| 9053 |
| 23633 |
| 24876 |
| 36081 |
| 35547 |
| 34660 |
| 20765 |
| 38715 |
| 28147 |
| 13520 |
| 33985 |
| 27194 |
| 42318 |
| 40073 |
| 36581 |
| 28977 |
| 29865 |
| 43225 |
| 29897 |
| 24342 |
| 16257 |
| 21263 |
| 28967 |
| 30534 |
| 24586 |
| 39966 |
| 6914 |
| 37739 |
| 35311 |
| 17283 |
| 47932 |
| 33411 |
| 24062 |
| 31911 |
| 34260 |
| 45958 |
| 28929 |
| 20889 |
| 38709 |
| 49685 |
| 22010 |
| 37126 |
| 30196 |
| 23522 |
| 31948 |
| 35261 |
| 30185 |
| 34416 |
| 32770 |
| 38143 |
| 24482 |
| 29892 |
| 14099 |
| 28276 |
| 22362 |
| 35448 |
| 35193 |
| 30938 |
| 22874 |
| 13906 |
| 16270 |
| 30643 |
| 27880 |
| 33914 |
| 27181 |
| 36287 |
| 32618 |
| 35435 |
| 51462 |
| 16117 |
| 25961 |
| 27658 |
| 41604 |
| 19776 |
| 28030 |
| 49731 |
| 20149 |
| 31712 |
| 15141 |
| 37742 |
| 21791 |
| 22124 |
| 21605 |
| 20258 |
| 36634 |
| 22245 |
| 14125 |
| 29148 |
| 34450 |
| 30368 |
| 35781 |
| 44163 |
| 23179 |
| 27684 |
| 32202 |
| 29616 |
| 31265 |
| 27711 |
| 31661 |
| 30009 |
| 20299 |
| 27605 |
| 34780 |
| 36633 |
| 39882 |
| 48667 |
| 33194 |
| 33926 |
| 19571 |
| 36943 |
| 30437 |
| 35146 |
| 30657 |
| 28479 |
| 40563 |
| 27587 |
| 14896 |
| 35955 |
| 37899 |
| 31861 |
| 30029 |
| 24875 |
| 34903 |
| 21248 |
| 29461 |
| 26043 |
| 28026 |
| 32637 |
| 45792 |
| 37418 |
| 36075 |
| 19764 |
| 31767 |
| 31569 |
| 29122 |
| 40277 |
| 17311 |
| 21835 |
| 28813 |
| 37453 |
| 36700 |
| 33457 |
| 26134 |
| 30112 |
| 27828 |
| 27208 |
| 29144 |
| 19284 |
| 23400 |
| 28025 |
| 27821 |
| 22579 |
| 22108 |
| 31372 |
| 21404 |
| 27984 |
| 33828 |
| 29313 |
| 36379 |
| 18626 |
| 26992 |
| 34019 |
| 13383 |
| 19651 |
| 34292 |
| 45159 |
| 22635 |
| 29829 |
| 25022 |
| 36841 |
| 41440 |
| 38941 |
| 25277 |
| 41226 |
| 23561 |
| 38169 |
| 51824 |
| 34754 |
| 21164 |
| 38510 |
| 28641 |
| 25296 |
| 37486 |
| 38751 |
| 16922 |
| 33310 |
| 43229 |
| 32430 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
Recommended textbooks for you
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON