{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-26T15:32:02+00:00","modifiedTime":"2016-09-14T02:21:14+00:00","timestamp":"2022-09-14T18:16:03+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"Excel Data Analysis Tools","strippedTitle":"excel data analysis tools","slug":"excel-data-analysis-tools","canonicalUrl":"","seo":{"metaDescription":"Excel's Analysis ToolPak is a helpful add-in that provides an extensive set of statistical analysis tools. Here are some of the tools in the ToolPak. Tool What ","noIndex":0,"noFollow":0},"content":"Excel's Analysis ToolPak is a helpful add-in that provides an extensive set of statistical analysis tools. Here are some of the tools in the ToolPak.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td>Tool</td>\r\n<td>What it Does</td>\r\n</tr>\r\n<tr>\r\n<td>Anova: Single Factor</td>\r\n<td>Analysis of variance for two or more samples</td>\r\n</tr>\r\n<tr>\r\n<td>Anova: Two Factor with Replication</td>\r\n<td>Analysis of variance with two independent variables, and multiple observations in each combination of the levels of the variables.</td>\r\n</tr>\r\n<tr>\r\n<td>Anova: Two Factor without Replication</td>\r\n<td>Analysis of variance with two independent variables, and one observation in each combination of the levels of the variables. You can use it for Repeated Measures ANOVA.</td>\r\n</tr>\r\n<tr>\r\n<td>Correlation</td>\r\n<td>With more than two measurements on a sample of individuals, calculates a matrix of correlation coefficients for all possible pairs of the measurements</td>\r\n</tr>\r\n<tr>\r\n<td>Covariance</td>\r\n<td>With more than two measurements on a sample of individuals, calculates a matrix of covariances for all possible pairs of the measurements</td>\r\n</tr>\r\n<tr>\r\n<td>Descriptive Statistics</td>\r\n<td>Generates a report of central tendency, variability, and other characteristics of values in the selected range of cells</td>\r\n</tr>\r\n<tr>\r\n<td>Exponential Smoothing</td>\r\n<td>In a sequence of values, calculates a prediction based on a preceding set of values, and on a prior prediction for those values</td>\r\n</tr>\r\n<tr>\r\n<td>F-Test Two Sample for Variances</td>\r\n<td>Performs an F-test to compare two variances</td>\r\n</tr>\r\n<tr>\r\n<td>Histogram</td>\r\n<td>Tabulates individual and cumulative frequencies for values in the selected range of cells</td>\r\n</tr>\r\n<tr>\r\n<td>Moving Average</td>\r\n<td>In a sequence of values, calculates a prediction which is the average of a specified number of preceding values</td>\r\n</tr>\r\n<tr>\r\n<td>Random Number Generation</td>\r\n<td>Provides a specified amount of random numbers generated from one of seven possible distributions</td>\r\n</tr>\r\n<tr>\r\n<td>Rank and Percentile</td>\r\n<td>Creates a table that shows the ordinal rank and the percentage rank of each value in a set of values</td>\r\n</tr>\r\n<tr>\r\n<td>Regression</td>\r\n<td>Creates a report of the regression statistics based on linear regression through a set of data containing one dependent variable and one or more independent variables</td>\r\n</tr>\r\n<tr>\r\n<td>Sampling</td>\r\n<td>Creates a sample from the values in a specified range of cells</td>\r\n</tr>\r\n</tbody>\r\n</table>","description":"Excel's Analysis ToolPak is a helpful add-in that provides an extensive set of statistical analysis tools. Here are some of the tools in the ToolPak.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td>Tool</td>\r\n<td>What it Does</td>\r\n</tr>\r\n<tr>\r\n<td>Anova: Single Factor</td>\r\n<td>Analysis of variance for two or more samples</td>\r\n</tr>\r\n<tr>\r\n<td>Anova: Two Factor with Replication</td>\r\n<td>Analysis of variance with two independent variables, and multiple observations in each combination of the levels of the variables.</td>\r\n</tr>\r\n<tr>\r\n<td>Anova: Two Factor without Replication</td>\r\n<td>Analysis of variance with two independent variables, and one observation in each combination of the levels of the variables. You can use it for Repeated Measures ANOVA.</td>\r\n</tr>\r\n<tr>\r\n<td>Correlation</td>\r\n<td>With more than two measurements on a sample of individuals, calculates a matrix of correlation coefficients for all possible pairs of the measurements</td>\r\n</tr>\r\n<tr>\r\n<td>Covariance</td>\r\n<td>With more than two measurements on a sample of individuals, calculates a matrix of covariances for all possible pairs of the measurements</td>\r\n</tr>\r\n<tr>\r\n<td>Descriptive Statistics</td>\r\n<td>Generates a report of central tendency, variability, and other characteristics of values in the selected range of cells</td>\r\n</tr>\r\n<tr>\r\n<td>Exponential Smoothing</td>\r\n<td>In a sequence of values, calculates a prediction based on a preceding set of values, and on a prior prediction for those values</td>\r\n</tr>\r\n<tr>\r\n<td>F-Test Two Sample for Variances</td>\r\n<td>Performs an F-test to compare two variances</td>\r\n</tr>\r\n<tr>\r\n<td>Histogram</td>\r\n<td>Tabulates individual and cumulative frequencies for values in the selected range of cells</td>\r\n</tr>\r\n<tr>\r\n<td>Moving Average</td>\r\n<td>In a sequence of values, calculates a prediction which is the average of a specified number of preceding values</td>\r\n</tr>\r\n<tr>\r\n<td>Random Number Generation</td>\r\n<td>Provides a specified amount of random numbers generated from one of seven possible distributions</td>\r\n</tr>\r\n<tr>\r\n<td>Rank and Percentile</td>\r\n<td>Creates a table that shows the ordinal rank and the percentage rank of each value in a set of values</td>\r\n</tr>\r\n<tr>\r\n<td>Regression</td>\r\n<td>Creates a report of the regression statistics based on linear regression through a set of data containing one dependent variable and one or more independent variables</td>\r\n</tr>\r\n<tr>\r\n<td>Sampling</td>\r\n<td>Creates a sample from the values in a specified range of cells</td>\r\n</tr>\r\n</tbody>\r\n</table>","blurb":"","authors":[{"authorId":9759,"name":"Joseph Schmuller","slug":"joseph-schmuller","description":" <p><b>Joseph Schmuller</b> works on the Digital & Enterprise Architecture Team at Availity. He has taught statistics at the undergraduate and graduate levels. He has created and delivered courses for LinkedIn Learning, and he is the author of all previous editions of <i>Statistical Analysis with Excel For Dummies.</i></p> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9759"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":227942,"title":"How to Use Excel’s POISSON.DIST Function","slug":"use-excels-poisson-dist-function","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227942"}},{"articleId":227936,"title":"How to Find Correlation in Excel","slug":"find-correlation-excel","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227936"}},{"articleId":227931,"title":"Using More Than Two Samples in Excel: Kruskal-Wallis One-Way ANOVA","slug":"using-two-samples-excel-kruskal-wallis-one-way-anova","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227931"}},{"articleId":227927,"title":"Juggling Many Relationships at Once in Excel: Multiple Regression","slug":"juggling-many-relationships-excel-multiple-regression","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227927"}},{"articleId":227920,"title":"How to Use 3D Maps in Excel","slug":"use-3d-maps-excel","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227920"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281873,"slug":"statistical-analysis-with-excel-for-dummies","isbn":"9781119844549","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/1119844541/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119844541/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119844541-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119844541/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119844541/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/9781119844549-203x255.jpg","width":203,"height":255},"title":"Statistical Analysis with Excel For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"<p><b><b data-author-id=\"9759\">Joseph Schmuller</b></b> works on the Digital & Enterprise Architecture Team at Availity. He has taught statistics at the undergraduate and graduate levels. He has created and delivered courses for LinkedIn Learning, and he is the author of all previous editions of <i>Statistical Analysis with Excel For Dummies.</i></p>","authors":[{"authorId":9759,"name":"Joseph Schmuller","slug":"joseph-schmuller","description":" <p><b>Joseph Schmuller</b> works on the Digital & Enterprise Architecture Team at Availity. He has taught statistics at the undergraduate and graduate levels. He has created and delivered courses for LinkedIn Learning, and he is the author of all previous editions of <i>Statistical Analysis with Excel For Dummies.</i></p> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9759"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119844549"]}]\" id=\"du-slot-63221a638f1e6\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119844549"]}]\" id=\"du-slot-63221a638f7fc\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":168992},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-03-04T05:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n","enabled":true},{"pages":["all"],"location":"footer","script":"\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'></div>\r\n","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":" <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/excel/excel-data-analysis-tools-168992/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"excel-data-analysis-tools-168992"},"fullPath":"/article/technology/software/microsoft-products/excel/excel-data-analysis-tools-168992/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

Excel Data Analysis Tools

By: Joseph Schmuller and

Updated: 09-14-2016

From The Book: Statistical Analysis with Excel For Dummies

Statistical Analysis with Excel For Dummies

Book image

Explore Book Buy On Amazon

Excel's Analysis ToolPak is a helpful add-in that provides an extensive set of statistical analysis tools. Here are some of the tools in the ToolPak.

Tool	What it Does
Anova: Single Factor	Analysis of variance for two or more samples
Anova: Two Factor with Replication	Analysis of variance with two independent variables, and multiple observations in each combination of the levels of the variables.
Anova: Two Factor without Replication	Analysis of variance with two independent variables, and one observation in each combination of the levels of the variables. You can use it for Repeated Measures ANOVA.
Correlation	With more than two measurements on a sample of individuals, calculates a matrix of correlation coefficients for all possible pairs of the measurements
Covariance	With more than two measurements on a sample of individuals, calculates a matrix of covariances for all possible pairs of the measurements
Descriptive Statistics	Generates a report of central tendency, variability, and other characteristics of values in the selected range of cells
Exponential Smoothing	In a sequence of values, calculates a prediction based on a preceding set of values, and on a prior prediction for those values
F-Test Two Sample for Variances	Performs an F-test to compare two variances
Histogram	Tabulates individual and cumulative frequencies for values in the selected range of cells
Moving Average	In a sequence of values, calculates a prediction which is the average of a specified number of preceding values
Random Number Generation	Provides a specified amount of random numbers generated from one of seven possible distributions
Rank and Percentile	Creates a table that shows the ordinal rank and the percentage rank of each value in a set of values
Regression	Creates a report of the regression statistics based on linear regression through a set of data containing one dependent variable and one or more independent variables
Sampling	Creates a sample from the values in a specified range of cells

About This Article

This article is from the book:

Statistical Analysis with Excel For Dummies ,

About the book author:

Joseph Schmuller works on the Digital & Enterprise Architecture Team at Availity. He has taught statistics at the undergraduate and graduate levels. He has created and delivered courses for LinkedIn Learning, and he is the author of all previous editions of Statistical Analysis with Excel For Dummies.

This article can be found in the category:

Excel ,