This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Example: Correlation Part 1: Use Tools > Data Analysis Part 2: Use Insert Function fx
Issue: The company wants to analyze the relationship between salary and years with the company. Objective: Use "Tools > Data Analysis" in Excel to find the correlation between salary and years with the company. Example: Correlation The Excel File Example: Correlation. First click on Tools, then Data Analysis and finally on Correlation. Example: Correlation Define ranges for Variables. Click on O.K. Example: Correlation The Excel output shows the correlation between Sales and Years with Midwest. Example: Correlation Part 2: Use Insert Function fx
Issue: The company wants to analyze the relationship between salary and years with the company. Objective: Use the Insert Function fx in Excel to find the correlation between salary and years with the company. Example: Correlation The Excel File Example: Correlation.
First click on an empty cell, then Insert Function fx, then Statistical Function Category, then Correl. Click on OK Example: Correlation Specify range for each variable. Click on OK. Example: Correlation Excel shows correlation in cell that was active when Insert Function fx was selected. ...
View
Full
Document
This note was uploaded on 04/21/2009 for the course BUS 350 taught by Professor Reiland during the Spring '08 term at N.C. State.
 Spring '08
 reiland
 Business

Click to edit the document details