Get regression in excel for mac

broken image
broken image
broken image

You can also use Excel to calculate a regression with a formula that uses an exponent for x different from 1, e.g. Which returns a single value, the linear slope ( m) according to the formula: You need to use an undocumented trick with Excel's LINEST function: =LINEST(known_y's,, , )Ī regular linear regression is calculated (with your data) as: =LINEST(B2:B21,A2:A21)