Web source: Database index (planecrashinfo.com) Goal is to extract the accident details for each year and date. That means get a access...

When data under analysis has a seasonal influence on it, further investigation cannot continue without deseasonalising the data. This...

Information functions Filter functions Table manipulation functions Grouping and summarizing Time intelligence functions...

Lag and Lead are functions used in many programming languages that provides access to a row at a specified physical offset which comes...

We want to calculate number of days between start date and end date. Then we want to exclude weekends. And at the end holidays. Source...

A rolling average also known as moving average is a statistical method that calculates the average of a data series for a given period....

I have a multiple excel files in one folder with the same metadata (structure). These tables are not proper tables, require some...

I have couple of files with different date and value formats. Will use a function which will format them correctly... Source files: There...

Power query, append tables using M code.

Multiple linear regression model is the most popular type of linear regression analysis. It is used to show the relationship between one...

In statistical modeling, regression analysis is used to estimate the relationships between two or more variables: Dependent variable (aka...

A two-way ANOVA test is a statistical test used to determine the effect of two nominal predictor variables on a continuous outcome...

The one-way analysis of variance (ANOVA) is used to determine whether there are any statistically significant differences between the...