|
Business and Investment Statistic Calculations with Excel for the beginner in Statistics. Calculates Averages, Moving Average, Mean, Median, Mode, Range, Frequency, Seasonality Trends, Correlation, Variance, Regression formula, Significance (T-Test), Sigma and Six Sigma values. There is no need to mess about with Excel statistic functions, just copy and paste data into the columns provided for the answers. Use the columns over and over again. Data columns hold up to 10,000 values. With Business Statistics you can easily and instantly eliminate all zeros in any range of values (zeros arise because of holidays, no data, missing data) and quickly 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 clearly low as the voltage dropped to zero. To obtain a valid measure of moisture content statistics for the consignment the user copies test data into the Average column, sets the program to eliminate all zero values and enters the lower limit of moisture content to accept in the calculations. The statistics are now corrected for the rogue data. Example 2. Moving Averages. Business Statistics calculates moving averages for any historical series over any two time periods. When you want to track the short and long daily moving averages of 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 displayed. 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 averages as described in the Gold price demo provided. Apply ExcelÂ?s Trendline to create predictions. Example 3. Sigma and Six Sigma calculations. With our Excel Sigma Excel columns 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 and 1 x Sigma, 2 x Sigma, 3 x Sigma, 4.5 x Sigma and Six Sigma values are displayed, plus the percentages within each quintile. Example 5. Correlation, Variance, Significance, T-Test and Regression Equation. There are so many useful applications of calculating correlation, significance, T (Student) test and regression equations in business (to establish the link between demand and advertising, between share price and market index movements, between changes in the gold price and the dollar, etc) that we have made it really easy to generate all these important values by simply entering two columns of your data into Excel. Budget Forecasting. We have used our own Business Statistics to calculate the clicks to orders regression formula for our web site. The program calculated a 91.4% correlation coefficient with a confidence value above 95%. You can create regression equations with confidence levels as the basis for realistic budget forecasting using Business Statistics. You can reformat the columns to accept percentages, currency values or just numbers. The templates come with easy to follow instructions for the beginner in statistics. The download zip file includes a demo file with examples and formulas.
|
