Question: how do i calculate the five year average in this question in excel . finally, she wants to know the market share for each product

how do i calculate the five year average in this question in excel

.

finally, she wants to know the market share for each product and region by month based on the ple and industry sales data, and the average market share by region over the five years.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

EXECEL Performance Lawn Equipment (PLE) - Read the file description in pages 31-32 and answer the following questions.Your manager, Elizabeth Burke, has received several questions from other managers...

Dealer Satisfaction End-User Satisfaction Customer S Dealer Satisfaction 0 1 2 3 4 Survey Scale: North America 2014 2015 2016 2017 2018 1 0 1 1 2 NOO 2 2 1 6 14 14 8 12 15 22 20 34 34 44 5 Sample...

do on excel and explain, please. thank you 1. First, she would like you to edit the worksheets Deqle, Satisfaction and End-User Satisfaction to display the total number of responses for each year. 2....

Introduction: Case SituationPLE, headquartered in St . Louis, Missouri, is a privately owned designer and producer of traditional lawn mowers used by homeowners. In the past ten years, PLE has added...

Evaluation and Control in Strategic Management Evaluation and control information consists of performance data and activity reports (gathered in Step 3 in Figure 11-1). If undesired performance...

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

This is the PLE below This is the industry mower total sales below Industry tractor total sales 4. Finally, she wants to know the market share for each product and region by month based on the PLE...

Calculate the amount of the bonus pool available under the existing bonus plan. How much would each manager get if that were applied to 2009 results? We want to break down the profit variance into...

HI this is a Marketing section that is part of a business plan I just need this part put into power point for me . I have the flu and don't know to much about Power Point can someone please help me....

Create your own Python code examples that demonstrate each of the following. Do not copy examples from the book or any other source. Try to be creative with your examples to demonstrate that you...

A geologist wants to measure the diameter of a crater. From her camp, it is 4 miles to the northernmost point of the crater and 2 miles to the southern-most point. If the angle between the two lines...

A vertical merger is a merger or business consolidation that occurs between firms that operate in the same space within an industry. True False Clear selection

Inventory records for Herb's Chemicals revealed the following: March 1, 2021, inventory: 1,950 gallons @ $9.10 per gallon = $17,745 Purchases: Sales: Mar. 10 790 gals @ $ 9.15 Mar. 5 590 gals Mar. 16...