Here's the results from yesterday with visits extrapolated:
--A--- ---B---- ---C--- --D-- ------------------E-------------------
1 1.0001 0.8530 57.2508 A1:C1: {=LOGEST(D4:D7, B4:C7)}
2
3 Year Category Visits Sales
4 2005 1 2500 63
5 2006 2 1850 50
6 2007 3 1910 33
7 2008 4 1700 40
8 2009 5 1486 29 C8 and down: =GROWTH($C$4:$C$7, , B8)
9 2010 6 1328 25 D8 and down: =$C$1 * $A$1^C8 * $B$1^B8
And here with your assumptions plugged in:
--A--- ---B---- ---C--- --D-- ------------------E-------------------
1 1.0001 0.8530 57.2508 A1:C1: {=LOGEST(D4:D7, B4:C7)}
2
3 Year Category Visits Sales
4 2005 1 2500 63
5 2006 2 1850 50
6 2007 3 1910 33
7 2008 4 1700 40
8 2009 5 2000 30
9 2010 6 2000 26 D8 and down: =$C$1 * $A$1^C8 * $B$1^B8
Note A1:C1 is an array formula; select all three cells, paste the formula (sans curly braces), press and hold Ctrl and Shift, then press Enter.
Bookmarks