3 **Finding the Equation of a Regression Line and Analyzing Scatterplots**The task involves using the given data to find the equation of the regression line, creating a scatterplot, and identifying a characteristic of the data ignored by the regression line.### Data Table\[\begin{array}{|c|c|}\hlinex & y \\\hline10 & 7.75 \\7 & 6.88 \\12 & 13.17 \\8 & 7.16 \\11 & 7.46 \\13 & 8.89 \\4 & 6.53 \\7 & 5.47 \\9 & 8.3 \\6 & 6.69 \\9 & 5.53 \\\hline\end{array}\]### Creating a ScatterplotThe objective is to choose the correct scatterplot that represents the data points. Four scatterplot options are available, labeled A, B, C, and D. Each plot displays data points on an XY plane with axes labeled from 0 to 25.### Finding the Equation of the Regression LineInput fields are provided to compute:- **y-intercept** (round to two decimal places)- **slope** (round to three decimal places)The regression line equation is expressed as $ \hat{y} = $.### Identifying Data Characteristics Ignored by the Regression LineChoose the correct option to describe a feature of the data that the regression line does not account for:- **A.** There is no trend in the data.- **B.** There is no characteristic of the data that is ignored by the regression line.- **C.** The data has a pattern that is not a straight line.- **D.** There is an influential point that strongly affects the graph of the regression line.**Note:** The task involves identifying patterns or anomalies in the scatterplot that the regression line might overlook, such as a curved trend or outliers.

Use EXCEL to construct the scatter plot. EXCEL procedure: Go to EXCEL Go to Insert menu Select the range $A$1:$B$12. Choose Scatter plot>Scatter with only markers. Click Enter. EXCEL output: Correct option: Option AUse EXCEL to determine the regression equation. EXCEL procedure: Go to EXCEL Go to Data>Data Analysis. Choose Regression. Input Y range as $A$1:$A$12. Input X range as $B$1:$B$12. Check the option Labels in First row. Click OK. EXCEL output: From the EXCEL output, the regression equation is, Determine the characteristic that is ignored by the regression line. The characteristic that is ignored by the regression line is determined below as follows: From the scatter plot obtained, it is clear that there is an influential point which effects the graph of the regression line. Correct option: Option D