1.6/ Linear Regression: Use Excel to determine the slope, m, and the y-intercept, b, of the distance speed following data. The distance, d, is the independent variable. Model your solution d (ft) v(ft/s) after the Linear Regression Example in the "Excel_07" class slide and the handout provided in class. The handwritten calculations should be done with excel with appropriate and clear annotations. Do not plot the data. Your spreadsheet will 26.1 include the following items: 23.9 An organized and labeled table that contains the data shown. Extra labeled columns that contain the intermediate calculation needed for m and b. Calculations for m and b should be done in excel with clear annotations so that the grader can see the formulas. These equations are both in the class handout and in the lecture slides. Include the "Gridlines" and "Headings" on your printout so that the grader can see the cell references in your equations. 21.4 19.5 9.8 17.3 1.6/ Linear Regression: Use Excel to determine the slope, m, and the y-intercept, b, of the distance speed following data. The distance, d, is the independent variable. Model your solution d (ft) v(ft/s) after the Linear Regression Example in the "Excel_07" class slide and the handout provided in class. The handwritten calculations should be done with excel with appropriate and clear annotations. Do not plot the data. Your spreadsheet will 26.1 include the following items: 23.9 An organized and labeled table that contains the data shown. Extra labeled columns that contain the intermediate calculation needed for m and b. Calculations for m and b should be done in excel with clear annotations so that the grader can see the formulas. These equations are both in the class handout and in the lecture slides. Include the "Gridlines" and "Headings" on your printout so that the grader can see the cell references in your equations. 21.4 19.5 9.8 17.3