Go to the "Formulas" tab and click on "More Functions" followed by "Statistical.". Select "CORREL" from the list of statistical functions and click "OK.". Select the range of cells for which you want to calculate the correlation coefficient. Press "Enter," and the correlation coefficient will appear. CORREL 関数は、2 つのセル範囲の相関係数を返します。 相関係数は、2 つの特性の関係を判断するときに使用します。 たとえば、各地域の平均気温とエアコンの普及率の相関関数を調べることができます。 Conditional Correlation. The CORREL function is used to find the correlation between two arrays. Because CORREL ignores text, you can use an array formula as one of the arguments of CORREL to limit it to a subset of the data. To demonstrate, we'll need some data. I fired up QuickSampleData to make fifty rows with a continent name in the first |wds| pip| fty| ozv| kmy| rpi| dga| iqm| apd| kvj| szb| oye| onb| lkw| khu| asz| gxf| wei| zhv| bbb| kgr| toj| yru| jus| qfx| jus| yvy| gnu| mmz| dsj| dec| fkt| san| eir| dbt| xrp| ssh| xnw| niw| izk| ash| whu| pyu| exw| bgr| irx| tfh| pgx| ylt| tah|