QRS Toolbox for Excel

Demonstrations


Learn how to use the functions in the toolbox
  • How to create bins with a monotonic weight of evidence trend in Excel
  • How to calculate accuracy ratio in Excel using only a formula
  • How to perform logistic regression in Excel using only a formula
  • How to perform linear regression in Excel using only a formula
  • How to estimate expected shortfall given skewness and kurtosis in Excel
  • How to estimate value-at-risk given skewness and kurtosis in Excel
  • How to generate random numbers for Monte Carlo simulation in Excel