Use the SLOPE and INTERCEPT functions for regression analysis
Syntax: SLOPE(known_y’s, known_x’s), INTERCEPT(known_y’s, known_x’s)
Step 1: Define known_y’s (dependent variable) and known_x’s (independent variable).
Step 2: Enter the appropriate formula in a cell and press Enter.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com