Instructor: James Lyons-Weiler, PhD

Thursdays 2PM EST Live Lecture; Video will be available thereafter.

Basic Math operations review

Spreadsheet examples

Compound operations

Lecture 2. Importing Data

xls format, text, delimiters, cut-and-paste operations

Formatting Cells

Saving Your File in the Right Format

Lecture 4. Intro to Formulas

Homework Review

Summing a Column or Row

Calculating proportions in a column

Calculating percentages from proportions

Lecture 5. Intro to Graphs

Homework Review

Line Graph

Bar Graph

Spreadsheet Example

Lecture 6. Using Reference cell

Homework Review

Use in a column

Use in a function

Graph

Lecture 7. Calculating and Plotting a Histogram

Method 1

Method 2

Lecture 8. Correlation

Math of Linear Correlations: y = mx+b

Plotting a linear function

Data Analysis Pack 1

Lecture 9. Charts

Charts: Histogram, Bar Chart, Line Chart

Combining Chats

Lecture 10. Pie Diagrams

Lecture 11 Creating a Filter

Graph: Bar Chart or Pie Chart

Lecture 12 Sorting Data

Graphic: Line Charts

Lecture 13. Recursive calculations

Example 1 Compound Interest

Example 2 Cumulative Incidence

Lecture 14 Data Analysis Pack 2

Comparing the averages of samples from two populations (T-Test)

Other statistical operations available

Lecture 15 Recap