excel_correl_tut

# excel_correl_tut - Example: Correlation Part 1: Use Tools...

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online