1) [5] A business analyst conducted a sales force analysis to determine if there is a correlation in a salesperson's intelligence and the average weekly sales. The Excel spreadsheet lists the data for a random selection of 13 salespersons. The intelligence is measured by an inventory each employee takes. (Number 1 Tab in Excel File) a) Create the scatterplot on your Excel Spreadsheet. Title the plot \"Sales Force Analysis\" and label the x and y axes appropriately. Also, right click on the axes numbers and choose the Format Axis option to edit the minimum for the x axis to 80 and y axis to $2000. b) Does it appear to be a positive linear correlation? Why or why not? c) Fill out the necessary cells in the spreadsheet to calculate the correlation coefficient . Use both the formulain the formula sheet and the built-in CORREL function in Excel to check your work. List the r value here: d) Use Excel to calculate the coefficient of determination r2. List it here: e) What does the value you found for r2 say about the explained and unexplained variations? Write the appropriate sentences. 2) [5] An athletic trainer knows there is a strong correlation between age and the 40 meter dash time of a local men's semi-pro fast-pitch softball team. The data is given in the Excel spreadsheet. Age is in years and the 40 meter dash time is in seconds. (Number 2 Tab in Excel File) a) Fill out the necessary cells in the spreadsheet to calculate the correlation coefficient . Use both the formula in the formula sheet and the built-in CORREL function in Excel to check your work. List the r value here: b) Use formulas from formula sheet to find the equation of the regression line. Show work below or in the Excel spreadsheet. Equation of the regression line: c) Using your regression line, how fast would you expect a 32 year old softball player to run the 40 meter dash