Consider the following data. Calculate mean and standard deviation for each test (can you see it is test-retestsituation?). Then find the regression equation of Final scores on Midterm scores.Predict the final scores for two students• For one who received 72 on Midterm• For one who received 90 on MidtermDraw a scatterplotComment how the regression effect manifest itself here.and the regression line; mark the two points (for x=72 and x=90). Exam scoresMidterm Final83.961.883.993.766.766.778.969.161.869.188.882.961.881.488.867.766.778.971.665.774.086.373.070.371.699.570.365.070.373.862.467.778.370.373.075.695.567.791.678.370.369.067.788.9

Given data for midterm scores and final scores is given below:83.97361.870.383.971.693.799.566.770.366.76578.970.369.173.861.862.469.167.788.878.382.970.361.87381.475.688.895.567.767.766.791.678.978.371.670.365.7697467.786.388.9The objective is:1) To plot the scatterplot and fit the regression model. 2) To calculate the mean and standard deviation of midterm and final scores.3) To find the predicted value of final scores for midterm scores 72 and 90. The mean for the sample data is the average data value. The standard deviation of the sample data tells how the sample data values vary from the mean of the data. The independent variable, .The dependent variable, .The table for the calculation of mean and standard deviation is given below :83.97361.870.3174.480322.133383.971.679.048111.591393.799.5349.3497600.024666.770.369.041122.133366.76569.0411100.092078.970.315.139122.133369.173.834.91751.451161.862.4174.4803158.875969.167.734.917553.357288.878.3190.188910.859782.970.362.266322.133361.873174.48034.018481.475.640.84360.354588.895.5190.1889420.061467.767.753.422953.357266.791.669.0411275.407378.978.315.139110.859771.670.311.622022.133365.76986.659336.05527467.71.018353.357286.388.9127.4844193.0821The sum of each column is given below :The sample mean for midterm scores is computed below ;The sample mean for final scores is computed below ;The sample standard deviation for midterm scores is computed below ;The sample standard deviation for final scores is computed belowwhere .The sample mean for midterm exam scores is 75.0091 .The sample standard deviation for the midterm exam is 10.0043 .The sample mean for final exam scores is 75.0046 .The sample standard deviation of the final exam score is 9.9940 .The general linear regression equation is :where , , , .The slope of the regression line represents the change in for one unit increase in . For 1 unit increase in the value of the dependent variable changes by units. The is y-intercept of the regression line. It is the point at which the regression line intersects the Y-axis. is the value of the dependent variable when the value of the independent variable is 0.Excel steps are used to plot the given values of and and fit the regression model.The steps to plot the scatterplot for given data is :Enter the values of and in Excel columns.2. Select the data along with labels, go to INSERT --> Charts --> Select the scatterplot option. 3. The scatterplot will be plotted for the selected values of and .4. To fit the regression model to the plotted data right-click on any data point from the scatterplot. The new pop-up window will appear. Select "add trendline" option .5. This will add the regression line along with the regression equation to the given data. 6. The values and can be shown on the scatterplot as given below :The fitted regression equation for the predicting final score from midterm scores is :where .The predicted value of the final exam score for :The predicted value of the final exam score for :The predicted final exam score for is 73.1734 .The predicted final exam score for is 74.121 .The sample mean for midterm exam scores is 75.0091 .The sample standard deviation for the midterm exam is 10.0043 .The sample mean for final exam scores is 75.0046 .The sample standard deviation for the final exam score is 9.9940 .The scatterplot and fitted regression equation along with plotting of 72 and 90 on the plot is ;The predicted final exam score for is 73.1734 .The predicted final exam score for is 74.121 .