Assignment #$8$

$1-$ Open the attached excel file C$03\_02.$xlsx

$2-$ Be sure you will have the data for $274$ couples:

$3-$ Select from Excel tabs: Data then Data Analysis then Correlation then press OK$.$

Data Analysis

Analysis Tools

$3-$ Select from Excel tabs: Data then Data Analysis then Correlation then press OK$.$

$4-$ In the Correlation Dialog Box, click Input Range then Select all the data with the labels:

Salary, Cars, Home, Savings and SC Index for the $274$ couples.

Then select Labels in first row option, then select Output Range then select Cell I$4$ in

the Excel sheet. Be sure you have the following then press OK$.$

$5-$ You should have the following correlation table:

$6-$ Note that the correlation between Savings and Salary is $-0\mathrm{.}16216$

and the correlation between SC Index and Salary is $0\mathrm{.}796737$

$7-$ Select the data of Column Salary and Savings with the labels Salary and Savings then

select Insert Tab in Excel Tabs then select Scatter Plot and be sure the output is the

following: Savings vs Salary with title Scatter Plot.

$8-$ Select the data of Column Salary and SC Index with the labels Salary and SC Index

then select Insert Tab in Excel Tabs then select Scatter Plot and be sure the output is the

following: SC Index vs Salary with title Scatter Plot.

$9-$ Based on your work, indicate whether there are correlation between the variables below

and the type of correlation:

$9\mathrm{.}1$ Salary and Savings $=>$

$9\mathrm{.}2$ SC Index and Salary $=>$