I will give 5 reward points to those who can answer this.

Starting Salaries:

A United States manufacturing company in Chicago has several subsidiaries in the 27 countries of the European Union including Calabas, Spain; Watford, United Kingdom; Bonn, Germany and Louny, Czech Republic. It is planning to hire new engineers to work in these subsidiaries and needs to decide on the starting salary to offer these new hires. These new engineers will be hired from their country of origin to work in their home country. The human resource department of the parent firm in Chicago, who is not too familiar with the employment practices in Europe, has the option to purchase a database of annual starting salaries for engineers in the European Union from a consulting firm in Paris. This database, with values converted to Euros, is given in the table below. It was compiled from European engineers working in the automobile, aeronautic, chemicals, pharmaceutical, textiles, food, and oil refining sectors. At the present time, the Chicago firm is considering hiring Markus Schroeder, offering a starting salary of 36,700, Xavier Perez offering a salary of 30,500, Joan Smith a salary of 32,700 and Jitka Sikorova a starting salary of 28,900. All these starting salaries include social benefits and mandatory employer charges which have to be paid for the employee. Required Assume that you work with the human resource department in Chicago. Use the information from Chapters 2 and 3 of your textbook to present in detail the salary database prepared by the Paris consulting firm. Then in using your results, describe the characteristics of the four starting salaries that have been offered and give your comments.

Here are the salaries: You can use excel please.

