Please finish the following assignment in excel ignoring...

Please finish the following assignment in Excel. Ignoring price, create a chart that displays the seasonality of cranberry sales. Ignoring price, create a chart that shows whether there is an upward trend in sales. Determine average sales per quarter, breaking it down based on whether your price was higher or lower than the competitor's price. You can use the following function to transform the price into a category variable: "=IF(J14<K14,"Higher Price", "Lower Price")" Year Quarter Units Competitor Price My Price 2006 1 453.4041 4.05 4.74 2006 2 454.8513 4.81 5.28 2006 3 523.9836 5.42 4.43 2006 4 578.7019 4.31 5.02 2007 1 608.5591 4.71 4.11 2007 2 577.5938 4.88 4.52 2007 3 571.9 5.81 4.41 2007 4 660.0556 4.14 4.87 2008 1 443.501 4.58 5.3 2008 2 390.6668 4.2 5.07 2008 3 429.6064 4.24 5.14 2008 4 788.3224 5.89 4.66 2009 1 581.585 5.2 4.52 2009 2 503.9166 5 4.86 2009 3 499.7705 4.5 4.63 2009 4 936.1867 5.05 4.25 2010 1 459.4822 5.42 4.94 2010 2 470.638 4.57 4.58 2010 3 349.4878 5.06 5.78 2010 4 912.5367 5.28 4.16 2011 1 400.3611 4.93 5.5 2011 2 528.4768 4.34 4.33 2011 3 605.8438 5.23 4.46 2011 4 574.5326 5.62 5.53

Transcript

00:01 All right, so for this problem, the first thing that we want to do is set up a little chart where we have our quarter, one, two, three, and four, and our year, 2006, 2007, 2008, 2009, 2010, and 2011, where we'll fill out our data, sort of copying it out from the given information on the table.

00:24 So let me just double check specifically what we're asked for there, where i'll note that we are told to, to break this down, or to break this chart, or pardon me, the first chart that we're asked to create displays the seasonality of sales.

00:39 Hence why we're going to be displaying this by quarter for each year, ignoring price.

00:46 So i'm just going to pause and fill out the relevant data here.

00:50 All right, so as we can see, i've copied the data down into excel here.

00:54 So what we'll want to do is grab all of this information and then insert a line.

01:00 Chart.

01:03 Now we can see that it doesn't seem to have quite interpreted this correctly.

01:07 So i will select or go to the select data option here and see what i can do about that.

01:13 So in fact, let's see here, we know that what we'll want to have is for the horizontal or the category axis labels, we'll want to have the different quarters.

01:24 So let's just modify this.

01:25 It doesn't seem like it understood what we wanted at all.

01:28 So we'll have our first series.

01:31 We'll be the values for, or for a series will be the values, or excuse me, the name should be 2006, and then we put in the four different values, where we then say, okay, yeah, it is automatically recognizing just a pattern one, two, three, four for determining what the horizontal axis labels should be.

01:52 So we have our 2006 data, then we'll add our 2007 data, then we'll add our 2008 data, and so on.

02:07 I'm just going to pause while i do.

02:08 This.

02:09 All right, so here we have our chart filled out.

02:13 And so what we can see is that there is an overall upward trend over the course of the year in the number of sales.

02:23 So moving along to the next part of the problem, we're asked to determine the average sales per quarter, bringing it down based on whether our price was higher or lower than the competitor.

02:33 So the way that we'll do this, let's see here.

02:38 We'll want to have a, or we'll want to add a new column for average sale per quarter, and then higher or lower as another column.

02:54 So for finding the average sale per quarter, what we'll do is we'll take the.....

Question

Please give Ace some feedback