1 Remove all formatting including filters from the data in the file
2 Create a pivot table to show all clients by region and the sum of their annual income.
3 Create a pivot table to show all clients by region with the average of their annual income.
4 Create a pivot table to show all clients by region and ownership with sum of their total purchases.
5 Create a pivot table to show all clients by region and ownership with the sum of their annual income and the average of their total purchases.
6 Create a pivot chart to show the data in 2 without the grand totals
7 Create a pivot chart to show the data in 5 without the grand totals
8 Create a pivot table to show all clients by region, ownership and annual income with the sum of their total purchases and the average number of their purchases. Then answer the following questions (Note: you will have to do and show more calculations in the pivot table):
(a) Which region has the renters with the highest annual income and the largest average number of purchases?
(b) Which region has the owners with the smallest annual income and the smallest average number of purchases?
(c) Which region and ownership have the clients whose sum of total purchases is closest to the median of the sum of the total purchases for all clients?
(d) In which regions do renters have a higher percentage of the sum of total purchases than owners?
29 фрилансеров(-а) готовы выполнить эту работу в среднем за $24
Hi, I can help you with your file. I have advanced knowledge of Excel's formulas, pivot tables, charts and visual basic coding. I'm willing to discuss more about your project.
Dear Sir / Madam, I understand your project and like to work with you. I am experienced in this field and would like do the work regarding to your requirements. . Regards.
The project will take place and completed on google data studios. A dashboard will be created that will be enticing. The project can be done in 2 days, 1 extra day is a buffer.
I am sufficient to do this work. I have experience to do this work.I do this work very pure and clear. I do this work like you give extra tip for this work.
I understand you project. and can do this on time i have 4 years of work experience in data entry and web searching. with good skills. and will timely submit it to you . Replies within a few minutes