Moving Average Forecasting Beyond One Period into Future (in Excel)
Joshua Emmanuel
Moving Average Forecasting Beyond One Period into Future (in Excel)
2:17
LP Sensitivity Analysis - Reduced Cost, Shadow Price, Optimality, Feasibility -Excel Output
Joshua Emmanuel
LP Sensitivity Analysis - Reduced Cost, Shadow Price, Optimality, Feasibility -Excel Output
13:16
One-Sample t-Test for μ: Hypothesis, P-value, Confidence Interval - Calorie Consumption
Joshua Emmanuel
One-Sample t-Test for μ: Hypothesis, P-value, Confidence Interval - Calorie Consumption
9:10
How to Install Data Analysis on Mac for Excel - ToolPak
Joshua Emmanuel
How to Install Data Analysis on Mac for Excel - ToolPak
0:37
How to install Solver on Mac for Excel - Addin
Joshua Emmanuel
How to install Solver on Mac for Excel - Addin
0:34
One Sample Z Test - Summary Statistics (workaround) using Data Analysis in Excel
Joshua Emmanuel
One Sample Z Test - Summary Statistics (workaround) using Data Analysis in Excel
4:06
Hypothesis Z-test Explained: One-tailed, 𝝈 known -Does This Fitness App's Claim Hold Up?
Joshua Emmanuel
Hypothesis Z-test Explained: One-tailed, 𝝈 known -Does This Fitness App's Claim Hold Up?
7:26
Geometric Mean of Investment Returns on the BAII Plus Calculator
Joshua Emmanuel
Geometric Mean of Investment Returns on the BAII Plus Calculator
2:26
Simulation in Excel - Discrete Distribution, RAND, DATA TABLE, LOOKUP, VLOOKUP, RANDARRAY
Joshua Emmanuel
Simulation in Excel - Discrete Distribution, RAND, DATA TABLE, LOOKUP, VLOOKUP, RANDARRAY
6:18
Calculating NPV and IRR in Excel: Project A vs. Project B - Discounted Cash Flow (DCF)
Joshua Emmanuel
Calculating NPV and IRR in Excel: Project A vs. Project B - Discounted Cash Flow (DCF)
2:11
Simple Linear Regression Problem Solved with explanation: Monthly Rent vs. Apartment Size - Excel
Joshua Emmanuel
Simple Linear Regression Problem Solved with explanation: Monthly Rent vs. Apartment Size - Excel
12:50
Excel-Scientific Notation to Regular Numbers | E+08 & E-07
Joshua Emmanuel
Excel-Scientific Notation to Regular Numbers | E+08 & E-07
1:47
Factorials, Permutations, Combinations in Excel, Google Sheets, Calc - Counting Rules #probability
Joshua Emmanuel
Factorials, Permutations, Combinations in Excel, Google Sheets, Calc - Counting Rules #probability
0:51
Bar Chart with Error Bars for Mean in Excel 365-Confidence interval, standard deviation, Std Error
Joshua Emmanuel
Bar Chart with Error Bars for Mean in Excel 365-Confidence interval, standard deviation, Std Error
4:54
Boxplots in SPSS: Summaries for separate variables & for groups of cases: Individual & side-by-side
Joshua Emmanuel
Boxplots in SPSS: Summaries for separate variables & for groups of cases: Individual & side-by-side
1:34
SPSS - Recoding Age into Categories and Creating Frequency Charts - Recoding into different variable
Joshua Emmanuel
SPSS - Recoding Age into Categories and Creating Frequency Charts - Recoding into different variable
4:09
SPSS – Construct Error Bar Chart (95% confidence interval or standard deviation) -significance
Joshua Emmanuel
SPSS – Construct Error Bar Chart (95% confidence interval or standard deviation) -significance
1:39
SPSS Histogram Tutorial (with Normal curve)
Joshua Emmanuel
SPSS Histogram Tutorial (with Normal curve)
0:55
SPSS - Sample & Population Descriptives: Mean, Standard Deviation, Variance, Range statistics
Joshua Emmanuel
SPSS - Sample & Population Descriptives: Mean, Standard Deviation, Variance, Range statistics
1:31
Solve systems of linear equations in Excel - Find intersection of two lines (Microsoft 365)
Joshua Emmanuel
Solve systems of linear equations in Excel - Find intersection of two lines (Microsoft 365)
0:54
Excel: Frequency Distribution & Histogram. Choose your bins (class widths or intervals)
Joshua Emmanuel
Excel: Frequency Distribution & Histogram. Choose your bins (class widths or intervals)
3:09
Project Scheduling in Excel -Critical Path- Complete Table -PERT/CPM
Joshua Emmanuel
Project Scheduling in Excel -Critical Path- Complete Table -PERT/CPM
3:58
Discrete Probability Distribution -Mean, Variance, Standard Deviation -Excel 365 template
Joshua Emmanuel
Discrete Probability Distribution -Mean, Variance, Standard Deviation -Excel 365 template
3:26
Using Names in Formulas in Excel + Break-even chart Template in Microsoft 365
Joshua Emmanuel
Using Names in Formulas in Excel + Break-even chart Template in Microsoft 365
5:29
Expected Value Discrete Probability Distribution #education #excel
Joshua Emmanuel
Expected Value Discrete Probability Distribution #education #excel
0:45
NPV & IRR: Formula + TI BA II Plus + Excel – Equipment Purchase & Residual value
Joshua Emmanuel
NPV & IRR: Formula + TI BA II Plus + Excel – Equipment Purchase & Residual value
4:24
Financial Planning + Inflation- College Education investment: Real Rate - (BA II Plus & Excel)
Joshua Emmanuel
Financial Planning + Inflation- College Education investment: Real Rate - (BA II Plus & Excel)
5:38
Select items from Vectors in R: Indexing and Subsetting in R Studio | A Beginner's Guide
Joshua Emmanuel
Select items from Vectors in R: Indexing and Subsetting in R Studio | A Beginner's Guide
3:28
T-Tests in R Studio: One Sample Mean with raw data | One-Tailed & Two-Tailed
Joshua Emmanuel
T-Tests in R Studio: One Sample Mean with raw data | One-Tailed & Two-Tailed
4:59
Hypothesis Z-Tests in RStudio: A Step-by-Step Guide (One Sample Mean)-1 & 2 tailed tests
Joshua Emmanuel
Hypothesis Z-Tests in RStudio: A Step-by-Step Guide (One Sample Mean)-1 & 2 tailed tests
6:17
Confidence Intervals for one Population Mean in R (Z & t) – Summary & Raw Data
Joshua Emmanuel
Confidence Intervals for one Population Mean in R (Z & t) – Summary & Raw Data
5:00
Population Standard Deviation in R - Sum of Squares, Variance, SD in RStudio
Joshua Emmanuel
Population Standard Deviation in R - Sum of Squares, Variance, SD in RStudio
1:50
Draw Normal Curves in RStudio with shading -Calculate Probabilities & Critical Z Values
Joshua Emmanuel
Draw Normal Curves in RStudio with shading -Calculate Probabilities & Critical Z Values
4:17
Areas under Normal Curve in R | Calculating probabilities in R Studio
Joshua Emmanuel
Areas under Normal Curve in R | Calculating probabilities in R Studio
1:38
Mean, Standard Deviation, Variance on BA II Plus Calculator | Probability Distribution x̄, SD, σ²
Joshua Emmanuel
Mean, Standard Deviation, Variance on BA II Plus Calculator | Probability Distribution x̄, SD, σ²
2:22
Discounted Cash Flows on BAII Plus – NPV, IRR, PB, DPB, PI - DCF - Capital Budgeting
Joshua Emmanuel
Discounted Cash Flows on BAII Plus – NPV, IRR, PB, DPB, PI - DCF - Capital Budgeting
3:10
General Annuity Problems Solved in Excel or Google Sheets – FV & PV: Ordinary (END) & Due (BGN)
Joshua Emmanuel
General Annuity Problems Solved in Excel or Google Sheets – FV & PV: Ordinary (END) & Due (BGN)
5:18
Number of Days between Dates in Excel or Google Sheets #excel #finance
Joshua Emmanuel
Number of Days between Dates in Excel or Google Sheets #excel #finance
0:26
Moving Averages in Excel -MAD (MAE), MSE, MAPE | Forecast + Graph
Joshua Emmanuel
Moving Averages in Excel -MAD (MAE), MSE, MAPE | Forecast + Graph
5:58
Draw Bell-Shaped Curves in Microsoft Excel and PowerPoint | Normal Distribution | Shade area
Joshua Emmanuel
Draw Bell-Shaped Curves in Microsoft Excel and PowerPoint | Normal Distribution | Shade area
3:32
Annuity Calculations in Excel – FV, PV, PMT, N | Simple - Ordinary (END) & Due (BGN)
Joshua Emmanuel
Annuity Calculations in Excel – FV, PV, PMT, N | Simple - Ordinary (END) & Due (BGN)
10:00
Solved: Compound Interest Problems in Excel–Future, Present Values, Rate, Periods Examples +Template
Joshua Emmanuel
Solved: Compound Interest Problems in Excel–Future, Present Values, Rate, Periods Examples +Template
6:13
Solved Examples: Normal Approximation to Binomial Distribution -Probability | Continuity Correction
Joshua Emmanuel
Solved Examples: Normal Approximation to Binomial Distribution -Probability | Continuity Correction
6:40
Create Payoff Table | Excel | Cost, Selling Price, Profit, Shortage, Excess, Demand/Supply
Joshua Emmanuel
Create Payoff Table | Excel | Cost, Selling Price, Profit, Shortage, Excess, Demand/Supply
3:27
Solved -Probabilities: AND, OR, GIVEN | Joint, Conditional, Union + Complements
Joshua Emmanuel
Solved -Probabilities: AND, OR, GIVEN | Joint, Conditional, Union + Complements
2:39
Hypothesis Test for Proportion Template in Excel/Google Sheets | Critical & P-values
Joshua Emmanuel
Hypothesis Test for Proportion Template in Excel/Google Sheets | Critical & P-values
2:42
Hypothesis t-test Template for mean in Excel/Google Sheets | Critical & P-values
Joshua Emmanuel
Hypothesis t-test Template for mean in Excel/Google Sheets | Critical & P-values
2:49
Hypothesis Z-test for mean – Excel Template | Hypothesis Testing | critical & p-values
Joshua Emmanuel
Hypothesis Z-test for mean – Excel Template | Hypothesis Testing | critical & p-values
5:59
Binary Integer LP – Capital Budgeting – Formulation + Solution
Joshua Emmanuel
Binary Integer LP – Capital Budgeting – Formulation + Solution
9:07
Solving Math/Stats Problems in Microsoft Copilot - Bing Chat - Prompt Engineering basics
Joshua Emmanuel
Solving Math/Stats Problems in Microsoft Copilot - Bing Chat - Prompt Engineering basics
6:28
Decision Analysis - Sensitivity Analysis | Find p | Draw Graph | Data Table in Excel
Joshua Emmanuel
Decision Analysis - Sensitivity Analysis | Find p | Draw Graph | Data Table in Excel
5:09
Solved - Hypothesis - Proportion Test | Z test, P-value | First-time home buyers
Joshua Emmanuel
Solved - Hypothesis - Proportion Test | Z test, P-value | First-time home buyers
3:01
Construct Horizontal Boxplot | Excel + PowerPoint to Word
Joshua Emmanuel
Construct Horizontal Boxplot | Excel + PowerPoint to Word
3:55
Hypothesis Testing 2-tailed: Solved Problem: Quiz 10#5
Joshua Emmanuel
Hypothesis Testing 2-tailed: Solved Problem: Quiz 10#5
6:41
Calculating Bond Value (Price) | Formula | Excel | BA II Plus calculator
Joshua Emmanuel
Calculating Bond Value (Price) | Formula | Excel | BA II Plus calculator
6:16
Special LP Cases in Simplex Method | Infeasibility, Alternative Solutions, Unboundedness, Degeneracy
Joshua Emmanuel
Special LP Cases in Simplex Method | Infeasibility, Alternative Solutions, Unboundedness, Degeneracy
9:20
Initial Simplex Tableau setup | Artificial Variables, Slack, Surplus | Iteration 0
Joshua Emmanuel
Initial Simplex Tableau setup | Artificial Variables, Slack, Surplus | Iteration 0
8:27
Paired t-test | Dependent Samples | Hypothesis test| Confidence Interval
Joshua Emmanuel
Paired t-test | Dependent Samples | Hypothesis test| Confidence Interval
6:28
Solve Transshipment in Excel 2 - Network Flow - Shipment between any 2 nodes
Joshua Emmanuel
Solve Transshipment in Excel 2 - Network Flow - Shipment between any 2 nodes
7:24
How to type Subscript & Superscript in Excel
Joshua Emmanuel
How to type Subscript & Superscript in Excel
1:15
Solve Linear Programming Graph in Desmos (FREE) | LP Optimal solution | Maximize | Minimize
Joshua Emmanuel
Solve Linear Programming Graph in Desmos (FREE) | LP Optimal solution | Maximize | Minimize
4:49
Scatterplot in Excel | Scatter Diagram | Residuals from Graph | Slope | Intercept | R-Square
Joshua Emmanuel
Scatterplot in Excel | Scatter Diagram | Residuals from Graph | Slope | Intercept | R-Square
3:14
Histogram in Excel using Pivot Tables | Frequency Distribution | Quantitative raw data
Joshua Emmanuel
Histogram in Excel using Pivot Tables | Frequency Distribution | Quantitative raw data
2:20
Boxplots in Excel | Single | Side-by-side box plot
Joshua Emmanuel
Boxplots in Excel | Single | Side-by-side box plot
1:11
Bar chart & Pie chart in Excel – Pivot Tables – Summary & Raw Data
Joshua Emmanuel
Bar chart & Pie chart in Excel – Pivot Tables – Summary & Raw Data
2:37
Chi-Square Test of Independence | Contingency Table | Hypothesis Test
Joshua Emmanuel
Chi-Square Test of Independence | Contingency Table | Hypothesis Test
6:31
Solve Transshipment in Excel | Network Flow | Plant - Warehouse - Distribution Centre
Joshua Emmanuel
Solve Transshipment in Excel | Network Flow | Plant - Warehouse - Distribution Centre
6:24
P-value from t-table | How to estimate P-value without software
Joshua Emmanuel
P-value from t-table | How to estimate P-value without software
2:20
Hypothesis Test for Proportion | Examples | P-value | Z table
Joshua Emmanuel
Hypothesis Test for Proportion | Examples | P-value | Z table
6:56
Transshipment Problem -LP Formulation | Solution
Joshua Emmanuel
Transshipment Problem -LP Formulation | Solution
7:23
Normal Distribution | Mean to Z Table | How to Calculate Probabilities
Joshua Emmanuel
Normal Distribution | Mean to Z Table | How to Calculate Probabilities
8:21
Intro to Simple Linear Regression | Slope, y-intercept, R-square
Joshua Emmanuel
Intro to Simple Linear Regression | Slope, y-intercept, R-square
19:21
Normal Distribution, Confidence Interval, Hypothesis Testing -Test Review
Joshua Emmanuel
Normal Distribution, Confidence Interval, Hypothesis Testing -Test Review
50:23
Amortization Schedule: Loan Repayment | Basic Intro | PV, PMT, BAL, PRN, INT
Joshua Emmanuel
Amortization Schedule: Loan Repayment | Basic Intro | PV, PMT, BAL, PRN, INT
3:35
BA II Plus - Store and Recall Values - Using Memory
Joshua Emmanuel
BA II Plus - Store and Recall Values - Using Memory
0:45
BA II Plus – Days Between Dates
Joshua Emmanuel
BA II Plus – Days Between Dates
0:49
Use BAII+ like Scientific Calculator – Order of Operations
Joshua Emmanuel
Use BAII+ like Scientific Calculator – Order of Operations
0:43
Change decimal Places | TI BAII+ calculator
Joshua Emmanuel
Change decimal Places | TI BAII+ calculator
0:41
One-Tailed vs Two-Tailed Hypothesis Tests | 2-sided vs lower and upper tails
Joshua Emmanuel
One-Tailed vs Two-Tailed Hypothesis Tests | 2-sided vs lower and upper tails
3:41
ChatGPT in action: Solving stats problems with the help of artificial intelligence
Joshua Emmanuel
ChatGPT in action: Solving stats problems with the help of artificial intelligence
4:27
Simple Linear Regression Equation | Prediction in Excel or Google Sheet
Joshua Emmanuel
Simple Linear Regression Equation | Prediction in Excel or Google Sheet
0:36
Chi-Square Goodness-of-Fit Test
Joshua Emmanuel
Chi-Square Goodness-of-Fit Test
7:00
Multiple Regression | Coefficients – Interpretation, C.I, Hypothesis Testing
Joshua Emmanuel
Multiple Regression | Coefficients – Interpretation, C.I, Hypothesis Testing
8:06
P(A | B) means … #Shorts
Joshua Emmanuel
P(A | B) means … #Shorts
0:27
Multiple Regression | ANOVA Table | F-Test | R-square | Standard Error
Joshua Emmanuel
Multiple Regression | ANOVA Table | F-Test | R-square | Standard Error
4:05
Multiple Regression Output - Finding Missing Values (Excel)
Joshua Emmanuel
Multiple Regression Output - Finding Missing Values (Excel)
3:48
LP Blending Problem | Formulation + Solution | Product Mix Example
Joshua Emmanuel
LP Blending Problem | Formulation + Solution | Product Mix Example
4:55
p-Chart in Excel | Control Chart | LCL & UCL
Joshua Emmanuel
p-Chart in Excel | Control Chart | LCL & UCL
3:34
Solve Decision Tree for a bidding problem | Bid High or Low
Joshua Emmanuel
Solve Decision Tree for a bidding problem | Bid High or Low
4:18
BAII Plus Down Payment Questions | PV & PMT | Time Value of Money
Joshua Emmanuel
BAII Plus Down Payment Questions | PV & PMT | Time Value of Money
3:55
Decision Tree | Solved Problem | Bank: Loan vs Bonds
Joshua Emmanuel
Decision Tree | Solved Problem | Bank: Loan vs Bonds
6:51
Frequency, Proportion, Mean, Median, SD -Filter + SUBTOTAL in Excel
Joshua Emmanuel
Frequency, Proportion, Mean, Median, SD -Filter + SUBTOTAL in Excel
4:30
Frequency Distribution in Excel + Relative Frequency + Using FILTER
Joshua Emmanuel
Frequency Distribution in Excel + Relative Frequency + Using FILTER
2:17
Simplex Method 2 | Big M Tableau | Minimization Problem
Joshua Emmanuel
Simplex Method 2 | Big M Tableau | Minimization Problem
13:30
Intro to Simplex Method | Solve LP | Simplex Tableau
Joshua Emmanuel
Intro to Simplex Method | Solve LP | Simplex Tableau
12:40
Z-table | create your own standard normal distribution in Excel or Google Sheets
Joshua Emmanuel
Z-table | create your own standard normal distribution in Excel or Google Sheets
1:36
Chi-square table ( χ²) - create your own in Excel or Google Sheets
Joshua Emmanuel
Chi-square table ( χ²) - create your own in Excel or Google Sheets
1:09
F-table | How to create F Distribution in Excel or Google Sheets
Joshua Emmanuel
F-table | How to create F Distribution in Excel or Google Sheets
1:25
t-table | create your own in Excel or Google Sheets
Joshua Emmanuel
t-table | create your own in Excel or Google Sheets
1:15
Hypothesis test for Equality of Two Variances | F-test
Joshua Emmanuel
Hypothesis test for Equality of Two Variances | F-test
3:00