Solve 4 and XC. I attached my answers to the other questions if needed Since the beginning of the semester, Mr. Bates has regularworkouts where his Apple Watch® keeps track of his caloriesburned. The data for his workouts is in the table on the left side.MinutesCalories302931. On a separate sheet of paper, graph this data in a scatterplot.Make sure to label your axes.30301262213333130276211822. Find the correlation coefficient of the data.29280159340327312673. Find a linear regression equation to model this data.322613026534357211944. If Mr. Bates exercises for 35 minutes, how many calories is he likelyto burn? (Round to the nearest whole number).28282XC. If Mr. Bates' watch says he burned 150 calories, how many minutes did he most likely exercise?(Round to the nearest whole number.) 30122130900906019030Software Procedure:2667648841574633331108910956110923828038228120The step-by-step procedure to draw a scatter diagram using EXCEL software is given below:3027690076176331247840021182441280841• Open an EXCEL file.• Enter the data of Minutes in column A and name it as Minutes.• Enter the data of Calories in column Band name it as Calories.• Select Data and go to Insert tab.• Select Scatter or Bubble chart Scatter plot.• Click OK.2258649106929712896812113951308082773271600267261961102483527950702251274493763679524y = 3930 Ex = 12838 Ey =1,092,3743026590011564417841213840747896343572119428282The Scatterplot is shown below:Σχ-430Ey =117,873ScatterplotTherefore , the required values are Σχ= 430, Σy= 3930, Σχ12838, Σ) = 1092374 and Σxy400117873.350Denote ras the sample correlation coefficient between the variables xand y.300The correlation coefficient is obtained as given below:250200n(Ew)-(Ex)(Ev)150100(15x117873)-(430 x 3930)50(15x12838) - (430) x(15x1092374)-(3930)51015202530354045= 0.9206 (Rounded to 4 decimal places)MinutesThus, the correlation coefficient is r= 0.9206.(c). Find the least squares regression equation:The values of x-bar and y-bar are obtained as given below:Ex43015= 28.6667 (Rounded to 4 decimal places)Σν393015= 262Regression coefficient:The regression coefficient is obtained as b= 10.1949 from the calculation given below:(Ew)-(Ex)(E»)(15x117873)-(430 × 3930)(15 x12838) -(430)=10.1949 (Rounded to 3 decimal places)Therefore, the regression coefficient is b= 10.1949.Intercept:The intercept is obtained as a =-30.254 from the calculation given below:a =j-bx= 262-(10.1949 x 28.6667)= 262 - 292.2541=-30.2541 (Rounded to 4 decimal places)Therefore, the regression equation is Calories=- 30.2541 + 10.1949* Minutes.Calories

Question

Solve 4 and XC. I attached my answers to the other questions if needed Since the beginning of the semester, Mr. Bates has regularworkouts where his Apple Watch® keeps track of his caloriesburned. The data for his workouts is in the table on the left side.MinutesCalories302931. On a separate sheet of paper, graph this data in a scatterplot.Make sure to label your axes.30301262213333130276211822. Find the correlation coefficient of the data.29280159340327312673. Find a linear regression equation to model this data.322613026534357211944. If Mr. Bates exercises for 35 minutes, how many calories is he likelyto burn? (Round to the nearest whole number).28282XC. If Mr. Bates' watch says he burned 150 calories, how many minutes did he most likely exercise?(Round to the nearest whole number.) 30122130900906019030Software Procedure:2667648841574633331108910956110923828038228120The step-by-step procedure to draw a scatter diagram using EXCEL software is given below:3027690076176331247840021182441280841• Open an EXCEL file.• Enter the data of Minutes in column A and name it as Minutes.• Enter the data of Calories in column Band name it as Calories.• Select Data and go to Insert tab.• Select Scatter or Bubble chart > Scatter plot.• Click OK.2258649106929712896812113951308082773271600267261961102483527950702251274493763679524y = 3930 Ex = 12838 Ey =1,092,3743026590011564417841213840747896343572119428282The Scatterplot is shown below:Σχ-430Ey =117,873ScatterplotTherefore , the required values are Σχ= 430, Σy= 3930, Σχ12838, Σ) = 1092374 and Σxy400117873.350Denote ras the sample correlation coefficient between the variables xand y.300The correlation coefficient is obtained as given below:250200n(Ew)-(Ex)(Ev)150100(15x117873)-(430 x 3930)50(15x12838) - (430) x(15x1092374)-(3930)51015202530354045= 0.9206 (Rounded to 4 decimal places)MinutesThus, the correlation coefficient is r= 0.9206.(c). Find the least squares regression equation:The values of x-bar and y-bar are obtained as given below:Ex43015= 28.6667 (Rounded to 4 decimal places)Σν393015= 262Regression coefficient:The regression coefficient is obtained as b= 10.1949 from the calculation given below:(Ew)-(Ex)(E»)(15x117873)-(430 × 3930)(15 x12838) -(430)=10.1949 (Rounded to 3 decimal places)Therefore, the regression coefficient is b= 10.1949.Intercept:The intercept is obtained as a =-30.254 from the calculation given below:a =j-bx= 262-(10.1949 x 28.6667)= 262 - 292.2541=-30.2541 (Rounded to 4 decimal places)Therefore, the regression equation is Calories=- 30.2541 + 10.1949* Minutes.Calories

Accepted Answer

4.
From part 3, the linear regression equation is Calories=-30.2541+10.1949 Minutes.
The number of…