80.2K

Verified Solution

Link Copied!

i) Correct any typo or NaN using the average built in func2on. ii) Usethefollowingformulatoes2matetheperformanceforeveryoffice.

Bonus = Sales * 12%, all divided by 0.2

iii) Create a new column called Performance using the values youve obtained. iii) Create a plot showing the performance per country in the most clear way. iv) Make a list of the three offices that show the best performance. In which country are they located? What is the companys total net sales? v) Create a business leZer repor2ng this informa2on. Address the leZer to: David Lynch, Mulholland drive 21400. Los Angeles California.

Office Bangor Bangor Sant Cougat Campo Grande Monterrey Sant Cougat Pula Kobe Pierre Monterrey Campo Grande Campo Grande Campo Grande Campo Grande Campo Grande Campo Grande Kobe Sales 10644 three thousand 34,293 hello 18,919 Country 16.635 UK 14.808 UK Spain 13.908 Brazil 48.656 Mexico Spain 9.339 Serbia 18.919 Japan 32.554 France Mexico 13.987 Brazil 21.984 Brazil 16879 Brazil 21872 Brazil Brazil 9999 Brazil Japan Office Bangor Bangor Sant Cougat Campo Grande Monterrey Sant Cougat Pula Kobe Pierre Monterrey Campo Grande Campo Grande Campo Grande Campo Grande Campo Grande Campo Grande Kobe Sales 10644 three thousand 34,293 hello 18,919 Country 16.635 UK 14.808 UK Spain 13.908 Brazil 48.656 Mexico Spain 9.339 Serbia 18.919 Japan 32.554 France Mexico 13.987 Brazil 21.984 Brazil 16879 Brazil 21872 Brazil Brazil 9999 Brazil Japan

Answer & Explanation Solved by verified expert

See Answer