create a Microsoft Excel spreadsheet with the two variables from the learning team's dataset.

Make a scatterplot of the Boston marathon data using years vs. time (in minutes)of both the men’s and women’s data in the same scatter plot.Display the linear equation of the trendline along with the R-squared Value.Use your equations to predict the winning men's and winning women’s time for the year 2012, then compare your equations times to the actual winning times (you will have to look them up)? How do your predictions compare to the actual?Approximately what year will the times be the same? Do you think this is possible?Turn in a word document with your answers to all the questions. Insert your graphs into the word document also

Respond to one of the following options in your initial post, citing at least one specific credible source in support. Question on credible sources? See the Scholarly, Peer-Reviewed, and Other Credible Sources (Links to an external site.). Option 1 Determine whether there is any link between the normal distribution and Variation 2: Standard Deviation (With a Digression on Eggroulette) (Links to an external site.) where we relied on statements such as “about two-thirds of observations are within one standard deviation of the mean.” Briefly discuss. Option 2 State an example of a variable that follows a normal distribution. State one way knowing this is useful in your professional or personal life. Briefly elaborate on your example. Option 3 Identify the minimum number of data points needed to generate a normal distribution. Create a data set of that size, and show that it meets the first three conditions for a Normal Distribution in section 5.1 on page 164 of the text.