{"id":52981,"date":"2021-09-23T23:05:48","date_gmt":"2021-09-23T23:05:48","guid":{"rendered":"https:\/\/papersspot.com\/blog\/2021\/09\/23\/mgrt-making-decision-hw-2\/"},"modified":"2021-09-23T23:05:48","modified_gmt":"2021-09-23T23:05:48","slug":"mgrt-making-decision-hw-2","status":"publish","type":"post","link":"https:\/\/papersspot.com\/blog\/2021\/09\/23\/mgrt-making-decision-hw-2\/","title":{"rendered":"Mgrt making decision HW #2"},"content":{"rendered":"<p>1) Ch43 Histograms &#8211; Use data from CH54 &#8211; Dynamichistograms.xlsx <\/p>\n<p> a) Provide descriptive statistics by using the Data Analysis function. <\/p>\n<p> b) Create a Histogram table (frequency distribution) with the Data Analysis function, and a chart with adjacent columns (without gaps). Use the following bin ranges: 4, 8, 12, 16, 20. <\/p>\n<p> 2) If you have qualitative raw data (no numbers), e.g. one column in a spreadsheet with a list of various colors with multiple occurrences (blue, blue, green, yellow, green, green \u2026 you have to create this data) how would you automate the process of generating a frequency table? Create a list of at least 20 data points with at least three categories and show how to count all occurrences of each category with an Excel formula. Tip: We used this formula in week 2. <\/p>\n<p> 3) Ch54 Charting Tricks <\/p>\n<p> Use the data below and create a combination chart with a secondary axis. Include some data labels. You have to handle <\/p>\n<p> missing data with the \u201cConnect data points with line\u201d option. Show your chart.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1) Ch43 Histograms &#8211; Use data from CH54 &#8211; Dynamichistograms.xlsx a) Provide descriptive statistics by using the Data Analysis function. b) Create a Histogram table (frequency distribution) with the Data Analysis function, and a chart with adjacent columns (without gaps). Use the following bin ranges: 4, 8, 12, 16, 20. 2) If you have qualitative [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10],"class_list":["post-52981","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-writing"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/52981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=52981"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/52981\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=52981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=52981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=52981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}