Explain the procedure for computation of correlation using Microsoft Excel.

How to Calculate Correlation Coefficient in Excel

1. Open Excel.
2. Install the Analysis Toolpak.
3. Select “Data” from the top bar menu.
4. Select “Data Analysis” in the top right-hand corner.
5. Select Correlation.
6. Define your data range and output.
7. Evaluate your correlation coefficient.

1. Open Excel.

Step one: Open Excel and start a new worksheet for your correlated variable data. Enter the data points of your first variable in column A and your second variable in column B. You can _______ ________ _______ __________ ________ ___ ________.
_____ _______ _______ ____ _______ ____ ____ ____ _____ ___ _______.
______ ___ __________ __________ _____ _________ ________ ________ ___ ______.
__________ ____ ________ _______ ______ ____ _____ ________ ____.
____ _________ ____ _______ ________ ___ __________.
____ ______ ___ ________ _______ ________ ____.
____ ________ _________ ______ ____.
_______ _____ _____ ___ ___ ____ ___ ______ ________.
________ __________ _______ ____ __________ __________.
______ ________ __________ ________ ___ ________.
_____ ___ __________ _______ ___ ____ _________ ________ ___.
_______ _________ _____ _________ ________ __________ ________ ________ ________ ________ ___.
_________ __________ __________ _______ _______ ________ __________ ___.
_________ ______ ________ ___ _______ _____ ________ _________ _______ _____.
__________ _______ ____ ___ __________ _______ ___ _________ _____ _______ _____ ______.
___ _____ ____ ________ _____ _______ ________.
______ ________ _________ ______ ________ _____ _________ _______ _______.
_____ _________ _________ _______ ___ ______ _______ ________ _________ _______.
___ ________ ____ _______ ___ __________ ____ ________ ___ ________.
______ ___ _________ ___ ___ ___ ______ ____ __________ __________.
_____ ______ ___ ________ _________ ___ _______ ________ _____.
__________ ________ _________ ______ ___ _________ ________ ___.
___ _____ _______ _______ _________ ___ _____.
_________ ______ __________ _____ ________ ______.
_____ _________ ______ ____ _____ ______ _________.
__________ ______ ________ _________ _______ ______ _______ _____ ______ _______ ______ _______.
____ ____ _____ ______ __________ ________ ______ ___ ___ _______.
_______ ____ _____ ____ ________ ____.
Get Full Answer on WhatsApp