How to Convert XML to Excel?

When sharing or importing and exporting data between services, XML format, along with CSV are some of the most commonly used formats. Both of these formats are readable by many software and services, and allow for easy further manipulation. However, if we want to perform some kind of statistical analysis on either format we need … Read more

Example of Future Value Calculation in Excel

Future value tells you how much money you could have in the future if you invested a certain amount of money today with a certain interest rate. This can be easily calculated in Excel, and we will show you how. The simple version: Image you have $100,000 and you want to invest them in a … Read more

Linear Regression Analysis in Excel

Regression analysis is a statistical process for establishing connections between certain variables. For example, we have one dependent variable and we want to determine how much other independent variables affect it. That is how we get a model of interdependence, and we can use it to predict the dependent variable’s value in the future. Excel … Read more