• IPAK-EDU

    • Store
  • Get directions
    Business hours

IPAK-EDU

IPAK-EDU

Categories
Analytics 102 - Introduction to Spreadsheets
Store/Analytics

Analytics 102 - Introduction to Spreadsheets

$133.00
Fall
REFERRAL CODE (WHO SENT YOU?)
Enter your text
Optional
Recitation Option
Have questions?
Share this product with your friends
ShareSharePin it

Analytics 102 - Introduction to Spreadsheets

Store/Analytics
Product Details
ANALYTICS 102 – SPREADSHEETS 1 (Fall 2025, Sept-Dec)

Instructor: James Lyons-Weiler, PhD

Mondays at 3pm

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

Show More
You May Also Like
Analytics
Analytics 100 - How to Read & Interpret a Scientific Study
Analytics 100 - How to Read & Interpret a Scientific Study
Analytics 100 - How to Read & Interpret a Scientific Study
$160.00
INFORMAL, THURSDAYS AT 11AM
CAUSALITY COFFEE
CAUSALITY COFFEE
CAUSALITY COFFEE
$16.00
TUESDAYS 11AM
Logic, Reason, and Knowledge
Logic, Reason, and Knowledge
Logic, Reason, and Knowledge
WIN ANY DEBATE OR ARGUMENT IN STYLE.
$200.00
Fall
Applied Biostatistics - Analytics 200
Applied Biostatistics - Analytics 200
Applied Biostatistics - Analytics 200
$160.00
Biology/Health/Analytics
How To Think Like an Epidemiologist
How To Think Like an Epidemiologist
How To Think Like an Epidemiologist
$160.00
  • Search Products
  • My Account
  • Track Orders
  • Favorites
  • Enrolled Courses
  • Gift Cards
Display prices in:USD
Share Share Pin
© IPAK-EDU Report abuse