Question

Standard Score for X х Y Y-X 35 102 Task 2 27 133 42 92 Compute the values in the highlighted cells 55 61 136 165 142 110 167 Factorial Combinations 38 24 Permutations N= 40 73 r= 7 92 62 162 172 NAME: Sum Sum of Squares Sum of Products Average (Mean) Sample Variance Sample Standard Deviation Correlation Task 1 Compute the values in the highlighted cells Draw a scatterplot for X, Y Draw a bar chart for X

Answer 1

For the sandard scores of X use the formula $Z_x=\frac{X-Average(X)}{Standard\, deviation (X)}=\frac{X-50.9 }{21.63561878 }$

Standard score for X	X	Y	Y-X
-0.734899208	35	102	67
-1.104659816	27	133	106
-0.411358676	42	92	50
0.189502311	55	136	81
0.466822767	61	165	104
-0.59623898	38	142	104
-1.243320044	24	110	86
1.021463679	73	167	94
1.899645122	92	162	70
0.513042843	62	172	110
sum	509	1381	872
Sum of squares	30121	198259	79650
sum of products	74365
average	50.9	138.1
sample variance	468.1	838.1
sample standard deviation	21.63562	28.94996
correlation	0.722368

Scatter plot between X and Y

Scatter plot 200 180 160 140 120 > 100 BO 60 40 20 O O 10 20 30 40 50 60 70 80 90 100 X

The bar graph for X is

х 100 90 80 70 60 50 40 IX 30 20 10 H 0 1 2 3 4 5 6 7 8 9 10

For task 2

		Factorial	Combinations	Permutations
N=	40	8.15915E+47	18643560	93963542400
r=	7	5040