71 тысяч подписчиков
156 видео
How to fit an equation to data using Excel Solver
Fit an equation to data by minimizing mean squared error (MSE) using Excel Solver.
Linear Programming on Excel. A simple maximization problem
Calculating Free Cash Flow for Capital Budgeting Purposes
Quickly solving a linear programming problem on Excel
Linear Programming Word Problem Solved with Excel Solver
Calculate the Payback Period in 30 seconds!
Calculate MSE on Excel to diagnose forecast accuracy
Beta, the risk-free rate, and CAPM. Calculate the expected return of a security on Excel.
Calculate the standard deviation and expected value of a discrete probability distribution on Excel
An intuitive method for solving a simple linear programming problem on Excel using Solver
Calculate portfolio expected return and variance using Excel using a variance-covariance matrix
Maximize Profit with tiered profits depending on quantity
Calculate the Future Value (FV) of Uneven Cash Flows on Excel -- Two Methods
Portfolio variance-covariance matrix, return, and standard deviation for 3 securities on Excel.
Linear Programming on Excel - finding the feasible region
Calculating the Profitability Index (PI) on Excel.
What age to retire? Maximize your total inflation-adjusted retirement income using Excel
Excel Solver to Maximize Revenue in an Assignment Prob.
Use Excel to graph the efficient frontier of a three security portfolio
Create a new Excel function that easily calculates returns using the Lambda function.
Bulk Stock Price download, Variance-Covariance Matrix, and Portfolio Optimization with Excel
