Salesperson Region Account Order Amount Month Albertson, Kathy East 29386 $925.00 January Albertson, Kathy East 74830 $875.00 February Albertson, Kathy East 90099 $500.00 February Albertson, Kathy East 74830 $350.00 March Brennan, Michael West 82853 $400.00 January Brennan, Michael West 72949 $850.00 January Brennan, Michael West 90044 $1,500.00 January Brennan, Michael West 82853 $550.00 February Brennan, Michael West 72949 $400.00 March Davis, William South 55223 $235.00 February Davis, William South 10354 $850.00 January Davis, William South 50192 $600.00 March Davis, William South 27589 $250.00 January Dumlao, Richard West 67275 $400.00 January Dumlao, Richard West 41828 $965.00 February Dumlao, Richard West 87543 $125.00 March Flores, Tia South 97446 $1,500.00 March Flores, Tia South 41400 $305.00 January Flores, Tia South 30974 $1,350.00 January Flores, Tia South 41400 $435.00 February Flores, Tia South 30974 $550.00 February Flores, Tia South 30974 $425.00 March Post, Melissa East 78532 $765.00 January Post, Melissa East 78532 $150.00 February Post, Melissa East 65532 $425.00 February Post, Melissa East 78532 $350.00 March Thompson, Shannon North 91987 $875.00 January Thompson, Shannon North 91041 $265.00 January Thompson, Shannon North 91987 $375.00 February Thompson, Shannon North 91041 $1,345.00 February Thompson, Shannon North 91987 $300.00 March Walters, Chris South 55667 $225.00 January Walters, Chris South 54393 $105.00 January Walters, Chris South 40028 $25.00 January Walters, Chris South 55667 $155.00 February Walters, Chris South 54393 $2,600.00 February Walters, Chris South 54393 $225.00 March Walters, Chris South 55667 $785.00 March Walters, Chris South 27589 $255.00 March -- 1-Heat map visualization for the column "Account"? 2-Make "Data bars" for the column "Order Amount"? 3-Create a PivotTable to sum the column "Account" according to the column "Salesperson"?

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Salesperson	Region	Account	Order Amount	Month
Albertson, Kathy	East	29386	$925.00	January
Albertson, Kathy	East	74830	$875.00	February
Albertson, Kathy	East	90099	$500.00	February
Albertson, Kathy	East	74830	$350.00	March
Brennan, Michael	West	82853	$400.00	January
Brennan, Michael	West	72949	$850.00	January
Brennan, Michael	West	90044	$1,500.00	January
Brennan, Michael	West	82853	$550.00	February
Brennan, Michael	West	72949	$400.00	March
Davis, William	South	55223	$235.00	February
Davis, William	South	10354	$850.00	January
Davis, William	South	50192	$600.00	March
Davis, William	South	27589	$250.00	January
Dumlao, Richard	West	67275	$400.00	January
Dumlao, Richard	West	41828	$965.00	February
Dumlao, Richard	West	87543	$125.00	March
Flores, Tia	South	97446	$1,500.00	March
Flores, Tia	South	41400	$305.00	January
Flores, Tia	South	30974	$1,350.00	January
Flores, Tia	South	41400	$435.00	February
Flores, Tia	South	30974	$550.00	February
Flores, Tia	South	30974	$425.00	March
Post, Melissa	East	78532	$765.00	January
Post, Melissa	East	78532	$150.00	February
Post, Melissa	East	65532	$425.00	February
Post, Melissa	East	78532	$350.00	March
Thompson, Shannon	North	91987	$875.00	January
Thompson, Shannon	North	91041	$265.00	January
Thompson, Shannon	North	91987	$375.00	February
Thompson, Shannon	North	91041	$1,345.00	February
Thompson, Shannon	North	91987	$300.00	March
Walters, Chris	South	55667	$225.00	January
Walters, Chris	South	54393	$105.00	January
Walters, Chris	South	40028	$25.00	January
Walters, Chris	South	55667	$155.00	February
Walters, Chris	South	54393	$2,600.00	February
Walters, Chris	South	54393	$225.00	March
Walters, Chris	South	55667	$785.00	March
Walters, Chris	South	27589	$255.00	March

1-Heat map visualization for the column "Account"?

2-Make "Data bars" for the column "Order Amount"?

3-Create a PivotTable to sum the column "Account" according to the column "Salesperson"?

4-Add a Pivot Chart to a new sheet?

5-Add a slicer to it to filter according to the "Region"?

6-Use the "Analysis ToolPak" to calculate the Standard Deviation of the column "Order Amount"?

Expert Solution