[go: up one dir, main page]

0% found this document useful (0 votes)
23 views22 pages

DLSU DSILYTC: Data Dec2

The document presents statistical analyses for three different datasets, including hypothesis tests and regression analyses. AIRICK's analysis shows a significant difference between two population means, leading to the rejection of the null hypothesis, while PABLO and RAMMUEL do not reject their null hypotheses. Additionally, regression outputs indicate strong relationships between midterm and final scores, with significant coefficients and a high R-squared value.
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
0% found this document useful (0 votes)
23 views22 pages

DLSU DSILYTC: Data Dec2

The document presents statistical analyses for three different datasets, including hypothesis tests and regression analyses. AIRICK's analysis shows a significant difference between two population means, leading to the rejection of the null hypothesis, while PABLO and RAMMUEL do not reject their null hypotheses. Additionally, regression outputs indicate strong relationships between midterm and final scores, with significant coefficients and a high R-squared value.
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/ 22

AIRICK

Data
Hypothesized Difference 0
Level of Significance 0.05
Population 1 Sample
Sample Size 100
Sample Mean 99
Population Standard Deviation 2.24
Population 2 Sample
Sample Size 100
Sample Mean 102
Population Standard Deviation 2.83

Intermediate Calculations
Difference in Sample Means -3
Standard Error of the Difference in Means 0.3609
Z Test Statistic -8.3120

Two-Tail Test
Lower Critical Value -1.9600
Upper Critical Value 1.9600
p-Value 0.0000 1.23E-08
Reject the null hypothesis
PABLO

Data
Null Hypothesis m= 250
Level of Significance 0.05
Sample Size 10
Sample Mean 249
Sample Standard Deviation 2.49

Intermediate Calculations
Standard Error of the Mean 0.7874
Degrees of Freedom 9
t Test Statistic -1.2700

Lower-Tail Test Calculations Area


Lower Critical Value -1.8331 For one-tailed tests:
p-Value 0.1180 T.DIST.RT value 0.1179691245
Do not reject the null hypothesis 1-T.DIST.RT value 0.8820308755
RAMMUEL

Data
Null Hypothesis m= 250
Level of Significance 0.05
Sample Size 10
Sample Mean 249
Sample Standard Deviation 2.49

Intermediate Calculations
Standard Error of the Mean 0.7874
Degrees of Freedom 9
t Test Statistic -1.2700

Two-Tail Test
Lower Critical Value -2.2622
Upper Critical Value 2.2622
p-Value 0.2359
Do not reject the null hypothesis
x x-mean (x-mean)2
6 x
7
7 Mean
7 Standard Error
8 Median
8 Mode
8 Standard Deviation
9 Sample Variance
9 Kurtosis
10 Skewness
Range
Mean Minimum
Median Maximum
Mode Sum
Minimum Count
Maximum
Range
Variance
S. Deviation
x

7.9
0.37859388972
8
7
1.19721899974
1.43333333333
-0.3685389786
0.233098345
4
6
10
79
10
Midterm (x) Final (y) x2 y2 xy
75 80
70 75
65 65
90 95
85 90
85 85
80 90
70 75
65 70
90 90
∑x ∑y ∑x2 ∑y2 ∑xy

Decision Rule:
Before:
Comp > Tab-----> Reject Ho formulate Regression Model
NOW y = bx + a
Pvalue < alpha --> Reject Ho y = 0.97x + 6.25

Ho There is NR
Ha Theres is R
Midterm (x) Final (y)
Midterm (x) 1
Final (y) 0.949 1
pearson r
r square 0.901

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.949

R Square 0.901
Adjusted R Squar 0.888714922317235
Standard Erro3.3405718507248
Observations 10

ANOVA
df SS MS
Regression 1 813.224638 813.224638
Residual 8 89.2753623 11.1594203
Total 9 902.5

Coefficients Standard Error t Stat


a Intercept 6.25 8.87848845 0.70354057
b Midterm (x) 0.97 0.113747344176 8.53659045658

