For large multidimensional data sets, two or more dimensions can be analysed using Pivot tables. It is widely used by the businesses to analyse payment receipts etc..
Constructing Pivot Tables in MS Excel Read More »
MS Excel can be used for multiple regression analysis where there are more than 1 independent variables.
Multiple Regression Analysis in MS Excel Read More »
MS Excel can be used to estimate simple linear regression and generate standard plots
Simple Linear Regression in MS Excel Read More »
Microsoft Excel can be used for DEA approach which in helpful in determining the efficiency of inputs used in the production in terms of their benefit or their cost.
Data Envelopment Analysis in Excel Read More »