MSE Calculator
Calculate mean squared error, root mean squared error, and mean absolute error from actual and predicted values.
About mean squared error
Error metric examples
These paired series illustrate imperfect, perfect, and differently scaled predictions.
| Actual and predicted | Metrics | Explanation |
|---|---|---|
| Y: 2,4,5,4,5; predicted: 2.5,3.5,4,5,5 | MSE 0.5; RMSE 0.707107; MAE 0.6 | Five paired residuals produce modest average error. |
| Y: 1,2,3; predicted: 1,2,3 | MSE 0; RMSE 0; MAE 0 | Exact predictions have zero error under every metric. |
| Y: 10,20; predicted: 12,18 | MSE 4; RMSE 2; MAE 2 | Equal absolute errors make RMSE and MAE identical. |
| Y: 0,0,0; predicted: 0,0,3 | MSE 3; RMSE 1.732051; MAE 1 | One large miss increases RMSE more than MAE. |
How to calculate prediction error
- Enter the observed target values in Actual Values, preserving their record order.
- Enter each corresponding model output in Predicted Values using the same order and list length.
- Select Calculate Errors to pair the series and compute all three metrics.
- Compare MSE, RMSE, and MAE while considering the target units and cost of large errors.
- Select Reset before evaluating another prediction set.
MSE calculator FAQ
What is a good MSE value?
Lower is better and zero is perfect, but there is no universal cutoff. Interpret MSE relative to the target scale and a meaningful baseline model.
What is the difference between MSE and RMSE?
RMSE is the square root of MSE. It has the same units as the target, while MSE is expressed in squared units.
Why compare RMSE with MAE?
RMSE penalizes large errors more heavily, whereas MAE weights errors linearly. A wide gap between them can indicate occasional large residuals.
Must the two lists have equal lengths?
Yes, every prediction needs one matching actual observation. Unequal lists cannot form a complete set of error pairs.
Can MSE compare models on different targets?
Not directly when the targets use different units or scales. Use normalization or another scale-independent metric for that comparison.