Skip to content

Real Statistics Using Excel

  • Home
  • Free Download
    • Resource Pack
    • Examples Workbooks
    • QAT Access
    • Donation
  • Basics
    • Introduction
    • Excel Environment
    • Real Statistics Environment
    • Probability Functions
    • Descriptive Statistics
    • Hypothesis Testing
    • General Properties of Distributions
  • Distributions
    • Normal Distribution
    • Sampling Distributions
    • Binomial and Related Distributions
    • Students t Distribution
    • Chi-square and F Distributions
    • Other Key Distributions
    • Distribution Fitting
    • Order Statistics
    • Testing for Normality and Symmetry
  • ANOVA
    • One-way ANOVA
    • Factorial ANOVA
    • ANOVA with Random or Nested Factors
    • Design of Experiments
    • ANOVA with Repeated Measures
    • Analysis of Covariance (ANCOVA)
  • Miscellaneous
    • Correlation and Association
    • Reliability
    • Non-parametric Tests
    • Time Series Analysis
    • Panel Data Models
    • Survival Analysis
    • Bayesian Statistics
    • Neural Networks
    • Matching
    • Winning at Wordle
    • Handling Missing Data
  • Regression
    • Linear Regression
    • Multiple Regression
    • Logistic Regression
    • Multinomial Regression
    • Ordinal Regression
    • Poisson Regression
    • Log-linear Regression
  • Multivariate
    • Descriptive Multivariate Statistics
    • Multivariate Normal Distribution
    • Hotelling T-square
    • MANOVA
    • Repeated Measures Tests
    • Box Test
    • Factor Analysis
    • Cluster Analysis
    • Discriminant Analysis
    • Correspondence Analysis
    • Gaussian Mixture Models
  • Appendix
    • FAQs
    • Mathematical Notation
    • Excel Capabilities
    • Matrices and Iterative Procedures
    • Linear Algebra and Advanced Matrix Topics
    • Other Mathematical Topics
    • Statistics Tables
    • Bibliography
    • Author
    • Citation
  • Blogs
  • Tools
    • Real Stat Function Info
    • Distribution Functions
    • Non-Parametric Test Functions
    • Descriptive Stats and Reformatting Functions
    • Regression and ANOVA Functions
    • Correlation/Reliability Functions
    • Multivariate Functions
    • Time Series Functions
    • Missing Data Functions
    • Mathematical Functions
    • Data Analysis Tools
    • YouTube Videos
  • Contact Us
  • Search
Real Statistics Using Excel
  • Home
  • Free Download
    • Resource Pack
    • Examples Workbooks
    • QAT Access
    • Donation
  • Basics
    • Introduction
    • Excel Environment
    • Real Statistics Environment
    • Probability Functions
    • Descriptive Statistics
    • Hypothesis Testing
    • General Properties of Distributions
  • Distributions
    • Normal Distribution
    • Sampling Distributions
    • Binomial and Related Distributions
    • Students t Distribution
    • Chi-square and F Distributions
    • Other Key Distributions
    • Distribution Fitting
    • Order Statistics
    • Testing for Normality and Symmetry
  • ANOVA
    • One-way ANOVA
    • Factorial ANOVA
    • ANOVA with Random or Nested Factors
    • Design of Experiments
    • ANOVA with Repeated Measures
    • Analysis of Covariance (ANCOVA)
  • Miscellaneous
    • Correlation and Association
    • Reliability
    • Non-parametric Tests
    • Time Series Analysis
    • Panel Data Models
    • Survival Analysis
    • Bayesian Statistics
    • Neural Networks
    • Matching
    • Winning at Wordle
    • Handling Missing Data
  • Regression
    • Linear Regression
    • Multiple Regression
    • Logistic Regression
    • Multinomial Regression
    • Ordinal Regression
    • Poisson Regression
    • Log-linear Regression
  • Multivariate
    • Descriptive Multivariate Statistics
    • Multivariate Normal Distribution
    • Hotelling T-square
    • MANOVA
    • Repeated Measures Tests
    • Box Test
    • Factor Analysis
    • Cluster Analysis
    • Discriminant Analysis
    • Correspondence Analysis
    • Gaussian Mixture Models
  • Appendix
    • FAQs
    • Mathematical Notation
    • Excel Capabilities
    • Matrices and Iterative Procedures
    • Linear Algebra and Advanced Matrix Topics
    • Other Mathematical Topics
    • Statistics Tables
    • Bibliography
    • Author
    • Citation
  • Blogs
  • Tools
    • Real Stat Function Info
    • Distribution Functions
    • Non-Parametric Test Functions
    • Descriptive Stats and Reformatting Functions
    • Regression and ANOVA Functions
    • Correlation/Reliability Functions
    • Multivariate Functions
    • Time Series Functions
    • Missing Data Functions
    • Mathematical Functions
    • Data Analysis Tools
    • YouTube Videos
  • Contact Us
  • Search

