QUESTION

# All of the Projects for MAT 114 will require you to utilize several features of a spreadsheet program. This problem is designed to introduce you to...

a) Which quantity is most likely to be the independent variable?

b) Does it appear this appear these quantities are positively related or negatively related? (answerPOS if positive,NEG if negative)

Next, our goal will be to create a linear regression trendline for this data and to test the strength of the correlation - both of which can be efficiently accomplished in a spreadsheet program.

Open a spreadsheet program (such as Microsoft Excel) and complete the following steps:

1) Select the data above; copy and paste it into the spreadsheet program.

2) Highlight all of the data within the spreadsheet program.

3) Click "Insert" on the menu bar; select/click Scatter plot. (A scatter plot displaying your data should appear.)

4) Right-click on one of the data points in the scatter plot; select "Add Trendline..."

5) Within Trendline Options, select "Linear" and "Display R-squared value on chart"

c) What is the R-squared value for the linear trendline for this data set?  d) What is the R value (the correlation coefficient) for the linear trendline for this data?

xyxyx21.34.515.8631.691.44.426.1881.961.64.417.0562.562.64.51 11.7262.563.84.43 16.8346.768.73.74 32.53814.449.14.15 37.76575.6911.43.641.0482.8112.52.99 37.375...