Fit a per-unit multiplier and a new level
Enter separate formulas in G2:G7. Fit positive Y in B2:B9 against the actual periods in A2:A9, allowing a fitted level at period zero. G2 is the per-unit multiplier and G3 the fitted level at zero. G4 is the estimate at D2, G5 the multiplier minus one, G6 log-space residual standard error with six degrees of freedom and G7 log-space training R-squared. Keep the period spacing and full computed precision.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter separate formulas in G2:G7. Fit positive Y in B2:B9 against the actual periods in A2:A9, allowing a fitted level at period zero. G2 is the per-unit multiplier and G3 the fitted level at zero. G4 is the estimate at D2, G5 the multiplier minus one, G6 log-space residual standard error with six degrees of freedom and G7 log-space training R-squared. Keep the period spacing and full computed precision.
No account. No upload. Just try it.