[go: up one dir, main page]
Scribd
Upload
16 views8 pages

Excel Class

The document presents statistical analysis comparing two classes, A and B, including F-tests for variances and correlation tests. It provides regression statistics, ANOVA results, and probability outputs related to family expenditure and income. Key findings include a high correlation between variables and significant regression results indicating predictive relationships.

Uploaded by

medini bhat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
16 views8 pages

Excel Class

The document presents statistical analysis comparing two classes, A and B, including F-tests for variances and correlation tests. It provides regression statistics, ANOVA results, and probability outputs related to family expenditure and income. Key findings include a high correlation between variables and significant regression results indicating predictive relationships.

Uploaded by

medini bhat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

Class A Class B

44 63
89 79
72 79
73 82 F-Test Two-Sample for Variances
55 66
24 84
77 88 Mean
87 39 Variance
47 64 Observations
74 79 df
67 31 F
68 70 P(F<=f) one-tail
57 48 F Critical one-tail
50 81
74 40
76 39 F test is for sample variance
66 23 if p value is less than 0.05 the we can reject null hy
if critical value is greater than the test we are doin
Variable 1 Variable 2 H0: VarA=VarB
62.06 64.71 H1: VarA>VarB One tailed test as only one side is being talked about
443.31 277.97 H1: VarA<VarB One tailed test.
17.00 17.00 H1: VarA~= VarB Two tailed test
16.00 16.00
1.59
0.18
2.33

05 the we can reject null hypothesis.


r than the test we are doing then we can reject null hypothesis.
is being talked about
Correlation: relationship between variables
to test the correlation: spearman correlation test

FIND THE RANK :


Class A Class B Rank A Rank B D^2
44 63 16 11 25 N 17
89 79 1 5 16 Sum of D^2 817
72 79 8 5 9 R= -0.001225
73 82 7 3 16
55 66 13 9 16
24 84 17 2 225
77 88 3 1 4
87 39 2 14 144
47 64 15 10 25
74 79 5 5 0
67 31 10 16 36
68 70 9 8 1
57 48 12 12 0
50 81 14 4 100
74 40 5 13 64
76 39 4 14 100
66 23 11 17 36
Sum 817
Weekly family expenditure Income Rank E Rank I
70 80 9 10
65 100 10 9
90 120 8 8
95 140 7 7
110 160 6 6
115 180 5 5
120 200 4 4
140 220 3 3
155 240 1 2
150 260 2 1

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.980847369
R Square 0.96206156
Adjusted R Square 0.957319256
Standard Error 6.493003227
Observations 10

ANOVA
df SS MS F Significance F
Regression 1 8552.72727273 8552.727273 202.8679245 5.752746E-07
Residual 8 337.272727273 42.15909091
Total 9 8890

Coefficients Standard Error t Stat P-value Lower 95%


Intercept 24.45454545 6.41381729874 3.812791091 0.005142172 9.6642562412
X Variable 1 0.509090909 0.0357428064 14.24317115 5.752746E-07 0.4266678497

PROBABILITY OUTPUT

Percentile Y
5 65
15 70
25 90
35 95
45 110
55 115
65 120
75 140
85 150
95 155
Normal Probability Plot
200
150
100
Y

50
0
0 10 20 30 40 50 60 70 80 90 100
Sample Percentile

Upper 95% Lower 95.0% Upper 95.0%


39.24483467 9.6642562412 39.244834668
0.591513968 0.4266678497 0.5915139685
ot

80 90 100

You might also like