QT R2
QT R2
45
05/04/2023 2257.75 0.0403658733 02/01/2024 3438.1
06/04/2023 2274.25 0.0073081608 03/01/2024 3440.35
10/04/2023 2309.7 0.0155875563 04/01/2024 3458.7
11/04/2023 2301.5 -0.0035502446 05/01/2024 3521.9
12/04/2023 2288.5 -0.0056484901 08/01/2024 3501.1
13/04/2023 2258.75 -0.0129997815 09/01/2024 3555.95
17/04/2023 2214 -0.0198118428 10/01/2024 3545.5
18/04/2023 2216.6 0.0011743451 11/01/2024 3504.85
19/04/2023 2219.6 0.0013534242 12/01/2024 3568.8
20/04/2023 2232.75 0.0059244909 15/01/2024 3543.05
21/04/2023 2215.2 -0.007860262 16/01/2024 3573.5
24/04/2023 2228.9 0.0061845432 17/01/2024 3570.95
25/04/2023 2247.95 0.0085468168 18/01/2024 3596
26/04/2023 2276.15 0.012544763 19/01/2024 3646
27/04/2023 2305.6 0.0129385146 20/01/2024 3634.5
28/04/2023 2364.4 0.0255031228 23/01/2024 3551
02/05/2023 2384.45 0.0084799526 24/01/2024 3589.2
03/05/2023 2356.3 -0.0118056575 25/01/2024 3593.45
04/05/2023 2356.9 0.0002546365 29/01/2024 3708
05/05/2023 2377.5 0.0087402945 30/01/2024 3633.3
08/05/2023 2365.4 -0.0050893796 31/01/2024 3479.75
09/05/2023 2374.35 0.0037837152 01/02/2024 3398
10/05/2023 2364.45 -0.0041695622 02/02/2024 3376.05
11/05/2023 2242.15 -0.0517245025 05/02/2024 3341.75
12/05/2023 2221.1 -0.0093883103 06/02/2024 3424.25
15/05/2023 2246.85 0.0115933546 07/02/2024 3394.7
16/05/2023 2227.2 -0.0087455771 08/02/2024 3335.5
17/05/2023 2219.6 -0.0034123563 09/02/2024 3324.55
18/05/2023 2188.2 -0.0141466931 12/02/2024 3299.55
19/05/2023 2190.05 0.0008454437 13/02/2024 3321.5
22/05/2023 2216.6 0.0121230109 14/02/2024 3309
23/05/2023 2197.65 -0.0085491293 15/02/2024 3300.3
24/05/2023 2185.15 -0.0056878939 16/02/2024 3386.75
25/05/2023 2204.7 0.0089467542 19/02/2024 3339.85
26/05/2023 2218.45 0.0062366762 20/02/2024 3356.75
29/05/2023 2224.55 0.0027496676 21/02/2024 3296.4
30/05/2023 2210.8 -0.0061810254 22/02/2024 3363.75
31/05/2023 2205.65 -0.0023294735 23/02/2024 3387.95
01/06/2023 2207.8 0.0009747693 26/02/2024 3470.15
02/06/2023 2234.55 0.0121161337 27/02/2024 3506.45
05/06/2023 2268.3 0.0151037122 28/02/2024 3470.2
06/06/2023 2277.95 0.0042542874 29/02/2024 3477.55
07/06/2023 2315.5 0.0164841195 01/03/2024 3633.5
08/06/2023 2340.3 0.0107104297 02/03/2024 3655.25
09/06/2023 2363 0.0096996112 04/03/2024 3644.45
12/06/2023 2339.95 -0.0097545493 05/03/2024 3612.6
13/06/2023 2354.4 0.0061753456 06/03/2024 3642.2
14/06/2023 2355.05 0.0002760788 07/03/2024 3676.95
15/06/2023 2361.3 0.0026538715 11/03/2024 3640.6
16/06/2023 2366.8 0.0023292254 12/03/2024 3621.65
19/06/2023 2366.35 -0.0001901301 13/03/2024 3538.55
20/06/2023 2382 0.006613561 14/03/2024 3608.2
21/06/2023 2394.45 0.0052267003 15/03/2024 3537.15
22/06/2023 2416.25 0.0091043872 18/03/2024 3561.2
23/06/2023 2389.55 -0.0110501811 19/03/2024 3501.7
26/06/2023 2377.55 -0.005021866 20/03/2024 3509.7
27/06/2023 2388.05 0.0044163109 21/03/2024 3560
28/06/2023 2421.45 0.0139863068 22/03/2024 3617.8
30/06/2023 2475.55 0.0223419852 26/03/2024 3670.1
03/07/2023 2454.05 -0.0086849387 27/03/2024 3706.4
04/07/2023 2461.85 0.0031784193 28/03/2024 3763.9
05/07/2023 2470.8 0.0036354774 01/04/2024 3838
06/07/2023 2488.6 0.0072041444 02/04/2024 3807.4
07/07/2023 2449.35 -0.01577192 03/04/2024 3782.45
10/07/2023 2438.75 -0.0043276788 04/04/2024 3797.85
11/07/2023 2474.55 0.0146796515 05/04/2024 3743.1
12/07/2023 2454.95 -0.007920632 08/04/2024 3807.85
13/07/2023 2450.15 -0.0019552333 09/04/2024 3785.25
14/07/2023 2472.25 0.0090198559 10/04/2024 3753.2
17/07/2023 2468.8 -0.0013954899 12/04/2024 3679.25
18/07/2023 2474.7 0.002389825 15/04/2024 3600.8
19/07/2023 2494.15 0.0078595385 16/04/2024 3543.45
20/07/2023 2489.7 -0.001784175 18/04/2024 3550.95
21/07/2023 2586.25 0.0387797727 19/04/2024 3518.35
24/07/2023 2605.25 0.0073465442 22/04/2024 3612.7
25/07/2023 2560.9 -0.0170233183 23/04/2024 3610.15
26/07/2023 2646.25 0.0333281268 24/04/2024 3634.85
27/07/2023 2660.2 0.0052716108 25/04/2024 3652.3
28/07/2023 2649.55 -0.0040034584 26/04/2024 3605.2
31/07/2023 2681.35 0.0120020381 29/04/2024 3634.3
01/08/2023 2666.65 -0.005482313 30/04/2024 3594.3
02/08/2023 2622.15 -0.0166876043 02/05/2024 3599.5
03/08/2023 2598.1 -0.0091718628 03/05/2024 3499.8
04/08/2023 2626.9 0.0110850237 06/05/2024 3463.3
07/08/2023 2635.9 0.0034260916 07/05/2024 3427.75
08/08/2023 2632.2 -0.0014036951 08/05/2024 3486.85
09/08/2023 2651.6 0.0073702606 09/05/2024 3275.45
10/08/2023 2643.5 -0.0030547594 10/05/2024 3271.45
11/08/2023 2638.5 -0.0018914318 13/05/2024 3293.85
14/08/2023 2659.9 0.0081106689 14/05/2024 3379.45
16/08/2023 2691.05 0.0117109666 15/05/2024 3411.3
17/08/2023 2652.5 -0.0143252634 16/05/2024 3460.6
18/08/2023 2641.95 -0.0039773798 17/05/2024 3450.75
21/08/2023 2662.25 0.0076837185 18/05/2024 3464.2
22/08/2023 2678.8 0.0062165462 21/05/2024 3440.95
23/08/2023 2717.6 0.0144840974 22/05/2024 3460.85
24/08/2023 2688.15 -0.0108367677 23/05/2024 3585.4
25/08/2023 2638.4 -0.0185071518 24/05/2024 3625.9
28/08/2023 2695.35 0.0215850515 27/05/2024 3652
29/08/2023 2718.95 0.0087558202 28/05/2024 3658.2
30/08/2023 2709 -0.0036595009 29/05/2024 3634.8
31/08/2023 2702.7 -0.0023255814 30/05/2024 3634.7
01/09/2023 2702.1 -0.0002220002 31/05/2024 3669.3
04/09/2023 2711.1 0.0033307428 03/06/2024 3897.15
05/09/2023 2732.95 0.0080594593 04/06/2024 3403.2
06/09/2023 2730.45 -0.0009147624 05/06/2024 3409
07/09/2023 2846.4 0.0424655277 06/06/2024 3482.55
08/09/2023 2901.6 0.0193929174 07/06/2024 3532.5
11/09/2023 2894.2 -0.0025503171 10/06/2024 3543.75
12/09/2023 2944.1 0.0172413793 11/06/2024 3598.7
13/09/2023 2906.75 -0.0126863897 12/06/2024 3630.3
14/09/2023 2918.6 0.004076718 13/06/2024 3703.65
15/09/2023 2908.55 -0.0034434318 14/06/2024 3687.8
18/09/2023 2919.85 0.0038850974 18/06/2024 3689.2
20/09/2023 2890 -0.0102231279 19/06/2024 3589.95
21/09/2023 2899.35 0.0032352941 20/06/2024 3594.45
22/09/2023 2918.5 0.0066049287 21/06/2024 3535
25/09/2023 2902.5 -0.0054822683 24/06/2024 3531.6
26/09/2023 2912.55 0.0034625323 25/06/2024 3587.8
27/09/2023 2965.05 0.0180254416 26/06/2024 3602.95
28/09/2023 3010 0.0151599467 27/06/2024 3564.4
29/09/2023 3023.55 0.0045016611 28/06/2024 3548.45
03/10/2023 3073.25 0.0164376313 01/07/2024 3526.55
04/10/2023 3027.75 -0.0148051737 02/07/2024 3626.5
05/10/2023 3096.05 0.0225580051 03/07/2024 3614.35
06/10/2023 3093.7 -0.0007590317 04/07/2024 3573.3
09/10/2023 3074.7 -0.0061415134 05/07/2024 3627.15
10/10/2023 3076 0.0004228055 08/07/2024 3632
11/10/2023 3088.7 0.0041287386 09/07/2024 3666.1
12/10/2023 3081.75 -0.0022501376 10/07/2024 3650.05
13/10/2023 3089.6 0.002547254 11/07/2024 3621.1
16/10/2023 3101.9 0.0039810979 12/07/2024 3649.35
17/10/2023 3066.3 -0.0114768368 15/07/2024 3651.6
18/10/2023 3045.6 -0.0067508072 16/07/2024 3636.55
19/10/2023 3054.4 0.0028894142 18/07/2024 3656.2
20/10/2023 3012.35 -0.0137670246 19/07/2024 3618.5
23/10/2023 2958.3 -0.0179428021 22/07/2024 3651.45
25/10/2023 2916.1 -0.0142649495 23/07/2024 3538.05
26/10/2023 2864.6 -0.0176605741 24/07/2024 3519.45
27/10/2023 2901.9 0.0130210152 25/07/2024 3619.15
30/10/2023 2926.35 0.0084255143 26/07/2024 3679.9
31/10/2023 2929.05 0.0009226511 29/07/2024 3774.95
01/11/2023 2895.3 -0.0115225073 30/07/2024 3784.65
02/11/2023 2918.1 0.0078748316 31/07/2024 3815
03/11/2023 2911.25 -0.0023474178 01/08/2024 3779.3
06/11/2023 2975.45 0.022052383 02/08/2024 3665.7
07/11/2023 2961.3 -0.0047555832 05/08/2024 3528
08/11/2023 2996.45 0.0118697869 06/08/2024 3576.2
09/11/2023 3024.85 0.0094778822 07/08/2024 3638.25
10/11/2023 3033.25 0.0027769972 08/08/2024 3553.55
12/11/2023 3052 0.0061814885 09/08/2024 3592.05
13/11/2023 3048.5 -0.001146789 12/08/2024 3571.95
15/11/2023 3064.95 0.0053960964 13/08/2024 3551.8
16/11/2023 3051.15 -0.0045025204 14/08/2024 3545.2
17/11/2023 3109 0.0189600642 16/08/2024 3568.35
20/11/2023 3088.8 -0.006497266 19/08/2024 3555.05
21/11/2023 3074.85 -0.004516317 20/08/2024 3572.7
22/11/2023 3082.3 0.0024228824 21/08/2024 3596.05
23/11/2023 3045.65 -0.0118904714 22/08/2024 3606.5
24/11/2023 3054.25 0.0028236994 23/08/2024 3598.55
28/11/2023 3050 -0.0013915036 26/08/2024 3641.9
29/11/2023 3083.75 0.0110655738 27/08/2024 3702.7
30/11/2023 3109.2 0.0082529388 28/08/2024 3689.05
01/12/2023 3190.65 0.0261964492 29/08/2024 3683.45
04/12/2023 3313.55 0.0385187971 30/08/2024 3704.65
05/12/2023 3315.45 0.0005734031 02/09/2024 3683.1
06/12/2023 3392.3 0.0231793573 03/09/2024 3690.15
07/12/2023 3355.6 -0.0108186186 04/09/2024 3650.8
08/12/2023 3378.45 0.0068095125 05/09/2024 3624.15
11/12/2023 3385.8 0.0021755539 06/09/2024 3574.75
12/12/2023 3342.4 -0.0128182409 09/09/2024 3578.3
13/12/2023 3399.8 0.0171732887 10/09/2024 3596.15
14/12/2023 3433.1 0.0097946938 11/09/2024 3536.95
15/12/2023 3488 0.0159913781 12/09/2024 3622
18/12/2023 3491.6 0.0010321101 13/09/2024 3613
19/12/2023 3498.95 0.0021050521 16/09/2024 3662.25
20/12/2023 3418.5 -0.0229926121 17/09/2024 3695.2
21/12/2023 3424.15 0.0016527717 18/09/2024 3730.45
22/12/2023 3477.95 0.0157119285 19/09/2024 3683.7
26/12/2023 3490.05 0.0034790609 20/09/2024 3793.9
27/12/2023 3544 0.0154582313 23/09/2024 3787.7
28/12/2023 3518.05 -0.0073222348 24/09/2024 3791.6
29/12/2023 3526 0.0022597746 25/09/2024 3793.85
26/09/2024 3762.15
27/09/2024 3705.65
30/09/2024 3675.55
01/10/2024 3653.5
03/10/2024 3497.65
04/10/2024 3493.95
07/10/2024 3468.35
08/10/2024 3532.4
09/10/2024 3487.1
10/10/2024 3460.35
11/10/2024 3482.55
14/10/2024 3555.05
15/10/2024 3551.9
16/10/2024 3532.6
17/10/2024 3570.3
18/10/2024 3577.8
21/10/2024 3585.6
22/10/2024 3511.9
23/10/2024 3455.4
24/10/2024 3442.65
25/10/2024 3326.4
28/10/2024 3340.8
29/10/2024 3380.9
30/10/2024 3408.35
31/10/2024 3622.3
01/11/2024 3626.35
04/11/2024 3574.45
05/11/2024 3574.8
06/11/2024 3645.45
07/11/2024 3646.55
08/11/2024 3660.3
11/11/2024 3628.85
12/11/2024 3591.35
13/11/2024 3547.95
14/11/2024 3526.25
18/11/2024 3542.15
19/11/2024 3505.9
21/11/2024 3483.5
22/11/2024 3603.5
25/11/2024 3753
26/11/2024 3702.6
27/11/2024 3698.7
28/11/2024 3666.05
29/11/2024 3724.8
02/12/2024 3704.05
03/12/2024 3787.05
04/12/2024 3789.9
05/12/2024 3831.55
06/12/2024 3866.7
09/12/2024 3947.3
10/12/2024 3923.15
11/12/2024 3916.75
12/12/2024 3859.9
13/12/2024 3887
16/12/2024 3877.85
17/12/2024 3807.2
18/12/2024 3758.15
19/12/2024 3716.35
20/12/2024 3629.85
23/12/2024 3640.5
24/12/2024 3639.75
26/12/2024 3629.5
27/12/2024 3608.1
30/12/2024 3578.95
31/12/2024 3607.65
Mean 0.001088
Standard Error 0.000707
Mean 0.002524 Median 0.000984
Standard Error 0.000887 Mode 0.062772
Median 0.002702 Standard Deviation 0.015707
Mode 0.042466 Sample Variance 0.000247
Standard Deviation 0.01197 Kurtosis 9.98684
Sample Variance 0.000143 Skewness -0.924967
Kurtosis 2.594692 Range 0.189519
Skewness -0.009195 Minimum -0.126746
Range 0.09419 Maximum 0.062772
Minimum -0.051725 Sum 0.537423
Maximum 0.042466 Count 494
Sum 0.459281 Largest(1) 0.062772
Count 182 Smallest(1) -0.126746
Largest(1) 0.042466 Confidence Level(95%) 0.001388
Smallest(1) -0.051725
Confidence Level(95%) 0.001751
for year 2023-24
Hypothesis tetsing for the year 2023-24
Sample Space 184
Sample Mean 0.0025235209
Standard Deviation 0.0119696261
Hypothesized Value 0
Standard Error 0.0008824125
Test Statistics z 2.8597971268
p-value (Lower Tail) 0.9978804395
p-value (Upper Tail) 0.0021195605
p-value (Two Tail) 0.004239121
Mean 0.0027303097
Standard Error 0.0009062929
Median 0.0027496676
Mode 0.0424655277
Standard Deviation 0.0122601026
Sample Variance 0.0001503101
Kurtosis 2.556117976
Skewness 0.1036888072
Range 0.0941900302
Minimum -0.0517245025
Maximum 0.0424655277
Sum 0.4996466688
Count 183
Largest(1) 0.0424655277
Smallest(1) -0.0517245025
Confidence Level(95%) 0.001788192
For year 2024-25 COMBINED FOR THE YEAR 2023 & 2024
hypothesis testing for the year 2024-25
Sample Space 249 Sample Space
Sample Mean 0.0025235209 Sample Mean
Standard Deviation 0.0119696261 Standard Deviation
Hypothesized Value 0 Hypothesized Value
Standard Error 0.0007585442 Standard Error
Test Statistics z 3.3267945974 Test Statistics z
p-value (Lower Tail) 0.9995607445 p-value (Lower Tail)
p-value (Upper Tail) 0.0004392555 p-value (Upper Tail)
p-value (Two Tail) 0.000878511 p-value (Two Tail)
495
0.00108790077
0.015706560548
0
0.000705957397
1.541028925755
0.938345126902
0.061654873098
0.123309746196
0.123309746196
0.001091257099
0.00070525049
0.000993076439
#N/A
0.015690832856
0.000246202236
10.01314489358
-0.926507756945
0.189518777755
-0.126746468573
0.062772309182
0.540172264076
495
0.001385660464
This chart isn't available in y
SCATTER PLOT
0.06 Editing this shape or saving
break the chart.
0.04
0.02
0
0 20 40 60 80 100 120 140 160 180 200
-0.02
-0.04
-0.06
0.05
0
0 50 100 150 200 250 300
-0.05
-0.1
-0.15
0.05
0
0 100 200 300 400 500 600
-0.05
-0.1
0.05
0
0 100 200 300 400 500 600
-0.05
-0.1
-0.15
This chart isn't available in your version of Excel. This chart isn't available in
Editing this shape or saving this workbook into a different file format will permanently Editing this shape or saving
break the chart. permanently break the chart
This chart isn't available in your version of Excel. This chart isn't available in
Editing this shape or saving this workbook into a different file format will Editing this shape or saving
permanently break the chart. permanently break the chart
This chart isn't available in your version of Excel. This chart isn't available in
Editing this shape or saving this workbook into a different file format will Editing this shape or saving
permanently break the chart. permanently break the chart
COMBINED FOR THE YEAR 2023-24
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will
permanently break the chart.
Editing this shape or saving this workbook into a different file format will
permanently break the chart.
Editing this shape or saving this workbook into a different file format will
permanently break the chart.
FOR COMBINED DATA FOR 2023-24
Return
Sample Data
Mean 0.0010912571 Sample Size 495
Standard Error 0.0007052505 Mean 0.0010912571
Median 0.0009930764
Mode #N/A Population Data
Standard Deviation 0.0156908329 Std. Dev 0.0156908329
Sample Variance 0.0002462022
Kurtosis 10.013144894
Skewness -0.9265077569
Range 0.1895187778 Sample Data
Minimum -0.1267464686 Sample Size 495
Maximum 0.0627723092 Mean 0.0010912571
Sum 0.5401722641
Count 495 Population Data
Confidence Level(95.0%) 0.0013856605 Std. Dev 0.0156908329
Sample Data
Sample Size 495
Mean 0.0010912571
Population Data
Std. Dev 0.0156908329
FOR 2023-24
Mean 0.0027303097 Sample Data
Standard Error 0.0009062929 Sample Size 184
Median 0.0027496676 Mean 0.0027303097
Mode 0.0424655277
Standard Deviation 0.0122601026 Population Data
Sample Variance 0.0001503101 Std. Dev 0.0122601026
Kurtosis 2.556117976
Skewness 0.1036888072
Range 0.0941900302
Minimum -0.0517245025 Sample Data
Maximum 0.0424655277 Sample Size 184
Sum 0.4996466688 Mean 0.0027303097
Count 183
Largest(1) 0.0424655277 Population Data
Smallest(1) -0.0517245025 Std. Dev 0.0122601026
Confidence Level(95%) 0.001788192
Sample Data
Sample Size 184
Mean 0.0027303097
Population Data
Std. Dev 0.0122601026
FOR2024-25
Mean 0.0025235209
Standard Error 0.0008872477 Sample Data
Median 0.0027017695 Sample Size 249
Mode 0.0424655277 Mean 0.0025235209
Standard Deviation 0.0119696261
Sample Variance 0.0001432719 Population Data
Kurtosis 2.594692417 Std. Dev 0.0119696261
Skewness -0.0091953373
Range 0.0941900302
Minimum -0.0517245025
Maximum 0.0424655277 Sample Data
Sum 0.4592807955 Sample Size 249
Count 182 Mean 0.0025235209
Largest(1) 0.0424655277
Smallest(1) -0.0517245025 Population Data
Confidence Level(95%) 0.001750679 Std. Dev 0.0119696261
Sample Data
Sample Size 249
Mean 0.0025235209
Population Data
Std. Dev 0.0119696261
95%
Margin of Error Confidence Interval
Confidence Level 95% Lower Limit -0.0002910085
Alpha 5% Upper Limit 0.0024735227
Alpha/2 0.025
Critical Value(z) 1.9599639845
Standard Error 0.0007052505
Margin of Error 0.0013822656
90%
Margin of Error Confidence Interval
Confidence Level 90% Lower Limit -6.877673E-05
Alpha 10% Upper Limit 0.0022512909
Alpha/2 0.05
Critical Value(z) 1.644853627
Standard Error 0.0007052505
Margin of Error 0.0011600338
99%
Margin of Error Confidence Interval
Confidence Level 99% Lower Limit -0.0007253478
Alpha 1% Upper Limit 0.002907862
Alpha/2 0.005
Critical Value(z) 2.5758293035
Standard Error 0.0007052505
Margin of Error 0.0018166049
95%
Margin of Error Confidence Interval
Confidence Level 95% Lower Limit 0.0009588418
Alpha 5% Upper Limit 0.0045017776
Alpha/2 0.025
Critical Value(z) 1.9599639845
Standard Error 0.0009038268
Margin of Error 0.0017714679
90%
Margin of Error Confidence Interval
Confidence Level 90% Lower Limit 0.001243647
Alpha 10% Upper Limit 0.0042169724
Alpha/2 0.05
Critical Value(z) 1.644853627
Standard Error 0.0009038268
Margin of Error 0.0014866627
99%
Margin of Error Confidence Interval
Confidence Level 99% Lower Limit 0.0004022062
Alpha 1% Upper Limit 0.0050584131
Alpha/2 0.005
Critical Value(z) 2.5758293035
Standard Error 0.0009038268
Margin of Error 0.0023281034
95%
Margin of Error Confidence Interval
Confidence Level 95% Lower Limit 0.0010368015
Alpha 5% Upper Limit 0.0040102402
Alpha/2 0.025
Critical Value(z) 1.9599639845
Standard Error 0.0007585442
Margin of Error 0.0014867194
90%
Margin of Error Confidence Interval
Confidence Level 90% Lower Limit 0.0012758266
Alpha 10% Upper Limit 0.0037712151
Alpha/2 0.05
Critical Value(z) 1.644853627
Standard Error 0.0007585442
Margin of Error 0.0012476942
99%
Margin of Error Confidence Interval
Confidence Level 99% Lower Limit 0.0005696404
Alpha 1% Upper Limit 0.0044774013
Alpha/2 0.005
Critical Value(z) 2.5758293035
Standard Error 0.0007585442
Margin of Error 0.0019538805