data in csv format , will give later.Hill running is a long-standing Scottish tradition, dating back to 1040. The races take place at various times of year throughout Scotland. The data set (scottish_hill_races.csv) posted on Blackboard contains recent information from 90 races regarding Distance (in kilometers), Climb (in meters), Time (record time in minutes), and Sex (1 for women and 0 for men).a) Find the equation of the estimated simple linear regression function that predicts Time based on Distance.b) Plot the data with regression function found in part a). Distinguish between data points for Women and data points for Men and include a key (legend).c) Now fit the first-order regression model that predicts Time based on Distance and Sex. Provide the equation.d) Plot Time against Distance with the two separate regression functions based on Sex (one for Women and one for Men). You also need to include the equations of the two regression functions.e) Find the joint confidence intervals for the slopes with a family (Bonferroni adjusted) confidence level of 98%. Include an interpretation of each.f) Test whether Sex should be dropped from the model while Distance is retained. Include the hypotheses, test-statistic, p-value, and conclusions.g) Finally, let us consider the model that predicts Time based on Distance and Sex with interaction. Provide the equation.h) Now test whether Sex should be dropped from the model while Distance and the interaction term are retained. Include the hypotheses, test-statistic, p-value, and conclusions.i) Report the final model with Sex dropped. Does this improve upon the model found in part d)? Explain.2. Continue with the data set scottish_hill_races.csv.a) Fit the first-order regression model that predicts Time based on all potential predictors- Distance Climb, and Sex. Provide the equation.b) Construct a 95% prediction interval for the time it takes a woman to complete a 10 km race with a “climb” of 500 meters.c) Perform an exhaustive search for the “best” subsets of predictors. Which model was chosen as “best” for one predictor? Was it the one we examined in #1? How about for the “best” model with two predictors? Is it the one we examined in #1?d) Examine important criteria for the three “best” models chosen in c). Which model(s) should be included for final consideration based on them?e) Use forward stepwise selection with partial 𝐹-tests and α-to-enter= 0.01. Then use backward stepwise selection with partial 𝐹-tests and α-to-remove= 0.01. Which model is chosen as “best” in each case?f) Considering all results, which model(s) should be considered? Assess the predictive ability of the model(s) by splitting the data into training and testing (sample size 𝑛 = 40) subsets and estimating the mean squared prediction error 𝑀𝑆𝑃𝐸.g) Is there any indication of nonlinear relationships between Time and any of the quantitative predictors? Explain.h) Using basic diagnostics, is there any evidence of multicollinearity?i) Find the variance inflation factors for the quantitative predictors. Explain

For this DQ, you’ll complete a modified version of Technology Assignment 1 in Lesson 3-3 of the textbook in ALEKS, for which you’ll calculate the probabilities of various games of chance, using permutations (selection of items when the order matters) and combinations (selection of items when order does not matter).Download the attached template (“QR 3-3 Tech Template MODIFIED.xlsx”) and follow these steps (note that the ALEKS video for the template may not help that much):For each game described in column A, indicate in column B whether this involves permutations (selection of items where the order of selection matters) or combinations (where the order of selection does not matter). Enter either “Permutation” or “Combination”.In column C, provide a short description, based on the game information in column A, of the number of outcomes for the game (i.e., different possible ways in which the game could come out).In column D, use either the Excel PERMUT() function or the Excel COMBIN() function to calculate the number of outcomes for the game.In column E, describe what you would have to do to win this game.In column F, enter the number of ways in which you can win. Note that these will all be simple number entries except for the last game, which requires a bit more consideration; for that last game, see the hint in the text box below the table.In column G, calculate the probability of winning, which will be =(# of ways to win)/(total # of outcomes). You must use Excel formulas here.Finally, in column H, calculate the odds against winning, which is given by:(odds against) = (1 – probability of winning) / (probability of winning)The entries for the first game are filled in for you; feel free to use these as a model for your other entries.MAT-144 T5 DQ2 Explanation - YouTube