 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 4. 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.
Example 5.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.
|
