Table of Video Tutorials:Some of these are EXE's that include the viewer. In that case, you may have to save to the hard drive and run using windows explorer or Start/ Run |
These are large files (3-20 MB). Although they will download rapidly in the school system, downloading by modem at home would be impractical. You can borrow earphones to listen while playing them in SSB103 lab. Double click on the speaker down in the taskbar to remove muting and increase volume. plug the earphone into the green connector on the back of the computer. It uses a mini-stereo plug. Some machines on campus have zipdisks which would allow you to download and copy for home use if you have a zipdrive at home. Sometime in the future, when I am more set on these, they will be available on CDROM. You have permission to copy, use and distribute these for personal and nonprofit educational use. |
video on importing text data and parsing. | import.av i |
Sampling from airplane empty seats data: | sample.av i |
Paste special transpose to transpose data from rows to columns. | transp ose.avi |
sorting rows | sortht.av i |
adding in addins/tools | addins.av i |
descriptive statistics procedure | dscstat s.avi |
histograms | histgra m.avi |
2-sample F test for unequal variances | ftestva r.avi |
t-test 2 sample treating variances as equal | ttst2sm p.avi |
1-sample ttest | 1samplt. avi |
conversion of survey text to logical values | |
paired values ttest | pairedt. avi |
1-factor ANOVA - with audio | anova1V. avi |
2-factor ANOVA with replication- with audio | anova2v. avi |
Copying text out of a pdf | pdftxt.av i |
pasting text into EXCEL | pastech i.avi |
Modifying (expand/contract) the Chi2 sheet | expchi.av i |
pasting in new data for the Chi2 | pastene w.avi |
chart with trendline | trendli ne.avi |
simple linear regression | simpreg r.avi |
multiple regression | yr1mreg r.avi |
Use of Access to predigest data for EXCEL analysis |
|
parsing YRBSS data into Access and Excel (ACCESS with yrbs1999 example) import wizard in EXCEL is very similar | imptaccs.avi and import2.avi |
Crosstab Query in ACCESS (yrbs1999 example) | crosstab.exe |
Using EXCEL Pivot Tables for Crosstabulation |
|
Yrbs Download | dlyrb1.avi |
import and parse YRBss 2001 into EXCEL | importxl.avi |
add labels to tops of columns for field names | lblontop.avi |
Use Pivot table to select crosstab variables | pivottbl.avi |
Calculate the percent of males and females who smoke | pcsmoke.avi |
What would you expect if there were no relationship (Ho true) | expect.avi |
Chi2 value =Does the Observation agree with your expectation? | chi2calc.avi |
Other Crosstabs modify Pivot tables to use a different field- | modfield.avi |
Other Crosstabs -adjust tables for new dimensions-- the "auto Chi-square" | newchi.avi |
Other summary measures- smoking, gender and average weight | smkavgwt.avi |
E-mail: ba3300 (at) bud banis,com
Campus office CCB 230
On-campus phone 314-516-6136
Off-campus 636-394-4950
Return
to Bud's Page
An imprint of Science & Humanities Press
PO Box 7151 Chesterfield MO 63006-7151 USA 636-394-4950
A Banis & Associates Company