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

Please see jpg files they are in order, Just use Microsoft Excel to answer this, this is very easy for you.

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 E36,700, Xavier Perez offering a salary of (30,500, Joan Smith a salary of (32,700 and Jitka Sikorova a starting salary of E28,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. 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 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 2 31,870 25,572 26,576 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,342\f\f