KN BoydLogistics Final Projex.. . Saved to this PC v Search KN X X AutoSave ( Off) Review View Automate Developer Help Power Pivot Comments Share File Home Insert Draw Page Layout Formulas Data AutoSum Calibri 11 ap Wrap Text General AY O % " Conditional Format as Cell Fill Insert Delete Format Sort & Find & Add-ins Analyze Paste B Merge & Center Formatting v Table v Styles v Clear Filter * Select Data Clipboard N Font Ny Alignment Number Styles Cells Editing Add-ins A1 ! X V fx v P A B D G H M N O Queries & Connections V X Queries | Connections Boyd Logistics Route Data Boyd 1 query BoydLogistics Txt-04 64 rows loaded. Date Invoice ID * Origin " Destination > Containers * Damaged 2/1/2023 BLOO1 Kansas City Chicago 90 2/4/2023 BLO02 Kansas City Fargo 35 2/7/2023 BLOO3 Chicago Omaha 80 2023 BLO04 Kansas City Minneapolis 90 2/1/2023 BLOO St. Louis Kansas City 75 2/4/2023 BLO06 Chicago St. Louis 90 2/7/2023 BLO07 Fargo Milwaukee 63 2/10/2023 BLOO8 Chicago Kansas City 90 2/13/2023 BLO09 Fargo Kansas City 35 2/16/2023 BLO10 Omaha Chicago 80 2/19/2023 BLO11 St. Louis Chicago 90 VU G W N N N U O HU DO 2/22/2023 BLO12 Minneapolis Kansas City 90 2/25/2023 BLO13 Fargo Chicago 35 2/28/2023 BL014 St. Louis Omaha 75 3/3/2023 BLO15 Kansas City Chicago 85 3/6/2023 BLO16 Kansas City Fargo 45 3/9/2023 BLO17 Chicago Omaha 80 3/12/2023 BLO18 Kansas City Minneapolis 90 10 3/15/2023 BLO19 St. Louis Kansas City 75 3/18/2023 BLO20 Chicago St. Louis 90 3/21/2023 BL021 Farg Milwaukee 45 3/24/2023 BLO22 Chicago Kansas City 75 3/27/2023 BLO23 Kansas City 35 OHWH WVNON Fargo 3/30/2023 BLO24 Omaha Chicago 80 4/2/2023 BLO25 St. Louis Chicago 90 4/5/2023 BLO26 olis Kansa 90 4/8/2023 BL027 Fargo Chicago 35 3 4/11/2023 BI 078 St. Louis Omaha 75 RouteData Scenario Summary OffLoading + Lod 100% Ready Lo Accessibility: Investigate5. Prepare descriptive statistics for data. a. Install the Analysis ToolPak if it is not installed. b. Select cell H5. c. Use the Descriptive Statistics tool with cells F5:F61 as the input range and the label in the first row. Cell H5 is the output range. Include Summary statistics and Kth values to display the largest and the smallest value in the range. d. AutoFit the results. Boyd Logistics Route Data Boyd D OU WN Date Invoice ID Origin . Destination Containers |Damaged Damaged 2/1/2023 BLOO1 Kansas City Chicago 90 2/4/2023 BLO02 Kansas City Fargo 35 Mean 4.232142857 8 2/7/2023 BLOO3 Chicago Omaha 80 Standard Error 0.365732738 9 2/10/2023 BLO04 Kansas City Minneapolis Median 4 10 2/1/2023 BLOO5 St. Louis Kansas City 75 Mode 11 2/4/2023 BLOO6 Chicago St. Louis 90 Standard Deviation 2.736893205 12 2/7/2023 BLO07 Fargo Milwaukee 63 Sample Variance 7.490584416 13 2/10/2023 BLO08 Chicago Kansas City 90 Kurtosis 0.79762018 14 2/15/2023 BLO09 Fargo Kansas City 35 JUGWNNNMOH UTI COG W G W CO Skewness 0.288226468 15 2/16/2023 BLO10 Omaha Chicago 80 Range 10 16 2/19/2023 BL011 St. Louis Chicago 90 Minimum 2/22/2023 BLO12 Minneapolisansas City 90 Maximum 10 2/25/2023 BL013 Fargo Chicago Sum 237 19 2/28/2023 BL014 St. Louis Omaha count 56 20 3/3/2023 BLO15 Kansas City Chicago Largest(1) 10 21 3/6/2023 BL016 Kansas City Fargo Smallest(1) 22 3/9/2023 BL017 chicago Omaha oneannlic COMPLETED ROUTEDATA SHEET BA 216A Final Project Part I Page 2 of 7 6. Create, move, and format a PivotTable. a. Build a PivotTable on a New Worksheet from the data in the RouteData sheet. b. Rename the new sheet as Dashboard. c. Show the Invoice ID field in the Rows area and the Containers field in the Values area. d. Use Tabular Form as the report layout. e. Show Grand Totals for columns. f. Select and move the entire PivotTable to cell C3. g. Edit the label in second column to display # of Containers and AutoFit both columns. h. Apply blue PivotTable style and All Borders to the entire PivotTable. i. Name the PivotTable as pytContainers