Excel sheet is attached below

Mining Company	Long-Term Assets	Long-Term Debt
1	26	16
2	39	20
3	45	24
4	47	26
5	47	30
6	48	36
7	54	38
8	56	43
9	60	46
10	65	43
11	69	44
12	71	48

1. An accounting firm that specializes in auditing mining companies collected the data describing the long-term assets and long-term debt of its 12 clients (the dataset is provided in an excel file along with this HW). a) Prepare a scatter plot of the data. Does there appear to be a linear relationship between these variables? b) Develop a simple linear regression model that can be used to predict long-term debt from long- term assets. c) Estimate the regression parameters using the ESS-minimization approach. d) Calculate the R2 in the spreadsheet (via R2 = 1 ESS/TSS) and interpret it. (You should show your works)