This\u00a0assignment\u00a0requires\u00a0you\u00a0to\u00a0use\u00a0Excel\u00a0to\u00a0answer\u00a0the\u00a0questions\u00a0and\u00a0create\u00a0the\u00a0charts.\u00a0However\u00a0when\u00a0presenting\u00a0reports\u00a0in\u00a0business,\u00a0you\u00a0will\u00a0find\u00a0that\u00a0most\u00a0managers\u00a0will\u00a0prefer\u00a0to\u00a0read\u00a0Word\u00ae\u00a0documents\u00a0or\u00a0PowerPoint\u00ae\u00a0slides\u00a0rather\u00a0than\u00a0go\u00a0through\u00a0Excel\u00a0sheets.\u00a0Being\u00a0able\u00a0to\u00a0move\u00a0your\u00a0work\u00a0from\u00a0Excel\u00a0to\u00a0Word\u00ae\u00a0is\u00a0a\u00a0valuable\u00a0skill.\u00a0For\u00a0this\u00a0assignment,\u00a0you\u00a0should\u00a0copy\u00a0all\u00a0your\u00a0charts\u00a0and\u00a0comments\u00a0to\u00a0a\u00a0Word\u00a0document\u00a0and\u00a0submit\u00a0that\u00a0Word\u00a0file.\u00a0Clearly\u00a0label\u00a0all\u00a0questions\u00a0and\u00a0charts,\u00a0as\u00a0well\u00a0as\u00a0your\u00a0answers.\tQuestion\u00a01\tAccording\u00a0to\u00a0T-100\u00a0Domestic\u00a0Market,\u00a0the\u00a0top\u00a0seven\u00a0airlines\u00a0in\u00a0the\u00a0United\u00a0States\u00a0by\u00a0domestic\u00a0boardings\u00a0in\u00a0a\u00a0recent\u00a0year\u00a0were\u00a0Southwest\u00a0Airlines\u00a0with\u00a081.1\u00a0million,\u00a0Delta\u00a0Airlines\u00a0with\u00a079.4\u00a0million,\u00a0American\u00a0Airlines\u00a0with\u00a072.6\u00a0million,\u00a0United\u00a0Airlines\u00a0with\u00a056.3\u00a0million,\u00a0Northwest\u00a0Airlines\u00a0with\u00a043.3\u00a0million,\u00a0U.S.\u00a0Airways\u00a0with\u00a037.8\u00a0million,\u00a0and\u00a0Continental\u00a0Airlines\u00a0with\u00a031.5\u00a0million.\u00a0Construct\u00a0a\u00a0pie\u00a0chart\u00a0and\u00a0a\u00a0bar\u00a0graph\u00a0to\u00a0depict\u00a0this\u00a0information.\tQuestion\u00a02\tThe\u00a0U.S.\u00a0Department\u00a0of\u00a0the\u00a0Interior\u00a0releases\u00a0figures\u00a0on\u00a0mineral\u00a0production.\u00a0Following\u00a0are\u00a0the\u00a015\u00a0leading\u00a0states\u00a0in\u00a0nonfuel\u00a0mineral\u00a0production\u00a0in\u00a0the\u00a0United\u00a0States\u00a0in\u00a02008.\tState\u00a0Value\u00a0($\u00a0billions)\u00a0Arizona\u00a07.84\tNevada\u00a06.48\tFlorida\u00a04.20\tUtah\u00a04.17\u00a0California\u00a04.00\u00a0Texas\u00a03.30\u00a0Minnesota\u00a03.21\u00a0Alaska\u00a02.74\u00a0Missouri\u00a02.08\u00a0Colorado\u00a02.05\u00a0Michigan\u00a02.05\u00a0Wyoming\u00a01.89\u00a0Georgia\u00a01.85\tNew\u00a0Mexico\u00a01.81\u00a0Pennsylvania\u00a01.68\ta)\u00a0Using\u00a0the\u00a0data\u00a0analysis\u00a0toolpak\u00a0in\u00a0Excel,\u00a0calculate\u00a0the\u00a0descriptive\u00a0statistics.\tb)\u00a0Briefly\u00a0explain\u00a0what\u00a0each\u00a0of\u00a0the\u00a0metrics\u00a0in\u00a0the\u00a0summary\u00a0statistics\u00a0means.\tc)\u00a0Commentonthefiguresinthereport.Whataretheytellingyouaboutthisdataset?Isit\tsymmetrical,\u00a0flat,\u00a0skewed,\u00a0does\u00a0it\u00a0have\u00a0outliers,\u00a0and\u00a0so\u00a0on?\tQuestion\u00a03\tSuppose\u00a0Procter\u00a0&\u00a0Gamble\u00a0sells\u00a0about\u00a020\u00a0million\u00a0bars\u00a0of\u00a0soap\u00a0per\u00a0week,\u00a0but\u00a0the\u00a0demand\u00a0is\u00a0not\u00a0constant,\u00a0and\u00a0production\u00a0management\u00a0would\u00a0like\u00a0to\u00a0get\u00a0a\u00a0better\u00a0handle\u00a0on\u00a0how\u00a0sales\u00a0are\u00a0distributed\u00a0over\u00a0the\u00a0year.\u00a0Let\u00a0the\u00a0following\u00a0sales\u00a0figures\u00a0given\u00a0in\u00a0units\u00a0of\u00a0million\u00a0bars\u00a0represent\u00a0the\u00a0sales\u00a0of\u00a0bars\u00a0per\u00a0week\u00a0over\u00a0one\u00a0year.\u00a0Construct\u00a0a\u00a0histogram\u00a0to\u00a0represent\u00a0these\u00a0data.\u00a0What\u00a0do\u00a0you\u00a0see\u00a0in\u00a0the\u00a0graph\u00a0that\u00a0might\u00a0be\u00a0helpful\u00a0to\u00a0the\u00a0production\u00a0(and\u00a0sales)\u00a0people?\t17.1\u00a017.1\u00a017\u00a025.2\u00a019.6\u00a012.2\u00a018.3\u00a026.3\u00a015.4\u00a019.9\u00a013.6\u00a023.9\u00a017.4\u00a018.7\u00a039.8\u00a030.6\t15\u00a020.4\u00a020.7\u00a025.2\u00a018.5\u00a020.3\u00a021.3\u00a026.2\u00a020.6\u00a015.5\u00a022.5\u00a026.9\u00a018.4\u00a016.8\u00a021.4\u00a032.8\t20\u00a019.1\u00a023.4\u00a026.3\u00a020.9\u00a020.4\u00a023.1\u00a026.6\u00a019.3\u00a015.4\u00a022.8\u00a024.3\u00a018.2\u00a020.3\u00a021.4\u00a026.2\u00a014.7\u00a017.5\u00a024\u00a023.8<\/p>\n","protected":false},"excerpt":{"rendered":"
This\u00a0assignment\u00a0requires\u00a0you\u00a0to\u00a0use\u00a0Excel\u00a0to\u00a0answer\u00a0the\u00a0questions\u00a0and\u00a0create\u00a0the\u00a0charts.\u00a0However\u00a0when\u00a0presenting\u00a0reports\u00a0in\u00a0business,\u00a0you\u00a0will\u00a0find\u00a0that\u00a0most\u00a0managers\u00a0will\u00a0prefer\u00a0to\u00a0read\u00a0Word\u00ae\u00a0documents\u00a0or\u00a0PowerPoint\u00ae\u00a0slides\u00a0rather\u00a0than\u00a0go\u00a0through\u00a0Excel\u00a0sheets.\u00a0Being\u00a0able\u00a0to\u00a0move\u00a0your\u00a0work\u00a0from\u00a0Excel\u00a0to\u00a0Word\u00ae\u00a0is\u00a0a\u00a0valuable\u00a0skill.\u00a0For\u00a0this\u00a0assignment,\u00a0you\u00a0should\u00a0copy\u00a0all\u00a0your\u00a0charts\u00a0and\u00a0comments\u00a0to\u00a0a\u00a0Word\u00a0document\u00a0and\u00a0submit\u00a0that\u00a0Word\u00a0file.\u00a0Clearly\u00a0label\u00a0all\u00a0questions\u00a0and\u00a0charts,\u00a0as\u00a0well\u00a0as\u00a0your\u00a0answers. Question\u00a01 According\u00a0to\u00a0T-100\u00a0Domestic\u00a0Market,\u00a0the\u00a0top\u00a0seven\u00a0airlines\u00a0in\u00a0the\u00a0United\u00a0States\u00a0by\u00a0domestic\u00a0boardings\u00a0in\u00a0a\u00a0recent\u00a0year\u00a0were\u00a0Southwest\u00a0Airlines\u00a0with\u00a081.1\u00a0million,\u00a0Delta\u00a0Airlines\u00a0with\u00a079.4\u00a0million,\u00a0American\u00a0Airlines\u00a0with\u00a072.6\u00a0million,\u00a0United\u00a0Airlines\u00a0with\u00a056.3\u00a0million,\u00a0Northwest\u00a0Airlines\u00a0with\u00a043.3\u00a0million,\u00a0U.S.\u00a0Airways\u00a0with\u00a037.8\u00a0million,\u00a0and\u00a0Continental\u00a0Airlines\u00a0with\u00a031.5\u00a0million.\u00a0Construct\u00a0a\u00a0pie\u00a0chart\u00a0and\u00a0a\u00a0bar\u00a0graph\u00a0to\u00a0depict\u00a0this\u00a0information. Question\u00a02 The\u00a0U.S.\u00a0Department\u00a0of\u00a0the\u00a0Interior\u00a0releases\u00a0figures\u00a0on\u00a0mineral\u00a0production.\u00a0Following\u00a0are\u00a0the\u00a015\u00a0leading\u00a0states\u00a0in\u00a0nonfuel\u00a0mineral\u00a0production\u00a0in\u00a0the\u00a0United\u00a0States\u00a0in\u00a02008. State\u00a0Value\u00a0($\u00a0billions)\u00a0Arizona\u00a07.84 Nevada\u00a06.48 Florida\u00a04.20 Utah\u00a04.17\u00a0California\u00a04.00\u00a0Texas\u00a03.30\u00a0Minnesota\u00a03.21\u00a0Alaska\u00a02.74\u00a0Missouri\u00a02.08\u00a0Colorado\u00a02.05\u00a0Michigan\u00a02.05\u00a0Wyoming\u00a01.89\u00a0Georgia\u00a01.85 New\u00a0Mexico\u00a01.81\u00a0Pennsylvania\u00a01.68 a)\u00a0Using\u00a0the\u00a0data\u00a0analysis\u00a0toolpak\u00a0in\u00a0Excel,\u00a0calculate\u00a0the\u00a0descriptive\u00a0statistics. b)\u00a0Briefly\u00a0explain\u00a0what\u00a0each\u00a0of\u00a0the\u00a0metrics\u00a0in\u00a0the\u00a0summary\u00a0statistics\u00a0means. c)\u00a0Commentonthefiguresinthereport.Whataretheytellingyouaboutthisdataset?Isit symmetrical,\u00a0flat,\u00a0skewed,\u00a0does\u00a0it\u00a0have\u00a0outliers,\u00a0and\u00a0so\u00a0on? Question\u00a03 Suppose\u00a0Procter\u00a0&\u00a0Gamble\u00a0sells\u00a0about\u00a020\u00a0million\u00a0bars\u00a0of\u00a0soap\u00a0per\u00a0week,\u00a0but\u00a0the\u00a0demand\u00a0is\u00a0not\u00a0constant,\u00a0and\u00a0production\u00a0management\u00a0would\u00a0like\u00a0to\u00a0get\u00a0a\u00a0better\u00a0handle\u00a0on\u00a0how\u00a0sales\u00a0are\u00a0distributed\u00a0over\u00a0the\u00a0year.\u00a0Let\u00a0the\u00a0following\u00a0sales\u00a0figures\u00a0given\u00a0in\u00a0units\u00a0of\u00a0million\u00a0bars\u00a0represent\u00a0the\u00a0sales\u00a0of\u00a0bars\u00a0per\u00a0week\u00a0over\u00a0one\u00a0year.\u00a0Construct\u00a0a\u00a0histogram\u00a0to\u00a0represent\u00a0these\u00a0data.\u00a0What\u00a0do\u00a0you\u00a0see\u00a0in\u00a0the\u00a0graph\u00a0that\u00a0might\u00a0be\u00a0helpful\u00a0to\u00a0the\u00a0production\u00a0(and\u00a0sales)\u00a0people? 17.1\u00a017.1\u00a017\u00a025.2\u00a019.6\u00a012.2\u00a018.3\u00a026.3\u00a015.4\u00a019.9\u00a013.6\u00a023.9\u00a017.4\u00a018.7\u00a039.8\u00a030.6 15\u00a020.4\u00a020.7\u00a025.2\u00a018.5\u00a020.3\u00a021.3\u00a026.2\u00a020.6\u00a015.5\u00a022.5\u00a026.9\u00a018.4\u00a016.8\u00a021.4\u00a032.8 20\u00a019.1\u00a023.4\u00a026.3\u00a020.9\u00a020.4\u00a023.1\u00a026.6\u00a019.3\u00a015.4\u00a022.8\u00a024.3\u00a018.2\u00a020.3\u00a021.4\u00a026.2\u00a014.7\u00a017.5\u00a024\u00a023.8<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-217226","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/217226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=217226"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/217226\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=217226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=217226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=217226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}