Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PivotTable EXCEL worksheet The PivotTable worksheet has 30 observations and four variables: Company name, Industry (whether the company is in the Agriculture, Hardware, or Office
PivotTable EXCEL worksheet
The PivotTable worksheet has 30 observations and four variables: Company name, Industry (whether the company is in the Agriculture, Hardware, or Office Supplies industry), Month (from January to March), and Sales (sales amounts in $USD from each of the three months). Use the data set and the Pivot Table function in Excel to create a cross tabulation between the industries and months and show the average sales in the Pivot Table. Use an appropriate format for the sales amounts
Company name | Industry | Month | Sales |
Best Vegetable Company | Agriculture | Jan | 2976 |
Bright Eggbeater Corporation | Agriculture | Jan | 3079 |
Bright Company | Office | Jan | 2637 |
Compelling Office Company | Office | Jan | 3324 |
Exclusive Shovel Traders | Hardware | Jan | 3489 |
Matchless Vise Inc. | Hardware | Jan | 4233 |
Reliable Tripod Company | Hardware | Jan | 2049 |
Remarkable Notebook Supply | Office | Jan | 2887 |
Safe Flagpole Supply | Hardware | Jan | 4863 |
Safe Trading Partners | Office | Jan | 3281 |
Secure Office Corporation | Office | Jan | 3157 |
Succulent Supplies Inc. | Office | Jan | 2752 |
Superior Vegetable Corporation | Agriculture | Jan | 1509 |
Supreme Eggbeater Corporation | Agriculture | Jan | 4011 |
Unsurpassed Banister Corporation | Hardware | Jan | 4748 |
Wonderful Writing Inc. | Office | Jan | 4998 |
Best Organic Company | Agriculture | Jan | 3021 |
OK Food Corporation | Agriculture | Jan | 4127 |
Ready Go Corporation | Hardware | Jan | 4845 |
Peerless Food | Agriculture | Jan | 4790 |
TriCounty Company | Hardware | Jan | 3906 |
Safety First Corporation | Hardware | Jan | 4030 |
SRC Supplies Inc. | Hardware | Jan | 3658 |
Step 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