stats

excelweek1.xlsx

Sheet1

Sample 1	Sample 2	Delete this text then place your Descriptive Statistics output in cell D1		Covariance and Coorelation	Formulas
42	47
70	83	Round all answers in the sheet to 2 decimal places using ROUND or the number formatting tool.		Covariance (COVARIANCE.S)	ERROR:#N/A
66	77
61	49			Correlation (CORREL)	ERROR:#N/A
50	54
40	32			Correlation Calculation	ERROR:#N/A
66	69
52	56			Correlation from ToolPak
64	60			Delete this text then place your correlation output here
34	43
28	30
34	29
32	32
37	52
52	61
Sample 1	Sample 2	Sample 1 z-score Formulas	Sample 2 z-score Formulas
z-scores	z-scores
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A
		ERROR:#N/A	ERROR:#N/A