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