{"id":78524,"date":"2020-04-20T11:34:25","date_gmt":"2020-04-20T06:04:25","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?p=78524"},"modified":"2024-04-12T14:24:28","modified_gmt":"2024-04-12T08:54:28","slug":"frequency-distributions","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/","title":{"rendered":"Frequency Distributions"},"content":{"rendered":"\n<p><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-inventory-and-warehouse-analytics-professional-tutorials\/\" target=\"_blank\" rel=\"noreferrer noopener\">Go back to Tutorial<\/a><\/p>\n\n\n<p>A frequency distribution is a table that shows how frequently each value of a variable occurs in a set of scores. It is an ordered array of data points (also called observations, measures, measurements, scores) from highest to lowest or vice versa. Before looking at frequency distributions, two important concepts in research methods need to be discussed: variables and cases.<\/p>\n<ul>\n<li>Variable: An attribute or property of a person, group, or object that can be measured; the resulting measures are capable of assuming different values.<\/li>\n<li>A case is an individual person, book, database, library, time period, and so on that can observe. Cases are sometimes called units of analysis.<\/li>\n<\/ul>\n<p>An attribute or characteristic of a case can be measured, that is, it can be observed systematically, not necessarily quantified, e.g., eye colour and gender. It can also vary. The difference between these two types of variables results from how variables are measured and not because of some supposed intrinsic characteristic any variable.<\/p>\n<p><a name=\"_Toc25854047\"><\/a><a name=\"_Toc24804121\"><\/a><a name=\"_Toc470535086\"><\/a><strong><u>Excel Descriptive Statistics Tool<\/u><\/strong><\/p>\n<p>Perhaps the most common Data Analysis tool that you&#8217;ll use in Excel is the one for calculating descriptive statistics. To see how this works, for example, you may have the scores of 14 participants for a test.<\/p>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-78525\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS-105x300.jpg\" alt=\"\" width=\"105\" height=\"300\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS-105x300.jpg 105w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS.jpg 137w\" sizes=\"auto, (max-width: 105px) 100vw, 105px\" \/><\/a><\/p>\n<p>To generate descriptive statistics for these scores, execute the following steps.<\/p>\n<ul>\n<li>On the Data tab, click <strong>Data Analysis<\/strong>.<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/Analytics.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-78526\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/Analytics-300x80.jpg\" alt=\"\" width=\"300\" height=\"80\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/Analytics-300x80.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/Analytics.jpg 444w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<ul>\n<li>Select Descriptive Statistics and click OK.<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/tools.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-78527\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/tools-300x147.jpg\" alt=\"\" width=\"300\" height=\"147\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/tools-300x147.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/tools.jpg 393w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<ul>\n<li>Select the range A2:A15 as the Input Range.<\/li>\n<li>Select cell C1 as the Output Range.<\/li>\n<li>Make sure Summary statistics is checked.<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/tools.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-78527\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/tools-300x147.jpg\" alt=\"\" width=\"300\" height=\"147\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/tools-300x147.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/tools.jpg 393w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Click OK and the result is as<\/p>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNG.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-78529\" src=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNG-300x281.jpg\" alt=\"\" width=\"300\" height=\"281\" srcset=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNG-300x281.jpg 300w, https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNG.jpg 417w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Here are the statistics that Excel calculates.<\/p>\n<p>&nbsp;<\/p>\n<table>\n<thead>\n<tr>\n<td width=\"232\"><strong>Statistic <\/strong><\/td>\n<td width=\"406\"><strong>Description<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td width=\"232\">Mean<\/td>\n<td width=\"406\">Shows the arithmetic mean of the sample data.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Standard Error<\/td>\n<td width=\"406\">Shows the standard error of the data set (a measure of the difference between the predicted value and the actual value).<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Median<\/td>\n<td width=\"406\">Shows the middle value in the data set (the value that separates the largest half of the values from the smallest half of the values).<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Mode<\/td>\n<td width=\"406\">Shows the most common value in the data set.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Standard Deviation<\/td>\n<td width=\"406\">Shows the sample standard deviation measure for the data set.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Sample Variance<\/td>\n<td width=\"406\">Shows the sample variance for the data set (the squared standard deviation).<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Kurtosis<\/td>\n<td width=\"406\">Shows the kurtosis of the distribution.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Skewness<\/td>\n<td width=\"406\">Shows the skewness of the data set\u2019s distribution.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Range<\/td>\n<td width=\"406\">Shows the difference between the largest and smallest values in the data set.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Minimum<\/td>\n<td width=\"406\">Shows the smallest value in the data set.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Maximum<\/td>\n<td width=\"406\">Shows the largest value in the data set.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Sum<\/td>\n<td width=\"406\">Adds all the values in the data set together to calculate the sum.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Count<\/td>\n<td width=\"406\">Counts the number of values in a data set.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Largest(X)<\/td>\n<td width=\"406\">Shows the largest X value in the data set.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Smallest(X)<\/td>\n<td width=\"406\">Shows the smallest X value in the data set.<\/td>\n<\/tr>\n<tr>\n<td width=\"232\">Confidence Level(X) Percentage<\/td>\n<td width=\"406\">Shows the confidence level at a given percentage for the data set values.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n<p><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-inventory-and-warehouse-analytics-professional-tutorials\/\" target=\"_blank\" rel=\"noreferrer noopener\">Go back to Tutorial<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Go back to Tutorial A frequency distribution is a table that shows how frequently each value of a variable occurs in a set of scores. It is an ordered array of data points (also called observations, measures, measurements, scores) from highest to lowest or vice versa. Before looking at frequency distributions, two important concepts in&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-78524","page","type-page","status-publish","hentry","category-logistics-and-supply-chain-management"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Frequency Distributions - Tutorial<\/title>\n<meta name=\"description\" content=\"Frequency Distributions\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Frequency Distributions - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Frequency Distributions\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:54:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS-105x300.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/\",\"name\":\"Frequency Distributions - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS-105x300.jpg\",\"datePublished\":\"2020-04-20T06:04:25+00:00\",\"dateModified\":\"2024-04-12T08:54:28+00:00\",\"description\":\"Frequency Distributions\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#primaryimage\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS.jpg\",\"width\":137,\"height\":390},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Frequency Distributions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Frequency Distributions - Tutorial","description":"Frequency Distributions","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/","og_locale":"en_US","og_type":"article","og_title":"Frequency Distributions - Tutorial","og_description":"Frequency Distributions","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:28+00:00","og_image":[{"url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS-105x300.jpg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/","name":"Frequency Distributions - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS-105x300.jpg","datePublished":"2020-04-20T06:04:25+00:00","dateModified":"2024-04-12T08:54:28+00:00","description":"Frequency Distributions","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#primaryimage","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2020\/04\/PNS.jpg","width":137,"height":390},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/frequency-distributions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Frequency Distributions"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/78524","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=78524"}],"version-history":[{"count":4,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/78524\/revisions"}],"predecessor-version":[{"id":89020,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/78524\/revisions\/89020"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=78524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=78524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=78524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}