For this assignment, you’ll use the Vinho Winery Scenario, linked in Supporting Materials, and other course resources to look at raw data sets. These data sets will explain the production, sales, and distribution of wine. You’ll need to study the different types of wine and distribution centers to figure out their financial effects on the organization’s total profits. All your analyses need to be submitted in an annotated Excel file, and each analysis needs to include your reasons for using the appropriate Excel functions. Specifically, you must address the following rubric criteria: Using a pivot table, figure out the percentage of wine varieties sold from each distribution center. Show your results in the form of a pie chart. Hint: Create a pivot table using the data spreadsheet as a starting point. Create a labeled bar chart that shows the amount of wine varieties sold to each distribution center. Use the pivot table already created to calculate the total amount of revenue made for each distribution center. Show your results in a bar chart. Hint: Production cost data is provided in the Costs & Distances tab. Make sure you don’t mix your units of measurement (i.e., pallets, cases, or bottles). Use the IF function to calculate the central tendencies (mean, median, and mode) of shipment volume for each distribution center. Show your results in a table. (Do NOT use a pivot table or manually identify each cell to be evaluated.) Analyze the frequency of shipment by size using a histogram. Use the following bin sizes (number of pallets): 72, 48, 24, 18, 12, 6, 3, 1. Create a shipment histogram to show the distribution of shipments for Portland and Riverside. Use the same bin sizes as you did in step five. Hint: Use the alphabetical sort for the destination column. Then select Data Analysis to plot the frequency of pallet shipments using the bin sizes listed for the two destinations separately. Write a summary statement that describes the inefficiencies shown in the organizational sales analysis. In your response, e