Maggie Winslow
Maggie Winslow
  • Видео 10
  • Просмотров 761 320
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.

Комментарии

  • @SANBANATHAN
    @SANBANATHAN Месяц назад

    good and practical illustration, thank you

  • @SANBANATHAN
    @SANBANATHAN Месяц назад

    Good and practical illustration, thank you

  • @jonpolio9475
    @jonpolio9475 Месяц назад

    HOW ABOUT EXTRA PAYMENT FOR EXAMPLE $1000 ON PRINCIPAL

  • @iyalmelan
    @iyalmelan 3 месяца назад

    Thank you. Good tutorial.

  • @lone9585
    @lone9585 4 месяца назад

    Thank you!

  • @Frank-mz3dh
    @Frank-mz3dh 8 месяцев назад

    this is amazing and succinct. thank you!

  • @deepaktimsina111
    @deepaktimsina111 11 месяцев назад

    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?

  • @ANJA-mj1to
    @ANJA-mj1to 11 месяцев назад

    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!

  • @Ardyrobeats
    @Ardyrobeats Год назад

    Used your method of doing a box and whisker in my recent publication (In press). Thank you, this method rocks!

  • @cradleofrelaxation6473
    @cradleofrelaxation6473 Год назад

    Thanks ma’am. Can you show manually how the amount is calculated?

  • @adamadam3718
    @adamadam3718 Год назад

    Did you listen your video by yourself and can you hear it.

  • @wafamk4565
    @wafamk4565 Год назад

    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 ?

  • @Inlearningmode
    @Inlearningmode Год назад

    Thanks you

  • @serkankaraman1711
    @serkankaraman1711 Год назад

    Fantastic! Thank you very much Maggie for creating a clear and precise tutorial.

  • @1MRNICKER
    @1MRNICKER Год назад

    Thanks Maggie!

  • @junal27
    @junal27 Год назад

    Thank you, very usefull and clearly explained!

  • @indian_scouser_ynwa
    @indian_scouser_ynwa Год назад

    not using discount rate?

  • @bboyrickoshea
    @bboyrickoshea Год назад

    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.

  • @QueenChanise
    @QueenChanise Год назад

    BLESS YOU!!! THANK YOU SO MUCH

  • @WealthyTurtl
    @WealthyTurtl Год назад

    Thank you

  • @auniedegroot4351
    @auniedegroot4351 2 года назад

    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?

  • @Eng_Kitumesh
    @Eng_Kitumesh 2 года назад

    The best explanation out there. Thank you

  • @TexasBluePatriot
    @TexasBluePatriot 2 года назад

    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.

  • @stellaunya5192
    @stellaunya5192 2 года назад

    thank you so much

  • @kirtikhemka2918
    @kirtikhemka2918 2 года назад

    「もっと多くの人が必要なので、このビデオをもっと

  • @delicious9930
    @delicious9930 2 года назад

    Wow you’re amazing - All this is a short straightforward video TYVM

  • @peakfeeling7311
    @peakfeeling7311 2 года назад

    Thank you very much

  • @jiabinchen1934
    @jiabinchen1934 2 года назад

    Nice!

  • @JSark-by2ts
    @JSark-by2ts 2 года назад

    Great job Maggie! You communicate in a very intelligent manner. Thank you.

  • @powervictory8819
    @powervictory8819 2 года назад

    What does CRF mean?

  • @MrSeropamine
    @MrSeropamine 2 года назад

    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.

  • @DanaJomaa
    @DanaJomaa 2 года назад

    Thank you for the video

  • @simulation001
    @simulation001 2 года назад

    Hey! Great video! Is it possible I could change ten years into months and it wouldn’t effect anything?

  • @Gracethedog101
    @Gracethedog101 2 года назад

    Maggie, do you offer formal training? I found your approach easy to learn from.

  • @tomatosquare4012
    @tomatosquare4012 2 года назад

    amazing explanation! 😃

  • @OriginalPrincess32
    @OriginalPrincess32 2 года назад

    How come when i drag mine, nothing happens? Is something up with my settings.

  • @suzannebernard4014
    @suzannebernard4014 2 года назад

    Exactly what I was looking for. How to link the formula itself to what XL does. So thank you!

  • @clipdat345
    @clipdat345 2 года назад

    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

  • @MrGroganmeister
    @MrGroganmeister 2 года назад

    That was very helpful. Thanks.

  • @naskkal4047
    @naskkal4047 2 года назад

    Thank you very much!!

  • @asheshsamaroo6220
    @asheshsamaroo6220 2 года назад

    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

  • @asheshsamaroo6220
    @asheshsamaroo6220 2 года назад

    where is the "command" function she said in the video?

  • @joerinaldi3418
    @joerinaldi3418 2 года назад

    Very clear and easy to follow explanation. Thank you for putting this together.

  • @tomwells936
    @tomwells936 2 года назад

    Perfect! Exactly what I was looking for. Thank You!

  • @laskuri1393
    @laskuri1393 2 года назад

    good demonstration.

  • @khanhlinhho8459
    @khanhlinhho8459 2 года назад

    Very good and funny videos bring a great sense of entertainment!

  • @appknow8253
    @appknow8253 3 года назад

    How did you come up or find the standard diviation

  • @jj-wz1im
    @jj-wz1im 3 года назад

    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?

  • @sidharthmohanty6434
    @sidharthmohanty6434 3 года назад

    Thank you

  • @_alexambroz
    @_alexambroz 3 года назад

    Very helpful, thank you!