10 F29 Xv fx A B ( 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Date 5/31/07 8/31/07 11/30/07 2/29/08 5/30/08 8/29/08 11/28/08 2/27/09 5/29/09 8/31/09 11/30/09 2/26/10 5/28/10 8/31/10 11/30/10 2/28/11 5/31/11 7/29/11 11/30/11 2/29/12 4/30/12 7/31/12 10/31/12 1/31/13 4/30/13 7/31/13 10/31/13 1/31/14 4/30/14 7/31/14 10/31/14 1/30/15 4/30/15 7/31/15 10/30/15 1/29/16 4/29/16 7/29/16 10/31/16 1/31/17 4/28/17 BBY 7,927 8,750 9,928 13,418 8,990 9,801 11,500 14,724 10,095 11,022 12,024 16,553 10,787 11,339 11,890 16,256 10,940 10,856 12,099 17,335 11,610 10,547 10,753 16,711 9,380 9,300 9,362 14,368 9,035 8,896 9,380 14,209 8,558 8,528 8,819 13,623 8,443 8,533 8,945 13,482 8,528 35 36 37 38 39 40 41 42 43 44 Sheet1 Sht OFF sert Draw Page Layout Formulas Topic 4 - VLOOKUP-ANSC Data Review Calibri (Body) View Tell me 11 B I U ' av A General Merge Center X fx 3-% 9 D E F ing Average H Seasonal Factor Seasonal Index Theoretical Values Analysis 1 2 10 F29 Xv fx A B ( 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Date 5/31/07 8/31/07 11/30/07 2/29/08 5/30/08 8/29/08 11/28/08 2/27/09 5/29/09 8/31/09 11/30/09 2/26/10 5/28/10 8/31/10 11/30/10 2/28/11 5/31/11 7/29/11 11/30/11 2/29/12 4/30/12 7/31/12 10/31/12 1/31/13 4/30/13 7/31/13 10/31/13 1/31/14 4/30/14 7/31/14 10/31/14 1/30/15 4/30/15 7/31/15 10/30/15 1/29/16 4/29/16 7/29/16 10/31/16 1/31/17 4/28/17 BBY 7,927 8,750 9,928 13,418 8,990 9,801 11,500 14,724 10,095 11,022 12,024 16,553 10,787 11,339 11,890 16,256 10,940 10,856 12,099 17,335 11,610 10,547 10,753 16,711 9,380 9,300 9,362 14,368 9,035 8,896 9,380 14,209 8,558 8,528 8,819 13,623 8,443 8,533 8,945 13,482 8,528 35 36 37 38 39 40 41 42 43 44 Sheet1 Sht OFF sert Draw Page Layout Formulas Topic 4 - VLOOKUP-ANSC Data Review Calibri (Body) View Tell me 11 B I U ' av A General Merge Center X fx 3-% 9 D E F ing Average H Seasonal Factor Seasonal Index Theoretical Values Analysis 1 2