• IPAK-EDU LLC

ANALYTICS 102 – SPREADSHEETS 1 (Fall 2023, Sept-Dec)

Instructor: James Lyons-Weiler, PhD

Email: james@ipak-edu.org

Lecture 1. Course Overview

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 Cells

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

SPREADSHEETS 2- Next term will focus on DATA ANALYSIS.

Statistical analysis, t-test, F-test, ANOVA, correlation, regression, rank tests, tests of association, odds ratios, relative risk, permutation tests, statistical power, macros, time series analysis, logistic regression