Question

please answe all parts of question 4

Year	Period	Division	Revenue	Number of Customer
2000	1	A	706	333
2000	1	B	151	195
2000	1	C	460	222
2001	1	A	879	252
2001	1	B	619	256
2001	1	C	361	376
2002	1	A	260	519
2002	1	B	302	788
2002	1	C	250	62
2003	1	A	588	67
2003	1	B	862	752
2003	1	C	966	250
2004	2	A	724	638
2004	2	B	933	650
2004	2	C	108	785
2005	2	A	749	640
2005	2	B	148	474
2005	2	C	280	51
2006	2	A	429	68
2006	2	B	719	26
2006	2	C	681	594
2007	3	A	264	295
2007	3	B	442	137
2007	3	C	853	49
2008	3	A	479	638
2008	3	B	374	732
2008	3	C	514	92
2009	3	A	599	668
2009	3	B	35	454
2009	3	C	554	350
2010	4	A	214	122
2010	4	B	455	942
2010	4	C	581	993
2011	4	A	22	624
2011	4	B	738	905
2011	4	C	158	47
2012	4	A	24	696
2012	4	B	540	53
2012	4	C	810	162
2013	5	A	176	930
2013	5	B	385	420
2013	5	C	883	962
2014	5	A	18	374
2014	5	C	200	305
2015	5	A	145	123
2015	5	B	456	432
2015	5	C	234	213

Question 4:         Use Data4 Sheet

                This table reports Revenue and Customer of 3 divisions (A, B, C) of a corporation over time

4a.          Create a table reporting the average annual revenue for each division.

                ( Note: So each division, you have only 1 number for average)

Report the SUM of the 3 average numbers for these 3 divisions (do NOT include or use the Grand Total) in that table?

4b.          Create a table reporting total revenue for each year for the whole corporation.

So your table should have 16 rows (or columns) associated with 16 years

(Note: Total sales of the corporation equals to the sum of 3 divisions’ sales)

Sort your table on year (Smallest to Largest)

                                From that table, report the SUM of total sales of the 3 years: 2000, 2001 and 2002.

4c.          Create a reporting the total sales for each division in each period (you have a column called period in the original table). See the table below.

Sort Division from A to Z and sort period from Largest to Smallest.

                Report the SUM of the Top left and Bottom Right number (highlighted in the table below).

                (do not include Grand total in your calculation)

                               

Answer 1

4a
	Division	Average Annual Revenue
	A	392
	B	477
	C	493
	Sum Of the 3 Average Numbers -			1363

4b
	Year	Total Revenue
	2000	1317
	2001	1859
	2002	812
	2003	2416
	2004	1765
	2005	1177
	2006	1829
	2007	1559
	2008	1367
	2009	1188
	2010	1250
	2011	918
	2012	1374
	2013	1444
	2014	218
	2015	835
	Total Sum For 2000,2001 & 2002			3988

4c
	Division	Period	Total Sales
	A	1	2433
	A	2	1902
	A	3	1342
	A	4	260
	A	5	339
	B	1	1934
	B	2	1800
	B	3	851
	B	4	1733
	B	5	841
	C	1	2037
	C	2	1069
	C	3	1921
	C	4	1549
	C	5	1317
	Total Sales		21328