Conducting a Correlation Coefficient Bus-311

Download this Excel File and open it on your system.

When you open it, you should see this image.
I already attached the file and I will list the steps in order
Step 2:

Click on the Data Tab at the on the top of screen and open Data Analysis ToolPak and scroll to “Correlation”

Step 3.

Once you select Correlation and click OK, you will see the following:

NOTE: In the above example, I have highlighted the Var1 Column and the Var 2 Column. Once you click OK, a sheet will open showing the correlation matrix. Note that the first row contains the Labels so the box is clicked.
Step 4

Once you run the correlation, you should see the following:So, the correlation between Var 1 and Var 2 is .776. It is reported as r2 = .776
Step 5

The correlation window allows you to run multiple variables at the same time. So you can select as many columns as you would like to do a correlation. In other words, you can run all the columns at once. What you will get is a matrix showing you all available correlations. In the sample shown in the image, Var1 to Var 4 columns are selected. Go ahead and run that.
Step 6

Once your run that correlation you will get a matrix in the Sheet below that shows all possible correlations. It should look something like this:

Th Corrlation betwe Var and Var 3 is .699 for example. I have blocked out a red box for the correlation between Var 2 and Var 4. Report that correlation as your response to this assignment and confirmation that you were able to complete the analyses.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.