Explanation of Regression Formula
The regression formula is:
Y = B
0 + B
1X or: Dependent variable = constant + B
1independent variable
B
1= for each change of the independent variable (X), it will increase or decrease the dependent variable (Y)
Rule of thumb:
T > 2 significant slope
T < 2 not significant slope
Hypothesis:
Ho: B
0 = 0 there is no relationship
Ha: B
0 =/= there is a relationship
R square (R
2) = explains the % of dependent variable Y, is explained by the variability of the variable independent X
I will recomend to use SPSS. It provides the factor that you need to resolve your necesity. You need historical information of your financial statement / accounting (sales, cost, and other information)
I hope the information will help others.