GROWTH: How to Create Rolling 7-Day Average in Google Sheets

Use GROWTH to create rolling 7-day average in Google Sheets. Complete tutorial with syntax and examples.

Syntax

GROWTH(known_data_y, [known_data_x], [new_data_x], [b])

How to Create Rolling 7-Day Average

Given partial data about an exponential growth trend, calculates various y-values. To create rolling 7-day average, combine GROWTH with the right arguments for your dataset.

Expert Tips

For exponential (compound) growth predictions.

Get a Free Quote →