X
3
3 Class Intervel Frequency Cumu MCF
4 0 - 5 9 9 131
4 5 - 10 97 106 median class 122
4 10 - 15 25 131 25
4 0 Char
4
140
4 0-5
4 Bins 5-10 120
5 4 10-15
100
5 9
5 15 80
5
60
5 Mode l + ((f1 - f2)/(2f1 - f0 - f2))*h 7.232704402516
5 40
5 f0 9
20
5 f1 97
5 f2 26 0
0 2 4 6
5 h 5
5 l 5
5
5
5 Median l + ((N/2)-C)/(f)*h
5
6 N 120
6 N/2 60
6 C 9
6 f 9
6 h 5 33.33333333333
6
6
6
6
6
6
6
6
6
6
6
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
9
9
9
9
9
9
9
9
9
9
9
9
9
9
9
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
11
11
11
11
11
11
12
12
13
14
LESS THAN(UCL) CFLESS THAN MORE THACF MORE THAN STEPS
MEAN
MEDIAN
MODE
CHARTS
OGIVE FOR MEDIAN FOR MEDIAN CREATE CUM
Chart Title IN CHARTS SELECT SCATTE
7
HISTOGRAM FOR MODE SELECT FREQNCY AND CLA
GO TO INSERT/BAR DIAGR
REMOVE SPACE BETWEEN
2 4 6 8 10 12 14 16
AVERAGE FUNCTION 7.503817
MEDIAN FUNCTION 7
MODE FUNCTION 7
FOR MEDIAN CREATE CUM FREQ
IN CHARTS SELECT SCATTER WITH SMOOTH LINE
SELECT FREQNCY AND CLASS LIMITS
GO TO INSERT/BAR DIAGRAM
REMOVE SPACE BETWEEN BARS
CREATE RANDOM NOS THRU RA
100 48 FIX THE NOS
76 21 USE DATA ANALYSIS TOOLPAK
86 40 USE DESCRIPTIVE STATISTICS
99 8
53 50
87 29
12 12
83 52
24 95
62 95
78 51
21 1
54 35
3 96
51 83
58 17
19 92
19 72
47 44
30 49
81 98
15 70
57 60
1 34
29 74
99 39
15 13 Column1
28 81
16 95 Mean 54.58
67 1 Standard Error 3.9689704623
3 68 Median 54
32 82 Mode 95
74 84 Standard Deviation 28.06485928222
81 43 Sample Variance 787.6363265306
26 24 Kurtosis -0.870704540333
48 52 Skewness -0.267890663411
61 61 Range 97
45 64 Minimum 1
1 31 Maximum 98
64 2 Sum 2729
56 56 Count 50
37 69 0
67 41
37 76
15 43
98 85
59 59
32 78
31 68
15 88
CREATE RANDOM NOS THRU RANDBETWEEN FUNCTION
FIX THE NOS
USE DATA ANALYSIS TOOLPAK
USE DESCRIPTIVE STATISTICS
X Y R1 R2 D D2
35 45 10 8 2 4
90 70 2 4 -2 4
70 65 5 5 0 0
40 30 9 10 -1 1
95 90 1 1 0 0
45 40 8 9 -1 1
60 50 6 7 -1 1
85 75 3 3 0 0
80 85 4 2 2 4
50 60 7 6 1 1
16
CORRELATION= 1-[(∑6D2)/N3-N] N= 10
NUMERATOR N3 1000
DENOMINATOR=
CORRELATION=
0.90303
STEPS
USE RANK FUNCTION
FIX THE DATA RANGE THRU DOLLAR SIGN
LEAVE ORDER AS IT TAKES ASCENDING BY DEFAULT
APPLY FORMULA
YEAR X TREND VALUES ELIMINATE
2021 15
2022 19
2023 22
2024 34
2025 40
INTERCEPT
SLOPE
YEARS AS X
STEPS
USE INTERCEPT AND SLOPE FUNCTION
HERE TREND LINE READ IN EXCEL IS Y=a+Bx
so Y IS X HERE
ANOTHER WAY
SELECT DATA
INSERT SCATTER
ADD TREND LINE AND EQAUATION
X Y X Y
30 7 4 10
7 30 5 23
23 9 33 22
28 11 28 19
26 39 25 0
10 1 34 1
38 40 0 6
7 13 28 20
38 25 27 9
13 0 35 20
15 20 26 0
36 13 20 15
28 1 11 18
26 29 16 10
34 39 31 2
13 34 23 12
8 7 25 22
12 32 25 22
16 33 1 39
32 16 27 3
21 3 39 5
35 14 26 7
17 0 4 20
16 34 2 15
33 16 33 0
CREATE RANDOM NUMBERS AND FIX THEM
CREATE PIVOT TABLE
FOR JOINT PROB TABLE
COPY PIVOT TABLE
RIGHTCLICK VALUE FIELD ANALYSIS SHOW VALUE AS %OF GRAND TOTA
FOR CONDITIONAL PROB BY COLUMN TABEL
COPY PIVOT TABLE
RIGHTCLICK VALUE FIELD ANALYSIS SHOW VALUE AS %OF COLUMN TOT
FOR CONDITIONAL PROB BY ROW TABEL
COPY PIVOT TABLE
RIGHTCLICK VALUE FIELD ANALYSIS SHOW VALUE AS %OF ROW TOTAL
VALUE AS %OF GRAND TOTAL
VALUE AS %OF COLUMN TOTAL
VALUE AS %OF ROW TOTAL
S.no STRESS(X) SYMPTOMS(Y)
1 30 99
2 9 80
3 20 70
4 3 100
5 15 109
6 5 62
7 10 81
8 23 74
9 34 121
10 20 100 a 69.336
11 17 73 b 1.059
12 26 88
13 16 87 y on x
14 17 73 y= a+bx 69.336+1.059x
15 15 65
16 38 89 x on y
17 16 86 x=a+by 69.336+1.059y
18 38 146
19 15 107
20 27 94
USE CORREL FUNCTION FOR CORRELATION IN DATA ANALYSI
USE INTERCEPT AND SLOPE FUNCTION
CAN USE FORECAST SHEET IN DATA TO FORECAST
OR CAN USE FORECAST FUNCTION
ORRELATION IN DATA ANALYSIS
ATA TO FORECAST
STRESS SYMPTOMS
STRESS 1
SYMPTOM 0.518953 1
N 10
P 0.8
LAMDA= 8
X f(X) f(x)
0
1
2
3
4
5
6
7
8
9
10
USE BINOMDIST FUNCTION FOR BOTH
IN FIRST TAKE FALSE
IN SECOND TAKE TRUE FOR CUMULATIVE
N 10
p 0.5
X f(x) F(x)
0 0.000977 0.000977
1 0.009766 0.010742
2 0.043945 0.054688
3 0.117188 0.171875
4 0.205078 0.376953
5 0.246094 0.623047
6 0.205078 0.828125
7 0.117188 0.945313
8 0.043945 0.989258
9 0.009766 0.999023 Err:502
10 0.000977 1
