|
Please Visit Our Other Business Libraries Mathematics Libraries General Interest Libraries Education Special Interest Libraries
Textbooks Libraries
General Interest Libraries
Education Please Visit our sponsors
|
Table of Video Tutorials:Some of these are EXE's that include
|
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
Learn Leadership Skills from the Experts
|
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 | ||