top of page
Home
Getting Started
Syllabus
Request Help
Log In
Assignment 1
Guidance for assignments in this class
Assignment #1 Using Excel
Installing the free MS Office Suite
Using comments in R
Tips on dealing with errors
Download Data for Assignment 1
Assignment #1 Using R
-------R-------
How to Install R
R Basics
Importing data in R using a Mac
Reading data in R, using a Mac
Maintaining an audit trail in R
Creating new variables in R
Working with variable names in R
-----Excel-----
Creating new variables with Excel
Submit Assignment #1
Assignment 2
Assignment #2 Using Excel
Assignment #2 using R
Assignment #2 Submission:
-------R-------
Box Plots in R
Box plot, Stem-and-leaf, frequency in R
Summation in R
-----Excel-----
Box plot using Microsoft 365 Excel
Box plots in old versions of Excel
Summation in Excel
Stem and leaf in Excel
Note about stem-and-leaf plots in Excel
Frequency tables with Excel pivot tables
Frequencies, cumulative percent, Excel
Youtube video on Excel frequency tables
Assignment 3
Assignment #3 using R
Assignment #3 using Excel
Assignment #3 Submission:
Data for Figure 3.1
Figure 3.1 in Excel
-------R-------
Figure 3.1 in R
Transforming data into z-scores in R
Saving data as a .csv file in R
-----Excel-----
Figure 3.1 in Excel
Data for Figure 3.1 in Excel
Transforming data into z-scores in Excel
Assignment 4
Assignment #4 using R
Assignment #4 using Excel
Assignment #4 Submission:
-------R-------
Attach and With commands in R
-----Excel-----
Line graph using MS Office 365
Line graph in Excel
Histogram and bar chart in Excel
Assignment #4 data
Assignment 5
Assignment #5: Using R
Assignment #5: Using Excel
Assignment #5 Submission:
---- R and Excel ----
Probabilities using R and Excel
Null hypothesis testing
Finding Type II error in Excel and R
-----Excel-----
Probabilities in NHST using Excel
Assignment 6
Assignment #6 using R
Assignment #6 using Excel
Assignment #6 Submission:
Add.dat Download
All steps in Excel, R and SPSS
-------R-------
Collapsing variables and OR in R
-----Excel-----
Collapsing variables and OR in Excel
Add.xlsx Data Download
Assignment 7
Assignment #7 using R
Assignment #7 using Excel
Assignment #7 Submission:
Writing about numbers and results (APA)
------R------
Scatter plot and best-fitting line in R
Correlations in R
Clear your workspace and var names in R
-----Excel-----
Scatter plot in Excel with 2 groups
Scatter plot with 2 groups in old Excel
Find the significance of r in Excel
Google Sheets to produce scatter plots w
Assignment 7 data
Assignment 8
Assignment #8 using Excel
Assignment #8 using R
Assignment #8 Submission:
Albatros Data Set
-------R-------
Bivariate regression in R
Add data
-----Excel-----
Bivariate regression: Excel Analysis kit
Bivariate regression by hand in Excel I
New Page
Bivariate regression by hand in Excel II
Table 10.5
Copy of Add.dat Download
About Data Analysis ToolPak
figure3_1.xlsx
bottom of page