![data analysis excel 2014 data analysis excel 2014](https://www.statisticshowto.com/wp-content/uploads/2018/06/2.png)
Which products generate 80 percent of the revenue?Ĭalculating the Percentage of Sales at Each Store.How much revenue does each product generate?.What percentage of sales occurs during each month?.What percentage of sales occurs at each store?.Throughout this section you will learn to analyze this data using Excel PivotTables to answer the following questions: Each store sells 10 types of tape, 10 types of adhesive, and 10 types of safety equipment. The data worksheet from the PARETO.xlsx file (available for download on the companion website) contains sales data from two local hardware stores (uptown store owned by Billy Joel and downtown store owned by Petula Clark). To start analyzing sales you first need some data to work with.
![data analysis excel 2014 data analysis excel 2014](https://i1.rgstatic.net/publication/263708871_Chemometrics_in_Excel/links/59df6631a6fdccfcfda3580d/largepreview.png)
#Data analysis excel 2014 how to
In this chapter you learn how to use PivotTables to perform the following: Excel PivotTables enable you to quickly summarize and describe your data in many different ways. In many marketing situations you need to analyze, or “slice and dice,” your data to gain important marketing insights. Slicing and Dicing Marketing Data with PivotTables Using Excel to Summarize Marketing DataĬhapter 1: Slicing and Dicing Marketing Data with PivotTablesĬhapter 2: Using Excel Charts to Summarize Marketing DataĬhapter 3: Using Excel Functions to Summarize Marketing Data Chapter 1. Marketing Analytics: Data-Driven Techniques with Microsoft Excel (2014) Part I.