Pvalue
RESIDUAL OUTPUT alpha

Observation Predicted Final (y) Residuals Standard Residuals


1 79.072463768116 0.92753623 0.2945007
2 74.217391304348 0.7826087 0.24848496
3 69.36231884058 -4.36231884 -1.38507359
4 93.63768115942 1.36231884 0.4325479
5 88.782608695652 1.2173913 0.38653217
6 88.782608695652 -3.7826087 -1.20101066
7 83.927536231884 6.07246377 1.92805925
8 74.217391304348 0.7826087 0.24848496
9 69.36231884058 0.63768116 0.20246923
10 93.6376811594203 -3.63768115942 -1.15499492178
Midterm (x) Residual Plot
8
6 Midterm (x) Line Fit
4
100

Residuals
2 90
80 Normal Prob
0 70
10075
-2 60 65 60 70 80 85 9

Final (y)
50 90
-4 40 80
30 70
-6 60
20

Final (y)
10 50
Midterm (x)
0 40
F Significance F 60 65 30
70 75 80 85 90 95
20
72.8733766 2.7E-05 Midterm (x)
10
0
0 10 20 30 40
Sample

P-value Lower 95% Upper 95%Lower 95.0%


Upper 95.0%
0.501678264525 -14.227 26.72 -14.227 26.72
2.72864707E-05 0.70871265 1.2333163 0.7087126 1.2333163

scientific notaton
0.00002728
0.05 PROBABILITY OUTPUT

rd Residuals Percentile Final (y)


5 65
15 70
25 75
35 75
45 80
55 85
65 90
75 90
85 90
95 95
x) Residual Plot

dterm (x) Line Fit Plot

Normal Probability Plot


10075 80 85 90 95
90 Final (y)
80 Predicted Final (y)
70
60
50
Midterm (x)
40
5 30
70 75 80 85 90 95
20
Midterm (x)
10
0
0 10 20 30 40 50 60 70 80 90 100
Sample Percentile
A B C D A2 B2
7 9 2 4
3 8 3 5
5 8 4 7
6 7 5 8
9 6 6 3
4 9 4 4
3 10 2 5

Decision Rule
Before Comp > Tab ---> Reject Ho Reject Ho
NOW Pvalue < Alpha ---> Reject Ho Reject Ho

CF
TSS
BSS
WSS
C2 D2
Ho they are all equal
Ha they are all NOT equal

Anova: Single Factor

SUMMARY
Groups Count Sum Average
A 7 37 5.2857
B 7 57 8.1429
Reject Ho C 7 26 3.7143
Reject Ho D 7 36 5.1428571

ANOVA
Source of Variation SS df MS
Between Groups 72.29 3 24.10

Within Groups 72.57 24 3.02

Total 144.86 27
Variance
4.9048
1.8095
2.2381
3.1428571
alpha
0.05

Fcomp P-value F tab


7.97 0.00073814636 3.01
SR1 SR2 SR3 Problem1
Method I 40 50 40 Problem2
Method I 41 50 41 Problem3
Method I 40 48 40
Method I 39 48 38
Method I 38 45 38
Method II 40 45 50
Method II 41 42 46
Method II 39 42 43
Method II 38 41 43
Method II 38 40 42
Method III 40 40 40
Method III 43 45 41
Method III 41 44 41
Method III 39 44 39
Method III 38 43 38

Decision Rule:
comp > tab ----> Reject Ho
pvalue < alpha --->Reject Ho

#2 Method
#1 SR
#3 Inter
SR
Methods
intersection bet SR and Methods

Anova: Two-Factor With Replication

SUMMARY SR1 SR2 SR3 Total


Method I
Count 5 5 5 15
Sum 198 241 197 636
Average 39.6 48.2 39.4 42.4
Variance 1.3 4.2 1.8 20.11429

Method II
Count 5 5 5 15
Sum 196 210 224 630
Average 39.2 42 44.8 42
Variance 1.7 3.5 10.7 10.14286

