Making sample means ,propotions,slopes on excell
Summary 1000 sample proportions sample size 4
|
Paste this summary into stage 3 of tbe assignment as well as the graphs
|
|
|
|
|
student number
|
453533
|
|
|
|
sample size
|
4
|
|
|
|
|
|
|
|
|
Answer?
|
|
|
|
Thing 1
|
yes
|
|
|
|
Thing 2
|
yes
|
|
|
|
Thing 3
|
yes
|
|
|
|
Thing 4
|
no
|
|
|
|
.....
|
....
|
......
|
|
|
Thing 1000
|
yes
|
|
|
|
Population proportion that says yes
|
0.582
|
|
|
|
|
|
|
|
|
0
|
Estimate percentile
|
|
|
|
sample proportion
|
P(ESTIMATES
|
|
|
sample 1
|
0.75
|
P(ESTIMATES<0.75)=546/1000=
|
0.546
|
|
sample 2
|
0.5
|
P(ESTIMATES<0.5)=188/1000=
|
0.188
|
|
sample 3
|
0.5
|
P(ESTIMATES<0.5)=188/1000=
|
0.188
|
|
sample 4
|
0.75
|
P(ESTIMATES<0.75)=546/1000=
|
0.546
|
|
sample 5
|
0.25
|
P(ESTIMATES<0.25)=23/1000=
|
0.023
|
|
sample 6
|
0.5
|
P(ESTIMATES<0.5)=188/1000=
|
0.188
|
|
,,,,
|
....
|
....
|
...
|
|
|
|
|
|
|
Mean of 1000 estimates
|
0.5898
|
|
|
|
Stdev of 1000 estimates
|
0.2412
|
|
|
Percentile plot of 1000 sample proportions with n=4
Summary 1000 sample proportions same population proportion as before but with n=100
Percentile plot of 1000 sample proportions with n=100
Summary of 1000 sample slopes from 1000 regressions with sample size n=5
Percentile plot of 1000 sample slopes with n=5
Summary of 1000 slopes, each slope is from a linear regression with sample size n=100
Percentile plot of 1000 sample slopes
Summary of 1000 differences between sample means n1=4, n2=4
Percentile plot of 1000 differences between means , the difference of the average of 100 students doing stats and the average of 100 students doing macroeconomics
Percentile plot of 1000 differences between means , the difference of the average of 4 students doing stats and the average of 4 students doing macroeconomics