Meta tags:
description=Free downloadable statistics software (Excel add-in) plus comprehensive statistics tutorial for carrying out a wide range of statistical analyses in Excel.;
keywords=statistics,statistics software,statistics tutorial,statistical analysis,excel,add-in,tutorial,software,learning statistics,learning statistics in excel,excel 2013,statistics tool,free download,psychology,medicine,marketing,business,formula,tool,function,excel 365;

Headings (most frequently used words):

real, statistics, excel, comment, welcome, what, using, do, navigation, is, does, consist, of, website, this, site, how, get, started, why, statistical, analysis, in, 957, thoughts, on, resources, search, leave, cancel, reply, resource, pack, examples, workbooks, community,

Text of the page (most frequently used words):
the (119), and (71), #statistics (69), you (61), real (51), charles (49), excel (45), regression (42), functions (39), reply (39), that (37), this (35), for (33), analysis (33), 2026 (28), data (26), your (24), have (23), are (19), anova (18), distributions (18), can (18), how (18), statistical (18), with (17), using (17), will (17), multivariate (16), distribution (16), use (16), test (14), capabilities (14), resource (14), pack (14), 2025 (14), tools (13), but (13), neural (12), link (12), not (12), linear (11), download (11), website (11), any (11), descriptive (10), has (10), also (10), thanks (10), https (10), mathematical (9), time (9), frank (9), what (9), com (9), more (9), analyses (9), bayesian (8), stat (8), other (8), faqs (8), appendix (8), environment (8), out (8), from (8), thank (8), hello (8), issue (8), all (8), some (8), march (8), examples (8), weather (8), search (7), non (7), topics (7), testing (7), access (7), free (7), want (7), november (7), add (7), following (7), there (7), probability (6), missing (6), series (6), correlation (6), reliability (6), parametric (6), advanced (6), models (6), repeated (6), measures (6), square (6), normal (6), binomial (6), networks (6), where (6), was (6), get (6), work (6), change (6), would (6), provides (6), these (6), perform (6), learn (6), multiple (5), one (5), students (5), introduction (5), comment (5), placed (5), recently (5), just (5), then (5), solution (5), december (5), microsoft (5), february (5), significant (5), see (5), new (5), july (5), settings (5), network (5), function (4), tests (4), way (4), key (4), home (4), best (4), noticed (4), spreadsheet (4), error (4), salvador (4), computer (4), which (4), problem (4), due (4), described (4), resolve (4), 20error (4), 20when (4), 20choosing (4), 20any (4), 20option (4), 20from (4), 20main (4), 20dialog (4), 20box (4), now (4), run (4), basic (4), joydee (4), two (4), variety (4), should (4), about (4), without (4), much (4), suggestions (4), rick (4), click (4), workbook (4), concepts (4), stepwise (4), important (4), software (4), supplemental (4), wide (4), built (4), step (4), contact (3), youtube (3), videos (3), stats (3), reformatting (3), info (3), blogs (3), citation (3), author (3), bibliography (3), tables (3), algebra (3), matrix (3), matrices (3), iterative (3), procedures (3), notation (3), gaussian (3), mixture (3), correspondence (3), discriminant (3), cluster (3), factor (3), box (3), manova (3), hotelling (3), log (3), negative (3), poisson (3), ordinal (3), multinomial (3), logistic (3), handling (3), winning (3), wordle (3), matching (3), survival (3), panel (3), association (3), miscellaneous (3), covariance (3), ancova (3), design (3), experiments (3), random (3), nested (3), factors (3), factorial (3), normality (3), symmetry (3), order (3), fitting (3), chi (3), related (3), sampling (3), general (3), properties (3), hypothesis (3), basics (3), donation (3), qat (3), email (3), comments (3), agency (3), ask (3), them (3), because (3), site (3), going (3), since (3), never (3), tab (3), well (3), done (3), need (3), sometimes (3), comma (3), decimal (3), approach (3), provide (3), tool (3), possible (3), john (3), probably (3), made (3), case (3), same (3), many (3), getting (3), works (3), most (3), people (3), before (3), again (3), whether (3), samples (3), cochrane (3), orcutt (3), address (3), does (3), gouri (3), lack (3), fit (3), book (3), been (3), very (3), version (3), something (3), specific (3), 365 (3), necessary (3), content (3), example (3), august (3), inputs (3), predictions (3), package (3), information (3), those (3), welcome (3), enable (3), menu (3), zaiontz (2), real1statistics (2), older (2), navigation (2), yes (2), nia (2), september (2), might (2), disavow (2), point (2), picked (2), backlink (2), seokicks (2), wanted (2), flag (2), known (2), farm (2), trigger (2), penalties (2), kill (2), rankings (2), cause (2), slow (2), steady (2), traffic (2), drop (2), emailed (2), account (2), holt (2), functioning (2), every (2), different (2), complements (2), referring (2), ins (2), ribbon (2), instead (2), tried (2), via (2), further (2), another (2), others (2), advance (2), symbol (2), replace (2), 220 (2), option (2), outlier (2), limit (2), idea (2), shopzirotti (2), why (2), come (2), often (2), worked (2), almost (2), everyone (2), january (2), britt (2), 424 (2), thoughts (2), users (2), message (2), webpage (2), when (2), day (2), grades (2), between (2), sample (2), handle (2), unbalanced (2), assumptions (2), stem (2), look (2), into (2), caution (2), properly (2), errors (2), know (2), online (2), like (2), results (2), output (2), shapley (2), having (2), alex (2), april (2), available (2), methods (2), given (2), throughout (2), may (2), pete (2), help (2), security (2), activex (2), show (2), controls (2), selected (2), control (2), cannot (2), through (2), installed (2), working (2), internet (2), addressing (2), end (2), above (2), located (2), www (2), receive (2), few (2), uploads (2), 2023 (2), xlsx (2), able (2), workbooks (2), page (2), paul (2), explain (2), simple (2), filter (2), outliers (2), especially (2), find (2), stations (2), their (2), contains (2), carry (2), range (2), learning (2), its (2), limited (2), user (2), already (2), standard (2), particular (2), copy (2), each (2), community (2), guide (2), extends (2), easily (2), practical (2), supports (2), 2016 (2), 2019 (2), 2021 (2), 2024 (2), close, follow, resources, name, leave, cancel, soares, tech, seo, analyst, blueprints, ntc, gmail, try, figure, wrong, report, correctly, runtime, regardless, sets, ses, winters, fine, assume, ctrl, sequence, hadn, disappeared, restore, past, file, options, customize, didn, seem, research, continuously, disappears, corrected, disabling, realstatiscs, enabling, addresses, configuration, explained, dear, first, effort, magnificent, question, values, multiplier, appear, separator, saying, they, fixed, vyn, everytime, process, tme, correct, had, ideas, solutions, visual, object, required, trying, noted, feedback, over, take, appropriate, actions, nice, difference, groups, indepndent, violations, independent, good, greetings, awesome, service, humanity, 185, obviously, highly, imagine, expectation, autocorrelation, addressed, call, attention, article, namely, thing, note, always, occurs, primarily, positively, autocorrelated, tends, underestimate, bias, serious, seriously, reduce, effectiveness, procedure, please, let, applicable, psu, edu, stat462, node, 189, expected, received, yesterday, seems, doubt, confirm, calculations, review, 049, flagged, statistically, mind, reviewing, could, owen, decomposition, difficulty, decompositon, methodology, pls, send, steps, regarding, regards, value, measure, therof, portilla, exaggeration, say, put, wouldn, published, amazon, kindle, titled, applying, relies, heavily, full, credit, clearly, cited, source, used, branko, pecar, june, gerardo, ardila, troubleshoot, checking, sure, office, licensing, installation, trust, center, disable, notification, safe, mode, helps, wondering, preventing, grayed, trouble, university, apps, enterprise, appears, making, progress, until, lost, connection, couple, days, ago, back, soon, start, appeared, meantime, place, cursor, here, open, browser, enter, removed, figures, formulas, hope, fix, links, next, week, longer, reach, notice, changed, suspect, thackeray, pretty, primitive, goal, main, easy, underlying, technology, under, hood, plan, future, robust, packages, big, subset, climate, easynn, create, read, who, utilize, prediction, don, play, role, giving, leverage, effects, found, relationships, several, sensors, bad, practice, great, guess, depends, algorithms, helpful, appreciate, dedicated, kalamaras, 957, created, shortcomings, various, leaving, charge, makes, ideal, performing, unfortunately, result, prefer, such, spss, sas, carrying, lot, flexibility, easier, unlike, popular, little, hidden, manipulating, drawing, graphs, incur, cost, yet, widely, reasons, choosing, follows, browse, suggest, begin, clicking, navigate, topic, organization, choose, later, once, downloaded, rest, summarized, elect, icon, opportunity, install, started, updates, releases, twitter, feed, right, side, sidebar, section, make, identify, questions, request, advice, focuses, concept, designed, demonstrate, moving, complicated, webpages, contain, even, recommend, powerful, student, novice, excellent, tutorial, presents, numerous, form, worksheets, provided, tutorials, descriptions, lets, worksheet, 2007, 2010, 2013, windows, 2011, mac, current, rel, released, support, 2002, 2003, comprised, four, components, consist, plus, skip,

