Data management tips 

Dealing with Data https://youtu.be/vWjCk9eo7FU

 

Excel to SPSS https://www.youtube.com/watch?v=nchjj4XzIWc

 

Changing Continuous to Categorical in Excel https://www.youtube.com/watch?v=kHJh0NqO9BQ&feature=youtu.be&hd=1

​

Learning 

Central tendency (KHAN academy) https://www.khanacademy.org/math/probability/descriptive-statistics/central-tendency/v/statistics-intro-mean-median-and-mode

​

Variability (KHAN academy) https://www.khanacademy.org/math/probability/descriptive-statistics/variance-std-deviation/v/range-variance-and-standard-deviation-as-measures-of-dispersion

​

Z score (YouTube): https://www.youtube.com/watch?v=SgpLb4xWsYk

​

Percentile ranking: https://www.youtube.com/watch?v=VcBGWPTkAw4  

​

Excel Help

Descriptives in Excel (youtube) https://www.youtube.com/watch?v=4_9vGqQaCFk

Note: when I highlight the input range I include the variable label.  If you do this be sure to click the box “label included”

Note: If you use the default for the output range it will put the table in a new tab.  To go back to your data, go to the bottom tabs. 

​

Descriptives in Execl tutorial: http://www.excel-easy.com/examples/descriptive-statistics.html

​

Visualizing data in excel:

Choosing a graph: http://www.optimizesmart.com/how-to-select-best-excel-charts-for-your-data-analysis-reporting/

 

Bar graph and pie chart: http://www.wikihow.com/Make-a-Bar-Graph-in-Excel

 

Histogram: http://www.ncsu.edu/labwrite/res/gt/gt-bar-home.html

 

Scatter plot: http://www.ncsu.edu/labwrite/res/gt/graphtut-home.html

​

Writing Descriptives:

http://abacus.bates.edu/~ganderso/biology/resources/writing/HTWstats.html#topofpage 

 

http://psc.dss.ucdavis.edu/sommerb/sommerdemo/report/presentation/presentcat.htm

 

http://psc.dss.ucdavis.edu/sommerb/sommerdemo/report/presentation/presentcont.htm