- Видео 10
- Просмотров 761 320
Maggie Winslow
США
Добавлен 9 дек 2015
Three Ways to Calculate Present Value (PV) in Excel
This video provides a simple example of how to calculate present value in Excel using =PV, using =NPV, and using the simple discounting formula.
Просмотров: 95 018
Видео
Very Simple Amortization Table in Excel
Просмотров 51 тыс.4 года назад
This short video shows how to easily create a simple amortization table in Excel.
Checking Normality of Data Using Mean Residuals Histogram - Example
Просмотров 3,1 тыс.4 года назад
This video shows two ways to create a histogram in Excel of mean residuals from a collection of small samples to see if the data is normal enough to conduct an ANOVA test. I know that I make a type in the end for the title of my graph.
Excel Solver Present Value Calculation Example
Просмотров 2 тыс.4 года назад
This video shows how to use Excel Solver to evaluate the different inputs in a present value calculation using a simple energy-using appliance (water heater) purchase decision.
Standard Deviation vs Standard Error Example
Просмотров 2,6 тыс.5 лет назад
This video uses Excel to illustrate how standard deviation and standard error differ. Tools used include a vlookup table and random numbers as well as what if analysis.
Break Even Analysis in Excel with Data Table
Просмотров 8 тыс.5 лет назад
This video shows how to do a simple break even analysis in Excel using the Data Table feature.
Paired t Test in Excel 2016
Просмотров 18 тыс.5 лет назад
This is a short video showing how to conduct a paired t test in Excel 2016.
Introduction to Monte Carlo Simulation in Excel 2016
Просмотров 344 тыс.5 лет назад
This video provides a simple introduction to how to run a Monte Carlo Simulation (MCS) in Excel. The example is for estimating profits given uncertainty in costs and revenue.
LCOE and Monte Carlo Simulation in Excel 2016
Просмотров 23 тыс.5 лет назад
This video provides an introduction to using Monte Carlo Simulation (MCS) to estimate the LCOE of a wind project.
Box and Whisker Plot Using Excel 2016
Просмотров 215 тыс.6 лет назад
This shows you how to make a Box and Whisker plot in Excel 2016 for Mac. There is now an automatic chart but these look nicer.
good and practical illustration, thank you
Good and practical illustration, thank you
HOW ABOUT EXTRA PAYMENT FOR EXAMPLE $1000 ON PRINCIPAL
Thank you. Good tutorial.
Thank you!
this is amazing and succinct. thank you!
Hi. Very nice tutorial. I have district wise immunization coverage for 60 months (5 yrs). Can I apply Monte Carlo to forecast the coverage for next year?
What to say or thank you for valuable information how to imply Monte Carlo method in Excel. Despite development of modern numerial and stohastiv methods with many desirable properties, most of hydraulic problems are based on Monte Carlo method BASED ON FINITE ELEMENT AND FINITE VOLUMEN APPROACH + adding yours Content we can assume many desirable concepts. Thank you for all good Excel workout!
Used your method of doing a box and whisker in my recent publication (In press). Thank you, this method rocks!
Thanks ma’am. Can you show manually how the amount is calculated?
Did you listen your video by yourself and can you hear it.
Hello If R is not giving how can we find PV ? If wacc can be used How can we calculate cost of equity if the company does not pay any dividends unless it generates revenue then we can use CAPM right then how can we find risk free of return and beta ?
Thanks you
Fantastic! Thank you very much Maggie for creating a clear and precise tutorial.
Thanks Maggie!
Thank you, very usefull and clearly explained!
not using discount rate?
Hi I'm having an issue at 2min 50sec. After you highlight, how do you command? I'm not sure if its a Mac issue but I can't seem to complete this part of the tutorial. Any help would be appreciated as this tutorial has been amazing so far.
BLESS YOU!!! THANK YOU SO MUCH
Thank you
this was super helpful! I was wondering what to do when you are given summary statistics and need to find the lower and upper confidence intervals?
The best explanation out there. Thank you
Great and simple explanation. Agree with some other comments on here that it's one of the most concise explanations I've seen on youtube and on hte internet.
thank you so much
「もっと多くの人が必要なので、このビデオをもっと
Wow you’re amazing - All this is a short straightforward video TYVM
Thank you very much
Nice!
Great job Maggie! You communicate in a very intelligent manner. Thank you.
What does CRF mean?
capital recovery factor
Best explanation for this I have found on RUclips, thank you. I even did a course where this was taught in an engineering risk analysis context- I did the thing but I didn't understand the nuts and bolts, whereas this explains it very clearly.
Thank you for the video
Hey! Great video! Is it possible I could change ten years into months and it wouldn’t effect anything?
Maggie, do you offer formal training? I found your approach easy to learn from.
amazing explanation! 😃
How come when i drag mine, nothing happens? Is something up with my settings.
Exactly what I was looking for. How to link the formula itself to what XL does. So thank you!
you are the best!! spent hours looking for an example and you are the only person that shows the difference between grabbing the sem from a sample of means or grabbing it from a single sample
That was very helpful. Thanks.
Thank you very much!!
the online version of 365 is extremely limited and doesnt even have the "Chart Design" tab needed to make the box plot. Great video tho
where is the "command" function she said in the video?
Very clear and easy to follow explanation. Thank you for putting this together.
Perfect! Exactly what I was looking for. Thank You!
good demonstration.
Very good and funny videos bring a great sense of entertainment!
How did you come up or find the standard diviation
Hi Maggie, On Risk of Loss, excel does not seem to read cell B12 when I use COUNTIF. It only gives me a % if I hardcode the mean number. Any ideas why that is?
Thank you
Very helpful, thank you!