34,756 30,196 29,164 37,022 32,842 28,356 43,504 31,380 31,030 28,366 25 ,700 40,750 33,012 33,726 37,594 33,038 30,004 33,388 38,224 29,728 33,400 35,450 31,658 35,044 36,104 27,894 37,224 34,754 33,122 32,310 33,800 27,662 33,208 31,752 39,724 33,866 36,032 34,132 30,180 32,380 31,624 24,370 35,136 33,858 30,456 30,538 29,052 29,796 34,978 29,110 34,786 33,936 33,586 30,530 31,178 24,652 27,580 40,160 33,926 30,568 33,928 32,932 30,774 30,914 36,750 27,280 26,886 33,152 36,580 35,324 27,956 26,016 25,802 29,722 34,454 35,964 23,282 29,908 29,772 27,200 37,198 31,056 34,852 30,370 30,828 26,776 28,650 33,958 28,974 35,204 26,752 28,478 29,264 37,898 32,724 34,082 29,948 34,410 32,456 29,928 32,884 25,974 21,566 26,310 31,836 35,898 27,396 28,292 35,784 32,220 24,342 36,302 32,184 34,788 32,098 30,044 31,610 36,282 24,842 24,742 29,514 35,566 27,556 39,886 31,468 33,302 37,980 38,174 35,644 37,370 35,072 27,400 35,838 29,858 24,062 28,606 28,012 34,442 35,018 31,638 26,154 29,706 33,850 28,668 31,870 25,572 26,576 28,758 32,580 24,114 34,878 31,860 31,216 31,668 37,490 42,072 29,242 28,086 25,054 33,248 33,654 25,892 34,902 33,294 31,712 32,312 27,546 31,472 34,020 32,704 40,202 27,252 28,870 36,414 29,586 28,906 35,434 34,332 33,564 34,268 24,246 35,214 33,102 29,274 29,454 34,126 29,412 31,588 30,766 31,052 34,614 31,630 31,024 29,242 30,924 35,032 37,334 26,660 36,616 25,34230,076 31,902 35,114 32,348 41,184 28,972 34,588 27,312 30,404 31,478 26,422 31,648 33,078 33,640 34,240 25,632 24,528 31,188 30,006 34,650 28,466 27,616 33,994 35,368 33,804 27,050 34,070 36,012 36,410 31,840 39,782 28,378 29,328 36,144 33,010 28,592 32,782 36,774 39,144 36,902 28,662 27,522 29,200 31,992 30,564 30,762 25,860 35,620 25,192 41,490 34,250 25,212 35,678 24,912 35,648 36,622 36,884 29,488 29,060 38,692 29,052 33,884 35,202 38,824 33,376 36,488 31,982 34,902 33,068 34,518 25,146 27,834 38,990 34,944 23,394 30,276 37,124 26,756 32,142 30,388 27,624 28,718 36,828 26,528 29,168 31,612 28,822 29,296 28,374 29,990 30,914 34,812 37,508 30,446 35,390 38,916 33,842 25,442 28,088 28,234 34,652 34,286 26,474 35,394 36,636 34,596 36,196 32,412 31,272 31,822 29,696 33,552 28,900 30,384 32,274 22,320 28,934 35,738 36,010 39,038 22,044 34,022 37,750 27,146 34,570 29,514 31,042 30,672 33,482 34,774 36,518 29,638 28,976 31,146 38,434 27,468 39,570 28,502 31,762 38,600 27,134 32,334 27,928 31,150 31,858 31,544 27,254 27,716 41,482 27,082 32,470 28,128 28,584 33,120 36,764 35,450 32,854 31,848 33,474 26,842 33,396 27,358 33,832 38,088 35,074 29,114 26,380 31,256 37,080 29,622 33,060 25,426 31,616 31,876 35,838 29,376 36,654 30,398 36,030 34,196 29,732 29,744 30,544 31,854 30,884 23,768 31,520 30,336 27,442 29,796 39,302 25,424 28,924 32,072 29,204 34,906 32,434 23,710 31,964 33,328 39,956 33,386 38,184 35,326 34,468 37,616 35,588 37,312 32,484 29,522 31,322 35,136 35,186 32,964 31,962 34,070 41,396 28,170 35,352 31,300 24,190 37,292 33,146 32,972 30,260 31,178 26,772 39,376 31,860 37,080 32,568 27,990 32,378 22,508 32,644 27,158 31,868 33,050 29,624 32,368 28,176 27,664 31,840 26,800 33,252 32,622 35,966 29,264 31,546 26,292 31,116 30,834 30,254 30,690 23,930 31,202 32,166 30,396 33,698 29,704 31,496 33,730 31,714 34,046 29,756 38,372 35,666 31,344 35,976 33,036 27,500 33,882 40,496 32,218 30,110 36,168 31,654 28,880 27,502 29,082 36,524 30,512 33,882 34,350 39,062 24,674 33,384 27,472 21,954 27,934 33,346 33,426 31,722 29,566 31,000 30,522 33,942 32,490 35,134 29,644 38,754 32,214 31,220 32,604 23,588 29,648 32,470 38,824 30,820 34,294 22,856 29,514 28,000 35,398 31,934 27,104 34,994 25,006 31,186 35,164 28,352 26,626 36,052 31,134 34,064 32,186 29,724 36,968 32,558 34,596 34,646 29,832 33,784 36,346 33,692 41,182 29,374 36,574 26,868 37,596 25,132 30,618 23,684 33,918 35,336 26,862 35,756 31,754 28,090 28,236 30,780 32,894 26,608 30,890 33,530 34,210 31,072 36,742 32,982 41,776 33,250 36,836 32,390 29,626 38,642 29,406 27,086 27,902 36,370 30,522 29,572 30,944 33,000 34,314 31,148 35,300 24,016 27,878 38,818 33,910 26,838 34,214 33,470 31,070 32,100 28,982 27,632 28,432 31,854 32,852 32,596 25,810 36,426 33,452 31,704 34,938 30,704 35,736 34,682 36,700 34,238 27,012 34,812 30,624 30,418 34,730 33,134 30,692 32,142 34,450 34,766 31,824 29,126 34,594 31,088 39,328 27,676 34,518 30,296 35,742 22,830 33,332 33,486 31,544 32,932 29,596 28,628 35,662 27,524 35,074 37,378 33,426 30,336 29,462 32,180 35,530 36,288 32,148 27,738 30,110 29,610 29,252 36,378 33,632 28,574 26,076 33,118 28,660 35,970 35,80630,698 32,620 28,642 35,738 34,744 34,828 29,520 23,676 32,424 32,538 27,782 29,062 27,266 30,916 29,868 29,746 35,976 32,204 30,992 35,100 38,164 30,698 31,002 34,276 30,846 29,952 27,972 35,484 31,812 32,620 31,974 31,932 33,348 27,468 33,736 27,100 31,120 30,492 39,210 28,310 27,216 31,428 33,268 29,196 29,868 35,784 31,938 33,570 27,300 37,214 28,758 30,968 33,402 36,310 37,372 35,490 35,254 23,456 29,628 29,966 32,102 41,046 31,504 26,562 33,400 28,768 32,270 27,726 32,422 30,504 27,662 29,844 30,178 33,942 32,794 27,536 27,354 29,754 31,814 29,426 31,498 39,300 26,742 40,572 36,102 32,950 20,376 35,892 29,254 36,222 30,880 30,040 25,360 36,004 28,592 29,334 26,960 25,978 27,216 32,292 33,090 27,826 31,052 31,774 32,562 32,112 26,386 37,556 28,554 23,048 36,176 27,392 37,216 24,314 24,410 36,304 29,568 33,214 31,284 37,264 25,518 33,618 36,218 31,148 26,620 31,178 31,490 28,338 26,770 31,498 31,404 32,206 34,552 34,842 26,664 24,960 32,798 22,856 33,082 32,514 26,856 29,672 33,786 30,502 31,766 31,854 35,450 29,188 32,692 29,830 28,858 36,308 30,292 30,298 32,124 31,730 33,534 35,440 28,990 29,606 29,554 25,062 28,502 34,388 31,052 34,826 34,024 33,926 32,330 33,460 32,216 32,160 40,642 27,986 33,040 36,398 36,084 25,664 29,852 37,400 29,674 32,048 33,100 30,606 34,902 34,538 32,438 28,844 30,502 29,178 26,656 26,730 26,690 31,236 35,788 29,438 33,088 28,930 27,342 32,070 36,686 30,786 27,364 35,570 39,390 28,258 35,902 33,858 27,742 31,358 39,762 33,386 37,550 30,652 24,938 33,852 30,508 30,422 34,022 29,790 33,316 26,600 29,916 31,562 22,092 32,998 34,746 35,340 30,336 32,256 30,336 31,462 31,918 31,994 25,040 30,986 32,220 26,830 28,882 29,426 33,048 31,510 33,382 32,680 35,802 36,704 29,836 31,160 33,318 25,824 37,688 34,382 34,504 31,868 30,872 36,156 42,592 33,636 38,870 25,470 34,658 30,430 36,060 37,306 39,048 35,334 28,598 32,664 34,958 39,414 42,786 43,258 35,260 35,068 30,454 30,880 34,776 29,942 26,144 26,432 25,936 31,368 26,992 26,452 28,084 28,036 28,780 36,382 35,248 32,926 36,662 27,056 27,762 28,616 34,842 28,582 37,860 31,134 36,704 29,992 37,560 32,108 29,358 27,562 29,490 31,316 35,590 33,520 30,462 28,802 35,772 34,220 34,490 29,224 37,310 30,246 27,920 30,000 35,144 29,814 28,584 32,202 35,650 24,874 36,094 34,774 38,626 30,520 24,750 28,578 39,180 30,170 30,220 29,564 34,306 33,834 34,368 27,344 32,548 32,702 30,792 23,460 31,302 29,472 25,530 29,028 34,350 33,748 35,530 31,732