Software

Stats Helper

Stats Helper is an way to do basic statistics in Excel. It is extremely simple to use. Functionality includes:

  • For understanding distributions: (v 0.8)
    • Histograms and Normality (Quantile-Quantile) plots
    • Descriptive Statistics
  • For understanding proportions: (new to version 1.0)
    • Work with actual pass/fail data, or summarized data
    • Confidence intervals for mean, basic descriptive statistics
    • Probable ranges, depicted graphically and numerically
  • For comparing sample distributions:
    • Graphing distributions and confidence intervals
    • Hypothesis testing
    • Confidence intervals for means and for the difference between 2 means.
    • Analysis of Variation (ANOVA)
  • For comparing distributions of proportions:
    • Graphs of distributions and confidence intervals
    • Hypothesis testing
    • Confidence intervals for means and for the difference between 2 means.
    • Binomial probabilities
  • Linear Regression
    • Regression plots
    • expression calculation
    • Calculate predictions
  • Control Charting
    • Create Individuals charts, Xbar charts, and P charts
    • Automatic calculation and display
  • Process Capability
    • Calculations of common capability indices (Cp, Cpk, Pp, Ppk)
    • Graphic representation of capability (new to version 1.0)
    • Confidence interval for Cpk
    • Calculator to translate Cpk, DPMO, Yields, and Z into other measurements
  • Power and Sample Size
    • For samples, calculate confidence levels, number of samples needed, standard deviation and difference detectable
    • For proportions, calculate confidence levels, number of samples needed and difference detectable.

Unlike professional statistical software packages that cost over $1000, Stats Helper gives you basic functionality simply, and at a fraction of the cost.

640true dots topright 380true 300http://www.jedcampbell.com/wp-content/plugins/thethe-image-slider/style/skins/white-rounded
  • 5000 slidenbounceright true 60 bottom
    Overview
    Brief overview of usage and functionality.
  • 5000 slidenbounceright true 60 bottom
    Understand Distributions
    Calculate descriptive statistics and view distribution graphically.
  • 5000 slidenbounceright true 60 bottom
    Understand Proportions
    Understand proportional data, see the shape of the expected distribution, and graphically determine future expectations.
  • 5000 slidenbounceright true 60 bottom
    Compare Sample Distributions
    Compare data sets visually and with summary statistics, perform hypothesis tests, graphically see confidence intervals
  • 5000 slidenbounceright true 60 bottom
    Compare Proportions
    Compare different proportions, view distributions graphically, calculate and view confidence intervals
  • 5000 slidenbounceright true 60 bottom
    Predict Results
    Enter data to perform linear regression, determine formula for relationship between 2 variables (including correlation and determination), predict outcome at specific levels
  • 5000 slidenbounceright true 60 bottom
    Process Capability
    Determine process capability metrics, and view graphically, translate freely to and from Z-score, Cpk, DPMO, and Yields.
  • 5000 slidenbounceright true 60 bottom
    Power and Sample Size
    Perform "Power and Sample Size" calculations to determine how many samples are needed, what difference can be detected, etc.
I enjoy developing this, and I hope you find it useful. You can choose the amount you pay for the software below (using PayPal), after which you’ll be given a download link.

Current Average Payment: $3.93

Corporate rate is suggested at the $50 level, for a small to medium sized company.

Any amount is appreciated.

