Question

Give the Excel formulas and the answers for:

A. Calculate a z-score for each of the data points in the variable height.

B. Calculate a T-score for each data point in Part A.

E. Calculate a Stanine score for each data point in Part A.

Height
64
66
69
63
68
62
63
60
66
66
63
68
75
68
65
64
78
71
68
66
53
71
78
69
77
68
62
69
55
67

Answer 1

here as we knw z scre =(X-mean)/std deviation

T score =50+10*a score

and fr z<-1.75 ; Stanine score =1;  -1.75<z<-1.25 ; Stanine score =2; -1.25z<--0.75 ; Stanine score =3;

-0.75 z<-0.25 ; Stanine score =4; -0.25<Z<0.25  Stanine score =5 ;   0.25<Z<0.75  Stanine score =6 ;

0.75<Z<1.25  Stanine score =7 ;  1.25<Z<1.75 Stanine score =8 ;Z>1.75 Stanine score =9 ;

	A	B	E
Height	z score	T score	Stanine Score
64	-0.47	45.3	4
66	-0.13	48.7	5
69	0.39	53.9	6
63	-0.65	43.5	4
68	0.22	52.2	5
62	-0.82	41.8	7
63	-0.65	43.5	4
60	-1.17	38.3	7
66	-0.13	48.7	5
66	-0.13	48.7	5
63	-0.65	43.5	4
68	0.22	52.2	5
75	1.43	64.3	8
68	0.22	52.2	5
65	-0.3	47	4
64	-0.47	45.3	4
78	1.95	69.5	9
71	0.74	57.4	6
68	0.22	52.2	5
66	-0.13	48.7	5
53	-2.38	26.2	1
71	0.74	57.4	6
78	1.95	69.5	9
69	0.39	53.9	6
77	1.78	67.8	9
68	0.22	52.2	5
62	-0.82	41.8	3
69	0.39	53.9	6
55	-2.03	29.7	1
67	0.05	50.5	5