Statistics Calculators and Solvers - BepalInfo

Statistics Calculators and Solvers

Skip to main content

888-831-0333
  • Blog
  • Students
  • Solver Magazine
  • Live Chat
  • Contact Us
  • Help Desk
  • Login

Home

Free Trial
  • Analyst Tools
    • Product Overview
    • Analytic Solver for Excel
    • Analytic Solver Optimization
    • Analytic Solver Simulation
    • Analytic Solver Data Mining
    • Analytic Solver Basic
    • AnalyticSolver.com
    • Solver Engines
  • Developer Tools
    • Product Overview
    • Solver SDK Platform
    • XLMiner SDK Platform
    • RASON Analytics API
    • Solver Engines
  • Examples
    • Case Studies
    • Live Webinars
      • Data Mining Webinar
      • Optimization Webinar
      • Simulation Webinar
    • Video Demos
    • Finance Examples
    • Investment Examples
    • Production Examples
    • Distribution Examples
    • Purchasing Examples
    • Scheduling Examples
  • Support
    • Excel Solver Help
    • Data Mining Help
    • Solver.Academy
    • Excel User Guides
    • SDK User Guides
    • Technical Support
    • Training and Consulting
    • Recommended Books
  • Order
    • Product Catalog
    • Types of Licenses
    • License Agreement
    • Limited Warranty
    • Standard vs Custom Terms
    • Consulting Assistance
    • Invoicing Payment
  • Free Trial
    • Contact Us
    • Login
    • Live Chat
    • Help Desk

Descriptive Statistics

You are here

  • Home
  • Google Sheets Solver Add-on Help
  • XLMiner Analysis ToolPak

The Descriptive Statistics tool in the XLMiner Analysis Toolpak calculates descriptive statistics for a dataset. 

The generated statistics are:

  • Mean
  • Standard Error
  • Median
  • Mode
  • Standard Deviation
  • Sample Variance
  • Kurtosis
  • Skewness
  • Range
  • Minimum
  • Maximum
  • Sum
  • Count

The example dataset below shows monthly TV Sales for a small appliance store. 

Descriptive Statistics Example Dataset

To generate the statistics: 

  1. On the XLMiner Analysis ToolPak pane, click Descriptive Statistics.
  2. Click the Input Range field and then select cells A1:A33 in the spreadsheet.
  3. Keep “Columns” selected for “Grouped by”.
  4. Leave “Labels in First Row” selected since the first row in the data range includes the column labels.  
  5. Click the Output Range field and then select cell C1
  6. Keep “Summary Statistics”, “Confidence Level for Mean”, “Kth Largest”, and “Kth Smallest” at their defaults. 
  • Summary Statistics:  When selected, this tool will generate the following statistics:
    • Mean
    • Standard Deviation
    • Median
    • Mode
    • Standard Error
    • Sample Variance
    • Kurtosis
    • Skewness
    • Range
    • Minimum
    • Maximum
    • Sum
    • Count
  • Confidence Level for Mean:  When selected, the Confidence Level for the Mean of the dataset will be calculated.
  • Kth Largest:  Select to display the Kth largest value, i.e, if 3 is entered, the 3rd largest value will be displayed. 
  • Kth Smallest:  Select to display the Kth smallest value, i.e., if 4 is entered, the 4th smallest value will be displayed. 

7.  Click OK. 

Descriptive Statistics Pane

The results are shown below.

Descriptive Statistics Results

‹ Covariance
up
Exponential Smoothing ›

Were Here to Help

Request Information
or a Quote

Live Chat

Support KnowledgeBase

Our Solver Magazine

Call Us
Inside USA: 888-831-0333
Outside: 01+775-831-0300

Product Catalog

  • Excel Products (10)
  • SDK Products (5)
  • Solver Engines (11)
  • Solver Academy (6)

Create a post

MathCracker.com

MathCracker.com




Statistics Calculators and Solvers

Our site contains a lot of Statistical Calculators that can greatly help you with all of your academic needs. Our solvers include Probability Calculators, Hypothesis Test solvers, non-parametric tests, etc. If you have any suggestion about solvers that should be included, please do not hesitate to contact us .

You can can use the search box below to find a specific Stats solver you are looking for, or you can browse below for any solver that catches your eye.

Hypergeometric Probability Calculator

Hypergeometric Probability Calculator

Instructions: Compute Hypergeometric Probabilities using the form below. Please type the total number of objects (N), the total number of defectives (K) and the sample size n, and provide details about the event you want to compute the probability …
Semi-Partial Correlation Calculator

Semi-Partial Correlation Calculator

Instructions: This tool will show you step-by-step calculations of the semi-partial correlations for three variables \(X_1\), \(X_2\) and \(X_3\). Please type your samples, using either a comma or space separated format (For example: “2, 3, 4, 5”, …
Partial Correlation Calculator

Partial Correlation Calculator

Instructions: You can use this tool to compute the corresponding Partial Correlations for three variables \(X_1\), \(X_2\) and \(X_3\). All you have to do is type your samples, using either a comma or space separated format (For example: “2, 3, 4, …
Coefficient of Variation Calculator

Coefficient of Variation Calculator

Instructions: In order to use this Coefficient of Variation, please provide the sample data below and this solver will provide step-by-step calculation of the CV: Type the sample (comma or space separated) Name of the variable (Optional) More About …
Correlation Coefficient Significance Calculator using p-value

Correlation Coefficient Significance Calculator using p-value

Instructions: Enter the sample correlation \(r\), sample size \(n\) and the significance level \(\alpha\), and the solver will test whether or not the correlation coefficient is significantly different from zero using the critical correlation …
Correlation Matrix Calculator

Correlation Matrix Calculator

Instructions: This correlation matrix calculator will provide you with a correlation matrix for a given set of samples. Please type in the box below two or more samples. Please press ‘\’ to start a new sample. Type the samples (comma or space …
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12

Related Posts:

  • Free Math Help ResourcesFree Math Help Resources
  • Probability Calculators and SolversProbability Calculators and Solvers
  • Algebra Calculators and Solvers OnlineAlgebra Calculators and Solvers Online
  • Write an Academic Essay by Gathering More Information about the Specific TopicWrite an Academic Essay by Gathering More…
  • Statistics Calculators OnlineStatistics Calculators Online
  • Grade Calculator OnlineGrade Calculator Online
  • Make the Most of Math Help OnlineMake the Most of Math Help Online
  • About UsAbout Us

In case you have any suggestion, or if you would like to report a broken solver/calculator, please do not hesitate to contact us .

log in

reset password

Back to

log in

This website uses cookies to improve your experience. We’ll assume you’re ok with this, but you can opt-out if you wish. Accept Read More