{"id":1317,"date":"2023-07-26T21:47:23","date_gmt":"2023-07-26T21:47:23","guid":{"rendered":"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/"},"modified":"2023-07-26T21:47:23","modified_gmt":"2023-07-26T21:47:23","slug":"frequenza-cumulativa-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/","title":{"rendered":"Come calcolare la frequenza cumulativa in excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Una <strong>tabella di frequenza<\/strong> \u00e8 una tabella che visualizza informazioni sulle frequenze. Le frequenze ci dicono semplicemente quante volte si \u00e8 verificato un determinato evento.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ad esempio, la tabella seguente mostra il numero di articoli venduti da un negozio in diverse fasce di prezzo in una determinata settimana:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<th style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>Prezzo dell&#8217;articolo<\/strong><\/span><\/th>\n<th style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>Frequenza<\/strong><\/span><\/th>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$1 \u2013 $10<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">20<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$ 11 \u2013 $ 20<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">21<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$21 \u2013 $30<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">13<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$ 31 \u2013 $ 40<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">8<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$41 \u2013 $50<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">4<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <span style=\"color: #000000;\">La prima colonna mostra la classe di prezzo e la seconda colonna mostra la frequenza di quella classe.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00c8 anche possibile calcolare la <strong>frequenza cumulativa<\/strong> per ogni classe, che \u00e8 semplicemente la somma delle frequenze fino ad una determinata classe.<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<th style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>Prezzo dell&#8217;articolo<\/strong><\/span><\/th>\n<th style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>Frequenza<\/strong><\/span><\/th>\n<th style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>Frequenza cumulativa<\/strong><\/span><\/th>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$1 \u2013 $10<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">20<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">20<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$ 11 \u2013 $ 20<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">21<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">41<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$21 \u2013 $30<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">13<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">54<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$ 31 \u2013 $ 40<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">8<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">62<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">$41 \u2013 $50<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">4<\/span><\/td>\n<td style=\"text-align: center;\"> <span style=\"color: #000000;\">66<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p> <span style=\"color: #000000;\">Ad esempio, la prima frequenza cumulativa \u00e8 semplicemente uguale alla prima frequenza di <strong>20<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">La seconda frequenza cumulativa \u00e8 la somma delle prime due frequenze: 20 + 21 = <strong>41<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">La terza frequenza cumulativa \u00e8 la somma delle prime tre frequenze: 20 + 21 + 13 = <strong>54<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">E cos\u00ec via.<\/span><\/p>\n<p> <span style=\"color: #000000;\">L&#8217;esempio seguente illustra come trovare frequenze cumulative in Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Esempio: frequenza cumulativa in Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Innanzitutto, inseriremo la classe e la frequenza nelle colonne A e B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7220 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/relfreqexcel1.png\" alt=\"Tabella delle frequenze in Excel\" width=\"388\" height=\"300\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Successivamente, calcoleremo la frequenza cumulativa di ciascuna classe nella colonna C.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nell&#8217;immagine seguente, la colonna D mostra le formule che abbiamo utilizzato:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12885 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cumfreqexcel1.png\" alt=\"Frequenza cumulativa in Excel\" width=\"498\" height=\"371\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Puoi anche creare un <a href=\"https:\/\/statorials.org\/it\/testata-eccellente\/\" target=\"_blank\" rel=\"noopener\">grafico a ogiva<\/a> per visualizzare le frequenze cumulative.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Per creare il grafico bullet, tieni premuto CTRL ed evidenzia le colonne A e C.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12887 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cumfreqexcel3.png\" alt=\"\" width=\"460\" height=\"343\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Quindi vai al gruppo <strong>Grafici<\/strong> nella scheda <strong>Inserisci<\/strong> e fai clic sul primo tipo di grafico in <strong>Inserisci grafico a colonne o a barre<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sulla barra multifunzione superiore di Excel, vai alla scheda <strong>Inserisci<\/strong> , quindi al gruppo <strong>Grafici<\/strong> . Fare clic su <strong>Nuvola dispersa<\/strong> , quindi <strong>Nuvola dispersa con linee rette e indicatori<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-1789 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ogive12.jpg\" alt=\"\" width=\"529\" height=\"114\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Questo produrr\u00e0 automaticamente la seguente grafica dell&#8217;ogiva:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12888 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cumfreqexcel4.png\" alt=\"Grafico della frequenza cumulativa in Excel\" width=\"540\" height=\"522\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Non esitate a modificare gli assi e il titolo per rendere il grafico pi\u00f9 estetico:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12890 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cumfreqexcel5.png\" alt=\"Curva di frequenza cumulativa\" width=\"434\" height=\"326\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Risorse addizionali<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/it\/calcolatore-della-frequenza-cumulativa\/\" target=\"_blank\" rel=\"noopener\">Calcolatore della frequenza cumulativa<\/a><br \/> <a href=\"https:\/\/statorials.org\/it\/frequenza-relativa-excel\/\" target=\"_blank\" rel=\"noopener\">Come calcolare la frequenza relativa in Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Una tabella di frequenza \u00e8 una tabella che visualizza informazioni sulle frequenze. Le frequenze ci dicono semplicemente quante volte si \u00e8 verificato un determinato evento. Ad esempio, la tabella seguente mostra il numero di articoli venduti da un negozio in diverse fasce di prezzo in una determinata settimana: Prezzo dell&#8217;articolo Frequenza $1 \u2013 $10 20 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Come calcolare la frequenza cumulativa in Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Questo tutorial spiega come calcolare le frequenze cumulative in Excel, con un esempio.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come calcolare la frequenza cumulativa in Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Questo tutorial spiega come calcolare le frequenze cumulative in Excel, con un esempio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T21:47:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/relfreqexcel1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/\",\"url\":\"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/\",\"name\":\"Come calcolare la frequenza cumulativa in Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/it\/#website\"},\"datePublished\":\"2023-07-26T21:47:23+00:00\",\"dateModified\":\"2023-07-26T21:47:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/it\/#\/schema\/person\/0896f191fb9fb019f2cd8623112cb3ae\"},\"description\":\"Questo tutorial spiega come calcolare le frequenze cumulative in Excel, con un esempio.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Casa\",\"item\":\"https:\/\/statorials.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come calcolare la frequenza cumulativa in excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/it\/#website\",\"url\":\"https:\/\/statorials.org\/it\/\",\"name\":\"Statorials\",\"description\":\"La tua guida all&#039;alfabetizzazione statistica!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/it\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/it\/#\/schema\/person\/0896f191fb9fb019f2cd8623112cb3ae\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/statorials.org\/it\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/it\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/it\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Ciao, sono Benjamin, un professore di statistica in pensione diventato insegnante dedicato di Statorials. Con una vasta esperienza e competenza nel campo della statistica, sono ansioso di condividere le mie conoscenze per potenziare gli studenti attraverso Statorials. Scopri di pi\u00f9\",\"sameAs\":[\"https:\/\/statorials.org\/it\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come calcolare la frequenza cumulativa in Excel \u2013 Statorials","description":"Questo tutorial spiega come calcolare le frequenze cumulative in Excel, con un esempio.","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:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/","og_locale":"it_IT","og_type":"article","og_title":"Come calcolare la frequenza cumulativa in Excel \u2013 Statorials","og_description":"Questo tutorial spiega come calcolare le frequenze cumulative in Excel, con un esempio.","og_url":"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T21:47:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/relfreqexcel1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Benjamin anderson","Est. reading time":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/","url":"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/","name":"Come calcolare la frequenza cumulativa in Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/it\/#website"},"datePublished":"2023-07-26T21:47:23+00:00","dateModified":"2023-07-26T21:47:23+00:00","author":{"@id":"https:\/\/statorials.org\/it\/#\/schema\/person\/0896f191fb9fb019f2cd8623112cb3ae"},"description":"Questo tutorial spiega come calcolare le frequenze cumulative in Excel, con un esempio.","breadcrumb":{"@id":"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/it\/frequenza-cumulativa-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Casa","item":"https:\/\/statorials.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come calcolare la frequenza cumulativa in excel"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/it\/#website","url":"https:\/\/statorials.org\/it\/","name":"Statorials","description":"La tua guida all&#039;alfabetizzazione statistica!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/it\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"it-IT"},{"@type":"Person","@id":"https:\/\/statorials.org\/it\/#\/schema\/person\/0896f191fb9fb019f2cd8623112cb3ae","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/statorials.org\/it\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/it\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/it\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Ciao, sono Benjamin, un professore di statistica in pensione diventato insegnante dedicato di Statorials. Con una vasta esperienza e competenza nel campo della statistica, sono ansioso di condividere le mie conoscenze per potenziare gli studenti attraverso Statorials. Scopri di pi\u00f9","sameAs":["https:\/\/statorials.org\/it"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/posts\/1317"}],"collection":[{"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/comments?post=1317"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/posts\/1317\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/media?parent=1317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/categories?post=1317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/tags?post=1317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}