S. NO.
NAME GENDERDESIGNATION
LOCATION SALARY BONUSCOMMISSION
1 ELEVEN F GM DELHI 1100000 110000 55000
2 MIKE M DM BLR 800000 80000 40000
3 MAX F GM BLR 1000000 100000 50000
4 JOYCE F AM MUMBAI 650000 65000 32500
5 LUCAS M DM DELHI 850000 85000 42500
6 NANCY F AM BLR 600000 60000 30000
7 DUSTIN M GM MUMBAI 1000000 100000 50000
8 JIM M AM BLR 550000 55000 27500
9 WILL M DM MUMBAI 750000 75000 37500
10 ERICA F AM DELHI 500000 50000 25000
11 STEVE M AM DELHI 500000 50000 25000
12 ROBIN F AM MUMBAI 500000 50000 25000
COUNT 0 0 0 12 12 12
COUNTA 12 12 12 12 12 12
COUNTIF 6 0 0 0 0 0
SUM 0 0 0 8800000 880000 440000
SUMIF 3950000 0 0
2950000
Sum of SA Column Labels
Row LabelsBLR DELHI MUMBAI Grand Total
AM 1150000 1000000 1150000 3300000
DM 800000 850000 750000 2400000
GM 1000000 1100000 1000000 3100000
Grand Tota 2950000 2950000 2900000 8800000
BONUS 10%
COMM 5%
DESCRIPTIVE ST
X CENTRAL TENDENCY
402 MEAN 454.5745 X
458 MEDIAN 458
412 MODE 497 Mean 454.5745
497 MODE.M 497 Standard Error 4.459474
496 MODE.SINGL 497 Median 458
422 Mode 497
414 MEASURES OF DISPERSION Standard Deviation 30.57261
500 RANGE Sample Variance 934.6846
445 MAX 500 Kurtosis -1.105192
497 MIN 401 Skewness -0.162081
434 RANGE 99 Range 99
433 Minimum 401
456 QUARTILES Maximum 500
462 Q1 428.5 Sum 21365
497 Q3 476 Count 47
447 QD 23.75
458
426 MD 25.6134
443 (MEAN DEVIATION)
470 SD 30.24562
425 (STD. DEVIATION) 30.57261
468
455
413 SKEWNESS -0.162081 GAMMA 1
475
491 KURTOSIS -1.105192 GAMMA 2
499
467
487
431
477
490
461
457
401
457
439
414
469
402
420
462
412
472
470
482
500
DESCRIPTIVE STATISTICS
Y CHANGE OF ORIGIN Z
412 Y 804
468 916
422 Mean 464.5745 824
507 Standard Error 4.459474 994
506 Median 468 992
432 Mode 507 844
424 Standard Deviation 30.57261 828
510 Sample Variance 934.6846 1000
455 Kurtosis -1.105192 890
507 Skewness -0.162081 994
444 Range 99 868
443 Minimum 411 866
466 Maximum 510 912
472 Sum 21835 924
507 Count 47 994
457 894
468 916
436 852
453 886
480 940
435 850
478 936
465 910
423 826
485 950
501 982
509 998
477 934
497 974
441 862
487 954
500 980
471 922
467 914
411 802
467 914
449 878
424 828
479 938
412 804
430 840
472 924
422 824
482 944
480 940
492 964
510 1000
CHANGE OF SCALE
Z X Count of X
401-410 3
Mean 909.1489 411-420 6
Standard Error 8.918947 421-430 3
Median 916 431-440 4
Mode 994 441-450 3
Standard Deviation 61.14522 451-460 6
Sample Variance 3738.738 461-470 8
Kurtosis -1.105192 471-480 3
Skewness -0.162081 481-490 3
Range 198 491-500 8
Minimum 802 Total Resul 47
Maximum 1000
Sum 42730
Count 47
X Y X Y R1 R2
15 120 14 115 10 12.5
11 117 10 117 2.5 14.5
14 101 17 109 16 6.5
16 120 17 110 16 8
20 114 18 111 18 9.5
20 117 14 115 10 12.5
19 113 14 118 10 16.5
13 116 20 105 19.5 2.5
12 118 10 118 2.5 16.5
11 110 11 109 5.5 6.5
10 120 14 111 10 9.5
11 115 20 108 19.5 5
15 103 14 119 10 19
11 111 15 113 13.5 11
16 104 13 105 7 2.5
19 109 15 107 13.5 4
13 111 10 119 2.5 19
17 109 11 117 5.5 14.5
14 114 17 101 16 1
19 100 10 119 2.5 19
N 20
CORRELATION-0.659304
STEP 1 CORRELATION RESIDUALS Y-Yc
STEP 2 RANK.AVG(F4)
STEP 3 D
STEP 4 D SQUARE
STEP 5 N(COUNT)
STEP 6 SUM
STEP 7 R
STEP 8 DATA ANALYSIS
STEP 9 Y
STEP 10 Yc
STEP 11 (Y-YC)^2
STEP 12 SE
CORRELATION AND REGRESSION
D= R1-R2 D*D Yc SUMMARY OUTPUT
-2.5 6.25 112.5231
-12 144 116.9849 Regression Statistics
9.5 90.25 109.1767 Multiple R 0.65930410696
8 64 109.1767 R Square 0.434681905454
8.5 72.25 108.0612 Adjusted R Square 0.403275344646
-2.5 6.25 112.5231 Standard Error 4.231786971574
-6.5 42.25 112.5231 Observations 20
17 289 105.8303
-14 196 116.9849 ANOVA
-1 1 115.8695 df
0.5 0.25 112.5231 Regression 1
14.5 210.25 105.8303 Residual 18
-9 81 112.5231 Total 19
2.5 6.25 111.4076
4.5 20.25 113.6386 Coefficients
9.5 90.25 111.4076 Intercept 128.1395582329
-16.5 272.25 116.9849 X -1.11546184739
-9 81 115.8695
15 225 109.1767
-16.5 272.25 116.9849
RESIDUAL OUTPUT
S 2170
Observation Predicted Y
R -0.631579 1 112.5230923695
2 116.984939759
3 109.1767068273
4 109.1767068273
5 108.0612449799
6 112.5230923695
7 112.5230923695
8 105.8303212851
9 116.984939759
10 115.8694779116
11 112.5230923695
12 105.8303212851
13 112.5230923695
14 111.4076305221
15 113.6385542169
16 111.4076305221
17 116.984939759
18 115.8694779116
19 109.1767068273
20 116.984939759
SS MS F Significance F
247.85562 247.85562249 13.84048091 0.0015662882
322.34438 17.90802097278
570.2
Standard Error t Stat P-value Lower 95% Upper 95%Lower 95.0%Upper 95.0%
4.3615109 29.3796258407 1.159455E-16 118.97636386 137.30275 118.97636 137.3028
0.2998328 -3.72027968229 0.001566288 -1.74538717 -0.485537 -1.745387 -0.485537
Residuals
2.4769076
0.0150602
-0.176707
0.8232932
2.938755
2.4769076
5.4769076
-0.830321
1.0150602
-6.869478
-1.523092
2.1696787
6.4769076
1.5923695
-8.638554
-4.407631
2.0150602
1.1305221
-8.176707
2.0150602
X Residual Plot
10
5
Residuals
0
-5 8 10 12 14 16 18 20 22
-10
X
X Line Fit Plot
130
120
110 Y
Y
100 Predicted Y
90
8 10 12 14 16 18 20 22
X
YEAR PROD X SUMMARY OUTPUT
2010 120 0
2011 125 1 Regression Statistics
2012 126 2 Multiple R 0.99118873824
2013 134 3 R Square 0.98245511482
2014 140 4 Adjusted R Square 0.98050568314
2015 148 5 Standard Error 2.91356978445
2016 155 6 Observations 11
2017 162 7
2018 170 8 ANOVA
2019 177 9 df
2020 175 10 Regression 1
Residual 9
Total 10
2025 210.7273 15 Coefficients
Intercept -12417.909091
2025 210.7273 YEAR 6.23636363636
2026 216.9636
2027 223.2
2028 229.4364
2029 235.6727 RESIDUAL OUTPUT
2030 241.9091
Observation Predicted PROD
1 117.181818182
2 123.418181818
3 129.654545455
4 135.890909091
5 142.127272727
6 148.363636364
7 154.6
8 160.836363636
9 167.072727273
10 173.309090909
11 179.545454545
TIME SERIES
Y= -12417.9 + 6.236X
Y = 117.18 + 6.2363
SS MS F Significance F
4278.1454545455 4278.145 503.97 3.27E-09
76.4 8.488889
4354.5454545455
Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
559.76361713737 -22.1842 3.633E-09 -13684.1824 -11151.6358 -13684.1824 -11151.6358149
0.2777979790634 22.44928 3.27E-09 5.607940948 6.86478632 5.607940948 6.86478632451
Residuals
2.8181818181838
1.5818181818195
-3.654545454545
-1.890909090907
-2.127272727272
-0.363636363636
0.4000000000015
1.1636363636371
2.9272727272746
3.6909090909103
-4.545454545454
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.99118873824
R Square 0.98245511482
Adjusted R Sq 0.98050568314
Standard Erro 2.91356978445
Observations 11
ANOVA
df SS MS F Significance F
Regression 1 4278.145 4278.145 503.97 3.27E-09
Residual 9 76.4 8.488889
Total 10 4354.545
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 117.181818182 1.643475 71.30125 1.061E-13 113.464
X 6.23636363636 0.277798 22.44928 3.27E-09 5.607941
RESIDUAL OUTPUT
Observation Predicted PROD Residuals
1 117.181818182 2.818182
2 123.418181818 1.581818
3 129.654545455 -3.654545
4 135.890909091 -1.890909
5 142.127272727 -2.127273
6 148.363636364 -0.363636
7 154.6 0.4
8 160.836363636 1.163636
9 167.072727273 2.927273
10 173.309090909 3.690909
11 179.545454545 -4.545455
Significance F
Upper 95%Lower 95.0%
Upper 95.0%
120.8996 113.464 120.8996
6.864786 5.607941 6.864786
ITEMS P0 P1 Q0 Q1 P V=P0Q0 PV
A 23 26 17 16 113.0435 391 44200
B 120 140 20 18 116.6667 2400 280000
C 15 20 8 8 133.3333 120 16000
D 55 70 10 7 127.2727 550 70000
E 340 380 7 5 111.7647 2380 266000
F 62 72 30 29 116.129 1860 216000
615 708 92 83 718.2099 7701 892200
SA 115.122 CPI
SP 119.7017 AE 115.8551
L 115.8551 FB 115.8551
P 115.97
F 115.9125
WAP 115.8551
P0Q0 7701
P1Q0 8922
P0Q1 6531
P1Q1 7574
