The data needed is uploaded below as well. Here are the questions.

Question 1: The Beauty Company

The Beauty Company is a small makeup company. The datafile Beauty Company Sales_Raw Data.xls gives the monthly sales data. Each row lists the salesperson, date of sales, product type, units sold, and revenue generated, and location of the sale.

Question 1.1: Please complete the codebook using the template on Canvas.

Question 1.2: Evaluating salesperson performance

· Create a PivotTable to summarize the units sold by each salesperson.

· Create a PivotTable to summarize the revenue generated by each salesperson.

· Which one of the salespersons had the best performance?

· Does the Pareto Principle apply to this scenario?

Question 1.3: Store location

· Create a PivotTable to summarize the units sold by location of the sale.

· Create a PivotTable to summarize the revenue generated by location of the sale.

· The Beauty Company plans to increase inventory in one of the locations, which location will you recommend to the management?

Question 1.4: The best seller.

· Create a PivotTable to show the unit sold by product type?

· Please use “Slicer” to find out revenue generated by “lip gloss” sold by “Colleen” in the “Midwest” region?

Question 2: Station Wagon

The State Wagon_Raw Data.elsx 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. Use this file to perform the following exercise.

Question 2.1: Please complete the codebook using the template on Canvas.

Question 2.2: Does it appear that family size or income is a more important determinant of station wagon purchases (please use PivotTable function).

Question 2.3: Compute the percentage of station wagon purchasers that are high or low income.

Question 2.4: Compute the fraction of station wagon purchasers that come from each of the following four categories:

· High income and large family;

· High income and small family;

· Low income and large family;

· Low income and small family.

Question 3: The ESPN Subscription

The ESPN Subscription_Raw Data.elsx file contains data for each subscriber of ESPN: The Magazine including the age, gender, income, and location. Use this file to perform the following exercise.

Question 3.1: Please complete the codebook using the template on Canvas.

Question 3.2: Which income group showed the largest number of subscriptions?

Question 3.3: Which gender group showed the largest number of subscriptions?

Question 3.4: Create a profile for the target market of ESPN: The Magazine using the four variables.