Excel Function
ComputeSse
Description:
Computes the sum of squared errors (SSE) between observed and predicted rate sequences. Returns a scalar value.
Excel Function Syntax:
ComputeSse(observedValues, predictedValues)
Online Calculator:
| Parameter | Value | Description |
|---|---|---|
| observedValues | Observed rates (range or array). | |
| predictedValues | Predicted rates (range or array). | |
| Result |
Related Functions
3 items
ComputeLogSse
Computes the sum of squared errors (SSE) in log-space between observed and predicted rate sequences. Small positive epsilon added before taking logs to avoid log(0).
ComputeWeightedSse
Computes the weighted SSE between observed and predicted sequences.
ComputeWeightedLogSse
Computes the weighted log-space SSE between observed and predicted sequences. Small positive epsilon added before taking logs to avoid log(0).