E.1 Case Study 1 (1)

.xlsx
In Class Case Study Extrapolate, Clean, Validate, Analyze, and Present *Hint: Data ribbon>Data Tools section *DO NOT copy or pull in any data from the Case Study Key tab, it is there as a guide and a check. All informatio *Pro-Tip: When creating a check figure, always reference the off tab number first in your formula. That way w *No right answer but I want you to back up your answer. Use a new excel sheet and format it to be able to tran Segment:Country:Product:Discount Band,Units Sold,Gross Sales, Sales>Profit>Date Government:Canada:Carretera:None,1618.5,32370,32370>16185>41640 Government:Germany:Carretera:None,1321,26420,26420>13210>41640 Midmarket:France:Carretera:None,2178,32670,32670>10890>41791 Midmarket:Germany:Carretera:None,888,13320,13320>4440>41791 Midmarket:Mexico:Carretera:None,2470,37050,37050>12350>41791 Government:Germany:Carretera:None,1513,529550,529550>136170>41974 Midmarket:Germany:Montana:None,921,13815,13815>4605>41699 Channel Partners:Canada:Montana:None,2518,30216,30216>22662>41791 Government:France:Montana:None,1899,37980,37980>18990>41791 Channel Partners:Germany:Montana:None,1545,18540,18540>13905>41791 Midmarket:Mexico:Montana:None,2470,37050,37050>12350>41791 Enterprise:Canada:Montana:None,2665.5,333187.5,333187.5>13327.5>41821 Small Business:Mexico:Montana:None,958,287400,287400>47900>41852 Government:Germany:Montana:None,2146,15022,15022>4292>41883 Enterprise:Canada:Montana:None,345,43125,43125>1725>41548 Midmarket:United States of America:Montana:None,615,9225,9225>3075>41974 Government:Canada:Paseo:None,292,5840,5840>2920>41671 Midmarket:Mexico:Paseo:None,974,14610,14610>4870>41671 Channel Partners:Canada:Paseo:None,2518,30216,30216>22662>41791 Government:Germany:Paseo:None,1006,352100,352100>90540>41791 Channel Partners:Germany:Paseo:None,367,4404,4404>3303>41821 Government:Mexico:Paseo:None,883,6181,6181>1766>41852 Midmarket:France:Paseo:None,549,8235,8235>2745>41518 Small Business:Mexico:Paseo:None,788,236400,236400>39400>41518 Midmarket:Mexico:Paseo:None,2472,37080,37080>12360>41883 Government:United States of America:Paseo:None,1143,8001,8001>2286>41913 First, Extrapolate the txt file data below into a table. Second , Clean the data to contain and look exactly like the table on the Case Study Key tab (does not need to b Third , Validate the information by comparing each column to the table on the Case Study Key tab to your creat Fourth , Analyze the information: Show a pivot table that will show the profit each year (Columns) of each cou Fifth , On a different tab than the fourth step, present a chart with any of the data for each product over each y
Government:Canada:Paseo:None,1725,603750,603750>155250>41579 Channel Partners:United States of America:Paseo:None,912,10944,10944>8208>41579 Midmarket:Canada:Paseo:None,2152,32280,32280>10760>41609 Government:Canada:Paseo:None,1817,36340,36340>18170>41974 Government:Germany:Paseo:None,1513,529550,529550>136170>41974 Government:Mexico:Velo:None,1493,10451,10451>2986>41640 Enterprise:France:Velo:None,1804,225500,225500>9020>41671 Channel Partners:Germany:Velo:None,2161,25932,25932>19449>41699 Government:Germany:Velo:None,1006,352100,352100>90540>41791 Channel Partners:Germany:Velo:None,1545,18540,18540>13905>41791 Enterprise:United States of America:Velo:None,2821,352625,352625>14105>41852 Enterprise:Canada:Velo:None,345,43125,43125>1725>41548 Small Business:Canada:VTT:None,2001,600300,600300>100050>41671 Channel Partners:Germany:VTT:None,2838,34056,34056>25542>41730 Midmarket:France:VTT:None,2178,32670,32670>10890>41791 Midmarket:Germany:VTT:None,888,13320,13320>4440>41791 Government:France:VTT:None,1527,534450,534450>137430>41518 Small Business:France:VTT:None,2151,645300,645300>107550>41883 Government:Canada:VTT:None,1817,36340,36340>18170>41974 Government:France:Amarilla:None,2750,962500,962500>247500>41671 Channel Partners:United States of America:Amarilla:None,1953,23436,23436>17577>41730 Enterprise:Germany:Amarilla:None,4219.5,527437.5,527437.5>21097.5>41730 Government:France:Amarilla:None,1899,37980,37980>18990>41791 Government:Germany:Amarilla:None,1686,11802,11802>3372>41821 Channel Partners:United States of America:Amarilla:None,2141,25692,25692>19269>41852 Government:United States of America:Amarilla:None,1143,8001,8001>2286>41913 Midmarket:United States of America:Amarilla:None,615,9225,9225>3075>41974 Government:France:Paseo:Low,3945,27615,27338.85>7613.85>41640 Midmarket:France:Paseo:Low,2296,34440,34095.6>11135.6>41671 Government:France:Paseo:Low,1030,7210,7137.9>1987.9>41760 Government:France:Velo:Low,639,4473,4428.27>1233.27>41944 Government:Canada:VTT:Low,1326,9282,9189.18>2559.18>41699 Channel Partners:United States of America:Carretera:Low,1858,22296,22073.04>16499.04>41671 Government:Mexico:Carretera:Low,1210,423500,419265>104665>41699 Government:United States of America:Carretera:Low,2529,17703,17525.97>4880.97>41821 Channel Partners:Canada:Carretera:Low,1445,17340,17166.6>12831.6>41883 Enterprise:United States of America:Carretera:Low,330,41250,40837.5>1237.5>41518 Channel Partners:France:Carretera:Low,2671,32052,31731.48>23718.48>41883 Channel Partners:Germany:Carretera:Low,766,9192,9100.08>6802.08>41548 Small Business:Mexico:Carretera:Low,494,148200,146718>23218>41548 Government:Mexico:Carretera:Low,1397,488950,484060.5>120840.5>41913 Government:France:Carretera:Low,2155,754250,746707.5>186407.5>41974 Midmarket:Mexico:Montana:Low,2214,33210,32877.9>10737.9>41699 Small Business:United States of America:Montana:Low,2301,690300,683397>108147>41730 Government:France:Montana:Low,1375.5,27510,27234.9>13479.9>41821
Government:Canada:Montana:Low,1830,12810,12681.9>3531.9>41852 Small Business:United States of America:Montana:Low,2498,749400,741906>117406>41518 Enterprise:United States of America:Montana:Low,663,82875,82046.25>2486.25>41548 Midmarket:United States of America:Paseo:Low,1514,22710,22482.9>7342.9>41671 Government:United States of America:Paseo:Low,4492.5,31447.5,31133.025>8670.525>41730 Enterprise:United States of America:Paseo:Low,727,90875,89966.25>2726.25>41791 Enterprise:France:Paseo:Low,787,98375,97391.25>2951.25>41791 Enterprise:Mexico:Paseo:Low,1823,227875,225596.25>6836.25>41821 Midmarket:Germany:Paseo:Low,747,11205,11092.95>3622.95>41883 Channel Partners:Germany:Paseo:Low,766,9192,9100.08>6802.08>41548 Small Business:United States of America:Paseo:Low,2905,871500,862785>136535>41944 Government:France:Paseo:Low,2155,754250,746707.5>186407.5>41974 Government:France:Velo:Low,3864,77280,76507.2>37867.2>41730 Government:Mexico:Velo:Low,362,2534,2508.66>698.66>41760 Enterprise:Canada:Velo:Low,923,115375,114221.25>3461.25>41852 Enterprise:United States of America:Velo:Low,663,82875,82046.25>2486.25>41548 Government:Canada:Velo:Low,2092,14644,14497.56>4037.56>41579 Government:Germany:VTT:Low,263,1841,1822.59>507.59>41699 Government:Canada:VTT:Low,943.5,330225,326922.75>81612.75>41730 Enterprise:United States of America:VTT:Low,727,90875,89966.25>2726.25>41791 Enterprise:France:VTT:Low,787,98375,97391.25>2951.25>41791 Small Business:Germany:VTT:Low,986,295800,292842>46342>41883 Small Business:Mexico:VTT:Low,494,148200,146718>23218>41548 Government:Mexico:VTT:Low,1397,488950,484060.5>120840.5>41913 Enterprise:France:VTT:Low,1744,218000,215820>6540>41944 Channel Partners:United States of America:Amarilla:Low,1989,23868,23629.32>17662.32>41518 Midmarket:France:Amarilla:Low,321,4815,4766.85>1556.85>41579 Enterprise:Canada:Carretera:Low,742.5,92812.5,90956.25>1856.25>41730 Channel Partners:Canada:Carretera:Low,1295,15540,15229.2>11344.2>41913 Small Business:Germany:Carretera:Low,214,64200,62916>9416>41548 Government:France:Carretera:Low,2145,15015,14714.7>3989.7>41579 Government:Canada:Carretera:Low,2852,998200,978236>236716>41974 Channel Partners:United States of America:Montana:Low,1142,13704,13429.92>10003.92>41791 Government:United States of America:Montana:Low,1566,31320,30693.6>15033.6>41913 Channel Partners:Mexico:Montana:Low,690,8280,8114.4>6044.4>41944 Enterprise:Mexico:Montana:Low,1660,207500,203350>4150>41579 Midmarket:Canada:Paseo:Low,2363,35445,34736.1>11106.1>41671 Small Business:France:Paseo:Low,918,275400,269892>40392>41760 Small Business:Germany:Paseo:Low,1728,518400,508032>76032>41760 Channel Partners:United States of America:Paseo:Low,1142,13704,13429.92>10003.92>41791 Enterprise:Mexico:Paseo:Low,662,82750,81095>1655>41791 Channel Partners:Canada:Paseo:Low,1295,15540,15229.2>11344.2>41913 Enterprise:Germany:Paseo:Low,809,101125,99102.5>2022.5>41548 Enterprise:Mexico:Paseo:Low,2145,268125,262762.5>5362.5>41548 Channel Partners:France:Paseo:Low,1785,21420,20991.6>15636.6>41579
Uploaded by AgentCobraPerson954 on coursehero.com