How To, Statistical Analysis, Web Intelligence

Linear Regression Analysis and Web Intelligence

This article looks at how to do linear regression analysis in Web Intelligence. Linear regression is a statistical technique for analysing data in order to obtain a measure of correlation between two variables where the relationship between the variables is expected to be linear. Web Intelligence does not contain a full set of formula for… Continue reading Linear Regression Analysis and Web Intelligence

How To, Statistical Analysis, Web Intelligence

When analysis is better using Web Intelligence than Excel

This article compares data analysis using Web Intelligence to the same workflow using Microsoft Excel and for the given scenario demonstrates why using Web Intelligence is quicker, easier and less error prone. The objective here is not to show that in all cases Web Intelligence is better than Excel rather to highlight that there are… Continue reading When analysis is better using Web Intelligence than Excel

How To, Statistical Analysis, Web Intelligence

Calculating Geometric Mean in Web Intelligence

A geometric mean is an average that is useful for sets of numbers that are interpreted according to their product and not their sum as is the case with the more commonly known arithmetic mean. An example of where you would use a geometric mean is in financial reporting when you want to calculate the… Continue reading Calculating Geometric Mean in Web Intelligence