This material is was created by Dr. Bud Banis, http://www.umsl.edu/~rbanis-Logistics and Operations Management, University of Missouri St Louis.
 

Our Tutors 
Available 24/7 

Accounting  
Career Services
Corporate Law
Economics  
Education    
Employment Issues
Desktop Publishing  
e-commerce  
Graduate Education
 
History      
Industrial Products

International Business
History   
Journalism
Investment
Management  
Marketing
 
Mathematics
 
Nursing
Physics  
Programming
 
Psychology
Secretarial-Services
Social Science

Statistics  
Writing Services

Free Book Summaries- 3 New York Times Bestsellers

 

 

 

 

 

 

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  window explorer or Start/ Run

These are FLASH format video files, small enough to download from home (if over the phone, eventually!).  You can borrow earphones to listen while playing them in School labs. 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.
For your convenience, these are widely available from students who have copied the course CD's.
 You have permission to copy, use and distribute all these videos for personal and nonprofit educational use.
 

 Use Windows Explorer rather than "open" for file management--how to copy vs. moving files
rtclkcpy

Print EXCEL file to one page prn1page
video on importing text data and parsing. import
Sampling from airplane empty seats data:  samplek
Paste special transpose to transpose data from rows to columns. transpose
sorting rows sortht
adding in addins/tools addins
descriptive statistics procedure dscstats
histograms histgram
2-sample F test for unequal variances ftestvar
t-test 2 sample treating variances as equal ttst2smp
1-sample ttest 1samplet
conversion of survey text to logical values  
paired values ttest pairedt
   
   
   
   
1-factor ANOVA - with audio  anova1V
 
 2-factor ANOVA with replication- with audio  anova2v
Interaction in 2-way ANOVA  interact
Copying text out of a pdf   pdftxt
pasting text into EXCEL pastechi
Modifying (expand/contract) the Chi2 sheet expchi
pasting in new data for the Chi2 pastenew
chart with trendline trendline
simple linear regression simpregr
multiple regression yr1mregr
Use of Winzip to compress files winzip
   

Data for the YRBSS 2001 & 2003 are on this disk, as well as NCHRBS 1995

The videos below are with EXCEL XP and the YRBS 2001 and YRBS 2003 data as indicated. New data is released every two years at the CDC website. There is also a dataset there for the National College Health Risk Behavior (NCHRBS) conducted in 1995.
There may be a new version of the NCHRBS in the near future, so it would be good to check the CDC websites from time to time. Data from adult risk behavior surveys and census data are available at the dataFerret site. For convenience, ASCII data and descriptions available now are linked here and are on this disk so you don't have to download it:
YRBS01.dat  yrb01codebook (pdf)
YRBS03.dat  yrb03codebook (pdf) YRB03powerpointslides
NCHRBS95.dat  NCHRBcodebook (pdf)
Use of Winzip to compress large files winzip
more instructions and links to WINZIP & FTP install on this disk  
   
screen captures of YRBS2001 parsing in EXCEL Screen Captures of YRBS2003 parsing in EXCEL
multiple regression (description handout) yr1mregr
   

Using EXCEL Pivot Tables for Crosstabulation

Completed sheet with YRBS2001 data imported and parsed

Mind Tools
has these essential skills to enhance your career.

Learn Leadership Skills from the Experts
 is a self-study leadership system with tools, tips,  and email leadership courses.

Make Time For Success
 is a self-study program with 39 tips from the pros on managing your time, effort, and that of others.

Stress Management Masterclass
 
how you how to tackle the deep structural problems that cause stress in your working life.

 

   

YRBS2001 

Yrbs Download  yrb03dl dlyrb1
Import and parse  all of YRBSS 2001or 2003 into EXCEL   yrb3pars importxl
add labels to tops of columns for field names  y3lbltop lblontop
Prepare EXCEL file of YRBS '03 data for multiple regression--converting to actual ages,height in inches, weight in pounds and eliminating empty data fields regrprep  
Use Pivot table to select crosstab variables
(Description handout)
    pivot03 pivottbl 
Current Marijuana Use and grades, with page variables.
"Do people smoke pot because they are stupid, or are they stupid because they smoke pot?"
mjgrd1       setting up the pivottable
mjgrdpct    calculating percents by rows and columns 
mjgrdgrf    adding graphs
mjgrdpag  using the page variables
 
More complex examples of pivottables with grouping of categories and more automated data extraction BA2000 website Spreadsheet models in Management Science  
 Calculate the percent of males and females who smoke    pctsmk03 pcsmoke
What would you expect if there were no relationship (Ho true)     expect03 expect
Chi2 value =Does the Observation agree with your expectation? (Description handout
Updated versions of these are on the web.
Printable handout as WORD document Chi2.doc
       03smkch2 chi2calc
Other Crosstabs modify Pivot tables to use a different field-     pivchvar modfield
Other Crosstabs -adjust tables for new dimensions-- the "auto Chi-square"     newchi  
Other summary measures- smoking, gender and average weight     pivchvar smkavgwt

Stock Return time Series and Market Beta

   
Stock returns--download IBM and S&P500 from http://finance.yahoo.com/
dl-sp-ibm
 
Stock returns--Calculating a Market Beta for IBM abibmsp  
Example Sheet IBM, AB and S&P SPbudibm.xls  

Use of Access to predigest data for EXCEL analysis

(an alternative to EXCEL Pivot Tables)
   
parsing YRBSS data into Access and Excel  (ACCESS with yrbs1999 example) import wizard in EXCEL is very similar  imptaccs  and import2  
Crosstab Query in ACCESS (yrbs1999 example)  crosstab