Link will be apear in 30 seconds.
Well done! you have successfully gained access to Decrypted Link.
Answer & Explanation
To calculate Slope in Excel you need to use the SLOPE function and enter the known Y and X values. For your specific spreadsheet, the known values of Y are listed in cells cell B16 through B23, whereas the known values of X are listed in cells A16 through A23. So, the slope can be calculated by typing =SLOPE(B16:B23, A16:A23) in cell B27.
Similarly, to calculate intercept, use the INTERCEPT function. Type =INTERCEPT(B16:B23, A16:A23) in cell B28.