Homework Help Q&A from O x I @ Assignments - MTH-1024) rs x @ MTH 102 Milestone 1 ['l].pdf x + e 9 G G) File I [UsersfuserfDownloadsfMTH%20102%20Milestone%201%20t1l.pdf MTH 1E12 Milestone 1 (1).pdf Part One: Excel Data Analysis For the rst part of the project you will analyze a few key performance characteristics of this toy company. This toy company does business internationally and it is interesting to look at where the company does business. It is also interesting to observe the types of products that are popular amongst each country. Consider how you might further develop the markets that seem promising in your analysis. You are welcome to make more pivots than suggested below if you would like to do a deeper analysis. First click anywhere on the data and click on \"Insert PivotTable". Add a new PivotTable for each part so you don't lose your work. In total you will need six tabsone forthe data and five for each ofthe ve pivotsjcharts you will create. Next please create the following PivotTables and insert PivotCharts as requested: 1] Find the total count of orders in each territory. Then add an additional row below the territory to find the breakdown among each country. 2] Create a pivotthat filters the country to only United States. Create a bar graph that shows the distribution of sales across each state. 3] Create a pie-chart that shoes the percentage of orders for each productline item listed in the data. 4] Create a line-graph that indicates the total sales per quarter over 2003, 2004, and 2005 [*hint add the orderdate column to your pivot and it will populate years and quarters automatically]. Create a histogram that shows the distribution of sales across all orders. Excel File Edit View Insert Format Tools Data Window Help 4 )) 50% ) Thu 4:29 PM User Q E DO MTH 102 Milestone 1 Data (2) Q ~ Search Sheet Home Insert Page Layout Formulas Data Review View Insert Calibri (Body) * 12 . A- A = = = 30 Wrap Text General x Delete Paste BI UTYM. A. Merge & Center $ ~ % " .00 $.0 Conditional Format Cell Sort & Formatting as Table Styles Format Filter X V fx ORDERNUMBER C D G H M O Q ORDERNUME QUANTITYOF PRICEEACH ORDERLINEN SALES ORDERDATE STATUS QTR_ID MONTH_ID YEAR_ID PRODUCTLIN MSRP PRODUCTCO CUSTOMERN PHONE ADDRESSLINE ADDRESSLINE2 10107 30 95.7 2871 ######## # ## Shipped 2003 Motorcycles 95 $10_1678 Land of Toys 2.126E+09 897 Long Airport Avenue 10121 34 81.35 2765.9 5/7/03 0:00 Shipped JU N 2003 Motorcycles 95 510_1678 Reims Collect 26.47.1555 59 rue de l'Abbaye 10134 41 94.74 3884.34 7/1/03 0:00 Shipped 2003 Motorcycles 95 $10_1678 Lyon Souvenirue du Colonel Pierre Avia 10145 45 83.26 3746.7 ######## ### Shipped 2003 Motorcycles 95 510_1678 Toys4Grown( 6.266E+09 78934 Hillside Dr. 10159 49 100 5205.27 ########### Shipped 10 2003 Motorcycles 95 $10_1678 Corporate Git 6.506E+09 7734 Strong St 10168 36 96.66 3479.76 ########### Shipped 10 2003 Motorcycles 95 $10_1678 Technics Stor 6.506E+09 9408 Furth Circle 10180 29 86.13 2497.77 ######## ### Shipped 11 2003 Motorcycles 95 S10_1678 Daedalus De: 20.16.1555 184, chausse de Tournai 10188 48 100 5512.32 ########### Shipped 11 2003 Motorcycles 95 $10_1678 Herkku Gifts +47 2267 321 Drammen 121, PR 744 Sentrum 10201 22 98.57 2168.54 ######## ###Shipped 12 2003 Motorcycles 95 $10_1678 Mini Wheels 6.506E+09 5557 North Pendale Street 10211 41 100 14 4708.44 ######## ###Shipped 2004 Motorcycles 95 510_1678 Auto Canal Pi (1) 47.55.655 25, rue Lauriston 10223 37 100 3965.66 ##### ###### Shipped 2004 Motorcycles 95 510_1678 Australian Co 03 9520 4555 636 St Kilda F Level 3 10237 23 100 2333.12 4/5/04 0:00 Shipped 2004 Motorcycles 95 $10_1678 Vitachrome I 2.126E+09 2678 Kingsto Suite 101 10251 28 100 3188.64 ######0# ### Shipped 2004 Motorcycles 95 510_1678 Tekni Collect: 2.016E+09 7476 Moss Rd. 10263 34 100 3676.76 ########### Shipped 2004 Motorcycles 95 $10_1678 Gift Depot In 2.036E+09 25593 South Bay Ln. 10275 45 92.83 4177.35 ########### Shipped 2004 Motorcycles 95 510_1678 La Rochelle G 40.67.8555 67, rue des Cinquante Otages 10285 36 100 4099.68 ######0# ###Shipped 2004 Motorcycles 95 510_1678 Marta's Repli 6.176E+09 39323 Spinnaker Dr. 10299 23 100 2597.39 ######## ### Shipped 2004 Motorcycles 95 $10_1678 Toys of Finlar 90-224 8555 Keskuskatu 45 10309 41 100 5 4394.38 ########### Shipped 10 2004 Motorcycles 95 $10_1678 Baane Mini Ir 07-98 9555 Erling Skakkes gate 78 10318 46 94.74 4358.04 ######## ### Shipped 11 2004 Motorcycles 95 510_1678 Diecast Class 2.156E+09 7586 Pompton St. 10329 42 100 4396.14 ########### Shipped 11 2004 Motorcycles 95 510_1678 Land of Toys 2.126E+09 897 Long Airport Avenue 10341 41 100 7737.93 #H### ### ### Shipped 11 2004 Motorcycles 95 $10_1678 Salzburg Colli 6562-9555 Geislweg 14 10361 20 72.55 13 1451 ########### Shipped 12 2004 Motorcycles 95 $10_1678 Souvenirs A +61 2 9495 8 Monitor Mor Level 6 10375 21 34.91 12 733.11 2/3/05 0:00 Shipped 2005 Motorcycles 95 S10_1678 La Rochelle G 40.67.8555 67, rue des Cinquante Otages 10388 42 76.36 3207.12 3/3/05 0:00 Shipped 2005 Motorcycles 95 $10_1678 FunGiftIdeas. 5.086E+09 1785 First Street 10403 24 100 2434.56 4/8/05 0:00 Shipped 95 510_1678 UK Collectabl (171) 555-22: Berkeley Gardens 12 Brewery WHUPWN 2005 Motorcycles 10417 66 100 IN 7516.08 ######## ### Disputed 2005 Motorcycles 95 510_1678 Euro Shoppin (91) 555 94 4 C/ Moralzarzal, 86 10103 26 100 11 5404.62 ### ##### ###Shipped 2003 Classic Cars 214 $10_1949 Baane Mini Ir 07-98 9555 Erling Skakkes gate 78 10112 29 100 1 7209.11 #H# ########Shipped 2003 Classic Cars 214 $10_1949 Volvo Model 0921-12 355: Berguvsv,gen 8 MTH 102 Milestone 1 Data (2) + Ready + 110% JACOB KA Ae Au Br Dw En FW Fl Ai Id Ps Pl Pr $8 Lr P 3 x] N] 7 / 497 4 ))49% Thu 4:30 PM User Q E Excel File Edit View Insert Format Tools Data Window Help Q ~ Search Sheet DO MTH 102 Milestone 1 Data (2) Home Insert Page Layout Formulas Data Review View Insert Calibri (Body) * 12 . A- A = = = 30 Wrap Text General x Delete .00 Conditional Format Cell Sort & Paste BI UTVS. A. Merge & Center $ ~ % " 100 $.0 Formatting as Table Styles Format Filter 21 X V fx ADDRESSLINE2 W X Z AA AB AC AD AE AF AG Q R S T U ADDRESSLINE2 CITY STATE POSTALCODE COUNTRY TERRITORY CONTACTLAS CONTACTFIR! DEALSIZE NYC NY 10022 USA NA YU Kwai Small port Avenue Reims 51100 France EMEA Henriot Paul Small bbaye onel Pierre Avia Pari 75508 France EMEA Da Cunha Daniel Medium Dr. Pasadena CA 90003 USA NA Young Julie Medium St. San Francisco CA USA NA Brown Julie Medium INA Hirano Juri rcle Burlingame CA 94217 USA Medium de Tournai Lille 59000 France MEA Rance Martine Small 1, PR 744 Sentrum Bergen N 5804 Norway EMEA Oeztan Veyse Medium endale Street San Francisco CA USA NA Murphy Julie Small Dominique Medium ton Paris 75016 France EMEA Perrier Melbourne Victoria APAC Peter Medium Level 3 3004 Australia Ferguson Small Suite 101 NYC NY 10022 USA NA Frick Michael Newark NJ 94019 USA NA Brown William Medium Bridgewater CT NA King Julie Medium Bay Ln. 97562 USA inquante Otages Nantes 44000 France EMEA Labrune Janine Medium Cambridge MA 51247 USA NA Hernandez Marta Medium ker Dr. 5 Helsinki 21240 Finland EMEA Karttunen Matti Small Jonas Medium 9 s gate 78 Stavern 4110 Norway EMEA Bergulfsen in St Allentown PA 70267 USA NA Yu Kyung Medium Yu Kwai Medium port Avenue NYC NY 10022 USA NA Salzburg 5020 Austria EMEA Pipps Georg Large Level 6 Chatswood NSW 2067 Australia APAC Huxley Adrian Small inquante Otages Nantes 44000 France EMEA Labrune Janine Small leet New Bedford MA 50553 USA NA Benitez Violeta Medium WX1 6LT EMEA Devon Elizabeth Small dens 12 Brewery Liverpool UK al, 86 Madrid 28034 Spain EMEA Freyre Diego Large Medium Is gate 78 Stavern 4110 Norway EMEA Bergulfsen Jonas 18 Lule S-958 22 Sweden EMEA Berglund Christina Large MTH 102 Milestone 1 Data (2) + + 1 10% Ready JACOB KA Ae Au Br Dw En FW Fl Ai Id Ps Pl Pr Sg Lr P 1 x] N JA