X AutoSave Off Marketing Analytical Exercise_ - Excel Search (Alt+Q) rashesh sayani RS X File Home Insert Draw Page Layout Formulas Data Review View Developer Add-ins Help Acrobat Power Pivot Analysis EPM Data Manager Comments Share D'a From Text/CSV To Recent Sources [ Queries & Connections Clear GE Data Analysis Get Le From Web La Existing Connections Refresh Properties Sort Filter 1Reapply Text to Outline All Stocks ZJ What-If Forecast Data From Table/Range Edit Links Geography Advanced Columns Analysis Sheet Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Analysis Q23 vi XVfx A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AWN Scenario Sales of ShoeLily.com's products follow a peculiar, but predictable, pattern that determines how many units will sell in any given year. This pattern is shown below Unit Sales Shoe Color 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 Red 28 42 21 23 29 15 8 2 discontinued Green 26 39 20 22 28 14 7 4 2 White 43 65 33 36 45 23 12 13 Brown 58 87 44 48 60 14 Yellow 37 56 28 31 Black 28 42 21 16 Orange 19 29 17 Purple 24 18 Total 28 42 21 49 68 78 95 123 176 181 164 179 19 Questions A) Which color will sell the most units in 2007? 24 B) Which color will sell the most units combined in the 2007 to 2009 period? 25 26 Please show all your analysis, leave formulas in cells, and specify any assumptions you make. 27 28 29 30 31 32 README ShoeLily Search Optimization Homepage Conversion + Ready 100% Type here to search O 2 0 G 20 X 22 C Cloudy d ENG 10:34 PM 12/17/2021