Correlation Access tech supplements, videos, and data sets at www.TriolaStats.com TECH CENTER continued 522 CHAPTER 10 Correlation and Regression TI-83, 83 84 Plus Calculator 8 us Ca cu ato 1. Press K, then select TESTS in the top menu. 2. Select LinRegTTest in the menu and press [. 3. Enter the list names for the x and y variables. Enter 1 for Freq and for b & r select 3 0 to test the null hypothesis of no correlation. 4. Select Calculate and press [. Scatterplot 1. Open the STAT PLOTS menu by pressing F, E. 2. Press [ to access the Plot 1 settings screen as shown: a. Select ON and press [. b. Select first chart option (scatterplot), then press [. c. Enter names of lists containing data for the x and y variables. 3. Press B then 9 (ZoomStat) to generate the scatterplot. R R commands: Correlation: cor(x,y) Scatterplot: plot(x,y) Add Regression Line to Scatterplot: abline(lm1y=x2 ) A complete list of R statistical commands is available at TriolaStats.com Excel XLSTAT Add-In 1. Click on the XLSTAT tab in the Ribbon and then click Modeling data. 2. Select Linear regression from the dropdown menu. 3. Enter the range of cells containing the Y>Dependent variable data and X>Explanatory variable data. Check the Quantitative box under X>Explanatory variable. If the first data row includes a label, check the Variable labels box. 4. Click the Outputs tab and ensure Correlations and Analysis of variance are both checked. 5. Click OK, and the linear correlation coefficient, P-value, a scatterplot, and hypothesis test results will be displayed. The linear coefficient r is found in the Correlation matrix and the P-value is found in the Analysis of Variance table under Pr 7 F. Excel 1. Click Insert Function ƒx, select the category Statistical, and select the function CORREL. Click OK. 2. For Array1 enter the data range for the independent x variable. For Array2 enter the data range for the dependent y variable. 3. Click OK for the linear correlation coefficient r. Scatterplot (Excel) 1. Select the data range. 2. Click the Insert tab in the Ribbon. 3. In the Charts section of the top menu select the Scatter chart type. 4. Right click on the chart to customize.
RkJQdWJsaXNoZXIy NjM5ODQ=