Bivariate regression: Excel Analysis kit | Mysite 1

top of page

Getting Started

Assignment 1
- Assignment #1 in Python and Excel
- Download Data for Assignment 1
- Assignment #1 Submission
- -------Python-------
- Getting Started in Colab
- Creating Variables in Python
- -----Excel-----
- How to Install the MS Office Suite
- Creating new variables with Excel
Assignment 2
- Assignment #2 using Python
- Assignment #2 Using Excel
- Assignment #2 Submission:
- -------Python-------
- Boxplots
- Histograms
- Frequency Tables
- Summation
- -----Excel-----
- Box Plots
- Histograms
- Frequency Tables
- Summation
- Data Analysis ToolPak
Assignment 3
- Assignment #3 using Python
- Assignment #3 using Excel
- Assignment #3 Submission:
- Data for Figure 3.1
- -------Python-------
- Mean and Standard Deviation
- Z-Scores and Scaling
- Figure 3.1
- Creating a .csv file
- -----Excel-----
- Mean and Standard Deviation
- Z-Scores and Scaling
- Figure 3.1 in Excel
- Creating a .csv file
Assignment 4
- Assignment #4 using Python
- Assignment #4 using Excel
- Assignment #4 Submission:
- Assignment #4 Data
- -------Python-------
- Line Graphs
- Histograms
- -----Excel-----
- Line Graphs
- Histograms
Assignment 5
- Assignment #5: Using Python
- Assignment #5: Using Excel
- Assignment #5 Submission:
- ----Python----
- Probabilities
- Finding Type II error in Python
- -----Excel-----
- Probabilities
- Finding Type II error in Excel
Assignment 6
- Assignment #6 using Python
- Assignment #6 using Excel
- Assignment #6 Submission:
- Add.xlsx Data Download
- -------Python-------
- Collapsing Variables
- Odds and Risk Ratios
- Chi-Square
- -----Excel-----
- Collapsing Variables
- Odds and Risk Ratios
- Chi-Square
Assignment 7
- Assignment #7 using Python
- Assignment #7 using Excel
- Assignment #7 Submission:
- Assignment 7 data
- Writing about numbers and results (APA)
- ------Python------
- Scatterplots
- Pearson Correlations
- -----Excel-----
- Scatterplots
- Pearson Correlations in Excel
Assignment 8

Bivariate Regression in Excel

bottom of page