D coefficient of determination only. Formula included The figures for Triple A's revenue and the amount of money earned by wage earners in Albany - NY hasbeen updated in 2020, and shown below:X: Local Payroll|($100,000,000s)Y: Sales($100,000s)6.58.08.55.54.09.0a) Create the scatter diagram, similar to Figure 4.1 on page 112.b) Create a table similar to Table 4.2 on page 114 and determine the estimated linear regressionequation.c) Calculate SST, SSE and SSR by using the formulas and shown on page 115 and create a table similar toTable 4.3.d) Calculate the coefficient of determination and the coefficient of correlation, by applying the formulaspresented on page 116.e) Estimate the variance for the linear regression model you created, by applying the formulas presentedon page 119.f) Calculate the value of the test statistic F, compare to the value of F associated with a 5% level ofsignificance and determine if there is a statistically significant relationship between X and Y.456 N5 8558/epubcfi/6/122[%39000000000000000001F70]|/4/2[P7001013399000000000000000001F70]/50[P70010133... Q E *bQ ACoefficient of DeterminationThe SSR is sometimes called the explained variability in Y, while the SSE is the unexplained variability in Y.The proportion of the variability in Y that is explained by the regression equation is called the coefficient ofdetermination D and is denoted by r. Thus,2 is the proportion of variability in Y that is explained by the regression equation.(4-10)SSRSSESSTSSTEither the SSR or the SSE can be used to find r. For Triple A Construction, we have2115.6250.69446322.5111This means that about 69% of the variability in sales (Y) is explained by the regression equation based on116/ 57Show alem 3.pdfProblem 1 Excel.pdfProblem 1 Excel.pdfEx. Credit Prob 1..pdfEx. Credit Prob 1..pdfPDFPDFPDFFOF2:30 PM69 F Sunny11/29/2021

Given: y x 6.5 3 8 4 8.5 5 5.5 6 4 2 9 5To get the coefficient of determination, we required SSR and SST. Procedure Step: 1Enter the data into an excel spreadsheet.Step: 2 Go to Data>Data Analysis>Regression.Step:3 select the data into the x and y range.Step: 4 Click OK.The obtained output is From the output SSR = 4.6314 SST = 18.7083 Therefore, the coefficient of determination r2=SSRSST=4.631418.7083=0.2476=24.76%