Method III

Count 5 5 5 15
Sum 201 216 199 616
Average 40.2 43.2 39.8 41.06667
Variance 3.7 3.7 1.7 5.066667

Total
Count 15 15 15
Sum 595 667 620
Average 39.66667 44.46667 41.33333
Variance 2.095238 10.98095 10.52381
alpha
0.05
ANOVA
Source of Variation SS df MS Fcomp P-value Ftab
Sample 14.04 2 7.022222 1.96 0.156072028 3.26
Columns 178.18 2 89.08889 24.82 1.677339E-07 3.26
Interaction 187.16 4 46.78889 13.04 1.163717E-06 2.63
Within 129.20 36 3.588889

Total 508.58 44

45-1
0.000000167
0.00000116

Accept Ho NSD Accept Ho


Reject Ho SD Reject Ho
Reject Ho SD or Effect Reject Ho
Weight of 10 cans of powdered milk
253 Ho m = 250
248 Weight of 10 cans of powdered milk Ha m < 250
252
245 Mean 249
247 Standard Error 0.788810638
249 Median 248.5
251 Mode 248
250 Standard Deviation 2.4944382578
247 Sample Variance 6.222222222
248 Kurtosis -0.708864796
Skewness 0.1610726235
Range 8
Minimum 245
Maximum 253
Sum 2490
Count 10
Size Mean Variance Standard Deviation
Provincial: 100 99 5 2.24
City: 100 102 8 2.83

Ho m1 = m2
Ha m1 NOT= m2
Income (y) Age (x1) Acad (x2) x12 x22 x1y x2y x1x2
81.7 38 1.5
73.3 30 2
89.5 46 1.75
79 40 1.75
69.9 32 2.5

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.96327709
R Square 0.92790276
Adjusted R Squa 0.85580551
Standard Error 2.89397724
Observations 5

ANOVA
df SS MS F Significance F
Regression 2 215.5777915 107.7889 12.87016 0.072097
Residual 2 16.75020851 8.375104
Total 4 232.328

Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%


Upper 95.0%
Intercept 56.3687239 17.67663245 3.188884 0.085862 -19.68769 132.4251 -19.68769 132.4251
Age (x1) 0.89970809 0.283422575 3.17444 0.086547 -0.319761 2.119177 -0.319761 2.119177
Acad (x2) -5.8725605 4.798208557 -1.223907 0.345602 -26.51759 14.77246 -26.51759 14.77246

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation
Predicted Income (y)
Residuals
Standard Residuals Percentile Income (y)
1 81.7487907 -0.04879066 -0.023843 10 69.9
2 71.6148457 1.685154295 0.823492 30 73.3
3 87.4783153 2.021684737 0.987946 50 79
4 82.0800667 -3.08006672 -1.505151 70 81.7
5 70.4779817 -0.57798165 -0.282445 90 89.5
Age (x1) Residual Plot
2 Acad (x2) Residual Plot
Residuals

0 4
-2
28 30
2
32 34 36 Age40(x1)42Line44Fit 46Plot48
38
Residuals

100
-4 0
80 Acad (x2) Line Fit Plot
-2 1.4 1.6 1.8 2 2.2 2.4 2.6
Income (y)

60 Age (x1) Income (y)


100
-4 40
20 80
Income (y)
Normal Probability Plot
Predicted Income (y)
0 Acad (x2) 60 Income (y)
40 100
28 30 32 34 36 38 40 42 4480 46 48 Predicted Income (y)
20
Age (x1) 0 Income (y)
60
1.4 1.6 40
1.8 2 2.2 2.4 2.6
20
Upper 95.0% Acad
0 (x2)
0 10 20 30 40 50 60 70 80 90
Sample Percentile
Fit Plot
me (y)
Probability Plot
icted Income (y)
Income (y)
Predicted Income (y)

2.6

30 40 50 60 70 80 90 100
Sample Percentile

You might also like