This problem is to be worked manually, not with R. The most efficient and accurate way to carry out the calculations is to use Excel, but you may use a calculator if you prefer. You also may use R to check your results. Show your work by including your spreadsheet with your submission or intermediate products from your calculations. Researchers at Washington University are attempting to predict the number of auto accidents in the city. They hypothesize that weather conditions, such as temperature and precipitation, go a long way toward determining the number of accidents. The researchers randomly select 10 days in 2012 and run a regression to determine if temperature and precipitation amounts significantly affected the number of accidents. Using the intermediate data provided, (i) construct the regression equation, (ii) calculate and interpret the R2 and adjusted R2, (iii) determine whether the overall regression is significant, (iv) test for the significance of the individual regression coefficients (except for 1), and (v) interpret the parameter estimates. Use = 0.05. Temperature, X2 5 Precipitation, X3 No. of Accidents, Y 29 62 75 -7 44 32 81 25202-23-6 20 11 12 4 31 10 12 5 7 72 97 8 = 120 2 = 490 EX3 = 14.1 Y = 12 X2 = 49 X3=1.41 Zy2=584 Ex2 = 10,488 22 = 10,488 x32 = 7.729 x2y = -2125_2x3y = 23.1 x2x3 = -75.2