Excel homework marketing

Marketing ResearchUtilizing the Homework2.xls attached at the bottom, answer and perform the following questions and summarizations.Within the excel file, label each request (1a, 1b, etc.) as a separate worksheet within the excel file. Make sure to answer the questions asked within the sheets and not just do the tables and charts. Before jumping right into the questions, it is recommended that you look at the data and the fields first to understand what the information is and its importance.1.      The Makeup worksheet gives sales data for a small makeup company. Each row lists the salesperson, product sold, location of the sale, units sold, and revenue generated. Use this data to perform the following exercises:a.       Summarize the total revenue and units sold by each person for each product. How many lipsticks did Betsy sell? What is the total amount of revenue for Jen?b.      Summarize the percentage of each person’s revenue sales that came from each location. Create a PivotChart to summarize this information. What area is Cristina’s strongest?c.       Summarize each girl’s unit sales (not revenue) by location and use the Report Filter to include the subsets of products. What location has the most number units sold? What location has the most unit sales of eyeliner?2.      The Tape worksheet contains data for the unit sales of 3M tape, price charged, whether an ad campaign was run that week (1 = ad campaign), and whether the product was displayed on the end of the aisle (1 = end cap). Use this date to perform the following exercises:a.       Analyze the nature of the monthly seasonality of tape sales. Use average monthly sales for your table and chart. Is there a season where tape sales is high? Low?b.      What are the total unit sales using an ad vs. no ad? What are the average unit sales using an ad vs. no ad? Does an ad campaign appear to increase sales? How many weeks was an ad used?c.       What are the total unit sales using an end cap vs. no end cap? What are the average unit sales using an end cap vs. no end cap? Does placing items on the end cap appear to increase sales?

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
Live Chat+1 763 309 4299EmailWhatsApp