his\u00a0is\u00a0your\u00a0final\u00a0project.\u00a0You\u00a0will\u00a0prepare\u00a0a\u00a0PowerPoint\tpresentation\u00a0to\u00a0present\u00a0your\u00a0findings.\u00a0This\u00a0assignment\u00a0requires\u00a0you\u00a0to\u00a0use\u00a0Excel;\u00a0make\u00a0sure\u00a0you\u00a0also\u00a0submit\u00a0the\u00a0Excel\u00a0file\u00a0to\u00a0show\u00a0your\u00a0work.\u00a0Place\u00a0all\u00a0calculations\u00a0for\u00a0each\u00a0of\u00a0the\u00a0questions\u00a0on\u00a0a\u00a0separate\u00a0worksheet.\u00a0Then,\u00a0using\u00a0the\u00a0results\u00a0of\u00a0your\u00a0work\u00a0from\u00a0Excel,\u00a0prepare\u00a0PowerPoint\u00a0slides\u00a0to\u00a0answer\u00a0the\u00a0questions\u00a0in\u00a0a\u00a0presentation\u00a0format.\u00a0Search\u00a0the\u00a0Internet\u00a0to\u00a0ensure\u00a0that\u00a0you\u00a0are\u00a0using\u00a0the\u00a0best\u00a0PowerPoint\u00a0tips\u00a0to\u00a0display\u00a0an\u00a0appropriate\u00a0presentation.\u00a0Check\u00a0the\u00a0Webliography\u00a0tab\u00a0at\u00a0the\u00a0top\u00a0of\u00a0the\u00a0course\u00a0page\u00a0for\u00a0help.\tFor\u00a0the\u00a0final\u00a0project,\u00a0you\u00a0will\u00a0be\u00a0analyzing\u00a0the\u00a0“Colonial\u00a0Broadcasting”\ufffd\u00a0case.\u00a0Answer\u00a0the\u00a0questions\u00a0listed\u00a0below,\u00a0NOT\u00a0the\u00a0questions\u00a0listed\u00a0in\u00a0the\u00a0case.\u00a0Ignore\u00a0everything\u00a0in\u00a0the\u00a0case\u00a0after\u00a0the\u00a0end\u00a0of\u00a0page\u00a06.\tThe\u00a0executives\u00a0at\u00a0CBC\u00a0want\u00a0to\u00a0see\u00a0how\u00a0they\u00a0are\u00a0doing\u00a0in\u00a0ratings\u00a0against\u00a0the\u00a0other\u00a0networks\u00a0and\u00a0how\u00a0the\u00a0ratings\u00a0will\u00a0continue\u00a0to\u00a0change\u00a0in\u00a0the\u00a0upcoming\u00a0months.\u00a0They\u00a0also\u00a0want\u00a0to\u00a0know\u00a0if\u00a0hiring\u00a0stars\u00a0makes\u00a0a\u00a0difference\u00a0and\u00a0the\u00a0impact\u00a0of\u00a0fact\u00a0based\u00a0programming\u00a0compared\u00a0to\u00a0hiring\u00a0stars.\u00a0You\u00a0will\u00a0create\u00a0a\u00a0PowerPoint\u00a0presentation\u00a0to\u00a0answer\u00a0the\u00a0questions\u00a0below.\u00a0Remember\u00a0that\u00a0your\u00a0audience\u00a0is\u00a0the\u00a0management\u00a0of\u00a0CBC:\u00a0Make\u00a0sure\u00a0your\u00a0presentation\u00a0is\u00a0professional\u00a0and\u00a0provides\u00a0sufficient\u00a0explanation.\t1.\u00a0Descriptive\u00a0statistics:\tWhat\u00a0is\u00a0the\u00a0average\u00a0rating\u00a0for\u00a0all\u00a0CBC\u00a0movies?\u00a0How\u00a0about\u00a0ABN\u00a0movies\u00a0and\u00a0BBS\u00a0movies?\u00a0Include\u00a0a\u00a0table\u00a0that\u00a0shows\u00a0the\u00a0average\u00a0and\u00a0the\u00a0other\u00a0descriptive\u00a0statistics\u00a0for\u00a0the\u00a0ratings\u00a0of\u00a0the\u00a0three\u00a0networks\u00a0(one\u00a0column\u00a0for\u00a0each\u00a0network).\u00a0Comment\u00a0on\u00a0which\u00a0network\u00a0is\u00a0doing\u00a0best\u00a0and\u00a0what\u00a0you\u00a0learn\u00a0from\u00a0the\u00a0other\u00a0key\u00a0metrics\u00a0in\u00a0the\u00a0table.\t2.\u00a0Charting:\tCreate\u00a0a\u00a0line\u00a0graph\u00a0of\u00a0the\u00a0monthly\u00a0average\u00a0ratings\u00a0for\u00a0CBC\u00a0for\u00a0the\u00a0year.\u00a0Note\u00a0that\u00a0there\u00a0are\u00a0multiple\u00a0ratings\u00a0data\u00a0for\u00a0the\u00a0months;\u00a0you\u00a0will\u00a0need\u00a0to\u00a0calculate\u00a0an\u00a0average\u00a0for\u00a0each\u00a0month\u00a0and\u00a0then\u00a0plot\u00a0the\u00a0averages.\u00a0After\u00a0you\u00a0create\u00a0the\u00a0graph,\u00a0fit\u00a0a\u00a0linear\u00a0trend\u00a0line,\u00a0displaying\u00a0the\u00a0formula\u00a0and\u00a0the\u00a0r-squared.\u00a0Explain\u00a0to\u00a0the\u00a0executives\u00a0if\u00a0you\u00a0can\u00a0use\u00a0this\u00a0time\u00a0series\u00a0data\u00a0to\u00a0forecast\u00a0the\u00a0ratings\u00a0of\u00a0upcoming\u00a0months.\u00a0How\u00a0accurate\u00a0can\u00a0you\u00a0expect\u00a0this\u00a0forecast\u00a0to\u00a0be?\t3.\u00a0Hypothesistesting:\tShould\u00a0the\u00a0CBC\u00a0hire\u00a0stars\u00a0for\u00a0their\u00a0movies?\u00a0To\u00a0answer\u00a0this\u00a0question,\u00a0run\u00a0a\u00a0hypothesis\u00a0test\u00a0to\u00a0see\u00a0if\u00a0there\u00a0is\u00a0a\u00a0significant\u00a0difference\u00a0between\u00a0the\u00a0ratings\u00a0of\u00a0movies\u00a0with\u00a0stars\u00a0vs.\u00a0movies\u00a0without\u00a0stars.\u00a0Use\u00a0the\u00a0data\u00a0for\u00a0CBC\u00a0movies\u00a0only.\u00a0Use\u00a095%\u00a0confidence.\u00a0Explain\u00a0your\u00a0answer-\u00a0do\u00a0not\u00a0simply\u00a0say\u00a0yes\u00a0or\u00a0no\u00a0without\u00a0referring\u00a0to\u00a0the\u00a0relevant\u00a0figures.\t4.\u00a0Regression:\tCBC\u00a0Management\u00a0has\u00a0several\u00a0questions:\u00a0Which\u00a0has\u00a0more\u00a0impact\u00a0on\u00a0a\u00a0movie’s\u00a0rating:\u00a0that\u00a0it\u00a0is\u00a0fact\u00a0based\u00a0or\u00a0that\u00a0it\u00a0has\u00a0one\u00a0star?\u00a0How\u00a0much\u00a0does\u00a0each\u00a0of\u00a0these\u00a0factors\u00a0change\u00a0the\u00a0ratings?\u00a0Do\u00a0you\u00a0expect\u00a0a\u00a0fact\u00a0based\u00a0movie\u00a0that\u00a0does\u00a0not\u00a0have\u00a0any\u00a0stars\u00a0to\u00a0get\u00a0better\u00a0ratings\u00a0than\u00a0a\u00a0fiction\u00a0movie\u00a0with\u00a0one\u00a0star?\u00a0Run\u00a0a\u00a0multiple\u00a0regression\u00a0where\u00a0the\u00a0dependent\u00a0variable\u00a0is\u00a0ratings\u00a0and\u00a0the\u00a0independent\u00a0variables\u00a0are\u00a0star\u00a0and\u00a0fact.\u00a0Use\u00a0data\u00a0from\u00a0all\u00a0networks,\u00a0not\u00a0just\u00a0CBC\u00a0movies.\u00a0How\u00a0well\u00a0does\u00a0this\u00a0regression\u00a0analysis\u00a0explain\u00a0the\u00a0ratings?\u00a0Justify\u00a0your\u00a0answers\u00a0based\u00a0on\u00a0the\u00a0results.<\/p>\n","protected":false},"excerpt":{"rendered":"
his\u00a0is\u00a0your\u00a0final\u00a0project.\u00a0You\u00a0will\u00a0prepare\u00a0a\u00a0PowerPoint presentation\u00a0to\u00a0present\u00a0your\u00a0findings.\u00a0This\u00a0assignment\u00a0requires\u00a0you\u00a0to\u00a0use\u00a0Excel;\u00a0make\u00a0sure\u00a0you\u00a0also\u00a0submit\u00a0the\u00a0Excel\u00a0file\u00a0to\u00a0show\u00a0your\u00a0work.\u00a0Place\u00a0all\u00a0calculations\u00a0for\u00a0each\u00a0of\u00a0the\u00a0questions\u00a0on\u00a0a\u00a0separate\u00a0worksheet.\u00a0Then,\u00a0using\u00a0the\u00a0results\u00a0of\u00a0your\u00a0work\u00a0from\u00a0Excel,\u00a0prepare\u00a0PowerPoint\u00a0slides\u00a0to\u00a0answer\u00a0the\u00a0questions\u00a0in\u00a0a\u00a0presentation\u00a0format.\u00a0Search\u00a0the\u00a0Internet\u00a0to\u00a0ensure\u00a0that\u00a0you\u00a0are\u00a0using\u00a0the\u00a0best\u00a0PowerPoint\u00a0tips\u00a0to\u00a0display\u00a0an\u00a0appropriate\u00a0presentation.\u00a0Check\u00a0the\u00a0Webliography\u00a0tab\u00a0at\u00a0the\u00a0top\u00a0of\u00a0the\u00a0course\u00a0page\u00a0for\u00a0help. For\u00a0the\u00a0final\u00a0project,\u00a0you\u00a0will\u00a0be\u00a0analyzing\u00a0the\u00a0“Colonial\u00a0Broadcasting”\ufffd\u00a0case.\u00a0Answer\u00a0the\u00a0questions\u00a0listed\u00a0below,\u00a0NOT\u00a0the\u00a0questions\u00a0listed\u00a0in\u00a0the\u00a0case.\u00a0Ignore\u00a0everything\u00a0in\u00a0the\u00a0case\u00a0after\u00a0the\u00a0end\u00a0of\u00a0page\u00a06. The\u00a0executives\u00a0at\u00a0CBC\u00a0want\u00a0to\u00a0see\u00a0how\u00a0they\u00a0are\u00a0doing\u00a0in\u00a0ratings\u00a0against\u00a0the\u00a0other\u00a0networks\u00a0and\u00a0how\u00a0the\u00a0ratings\u00a0will\u00a0continue\u00a0to\u00a0change\u00a0in\u00a0the\u00a0upcoming\u00a0months.\u00a0They\u00a0also\u00a0want\u00a0to\u00a0know\u00a0if\u00a0hiring\u00a0stars\u00a0makes\u00a0a\u00a0difference\u00a0and\u00a0the\u00a0impact\u00a0of\u00a0fact\u00a0based\u00a0programming\u00a0compared\u00a0to\u00a0hiring\u00a0stars.\u00a0You\u00a0will\u00a0create\u00a0a\u00a0PowerPoint\u00a0presentation\u00a0to\u00a0answer\u00a0the\u00a0questions\u00a0below.\u00a0Remember\u00a0that\u00a0your\u00a0audience\u00a0is\u00a0the\u00a0management\u00a0of\u00a0CBC:\u00a0Make\u00a0sure\u00a0your\u00a0presentation\u00a0is\u00a0professional\u00a0and\u00a0provides\u00a0sufficient\u00a0explanation. 1.\u00a0Descriptive\u00a0statistics: What\u00a0is\u00a0the\u00a0average\u00a0rating\u00a0for\u00a0all\u00a0CBC\u00a0movies?\u00a0How\u00a0about\u00a0ABN\u00a0movies\u00a0and\u00a0BBS\u00a0movies?\u00a0Include\u00a0a\u00a0table\u00a0that\u00a0shows\u00a0the\u00a0average\u00a0and\u00a0the\u00a0other\u00a0descriptive\u00a0statistics\u00a0for\u00a0the\u00a0ratings\u00a0of\u00a0the\u00a0three\u00a0networks\u00a0(one\u00a0column\u00a0for\u00a0each\u00a0network).\u00a0Comment\u00a0on\u00a0which\u00a0network\u00a0is\u00a0doing\u00a0best\u00a0and\u00a0what\u00a0you\u00a0learn\u00a0from\u00a0the\u00a0other\u00a0key\u00a0metrics\u00a0in\u00a0the\u00a0table. 2.\u00a0Charting: Create\u00a0a\u00a0line\u00a0graph\u00a0of\u00a0the\u00a0monthly\u00a0average\u00a0ratings\u00a0for\u00a0CBC\u00a0for\u00a0the\u00a0year.\u00a0Note\u00a0that\u00a0there\u00a0are\u00a0multiple\u00a0ratings\u00a0data\u00a0for\u00a0the\u00a0months;\u00a0you\u00a0will\u00a0need\u00a0to\u00a0calculate\u00a0an\u00a0average\u00a0for\u00a0each\u00a0month\u00a0and\u00a0then\u00a0plot\u00a0the\u00a0averages.\u00a0After\u00a0you\u00a0create\u00a0the\u00a0graph,\u00a0fit\u00a0a\u00a0linear\u00a0trend\u00a0line,\u00a0displaying\u00a0the\u00a0formula\u00a0and\u00a0the\u00a0r-squared.\u00a0Explain\u00a0to\u00a0the\u00a0executives\u00a0if\u00a0you\u00a0can\u00a0use\u00a0this\u00a0time\u00a0series\u00a0data\u00a0to\u00a0forecast\u00a0the\u00a0ratings\u00a0of\u00a0upcoming\u00a0months.\u00a0How\u00a0accurate\u00a0can\u00a0you\u00a0expect\u00a0this\u00a0forecast\u00a0to\u00a0be? 3.\u00a0Hypothesistesting: Should\u00a0the\u00a0CBC\u00a0hire\u00a0stars\u00a0for\u00a0their\u00a0movies?\u00a0To\u00a0answer\u00a0this\u00a0question,\u00a0run\u00a0a\u00a0hypothesis\u00a0test\u00a0to\u00a0see\u00a0if\u00a0there\u00a0is\u00a0a\u00a0significant\u00a0difference\u00a0between\u00a0the\u00a0ratings\u00a0of\u00a0movies\u00a0with\u00a0stars\u00a0vs.\u00a0movies\u00a0without\u00a0stars.\u00a0Use\u00a0the\u00a0data\u00a0for\u00a0CBC\u00a0movies\u00a0only.\u00a0Use\u00a095%\u00a0confidence.\u00a0Explain\u00a0your\u00a0answer-\u00a0do\u00a0not\u00a0simply\u00a0say\u00a0yes\u00a0or\u00a0no\u00a0without\u00a0referring\u00a0to\u00a0the\u00a0relevant\u00a0figures. 4.\u00a0Regression: CBC\u00a0Management\u00a0has\u00a0several\u00a0questions:\u00a0Which\u00a0has\u00a0more\u00a0impact\u00a0on\u00a0a\u00a0movie’s\u00a0rating:\u00a0that\u00a0it\u00a0is\u00a0fact\u00a0based\u00a0or\u00a0that\u00a0it\u00a0has\u00a0one\u00a0star?\u00a0How\u00a0much\u00a0does\u00a0each\u00a0of\u00a0these\u00a0factors\u00a0change\u00a0the\u00a0ratings?\u00a0Do\u00a0you\u00a0expect\u00a0a\u00a0fact\u00a0based\u00a0movie\u00a0that\u00a0does\u00a0not\u00a0have\u00a0any\u00a0stars\u00a0to\u00a0get\u00a0better\u00a0ratings\u00a0than\u00a0a\u00a0fiction\u00a0movie\u00a0with\u00a0one\u00a0star?\u00a0Run\u00a0a\u00a0multiple\u00a0regression\u00a0where\u00a0the\u00a0dependent\u00a0variable\u00a0is\u00a0ratings\u00a0and\u00a0the\u00a0independent\u00a0variables\u00a0are\u00a0star\u00a0and\u00a0fact.\u00a0Use\u00a0data\u00a0from\u00a0all\u00a0networks,\u00a0not\u00a0just\u00a0CBC\u00a0movies.\u00a0How\u00a0well\u00a0does\u00a0this\u00a0regression\u00a0analysis\u00a0explain\u00a0the\u00a0ratings?\u00a0Justify\u00a0your\u00a0answers\u00a0based\u00a0on\u00a0the\u00a0results.<\/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-217231","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/217231","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=217231"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/217231\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=217231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=217231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=217231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}