%CO:A,9,75%

%H2%Linear Regression







-------data------

%H2%Month

%V%%R%%D0%1

%V%%R%%D0%2

%V%%R%%D0%3

%V%%R%%D0%4

%V%%R%%D0%5

%V%%R%%D0%6

%V%%R%%D0%7

%V%%R%%D0%8

%V%%R%%D0%9

%V%%R%%D0%10

%V%%R%%D0%11

%V%%R%%D0%12

-------------------------------------------------------

%V%%R%%D0%sum(A8A19)

%CO:B,9,66%





Formula: Predicted sales = (slope*month) + intercept

      



%H2%Sales

%V%%R%%D0%161

%V%%R%%D0%194

%V%%R%%D0%208

%V%%R%%D0%204

%V%%R%%D0%186

%V%%R%%D0%203

%V%%R%%D0%225

%V%%R%%D0%211

%V%%R%%D0%197

%V%%R%%D0%209

%V%%R%%D0%222

%V%%R%%D0%213



%V%%R%%D0%sum(B8B19)

%V%%R%B21/F21

%CO:C,9,57%











%H2%x^2

%V%%R%%D0%A8^2

%V%%R%%D0%+A9^2

%V%%R%%D0%+A10^2

%V%%R%%D0%+A11^2

%V%%R%%D0%+A12^2

%V%%R%%D0%+A13^2

%V%%R%%D0%+A14^2

%V%%R%%D0%+A15^2

%V%%R%%D0%+A16^2

%V%%R%%D0%+A17^2

%V%%R%%D0%+A18^2

%V%%R%%D0%+A19^2



%V%%R%%D0%sum(C8C19)

%CO:D,9,48%







%H4%y = ax + b



%H2%y^2

%V%%R%%D0%B8^2

%V%%R%%D0%B9^2

%V%%R%%D0%B10^2

%V%%R%%D0%B11^2

%V%%R%%D0%B12^2

%V%%R%%D0%B13^2

%V%%R%%D0%B14^2

%V%%R%%D0%B15^2

%V%%R%%D0%B16^2

%V%%R%%D0%B17^2

%V%%R%%D0%B18^2

%V%%R%%D0%B19^2



%V%%R%%D0%sum(D8D19)

%CO:E,9,39%











%H2%x*y

%V%%R%%D0%A8*B8

%V%%R%%D0%A9*B9

%V%%R%%D0%A10*B10

%V%%R%%D0%A11*B11

%V%%R%%D0%A12*B12

%V%%R%%D0%A13*B13

%V%%R%%D0%A14*B14

%V%%R%%D0%A15*B15

%V%%R%%D0%A16*B16

%V%%R%%D0%A17*B17

%V%%R%%D0%A18*B18

%V%%R%%D0%A19*B19



%V%%R%%D0%sum(E8E19)

%CO:F,5,30%











%H2%n



























%V%%R%%D0%count(A8A19)

%CO:G,9,25%











%H2%Pred.

%V%%R%A8*$I$7+$I$9

%V%%R%A9*$I$7+$I$9

%V%%R%A10*$I$7+$I$9

%V%%R%A11*$I$7+$I$9

%V%%R%A12*$I$7+$I$9

%V%%R%A13*$I$7+$I$9

%V%%R%A14*$I$7+$I$9

%V%%R%A15*$I$7+$I$9

%V%%R%A16*$I$7+$I$9

%V%%R%A17*$I$7+$I$9

%V%%R%A18*$I$7+$I$9

%V%%R%A19*$I$7+$I$9



%V%%R%sum(G8G19)

%V%%R%G21/F21

%CO:H,9,16%











%H2%slope =

%H2%intercept

      =

%CO:I,9,7%











%V%%R%((F21*E21)-(B21*A21))/((F21*C21)-(A21*A21))



%V%%R%(B21/F21)-(I7*A21)/F21