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)
Parameters:
| Parameter | Description |
|---|---|
| observedValues | Observed rates (range or array). |
| predictedValues | Predicted rates (range or array). |
Related Theory
1 item
Decline Curve Statistics
Decline Models
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).
ComputeWeightedLogSse
Computes the weighted log-space SSE between observed and predicted sequences. Small positive epsilon added before taking logs to avoid log(0).
ComputeWeightedSse
Computes the weighted SSE between observed and predicted sequences.
Missing a formula?Suggest a New Formula