In addition to two clusters, the plot shows an overall roughly straight line pattern. The least squares regression line for predicting average SAT math score from percentage taking is average math SAT score = 602.4 - (1.142 times percentage taking) In Georgia, the percentage of high school seniors who took the SAT was 61%. Predict their average score to the nearest whole number. (The actual average score in Georgia was 515)

Brandon works as a statistician for the Toronto Blue Jays, and wants to analyze the relationship between a player's age and how many strikeouts they accumulate in a season. He takes a sample of 8 Blue Jays players with age between 25 and 34 and finds there is a linear relationship between their ages and the number of strikeouts they had in the 2015 season. Here are the numerical summaries for age and the number of strikeouts: r = 0.67, age = 28.4, Sage = 3.96, strikeout= 102.9, S strikeout = 7.7 (a) What is the value of b₁, i.e. the fitted slope? (Round your answer to 3 decimal places) Answer: (b) What the value of bo, i.e. the fitted intercept? (Round your answer to 3 decimal places.) Answer: (c) What is the percent of variation of the number of strikeouts that is explained by age using a linear regression? (Round your answer to 2 decimal places.) Answer: % (d) Can we use this linear regression to predict the number of strikeouts for a player age 38? Answer: O No, because the…

The datasetBody.xlsgives the percent of weight made up of body fat for 100 men as well as other variables such as Age, Weight (lb), Height (in), and circumference (cm) measurements for the Neck, Chest, Abdomen, Ankle, Biceps, and Wrist. We are interested in predicting body fat based on abdomen circumference. Find the equation of the regression line relating to body fat and abdomen circumference. Make a scatter-plot with a regression line. What body fat percent does the line predict for a person with an abdomen circumference of 110 cm? One of the men in the study had an abdomen circumference of 92.4 cm and a body fat of 22.5 percent. Find the residual that corresponds to this observation. Bodyfat Abdomen 32.3 115.6 22.5 92.4 22 86 12.3 85.2 20.5 95.6 22.6 100 28.7 103.1 21.3 89.6 29.9 110.3 21.3 100.5 29.9 100.5 20.4 98.9 16.9 90.3 14.7 83.3 10.8 73.7 26.7 94.9 11.3 86.7 18.1 87.5 8.8 82.8 11.8 83.3 11 83.6 14.9 87 31.9 108.5 17.3…

Please answer question 4 and please show me how to do it in excel.