Question
Below I have analyzed the last 24 months of Hoover's carrier transactions. Service, price, and quality. See below my analysis and I only need help
Below I have analyzed the last 24 months of Hoover's carrier transactions. Service, price, and quality. See below my analysis and I only need help with question #3. The career name is labeled in the Row Labels
2) Apply what you learned about the use of Excel Pivot Tables and do a thorough analysis of the data to determine which carriers provide the best service at the best price to the states that Hoover services. Consider whether you should look at totals or averages in your analysis. Slice and Dice (pivot) the data in a number of different ways to help you in your analysis. Look at each factor - service, price, and quality. Spend some time thinking about the problem and how best to analyze the data.
| Row Labels |
| All-State Trucking |
| IN |
| KY |
| MI |
| OH |
| PA |
| VA |
| WV |
| BLTN Transport |
| IN |
| KY |
| MI |
| OH |
| PA |
| Count on Us |
| IN |
| KY |
| MI |
| OH |
| PA |
| Sure Shipping |
| IN |
| KY |
| MI |
| OH |
| PA |
| There Tomorrow |
| IN |
| KY |
| MI |
| OH |
| PA |
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
Get Rich With Dividends
Authors: Marc Lichtenfeld
3rd Edition
1119985552, 978-1119985556
