help

1. Makeup.xsx file gives sales data for a small makeup company. Each column lists the salesperson, location of the sale, unit sales, and revenue generated. Use this file to perform the following exercises (Provide screenshots of PivotTable results to support your answers): a. Summarize the total revenue (sum of dollars) and unit sales (sum of units) by each person (Provide a PivotTable result). b. How much of the total revenue (sum of dollars) is made by Ashley and Colleen (each person)? c. How many of the total unit sales (sum of units) are made by Cristina and Jen (each person)? d. Summarize each person's sales revenue (sum of dollars) that came from each location (east, midwest, south, and west) (Provide a PivotTable result). c. How much sales revenue (sum of dollars) is made by Emilee in east? f How much sales revenue (sum of dollars) is made by Cici in south? 2. Station.xlsx file contains data for each family including the family size (large or small), income (high or low), and whether the family bought a station wagon (yes or no). Use this file to perform the following exercises (Provide screenshots of PivotTable results to support your answers): a. Compute the percentage of station wagon purchasers (yes). b. Compute the percentage of station wagon purchasers (yes) that have large family (Use % of Grand Total). 3. Cranberrydata.xlsx file contains data for each quarter in the years 2006-2011 detailing the pounds of cranberries sold by a small grocery store (units). You also see whether your price is higher or lower compared to the major competitor (higher or lower). Use this file to perform the following exercises (Provide screenshots of PivotTable results to support your answers): a. Create a table and chart (histogram) that display the seasonality of cranberry sales (sum of units) in quarters. b. Create a table and chart (line) that show whether there is upward trend in sales (sum of units) in years. c. Determine average sales (average of units) per quarter, breaking it down based on whether your price was higher or lower than the competitor. (Continued on the next page) 4. Tapedata.xlsx file contains data for weeks during 2009-2011 for the unit sales of 3M tape and whether an ad campaign was run that week (1- ad campaign, 0-no ad campaign). Use this file to perform the following exercises (Provide screenshots of PivotTable results to support your answers): a Analyze the nature of the monthly seasonality of tape sales (Average of monthly unit sales) in 2009-2011. What is the average tape sales in March (3), 2010 b. Does an ad campaign appear to increase average sales in 2009-2011 (Average of yearly unit sales)? 1. Makeup.xsx file gives sales data for a small makeup company. Each column lists the salesperson, location of the sale, unit sales, and revenue generated. Use this file to perform the following exercises (Provide screenshots of PivotTable results to support your answers): a. Summarize the total revenue (sum of dollars) and unit sales (sum of units) by each person (Provide a PivotTable result). b. How much of the total revenue (sum of dollars) is made by Ashley and Colleen (each person)? c. How many of the total unit sales (sum of units) are made by Cristina and Jen (each person)? d. Summarize each person's sales revenue (sum of dollars) that came from each location (east, midwest, south, and west) (Provide a PivotTable result). c. How much sales revenue (sum of dollars) is made by Emilee in east? f How much sales revenue (sum of dollars) is made by Cici in south? 2. Station.xlsx file contains data for each family including the family size (large or small), income (high or low), and whether the family bought a station wagon (yes or no). Use this file to perform the following exercises (Provide screenshots of PivotTable results to support your answers): a. Compute the percentage of station wagon purchasers (yes). b. Compute the percentage of station wagon purchasers (yes) that have large family (Use % of Grand Total). 3. Cranberrydata.xlsx file contains data for each quarter in the years 2006-2011 detailing the pounds of cranberries sold by a small grocery store (units). You also see whether your price is higher or lower compared to the major competitor (higher or lower). Use this file to perform the following exercises (Provide screenshots of PivotTable results to support your answers): a. Create a table and chart (histogram) that display the seasonality of cranberry sales (sum of units) in quarters. b. Create a table and chart (line) that show whether there is upward trend in sales (sum of units) in years. c. Determine average sales (average of units) per quarter, breaking it down based on whether your price was higher or lower than the competitor. (Continued on the next page) 4. Tapedata.xlsx file contains data for weeks during 2009-2011 for the unit sales of 3M tape and whether an ad campaign was run that week (1- ad campaign, 0-no ad campaign). Use this file to perform the following exercises (Provide screenshots of PivotTable results to support your answers): a Analyze the nature of the monthly seasonality of tape sales (Average of monthly unit sales) in 2009-2011. What is the average tape sales in March (3), 2010 b. Does an ad campaign appear to increase average sales in 2009-2011 (Average of yearly unit sales)