Forecasting Accuracy

We now describe various approaches for determining the accuracy of a forecast and whether one forecast is more accurate than another.

Topics:

  • Forecast error statistics
  • Diebold-Mariano test
  • Pesaran-Timmermann test
  • Real Statistics support

Reference

Hyndman, R. J. and Athanasopoulos, G. (2018) Evaluating forecast accuracy. Forecasting: Principles and Practice. 2nd ed.
https://otexts.com/fpp2/accuracy.html

Real Statistics Resources


Free Download

Follow @Real1Statistics

Search

  • Time Series Analysis
    • Forecasting Accuracy
      • Time Series Forecast Error
      • Diebold-Mariano Test
      • Pesaran-Timmermann Test
      • Real Statistics Support for Forecast Accuracy
    • Basic Time Series Forecasting
    • Stochastic Processes
    • Autoregressive Processes
    • Moving Average Processes
    • ARMA Processes
    • ARIMA Processes
    • Seasonal ARIMA (SARIMA)
    • Miscellaneous Time Series Topics

Charles Zaiontz

Charles Zaiontz

© 2025 REAL STATISTICS USING EXCEL - Charles Zaiontz
  • Home
  • Free Download
    • Resource Pack
    • Examples Workbooks
    • QAT Access
    • Donation
  • Basics
    • Introduction
    • Excel Environment
    • Real Statistics Environment
    • Probability Functions
    • Descriptive Statistics
    • Hypothesis Testing
    • General Properties of Distributions
  • Distributions
    • Normal Distribution
    • Sampling Distributions
    • Binomial and Related Distributions
    • Students t Distribution
    • Chi-square and F Distributions
    • Other Key Distributions
    • Distribution Fitting
    • Order Statistics
    • Testing for Normality and Symmetry
  • ANOVA
    • One-way ANOVA
    • Factorial ANOVA
    • ANOVA with Random or Nested Factors
    • Design of Experiments
    • ANOVA with Repeated Measures
    • Analysis of Covariance (ANCOVA)
  • Miscellaneous
    • Correlation and Association
    • Reliability
    • Non-parametric Tests
    • Time Series Analysis
    • Panel Data Models
    • Survival Analysis
    • Bayesian Statistics
    • Neural Networks
    • Matching
    • Winning at Wordle
    • Handling Missing Data
  • Regression
    • Linear Regression
    • Multiple Regression
    • Logistic Regression
    • Multinomial Regression
    • Ordinal Regression
    • Poisson Regression
    • Log-linear Regression
  • Multivariate
    • Descriptive Multivariate Statistics
    • Multivariate Normal Distribution
    • Hotelling T-square
    • MANOVA
    • Repeated Measures Tests
    • Box Test
    • Factor Analysis
    • Cluster Analysis
    • Discriminant Analysis
    • Correspondence Analysis
    • Gaussian Mixture Models
  • Appendix
    • FAQs
    • Mathematical Notation
    • Excel Capabilities
    • Matrices and Iterative Procedures
    • Linear Algebra and Advanced Matrix Topics
    • Other Mathematical Topics
    • Statistics Tables
    • Bibliography
    • Author
    • Citation
  • Blogs
  • Tools
    • Real Stat Function Info
    • Distribution Functions
    • Non-Parametric Test Functions
    • Descriptive Stats and Reformatting Functions
    • Regression and ANOVA Functions
    • Correlation/Reliability Functions
    • Multivariate Functions
    • Time Series Functions
    • Missing Data Functions
    • Mathematical Functions
    • Data Analysis Tools
    • YouTube Videos
  • Contact Us
  • Search