Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Country Customers Argentina 1 Australia 1 Austria 1 Belgium 1 Brazil 5 Canada 8 Chile 1 Czech Republic 2 Denmark 1 Finland 1 France 5

image text in transcribed

Country Customers
Argentina 1
Australia 1
Austria 1
Belgium 1
Brazil 5
Canada 8
Chile 1
Czech Republic 2
Denmark 1
Finland 1
France 5
Germany 4
Hungary 1
India 2
Ireland 1
Italy 1
Netherlands 1
Norway 1
Poland 1
Portugal 2
Spain 1
Sweden 1
USA 13
United Kingdom 3
The Sales Manager of Chinook wants to generate a report depicting the distribution of customers among different countries The countries.csv file contains two columns named as Country and Customers. The column Customers contains the number of customers for each country, Using Sheets, create a regular table and bar chart that displays the percentage of customers that exists in each country Use the figures below as a guide for creating and validating the results in your table and chart. Top 10 Countries Country % Customers 1 USA 22.03% 2 Canada 13.56% 3 Brazil 8.47% 4 France 8.47% 5 Germany 6.78% United Kingdom 5.08% 7 Czech Republic 3.39% 8 India 3.39% 9 Portugal 3.39% 10 Argentina 1.699 Customers per Country TDO 13.00 General Constraints you must calculate every value from the dataset provided to you using cell references, formulas, and functions. You are not allowed to enter literal values except for names in headers of tables

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Xbrl Financial Reporting In The 21st Century

Authors: Bryan Bergeron

1st Edition

0471220779, 978-0471220770

More Books

Students also viewed these Accounting questions

Question

explain what is meant by redundancy

Answered: 1 week ago