Please anwser using SPSS! A random sample of ten patients at a medical clinic provided information on age of the patient (x) inyears and number of days since the last doctors visit at the clinic (y).Age of Patient (x)Days Since Last Visit (y)22260273196231471253822332257558750121589843192 a. Construct a scatterplot of the data. What does it suggest?b. Assuming that the simple linear regression model is appropriate, obtain the equation of theestimated regression line.c. What percentage of the observed variation in Days Since Last Visit can be explained by theresulting model?

Given information: Age of Patient(x) Days Since Last Visit (y) 22 260 27 319 62 31 47 125 38 223 32 257 55 87 50 121 58 98 43 192a) Construct the scatter plot using the given data: b) Use the given data to form the excel table: X Y X*Y X*X 22 260 5720 484 27 319 8613 729 62 31 1922 3844 47 125 5875 2209 38 223 8474 1444 32 257 8224 1024 55 87 4785 3025 50 121 6050 2500 58 98 5684 3364 43 192 8256 1849 Sum 434 1713 63603 20472 The regression equation is given as y^=β0+β1·x. Use the table to determine the value of β0 and β1: β0=∑Y·∑X2-∑X·∑XYn·∑X2-∑X2=(1713)·(20472)-(434)·(63603)10·(20472)-4342=456.2β1=n·∑XY-∑X·∑Yn·∑X2-∑X2=(10)·(63603)-(434)·(1713)10·(20472)-4342=-6.564 The estimated regression equation is y^=456.2-6.564·x. c) Determine the correlation coefficient and coefficient of correlation using the formula: r=n(∑xy)-∑x·∑yn∑x2-(∑x)2n∑y2-(∑y)2∑X=434,∑Y=1713,∑XY=63603,∑X2=20472,∑Y2=370403r=10(63603)-(434)(1713)10(20472)-(434)2(10)(370403)-(1713)2=-0.9571r2=(r)2 =(-0.9571)2 =0.916040410≈0.9160 The percentage of observed variation in Days Since Last Visit can be explained by the resulting model is 91.60%.SPSS steps: Step 1) Click the Analyze tab > Regression > Linear Step 2) Drag the variable Days Since Last Visit (y) into the box labelled Dependent and drag Age of Patient(x) into the box labelled Independent. Step 3) Click OK. Output: