{"id":3156,"date":"2016-05-23T00:00:59","date_gmt":"2016-05-23T00:00:59","guid":{"rendered":"https:\/\/assignment.essayshark.com\/blog\/?p=3156"},"modified":"2022-01-12T10:59:18","modified_gmt":"2022-01-12T10:59:18","slug":"how-to-construct-a-relative-frequency-distribution","status":"publish","type":"post","link":"https:\/\/assignmentshark.com\/blog\/how-to-construct-a-relative-frequency-distribution\/","title":{"rendered":"How to Construct a Relative Frequency Distribution"},"content":{"rendered":"<p>Suppose that as a result of some experiment, a sample x<sub>1<\/sub>, x<sub>2<\/sub>, x<sub>3<\/sub> &#8230; x<sub>n<\/sub> has been obtained.<!--more--><\/p>\n<p>We have a <u>data retrieval<\/u>: 7, 12, 24, 24, 24, 17. 17. Let\u2019s find the relative frequency distribution using Microsoft Excel:<\/p>\n<ul>\n<li>Input the original data into the table:<br \/>\n<a href=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image001-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3162\" src=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image001-2.png\" alt=\"Table\" width=\"141\" height=\"161\" \/><\/a><\/li>\n<li>Create an array of values in which we will put a data array for which we calculate frequencies (7, 12, 24, 17):<br \/>\n<a href=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image003-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3164\" src=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image003-2.png\" alt=\"Table\" width=\"161\" height=\"161\" srcset=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image003-2.png 161w, https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image003-2-150x150.png 150w\" sizes=\"auto, (max-width: 161px) 100vw, 161px\" \/><\/a><\/li>\n<li>Calculate the frequencies using the statistical function FREQUENCY, so we get statistical distribution of the <u>data retrieval<\/u> (to record the array of frequencies to the table, it is necessary to allocate a certain number of cells, and after the call of the function FREQUENCY press F2, and then Ctrl + Shift + Enter):<br \/>\n<a href=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image005-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3166\" src=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image005-1.png\" alt=\"Calculate\" width=\"471\" height=\"226\" srcset=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image005-1.png 471w, https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image005-1-300x144.png 300w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/a><br \/>\n<a href=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image007-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3168\" src=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image007-1.png\" alt=\"Calculate \" width=\"347\" height=\"167\" srcset=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image007-1.png 347w, https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image007-1-300x144.png 300w\" sizes=\"auto, (max-width: 347px) 100vw, 347px\" \/><\/a><\/li>\n<li>Calculate the sum of the frequencies using the SUM function:<br \/>\n<a href=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image009-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3170\" src=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image009-1.png\" alt=\"Sum\" width=\"366\" height=\"284\" srcset=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image009-1.png 366w, https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image009-1-300x233.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/a><\/li>\n<li>Calculate the relative frequency distribution: divide each frequency by the sum of the frequencies (it\u2019s useful to put the dollar sign between the letter and the number of the sum cell because it will be easy to multiply it):<br \/>\n<a href=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image011-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3172\" src=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image011-1.png\" alt=\"image011\" width=\"543\" height=\"272\" srcset=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image011-1.png 543w, https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image011-1-300x150.png 300w\" sizes=\"auto, (max-width: 543px) 100vw, 543px\" \/><\/a><br \/>\n<a href=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image013-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3174\" src=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image013-1.png\" alt=\"image013\" width=\"521\" height=\"227\" srcset=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image013-1.png 521w, https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image013-1-300x131.png 300w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/a><\/li>\n<li>Format the cells to make them more comfortable to read:<br \/>\n<a href=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image015-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3176\" src=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image015-1.png\" alt=\"image015\" width=\"586\" height=\"721\" srcset=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image015-1.png 586w, https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image015-1-244x300.png 244w\" sizes=\"auto, (max-width: 586px) 100vw, 586px\" \/><\/a><\/li>\n<\/ul>\n<p>Now it\u2019s much more understandable:<br \/>\n<a href=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image017-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3178\" src=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image017-1.png\" alt=\"image017\" width=\"505\" height=\"231\" srcset=\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image017-1.png 505w, https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/05\/image017-1-300x137.png 300w\" sizes=\"auto, (max-width: 505px) 100vw, 505px\" \/><\/a><\/p>\n<blockquote><p><em>So with the help of such a simple manipulations we got the relative frequency distribution. Thanks for your attention. If you still don&#8217;t know how to construct a relative frequency distribution, ask our experts for <a href=\"https:\/\/assignmentshark.com\/\" target=\"_blank\" rel=\"noopener\">online assignment help<\/a> you. We work 24\/7 to meet your deadlines and provide qualified help.<\/em><\/p>\n<p>You can also like <a href=\"https:\/\/assignmentshark.com\/blog\/cumulative-frequency-distribution-table-sample\/\" target=\"_blank\" rel=\"noopener\">cumulative frequency distribution table sample<\/a> completed by one of our experts.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Suppose that as a result of some experiment, a sample x1, x2, x3 &#8230; xn has been obtained.<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35,61],"tags":[],"class_list":["post-3156","post","type-post","status-publish","format-standard","hentry","category-samples","category-statistics"],"_links":{"self":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts\/3156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/comments?post=3156"}],"version-history":[{"count":11,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts\/3156\/revisions"}],"predecessor-version":[{"id":13045,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts\/3156\/revisions\/13045"}],"wp:attachment":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/media?parent=3156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/categories?post=3156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/tags?post=3156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}