7100%You are provided the following information from a class of 15 students:=Att Class attendance (i.e. 90% - attended 90% of course classes)Score Overall Course Score (range 0 to 100)Avg Calories= Avg Calories consumed before Course classesSleep Avg Hours of sleep night before Course classes=Avg AvgAtt ScoreCal Sleep90% .5 250 750% 70.7 1200 5100% 65.3 150 5.595% 71.8 300 5.5700 755% 67.8Avg Avg8Att Score Cal Sleep85% 71.6 43090% 72.5 420 985% 77.8 625 955% 78.4 1000 7.5895% 79.8 490Avg AvgAtt Score Cal Sleep100% 78.8 410 990% 80.6 600 1095% 81.5 575 885% 85.2 875 8.587.1 965 895%You are directed to conduct a statistical analysis of the 15 person class(provided above) and make recommendations to improve student academicperformance as measured by course overall score.***Provide your statistical analysis (calculations, visual illustrations, etc.)along with an explanation (limited to 250 words) of the rationale behindyour statistical analysis and methods.***WhuluB

Statistics is the branch of mathematics is used to collect, tabulate, analyze, and the interpretation of data. The statistics uses measures of central tendency, measures of dispersion, regression analysis and the time series analysis for the analysis purpose. The stated problem has four variables,Att: Attendance of the classScore: Overall course score.Avg Cal: Calories consumed before classes.Avg Sleep: Night sleep before course classes.The calculation table isAttScoreAvg CalAvg Sleep9067.525075070.71200510065.31505.59571.83005.55567.870078571.643089072.542098577.862595578.410007.59579.8490810078.841099080.6600109581.557588585.28758.59587.19658Total12651136.48990115The average attendance before the class isthe average score of the course isThe average calories consumed before classes isthe average night's sleep before classes isThe dependent variable is the Score which is dependent on the Att, Avg Cal, and Avg Sleep.The regression model isUse the Excel command to find the coefficient of the regression modelCommandLINEST(A2:A16,B2:D16)value1.61700.02340.338320.7952coefficientb3b2b1b0The fitted regression model isthe least square method is used for estimating the regression coefficient.The regression model is used to predict the score of the student when the all other variables are known.The scatter plot for the dependent variable by all independent variable isThe average of all variables isVariablesAverageScore75.76Att84.3333Avg Cal599.3333Avg Sleep7.6667The fitted regression model is From the scatter diagrams, it is visible that there exists a positive linear relationship between Avg Sleep and Score, which is more evident.