Text of the page (random words):
ask questions to others in the community or request their advice you can also get updates about new releases and other information via the real1statistics twitter feed click on the link located on the right side sidebar how do i get started step 1 if you elect to use the real statistics resource pack click on the following icon you will be given the opportunity to download and install for free the real statistics resource pack once you have downloaded and installed the real statistics resource pack you will be able to use the supplemental capabilities with your copy of excel this is described throughout the rest of the website and is summarized in using real statistics functions and real statistics data analysis tools if you choose not to download the resource pack or examples now you can do so later at any time step 2 browse through the website to learn how to perform a wide range of statistical analyses in excel using standard built in as well as supplemental real statistics capabilities we suggest that you begin by clicking on the website introduction and especially organization of the website these will explain how to navigate the website to get the information you need to run any specific statistical test or learn about any particular topic why do statistical analysis in excel the reasons for choosing excel are as follows it is widely available and many people already know how to use it it is not necessary to incur the cost of yet another tool there is no need to learn new methods of manipulating data and drawing graphs it already contains some basic statistics functions and data analysis tools it is much easier to see what is going on since unlike the more popular statistical analysis tools very little is hidden from the user excel provides the user with a lot of control and flexibility this makes excel an ideal tool for learning statistical concepts and performing some basic statistical analyses unfortunately its built in statistics capabilities are limited as a result many prefer to use statistical tools such as r spss or sas for carrying out more advanced statistical analyses we created the real statistics resource pack to address these shortcomings this software package contains various supplemental tools that enable you to carry out a wide range of advanced statistical analyses without leaving the excel environment you can download the real statistics resource pack free of charge from this website 957 thoughts on welcome comment navigation older comments paul kalamaras august 17 2026 at 1 41 pm charles thank so much for your real statistics add on excel packages it is been a big help to use regression and stepwise regression to filter for best subset of inputs to do weather and climate predictions i have also easynn that i use but will download your version of neural network to learn how to use it does the neural network package create predictions and so i can test with the new data i will read up on your neural network information online there are those who utilize neural ai or neural networks in weather prediction and if you don t filter those inputs that play the most important role in giving you the best weather predictions then you can never get the best results due to leverage effects and outliers also qa of weather data is important especially if you use stepwise regression i found out that using stepwise regression can find relationships between different weather data inputs from several weather stations that is important but qa of data is also important as well i find sometimes there are a few outliers where some weather sensors on some weather stations sometimes go bad one day or so in any case any suggestions on how i can practice using your neural network would be great not all neural networks work the same i guess it depends on their algorithms any helpful suggestions i will appreciate it thanks again for your dedicated work reply charles august 18 2026 at 10 11 am hi paul the neural network capabilities in real statistics are pretty primitive my goal was to explain the main concepts of neural networks and provide easy access to the underlying technology i e to show what is under the hood and how it works in as simple a way as possible i do plan to add more capabilities in the future the regression and stepwise regression capabilities are more robust charles reply rick thackeray july 19 2026 at 8 27 pm hi charles i am no longer able to access your examples workbooks i receive a cannot reach this page notice has something changed at your end or would you suspect an issue with my computer thank you rick reply charles july 20 2026 at 7 05 pm hi rick this is a problem on my end that just appeared i am working on addressing this issue but in the meantime if you place the cursor above the click here link you will see the address where the workbook is located this will look something like https www real statistics com wp content uploads 2023 09 bayesian example xlsx if you open a new tab on your browser and enter the following link i e the above link with www removed https real statistics com wp content uploads 2023 09 bayesian example xlsx then you will receive the examples workbook this may be necessary for a few of the figures and formulas i hope to fix all of these links in the next week or so charles reply charles july 24 2026 at 5 49 pm hi rick i was making progress until i lost my internet connection a couple of days ago internet is now back up and so soon i will start addressing this issue again charles reply pete july 7 2026 at 12 24 am hi charles i m having trouble getting real statistics to work in excel i m using excel through my university microsoft 365 apps for enterprise account and the add in appears to be installed but the controls are not working in the excel trust center i noticed that activex settings show disable all controls without notification selected and safe mode helps limit the control s access to your computer is also selected i m wondering if these security settings are preventing real statistics from functioning properly all activex settings are also grayed out so i cannot change them i have tried checking the add in settings but i m not sure whether this is an excel security issue an office licensing issue or something specific to the real statistics installation do you have any suggestions for what settings i should change or how i can troubleshoot this thanks for your help reply charles july 9 2026 at 11 24 am hi pete the following link provides a solution that works for most people https real statistics com appendix faqs resolve 20error 20when 20choosing 20any 20option 20from 20main 20dialog 20box charles reply gerardo ardila june 3 2026 at 3 47 am dr thank you very much by your new version reply branko pecar may 6 2026 at 9 51 am hi charles i ve just published a book on amazon kindle titled applying multivariate methods using excel the book relies heavily on real statistics i ve given you full credit in the introduction and have clearly cited the source of every real statistics function used throughout it s no exaggeration to say that without real statistics and all the work you ve put into it this book wouldn t have been possible thank you very much for that reply alex portilla april 2 2026 at 12 29 am hello how can i perform the lack of fit test in real statistics it s not available in the multiple linear regression option reply charles april 6 2026 at 10 40 am hello alex which lack of fit test are you referring to the p value in the regression output is a measure of the fit or lack therof charles reply gouri march 29 2026 at 1 07 pm hello i am having difficulty as to how to use shapley decompositon methodology pls send me the steps regarding the same regards gouri reply charles march 29 2026 at 3 06 pm hello gouri see https real statistics com multiple regression shapley owen decomposition charles reply frank march 23 2026 at 10 32 pm hi charles i have a d stat of 2 049 flagged as statistically significant would you mind reviewing my data to see what could be going on thank you reply charles march 24 2026 at 8 30 pm hi frank if you email me an excel spreadsheet with your data and calculations i will review the output charles reply frank march 25 2026 at 5 34 pm hi charles i have emailed you the data and results thank you reply charles march 26 2026 at 10 35 am hi frank i have received your spreadsheet thanks from your comment from yesterday it seems like you have some doubt that the d stat is significant is this what you want me to confirm charles reply frank march 26 2026 at 3 24 pm yes i expected a d stat of 2 04 not to be significant charles march 30 2026 at 10 04 pm hi frank since you are using a cochrane orcutt approach i imagine that your expectation is that the autocorrelation would be addressed and so the d stat should not be significant before i look into this further i want to call your attention to the caution described in the article at the following address https online stat psu edu stat462 node 189 namely one thing to note about the cochrane orcutt approach is that it does not always work properly this occurs primarily because if the errors are positively autocorrelated then r tends to underestimate ρ when this bias is serious then it can seriously reduce the effectiveness of the cochrane orcutt procedure please let me know whether this caution is applicable to your data charles joydee february 12 2026 at 2 16 am good greetings dr charles awesome of you to have this service to humanity thanks now how should i go about analysis of two sample grades of students stem n 185 non stem n 80 obviously highly unbalanced samples what test should i use reply charles february 12 2026 at 9 22 am hello joydee if you are testing whether there is a significant difference in the grades between the two groups you can use a two indepndent sample t test see https real statistics com students t distribution two independent samples t test this test will handle unbalanced samples but there are assumptions there are a variety of other tests that handle violations of these assumptions charles reply joydee february 14 2026 at 12 37 am hi charles thank you and noted the feedback i will go over and take appropriate actions again thanks and have a nice day joydee reply qi ao february 8 2026 at 10 36 pm i am getting the following error message when trying to use real statistics microsoft visual basic run time error 424 object required i never had this before any ideas and solutions thanks reply charles february 9 2026 at 6 36 pm hello recently many users are getting this message probably due to some change that microsoft made the following webpage provides a solution that works for most people https real statistics com appendix faqs resolve 20error 20when 20choosing 20any 20option 20from 20main 20dialog 20box charles reply britt december 29 2025 at 10 35 pm hi charles everytime i now run any process i get a vb run tme error 424 i have no idea how to correct that do you have thoughts on this reply charles december 30 2025 at 11 33 am hi britt this problem has come up more often recently probably due to some change that microsoft has made to excel in any case the solution that has worked for almost everyone is described at https real statistics com appendix faqs resolve 20error 20when 20choosing 20any 20option 20from 20main 20dialog 20box charles reply vyn january 8 2026 at 7 39 pm i have the same problem have you fixed it reply charles january 9 2026 at 3 49 pm this problem has come up more often recently probably due to some change that microsoft has made to excel in any case the solution that has worked for almost everyone is described at https real statistics com appendix faqs resolve 20error 20when 20choosing 20any 20option 20from 20main 20dialog 20box charles reply john december 20 2025 at 9 10 pm shopzirotti reply john december 20 2025 at 9 09 pm i noticed you recently picked up a backlink from seokicks just wanted to flag it because that site is a known link farm can trigger penalties kill your rankings and cause a slow but steady traffic drop if an agency placed it you might want to ask them to disavow it want me to point out where that link was placed reply charles december 22 2025 at 7 54 pm hi john i have no idea which agency would have done this are you saying that this was done by shopzirotti why would they do that charles reply salvador november 19 2025 at 8 52 pm dear charles first of all thanks for your effort to provide us with this magnificent tool i have a question in descriptive statistics the values in outlier multiplier and outlier limit appear with a comma for the decimal separator is it possible to change to instead of thanks in advance reply charles november 19 2025 at 9 09 pm hello salvador real statistics addresses the issue of using a comma as the decimal symbol the approach is not to replace 2 2 by 2 2 but to replace it by 220 as in 220 this is a configuration option as explained in https real statistics com appendix faqs comma as decimal symbol charles reply salvador november 22 2025 at 2 41 am thanks charles another issue is the tab complements in excel which continuously disappears sometimes it is corrected by disabling realstatiscs and then re enabling it but others not do you have a solution for this issue thanks in advance reply charles november 25 2025 at 10 33 pm salvador i assume by complements you are referring to the add ins ribbon since i never use the add ins tab but instead just use the ctrl m key sequence i hadn t noticed that it has also disappeared on my computer as well i tried to restore it as i have done in the past via file options customize ribbon but that didn t seem to work i need to research this further charles reply frank november 2 2025 at 7 27 pm i want to report that holt s linear is not functioning correctly i get a runtime error every time regardless of the different data sets ses and holt winters are fine reply charles november 3 2025 at 10 00 am hello frank if you email me an excel spreadsheet with your data i will try to figure out what is going wrong charles reply frank november 3 2025 at 5 18 pm i have emailed the spreadsheet to your gmail account thank you reply co ntc d september 25 2025 at 9 54 am i noticed you recently picked up a backlink from seokicks just wanted to flag it because that site is a known link farm can trigger penalties kill your rankings and cause a slow but steady traffic drop if an agency placed it you might want to ask them to disavow it want me to point out where that link was placed best nia soares tech seo analyst the blueprints reply charles september 25 2025 at 5 16 pm yes nia where was the link placed charles reply comment navigation older comments leave a comment cancel reply comment name email website δ real statistics resources follow real1statistics search search for charles zaiontz search for 2026 real statistics using excel charles zaiontz close home free download resourc...