Click a different cell that you want to use to calculate the p-value that is associated with your correlation.ħ. Press 'Enter.' Excel calculates the Pearson correlation coefficient for your data range and displays it in the cell.Ħ. Substitute the addresses of your data ranges in place of these sample ranges.ĥ. Type '=PEARSON(A1:A20,B1:B20)' - without the quotes - in the cell. Click a cell that you want to use to calculate the Pearson correlation coefficient 'r.'Ĥ. For example, if your data is contained in the first 20 rows of columns 'A' and 'B,' then the two cell address ranges for your data are 'A1:A20' and 'B1:B20.'ģ. Determine the cell addresses that contain the two ranges of data that you want to compare. Open the workbook that contains your data in Excel 2007.Ģ.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |