Scribd
Upload
82 views7 pages

Excel Work

The document presents results from a one-sample t-test analysis. It includes the mean, standard deviation, sample size, t-value and p-value for a variable called USG, based on a sample of 500 observations. A second table shows t-values and p-values for Drafted and Undrafted groups based on different sample sizes and standard deviations. Graphs and outputs from regression and residual analyses are also presented but not described in detail.

Uploaded by

arambooo
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
82 views7 pages

Excel Work

The document presents results from a one-sample t-test analysis. It includes the mean, standard deviation, sample size, t-value and p-value for a variable called USG, based on a sample of 500 observations. A second table shows t-values and p-values for Drafted and Undrafted groups based on different sample sizes and standard deviations. Graphs and outputs from regression and residual analyses are also presented but not described in detail.

Uploaded by

arambooo
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

One-sample t-test are as follows:

Variable USG
Mean=AVERAGE(A2:A501) 17.74
Standard Deviationσ = √[ Σ(xi - μ)2 / N ] 6.34
Sample size 500
T value =[Link](A2:A501,0.1764,0.0634,2) -12.34
P value=[Link](A2:A501,0.1764,0.0634,2) <0.001

Variable Value
Mean 17.74
Standard Deviation (σ) 6.34
Sample size 500
T value -12.34
P value <0.001
P and t values

T P
value=T. value=T.
Group=T TEST(Dr TEST(Dr
.TEST(f7 afted afted
,8, column, column,
Undrafte Sample Undrafte Undrafte
d Standard d d
column, Deviation column, column,
F9,10) Sample Size (n) (s) 2, 2) 2, 2)
Drafted=
AVERA
GE(Draft 100 4.5 0.016
ed
Err:508 column) 2.4
Mean Drafted 96 6.3
Undrafte
d=AVER
AGE(Dr 120 3.7
afted
column)
Undrafte
109 4.2
d

Sample
Standard
Sample Sample Deviatio
Variable Size (n) Mean (x) n (s)
Drafted 100 4.5 5.8
Drafted 96 7.8
Undrafted 120 4.1 4.94
Undrafted 109 5.6
T value P value
2.4 0.016
Conferenc
PTS GP RB AST e
10 20 5 2 1
15 15 7 3 1
20 25 8 4 1
12 18 6 2 1
18 22 7 3 1
14 19 6 4 1
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9990949785
R Square 0.9981907761
Adjusted R Square -0.0072368954
Standard Error 1.5271180545
Observations 5

ANOVA
df SS MS F Significance F
Regression 4 1286.667910448 321.66697761194 137.9308 #NUM!
Residual 1 2.332089552239 2.33208955223881
Total 5 1289

Coefficients Standard Error t Stat P-value Lower 95%


Intercept 0 #N/A #N/A #N/A #N/A
20 0.2686567164 0.263845813876 1.01823376490863 0.4942486051 -3.0838222135
5 2.5205223881 1.171628422302 2.151298432234 0.2770075581 -12.36642822
2 0.5391791045 1.062573297565 0.507427681189907 0.7010611278 -12.962094762
1 -8.3843283582 6.251392137226 -1.34119379718339 0.40787082 -87.81579674

RESIDUAL OUTPUT

Observation Predicted 10 Residuals Standard Residuals


1 14.906716418 0.09328358209 0.136589591177027
2 20.652985075 -0.65298507463 -0.956127138239275
3 12.652985075 -0.65298507463 -0.95612713823927
4 16.787313433 1.212686567164 1.77566468530149
5 14 -3.55271368E-15 -5.202026960013E-15
Upper 95% Lower 95.0% Upper 95.0%
#N/A #N/A #N/A
3.6211356463 -3.0838222135 3.6211356463
17.407472997 -12.36642822 17.407472997
14.040452971 -12.962094762 14.040452971
71.047140024 -87.81579674 71.047140024

You might also like