Excel Function

ComputeWeightedSse


Description:

Computes the weighted SSE between observed and predicted sequences.

Excel Function Syntax:

=ComputeWeightedSse(observedValues, predictedValues, weightsValues)

Parameters:

ParameterDescription
observedValuesObserved rates (range or array).
predictedValuesPredicted rates (range or array).
weightsValuesPer-sample weights (range or array), same length as inputs.

Related Theory


1 item

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).

ComputeSse

Computes the sum of squared errors (SSE) between observed and predicted rate sequences. Returns a scalar value.

ComputeWeightedLogSse

Computes the weighted log-space SSE between observed and predicted sequences. Small positive epsilon added before taking logs to avoid log(0).

Missing a formula? Suggest a new formula →

This website uses cookies to enhance your experience and analyze site usage. By clicking "Accept", you consent to the use of cookies for analytics purposes. Read our privacy policy