Skip to content
  • Cart
  • My Account
  • Log In
  • Sign up Free!
  • Forum
  • Shop FRM®
  • FAQs
  • My Courses
  • My Account
  • Login
  • Log Out

Learning Spreadsheet: Random Variables

FRM® Part 1 Mastery Series Chapter 2: Random Variables Learning Spreadsheet: Random Variables

Download XLS

Shop Courses
Previous Topic
Back to Lesson
Next Lesson
Upgrade Your Account <br />to Access More Content Upgrade Your Account
to Access More Content

Course Navigation

Course Home Expand All
Interactive Practice Question Platform Tutorial
1 Topic
How to Use the Interactive Practice Question Platform
Foundations of Risk Management
Introduction to Foundations of Risk Management
2 Topics
Instructional Video: Intro to Foundations of Risk
Learning Spreadsheet: Intro to VaR
Chapter 1: The Building Blocks of Risk Management
3 Topics
Study Notes: The Building Blocks of Risk Management
Practice Question Set: The Building Blocks of Risk Management
Instructional Video: The Building Blocks of Risk Management
Chapter 2: How Do Firms Manage Financial Risk?
3 Topics
Study Notes: How Do Firms Manage Financial Risk?
Practice Question Set: How Do Firms Manage Financial Risk?
Instructional Video: How Do Firms Manage Financial Risk?
Chapter 3: The Governance of Risk Management
3 Topics
Study Notes: The Governance of Risk Management
Practice Question Set: The Governance of Risk Management
Instructional Video: The Governance of Risk Management
Chapter 4. Credit Risk Transfer Mechanisms
3 Topics
Study Notes: Credit Risk Transfer Mechanisms
Practice Question Set: Credit Risk Transfer Mechanisms
Instructional Video: Credit Risk Transfer Mechanisms
Chapter 5: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
5 Topics
Study Notes: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Practice Question Set: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Instructional Video: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Learning Spreadsheet 1 of 2: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Learning Spreadsheet 2 of 2: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Chapter 6: The Arbitrage Pricing Theory and Multifactor Models of Risk and Return
4 Topics
Study Notes: APT and Multifactor Models of Risk and Return
Practice Question Set: APT and Multifactor Models of Risk and Return
Instructional Video: APT and Multifactor Models of Risk and Return
Learning Spreadsheet: APT and Multifactor Models of Risk and Return
Chapter 7: Principles for Effective Data Aggregation and Risk Reporting
2 Topics
Study Notes: Principles for Effective Data Aggregation and Risk Reporting
Practice Question Set: Risk Data Aggregation and Reporting Principles
Chapter 8: Enterprise Risk Management and Future Trends
3 Topics
Study Notes: Enterprise Risk Management (ERM) and Future Trends
Practice Question Set: ERM and Future Trends
Instructional Video: Enterprise Risk Management and Future Trends
Chapter 9: Learning from Financial Disasters
3 Topics
Study Notes: Learning from Financial Disasters
Practice Question Set: Learning from Financial Disasters
Instructional Video: Learning from Financial Disasters
Chapter 10: Anatomy of the Great Financial Crisis
3 Topics
Study Notes: Anatomy of the Great Financial Crisis
Practice Question Set: Anatomy of the Great Financial Crisis
Instructional Video: Anatomy of the Great Financial Crisis
Chapter 11: GARP Code of Conduct
2 Topics
Study Notes: GARP Code of Conduct
Practice Question Set: GARP Code of Conduct
Foundations of Risk Topic Review
3 Topics
Foundations of Risk Focus Review Video 1 of 2
Foundations of Risk Focus Review Video 2 of 2
Learning Spreadsheets: P1.T1.XLS Bundle
Quantitative Analysis
Chapter 1: Fundamentals of Probability
4 Topics
Study Notes: Fundamentals of Probability
Practice Question Set: Fundamentals of Probability
Instructional Video: Fundamentals of Probability
Learning Spreadsheet: Fundamentals of Probability
Chapter 2: Random Variables
4 Topics
Study Notes: Random Variables
Practice Question Set: Random Variables
Instructional Video: Random Variables
Learning Spreadsheet: Random Variables
Chapter 3: Common Univariate Random Variables
4 Topics
Study Notes: Common Univariate Random Variables
Practice Question Set: Common Univariate Random Variables
Instructional Video: Common Univariate Random Variables
Learning Spreadsheet: Common Univariate Random Variables
Chapter 4: Multivariate Random Variables
4 Topics
Study Notes: Multivariate Random Variables
Practice Question Set: Multivariate Random Variables
Instructional Video: Multivariate Random Variables
Learning Spreadsheet: Multivariate Random Variables
Chapter 5: Sample Moments
4 Topics
Study Notes: Sample Moments
Practice Question Set: Sample Moments
Instructional Video: Sample Moments
Learning Spreadsheet: Sample Moments
Chapter 6: Hypothesis Testing
4 Topics
Study Notes: Hypothesis Testing
Practice Question Set: Hypothesis Testing
Instructional Video: Hypothesis Testing
Learning Spreadsheet: Hypothesis Testing
Chapter 7: Linear Regression
4 Topics
Study Notes: Linear Regression
Practice Question Set: Linear Regression
Instructional Video: Linear Regression
Learning Spreadsheet: Linear Regression
Chapter 8: Regression with Multiple Explanatory Variables
5 Topics
Study Notes: Regression with Multiple Explanatory Variables
Practice Question Set: Regression with Multiple Explanatory Variables
Instructional Video 1 of 2: Regression with Multiple Explanatory Variables
Instructional Video 2 of 2: Regression with Multiple Explanatory Variables
Learning Spreadsheet: Regression with Multiple Explanatory Variables
Chapter 9: Regression Diagnostics
4 Topics
Study Notes: Regression Diagnostics
Practice Question Set: Regression Diagnostics
Instructional Video: Regression Diagnostics
Learning Spreadsheet: Regression Diagnostics
Chapter 10: Stationary Time Series
4 Topics
Study Notes: Stationary Time Series
Practice Question Set: Stationary Time Series
Instructional Video: Stationary Time Series
Learning Spreadsheet: Stationary Time Series
Chapter 11: Nonstationary Time Series
4 Topics
Study Notes: Nonstationary Time Series
Practice Question Set: Nonstationary Time Series
Instructional Video: Nonstationary Time Series
Learning Spreadsheet: Nonstationary Time Series
Chapter 12: Measuring Return, Volatility, and Correlation
6 Topics
Study Notes: Measuring Return, Volatility, and Correlation
Practice Question Set: Measuring Return, Volatility, and Correlation
Instructional Video: Chapter 12: Measuring Return, Volatility, and Correlation
Learning Spreadsheet: Measuring Return, Volatility, and Correlation
ARCHIVED: Instructional Video 1 of 2: Measuring Return, Volatility, and Correlation
ARCHIVED: Instructional Video 2 of 2: Measuring Return, Volatility, and Correlation
Chapter 13: Simulation and Bootstrapping
5 Topics
Study Notes: Simulation and Bootstrapping
Practice Question Set: Simulation and Bootstrapping
Instructional Video: Simulation and Bootstrapping
Learning Spreadsheet: Simulation and Bootstrapping
Archived Instructional Video: Simulation and Bootstrapping
Chapter 14: Machine-Learning Methods
4 Topics
Study Notes: Machine-Learning Methods
Practice Questions: Machine-Learning Methods
Instructional Video: Machine-Learning Methods
Learning Spreadsheet: Machine-Learning Methods
Chapter 15: Machine Learning and Prediction
4 Topics
Study Notes: Machine Learning and Prediction
Practice Questions: Machine Learning and Prediction
Instructional Video: Machine-Learning and Prediction
Learning Spreadsheet: Machine-Learning and Prediction
Quantitative Analysis Topic Review
7 Topics
Quantitative Focus Review Video (1 of 3)
Quantitative Focus Review Video (2 of 3)
Quantitative Focus Review Video (3 of 3)
Learning Spreadsheets: P1.T2.a XLS Bundle
Learning Spreadsheets: P1.T2.b XLS Bundle
Learning Spreadsheets: P1.T2.c XLS Bundle
Learning Spreadsheets: P1.T2.d XLS Bundle
Financial Markets & Products
Chapter 1: Banks
4 Topics
Study Notes: Banks
Practice Question Set: Banks
Instructional Video: Banks
Learning Spreadsheet: Banks
Chapter 2. Insurance Companies and Pension Plans
4 Topics
Study Notes: Insurance Companies and Pension Plans
Practice Question Set: Insurance Companies and Pension Plans
Instructional Video: Insurance Companies and Pension Plans
Learning Spreadsheet: Insurance Companies and Pension Plans
Chapter 3: Fund Management
4 Topics
Study Notes: Fund Management
Practice Question Set: Fund Management
Instructional Video: Fund Management
Learning Spreadsheet: Fund Management
Chapter 4. Introduction to Derivatives
4 Topics
Study Notes: Introduction to Derivatives
Practice Question Set: Introduction to Derivatives
Instructional Video: Introduction to Derivatives
Learning Spreadsheet: Introduction to Derivatives
Chapter 5: Exchanges and OTC Markets
4 Topics
Study Notes: Exchanges and OTC Markets
Practice Question Set: Exchanges and OTC Markets
Instructional Video: Chapter 5: Exchanges and OTC Markets & Chapter 6: Central Clearing
Learning Spreadsheet: Exchanges and OTC Markets
Chapter 6: Central Clearing
4 Topics
Study Notes: Central Clearing
Practice Question Set: Central Clearing
Learning Spreadsheet: Central Clearing
Instructional Video: See Chapter 5 Exchanged and OTC Markets (combined video)
Chapter 7: Futures Markets
4 Topics
Study Notes: Futures Markets
Practice Question Set: Futures Markets
Instructional Video: Futures Markets
Learning Spreadsheet: Futures Markets
Chapter 8: Using Futures for Hedging
4 Topics
Study Notes: Using Futures for Hedging
Practice Question Set: Using Futures for Hedging
Instructional Video: Using Futures for Hedging
Learning Spreadsheet: Using Futures for Hedging
Chapter 9: Foreign Exchange Markets
4 Topics
Study Notes: Foreign Exchange Markets
Practice Question Set: Foreign Exchange Markets
Instructional Video: Foreign Exchange Markets
Learning Spreadsheet: Foreign Exchange Markets
Chapter 10: Pricing Financial Forwards and Futures
4 Topics
Study Notes: Pricing Financial Forwards and Futures
Practice Question Set: Pricing Financial Forwards and Futures
Instructional Video: Pricing Financial Forwards and Futures
Learning Spreadsheet: Pricing Financial Forwards and Futures
Chapter 11: Commodity Forwards and Futures
4 Topics
Study Notes: Commodity Forwards and Futures
Practice Question Set: Commodity Forwards and Futures
Instructional Video: Commodity Forwards and Futures
Learning Spreadsheet: Commodity Forwards and Futures
Chapter 12: Options Markets
4 Topics
Study Notes: Options Markets
Practice Question Set: Options Markets
Instructional Video: Options Markets
Learning Spreadsheet: Options Markets
Chapter 13: Properties of Options
4 Topics
Study Notes: Properties of Options
Practice Question Set: Properties of Options
Instructional Video: Properties of Options
Learning Spreadsheet: Properties of Options
Chapter 14: Trading Strategies
4 Topics
Study Notes: Trading Strategies
Practice Question Set: Trading Strategies
Instructional Video: Trading Strategies
Learning Spreadsheet: Trading Strategies
Chapter 15: Exotic Options
5 Topics
Study Notes: Exotic Options
Practice Question Set: Exotic Options
Instructional Video: Exotic Options
Practice Questions Learning Spreadsheet: Exotic Options
Study Notes Learning Spreadsheet: Exotic Options
Chapter 16: Properties of Interest Rates
4 Topics
Study Notes: Properties of Interest Rates
Practice Question Set: Properties of Interest Rates
Instructional Video: Properties of Interest Rates
Learning Spreadsheet: Properties of Interest Rates
Chapter 17: Corporate Bonds
3 Topics
Study Notes: Corporate Bonds
Practice Question Set: Corporate Bonds
Instructional Video: Corporate Bonds
Chapter 18: Mortgages and Mortgage-Backed Securities
4 Topics
Study Notes: Mortgages and Mortgage-Backed Securities
Practice Question Set: Mortgages and Mortgage-Backed Securities
Instructional Video: Mortgages and Mortgage-Backed Securities
Learning Spreadsheet: Mortgages and Mortgage-Backed Securities
Chapter 19: Interest Rate Futures
4 Topics
Study Notes: Interest Rate Futures
Practice Question Set: Interest Rate Futures
Instructional Video: Interest Rate Futures
Learning Spreadsheet: Interest Rate Futures
Chapter 20: Swaps
4 Topics
Study Notes: Swaps
Practice Question Set: Swaps
Instructional Video: Swaps
Learning Spreadsheet: Swaps
Financial Markets & Products Topic Review
7 Topics
Financial Markets & Products Focus Review Video (1 of 3)
Financial Markets & Products Focus Review Video (2 of 3)
Financial Markets & Products Focus Review Video (3 of 3)
Learning Spreadsheets: P1.T3.a XLS Bundle
Learning Spreadsheets: P1.T3.b XLS Bundle
Learning Spreadsheets: P1.T3.c XLS Bundle
Learning Spreadsheets: P1.T3.d XLS Bundle
Valuation & Risk Models
Chapter 1: Measures of Financial Risk
4 Topics
Study Notes: Measures of Financial Risk
Practice Question Set: Measures of Financial Risk
Instructional Video: Measures of Financial Risk
Learning Spreadsheet: Measures of Financial Risk
Chapter 2: Calculating and Applying VaR
4 Topics
Study Notes: Calculating and Applying VaR
Practice Question Set: Calculating and Applying VaR
Instructional Video: Calculating and Applying VaR
Learning Spreadsheet: Calculating and Applying VaR
Chapter 3: Measuring and Monitoring Volatility
4 Topics
Study Notes: Measuring and Monitoring Volatility
Practice Question Set: Measuring and Monitoring Volatility
Instructional Video: Measuring and Monitoring Volatility
Learning Spreadsheet: Measuring and Monitoring Volatility
Chapter 4. External and Internal Ratings
4 Topics
Study Notes: External and Internal Ratings
Practice Question Set: External and Internal Ratings
Instructional Video: External and Internal Ratings
Learning Spreadsheet: External and Internal Ratings
Chapter 5: Country Risk: Country Risk: Determinants, Measures, and Implications
3 Topics
Study Notes: Country Risk: Country Risk: Determinants, Measures, and Implications
Practice Question Set: Country Risk: Country Risk: Determinants, Measures, and Implications
Instructional Video: Country Risk: Country Risk: Determinants, Measures, and Implications
Chapter 6: Measuring Credit Risk
3 Topics
Study Notes: Measuring Credit Risk
Practice Question Set: Measuring Credit Risk
Learning Spreadsheet: Measuring Credit Risk
Chapter 7: Operational Risk
3 Topics
Study Notes: Operational Risk
Practice Questions: Operational Risk
Learning Spreadsheet: Operational Risk
Chapter 8: Stress Testing
3 Topics
Study Notes: Stress Testing
Practice Question Set: Stress Testing
Instructional Video: Stress Testing
Chapter 9: Pricing Conventions, Discounting, and Arbitrage
4 Topics
Study Notes: Pricing Conventions, Discounting, and Arbitrage
Practice Question Set: Pricing Conventions, Discounting, and Arbitrage
Instructional Video: Pricing Conventions, Discounting, and Arbitrage
Learning Spreadsheet: Pricing Conventions, Discounting, and Arbitrage
Chapter 10: Interest Rates
4 Topics
Study Notes: Interest Rates
Practice Question Set: Interest Rates
Instructional Video: Interest Rates
Learning Spreadsheet: Interest Rates
Chapter 11: Bond Yields and Return Calculations
4 Topics
Study Notes: Bond Yields and Return Calculations
Practice Question Set: Bond Yields and Return Calculations
Instructional Video: Bond Yields and Return Calculations
Learning Spreadsheet: Bond Yields and Return Calculations
Chapter 12: Applying Duration, Convexity, and DV01
4 Topics
Study Notes: Applying Duration, Convexity, and DV01
Practice Question Set: Applying Duration, Convexity, and DV01
Instructional Video: Applying Duration, Convexity, and DV01
Learning Spreadsheet: Applying Duration, Convexity, and DV01
Chapter 13: Modeling and Hedging Non-Parallel Term Structure Shifts
4 Topics
Study Notes: Modeling and Hedging Non-Parallel Term Structure Shifts
Practice Question Set: Modeling and Hedging Non-Parallel Term Structure Shifts
Instructional Video: Modeling and Hedging Non-Parallel Term Structure Shifts
Learning Spreadsheet: Modeling and Hedging Non-Parallel Term Structure Shifts
Chapter 14: Binomial Trees
4 Topics
Study Notes: Binomial Trees
Practice Question Set: Binomial Trees
Instructional Video: Binomial Trees
Learning Spreadsheet: Binomial Trees
Chapter 15: The Black-Scholes-Merton Model
4 Topics
Study Notes: The Black-Scholes-Merton Model
Practice Question Set: The Black-Scholes-Merton Model
Instructional Video: The Black-Scholes-Merton Model
Learning Spreadsheet: The Black-Scholes-Merton Model
Chapter 16: Option Sensitivity Measures: The “Greeks”
4 Topics
Study Notes: Option Sensitivity Measures: The “Greeks”
Practice Question Set: Option Sensitivity Measures: The “Greeks”
Instructional Video: Option Sensitivity Measures: The “Greeks”
Learning Spreadsheet: Option Sensitivity Measures: The “Greeks”
Valuation & Risk Models Topic Review
7 Topics
Valuation and Risk Models Focus Review Video (1 of 3)
Valuation and Risk Models Focus Review Video (2 of 3)
Valuation and Risk Models Focus Review Video (3 of 3)
Learning Spreadsheets: P1.T4.a XLS Bundle
Learning Spreadsheets: P1.T4.b XLS Bundle
Learning Spreadsheets: P1.T4.c XLS Bundle
Learning Spreadsheets: P1.T4.e XLS Bundle
PART I REVIEW
Formula Sheets
1 Topic
Part 1 Formula Sheets (Coming Soon)
Interactive Mock Exam
1 Topic | 1 Quiz
Part 1 Interactive PQ Platform – Build a Mock Exam
Part 1 Full Length Interactive Mock Exam 1
Expert-Led Live Online Review Sessions
Foundations of Risk Live Review – October 1, 2025 – 1:00p.m. Eastern Time
3 Topics
Foundations of Risk Pre-Session Video
Foundations of Risk Live Session Agenda & Access
Foundations of Risk Live Session Replay & Slides
Quantitative Analysis Live Review – October 8, 2025 – 1:00 p.m. Eastern Time
3 Topics
Quantitative Analysis Pre-Session Video
Quantitative Analysis Live Session Agenda & Access
Quantitative Analysis Live Session Replay & Slides
Financial Markets & Products Live Review – October 15 – 1:00 p.m. Eastern Time
3 Topics
Financial Markets & Products Pre-Session Video – November 2025 Exam
Financial Markets & Products Live Session Agenda & Access – November 2025 Exam
Financial Markets & Products Live Session Replay & Slides – November 2025 Exam
Valuation & Risk Models Live Review – October 22, 2025 – 1:00 p.m. Eastern Time
3 Topics
Valuation & Risk Models Pre-Session Video – November 2025 Exam
Valuation & Risk Models Live Session Agenda & Access – November 2025 Exam
Valuation & Risk Models Live Session Replay & Slides – November 2025 Exam
Part 1 Final Live Review – October 30, 2025 – 1:00 p.m. Eastern Time
3 Topics
Part 1 Final Review Pre-Session Video – November 2025 Exam
Part 1 Final Review Live Session Agenda & Access – November 2025 Exam
Part 1 Final Review Live Session Replay & Slides – November 2025 Exam
Past Expert- Led Sessions
Foundations of Risk Live Review Sessions
2 Topics
Foundations of Risk Live Session Replay & Slides – May 2025 Exam
Foundations of Risk Live Session Replay & Slides – August 2025 Exam
Quantitative Analysis Live Review Sessions
2 Topics
Quantitative Analysis Live Session Replay & Slides – May 2025 Exam
Quantitative Analysis Live Session Replay & Slides – August 2025 Exam
Financial Markets & Products Live Review Sessions
2 Topics
Financial Markets & Products Live Session Replay & Slides – May 2025 Exam
Financial Markets & Products Live Session Replay & Slides – August 2025 Exam
Valuation & Risk Models Live Review Sessions
2 Topics
Valuation & Risk Models Live Session Replay & Slides – May 2025 Exam
Valuation & Risk Models Live Session Replay & Slides – August 2025 Exam
Part 1 Final Live Review Sessions
2 Topics
Part 1 Final Review Live Session Replay & Slides – May 2025 Exam
Final Live Review Live Session Replay & Slides – August 2025 Exam
Return to FRM® Part 1 Mastery Series
  • FRM Study Guide
  • My Courses

Stay connected

We'll keep you informed on new forum posts, relevant blog articles, and everything you'll need to prepare for your exam.
  • Privacy Policy
  • Terms of Use
  • Affiliate Disclosure

© Copyright 2025 – Bionic Turtle