Business Statistics gives you instant statistic answers without you having to understand statistics! Just copy and paste data values into the Excel columns provided (10,000 rows) and the answers are displayed. No hassle, no Excel functions, no complicated statistical analysis, you get instant straightforward answers.
Extra features not available using Microsoft Excel statistic functions:
With Business Statistics you can easily and instantly eliminate all zeros in a range of values and set upper and lower acceptance boundary limits. Boundaries allow you to calculate only values that lie within an acceptable range.
Example 1. Process Control. A company analyses moisture content of dried lumber every hour. Today several tests are showing zeros because of a power failure, and some results are too low because the voltage dropped to zero. To obtain a true measure of moisture content the user copies test data into the Average column, sets all zero values to eliminate and enters a lowest value of moisture content to accept in the calculations. The statistic values are now corrected for all rogue data.
Example 2. Correcting for non working weekdays. When you need to analyze average, range and frequency of daily order values within a large series of working weeks, you need to eliminate all zeros arising due to public holidays. Set the calculation controls to eliminate all zero values and the mean and range are calculated for actual working days only.
Example 3. Moving Averages. When you want to track the short and long daily moving averages of sales, a share, bond or commodity price, enter the time periods to measure (30 and 200 days for example, or 7 and 500 days) and both moving average values are calculated instantly. You can retrieve moving averages from any historical time series as well as keeping up to date with current moving averages. Use Excel Chart to graph moving average trends as described in the Gold price demo provided. Apply Excel's Trendline to create forecasts.
Example 4. Sigma and Six Sigma calculations. With our Sigma spreadsheet there is absolutely no need to get involved with any complicated graphs, X-bars, distribution curves or mind blowing statistics. Copy quality control values (to 10,000) into the Excel Sigma column to calculate 1 x Sigma, 2 x Sigma, 3 x Sigma, 4.5 x Sigma and Six Sigma values, plus the percentages within each quintile.
Example 5. Correlation, Variance, Significance, T-Test, Regression Equation & Least Squares Best Fit. There are so many useful applications of calculating correlation, significance, T (Student) test, regression equations and least squares best fit for business (to establish the link between demand and advertising, between share price and market index movements, between changes in the one price and another etc) that we have made it really easy for you to generate all these important answers by simply entering two columns of your data into Excel.
Budget & Investment Forecasting. Use Business Statistics to create regression based forecasts and least squares best fit values with high confidence (T-Test) scores as your basis for accurate budgeting and forecasting. It's quick and straightforward.
You can format all value columns to accept percentages, currencies or just numbers.
For the beginner with Excel or with statistics you learn all about analyzing data and time series by working with our demos and the examples provided. The formulas for regression, sigma, T-Test etc are written down in the demo version and you can copy these into your own Excel if you wish to create your own analysis spreadsheets.
Business & Finance
Material Resources Planning Systems Accounting Amortization Business Business Plan Automation Finance
Info Managers Inventory Systems Bar Code Fonts Legal Planners/Schedulers Presentation Tools
Project Management Internet Marketing
Management Systems (
Contact Management Document Management Sales Management
Real Estate Vehicles Venture Capital
Business Using Mail, Phone, or Email
Publishing Gem Management Rental Repair Travel )
Software for MS Excel (Accounting Analysis Budgeting Calculators Cars Cash Flow Charting Checks Converters E-Books Finance Forecasting Employment Inventory Investment IRR Management Marketing NPV Planners Project Management Quality Control Schedulers )