Question
i) Correct any typo or NaN using the average built in func2on. ii) Usethefollowingformulatoes2matetheperformanceforeveryoffice. Bonus = Sales * 12%, all divided by 0.2 iii) Create
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 JapanStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started