{"id":80566,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/risk-frequency-distribution-probabilities-and-expected-value-case"},"modified":"2017-08-18T07:41:19","modified_gmt":"2017-08-18T07:41:19","slug":"risk-frequency-distribution-probabilities-and-expected-value-case","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/risk-frequency-distribution-probabilities-and-expected-value-case\/","title":{"rendered":"Risk: Frequency Distribution, Probabilities, and Expected Value Case"},"content":{"rendered":"<p>Module 2 \u2013 Case INSTRUCTIONS<br \/> Assignment Overview<br \/> Scenario: Your boss has asked you to analyze the ages of your customers to get a better idea of what might motivate their buying habits. Outside research has shown that different age groups buy products for different reasons. And that different age groups buy different kinds of products. Your boss developed a survey that was sent to 200 of your customers and simply asked their age and income level. 124 customers responded and received a gift card for $25 towards their next purchase. See the Data section below for the raw data.<br \/> Case Assignment<br \/> Using Excel, create a frequency distribution (histogram) of the age data that was captured from the survey. You should consider the width of the age categories (<a href=\"http:\/\/e.g\">e.g<\/a>., 5 years, 10 years, or ??). Once you have created this histogram, determine the mean, median and mode.<br \/> Then write a report to your boss that briefly describes the results that you obtained. Make a recommendation on how this data might be used for marketing purposes.<br \/> Data: Download the Word file Case 2 <a href=\"http:\/\/Data.docx\">Data.docx<\/a> or the Excel-based data file Case 2 <a href=\"http:\/\/Data.xlsx\">Data.xlsx<\/a> with the data of ages of the 124 customers. Use this data in Excel to create your histogram.<br \/> Assignment Expectations<br \/> Analysis<br \/> \u2022 Accurate and complete analysis in Excel using the Histogram function.<br \/> Written Report<br \/> \u2022 Length requirements = 4\u20135 pages minimum (not including Cover and Reference pages)<br \/> \u2022 Provide a brief introduction\/ background of the problem.<br \/> \u2022 Complete and accurate Excel analysis.<br \/> \u2022 Written analysis that supports Excel analysis, and provides thorough discussion of assumptions, rationale, and logic used.<br \/> Complete, meaningful, and accurate recommendation(s).<\/p>\n<p>The PIVOT Table and paper that you completed for me approxamatly 3 weeks ago was outstanding. Please do the same here<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Module 2 \u2013 Case INSTRUCTIONS Assignment Overview Scenario: Your boss has asked you to analyze the ages of your customers to get a better idea of what might motivate their buying habits. Outside research has shown that different age groups <a href=\"https:\/\/www.benedictsol.com\/blogs\/risk-frequency-distribution-probabilities-and-expected-value-case\/\" class=\"read-more\">Read More &#8230;<\/a><\/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-80566","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/80566","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=80566"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/80566\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=80566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=80566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=80566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}