33 Comments

  1. Paul Butchart says:

    I think you’re crazy to sell this for such a low price but who am I to judge? One problem though, the download link still points to version 0.61. Is it possible to get an updated link?

    1. Jed Campbell says:

      This should be fixed now. Thanks.

  2. Jed Campbell says:

    Thanks for the heads up. I’ll get that fixed ASAP. I sent you the new file privately.

  3. Jakub Treml says:

    Hi,
    I have one question about this program. I didn’t found if it is also capable of ANOVA analysis and some post-hoc tests (e. g. Tuckey’s).
    Btw. I’m really suprised with the price!

    Thanks!

    1. Jed Campbell says:

      I’m working on adding ANOVA in the next week or two, and the price will be this low until version 1.0 is released. After that, it will be closer to $5. Thanks for the input.

  4. Mike says:

    I purchased your product, but when I opened it – all I see is the Stats Helper -v1_1 page with two graphs (samples and proportions). I guess this is a case of gross user error but I cannot see tabs or find any other pages and and cannot figure out how to use the program. Duh, I would appreciate a hint to get me started, By the way Macros are enabled. I am running Excel 2010 on 64 bit Windows . Thanks

    1. Jed Campbell says:

      Looks like a case of my own error. In my haste to post version 1.1, I saved the file on the “Power and Sample Size” tab, instead of the instructions tab. Please look towards the bottom of the page, where you should see tabs for the various types of analysis. I’ll get the file updated ASAP; thanks for the heads up. Please let me know if you have any other questions.

  5. Mike says:

    Never mind. It was a scaling problem – the tabs were not visible. Thanks.

  6. Antonio says:

    I purchased your product too, but I can’t find the download link of Stats Helper, and no message was sent to my e-mail yet. Could you please help me?

    1. Jed Campbell says:

      After the Paypal transaction is complete, you should have been taken to the download page. I’ve sent you the link and the file offline. I’ve verified that the Paypal thing is working–it must have been a glitch. Sorry.

  7. Carlos says:

    Hi, does the software have SPC graphs ? Statistical Process Control graphs.

    Thank you,

    Carlos

    1. Jed Campbell says:

      Give me a week it so, and it will.

    2. Jed Campbell says:

      Done and implemented as of version 1.2. Thanks for the suggestion.

      1. Carlos says:

        Can you email the URL to download the app ? I was not taken to the download page after the transaction was completed – Thanks ;)

        1. Jed Campbell says:

          No problem. Let me know if you need anything else.

  8. John says:

    Can it do IMR charts? Specifically individuals.

    1. Jed Campbell says:

      Currently it does individual charts, x bar charts, and p charts. Within the next few weeks, I’ll add the moving range charts as a free upgrade.

      1. John says:

        Great!, that just what i need at the moment. Can you be more specific on when will that be included?

        1. Jed Campbell says:

          Within 2 weeks, for sure.

        2. Jed Campbell says:

          I just finished uploading an update, which includes MR and R charts for the control charts. Now, Stats Helper does IMR, Xbar and R, and P charts. Thanks for letting me know that it was needed.

  9. Hi, its good piece of writing concerning media print, we
    all be aware of media is a impressive source of information.

  10. Hi there to every , because I am actually keen of reading this blog’s post to be updated on
    a regular basis. It includes good stuff.

  11. Julie says:

    I see a lot of interesting posts on your page. You have to spend a lot of time writing,
    i know how to save you a lot of time, there is a tool that
    creates unique, SEO friendly posts in couple of minutes, just search
    in google – laranita’s free content source

  12. Howdy very nice website!! Man .. Beautiful ..
    Wonderful .. I will bookmark your blog and take the feeds
    additionally? I’m glad to seek out numerous helpful information here within the post, we want work
    out more techniques on this regard, thanks for sharing.
    . . . . .

  13. Good respond in return of this question with firm arguments
    and telling everything on the topic of that.

Leave a Reply

Pingbacks & Trackbacks

  1. problem.solve.create.share » Stats Helper v0.8 released - Pingback on 2011/08/13
  2. problem.solve.create.share » The Binomial Distribution and the Importance of Continuous Data - Pingback on 2011/10/05
  3. problem.solve.create.share » Stats Helper v0.6 Released - Pingback on 2011/10/05
  4. problem.solve.create.share - Pingback on 2011/10/05
  5. problem.solve.create.share » Why Does Needed Sample Size Larger Smaller as Proportions Approach 50%? - Pingback on 2011/12/22
  6. problem.solve.create.share » Why is 30 the “Magic Number” for Sample Size? - Pingback on 2012/03/05
  7. problem.solve.create.share » Stats Helper Version 1.2 Released - Pingback on 2012/05/05
  8. problem.solve.create.share » Stats Helper Version 1.4 Released - Pingback on 2013/03/11