How does SIPmath work?

NOTE: To experiment with the Excel examples below, you will need to Enable Content, if asked, and make sure that Excel is in Automatic Calculation mode. The first Excel example requires Excel 2010 or later. The following models below require 2007 or later.

 

SIPmath™ Part 1: Calculating with Uncertainties

                                Screenshot of the Excel example               Download  the Sparkland demonstration of SIPmath

                              Screenshot of the Excel example

           Download the Sparkland demonstration of SIPmath

SIPmath™ Part 2: The Model that Launched 1,000 Mutual Funds

                                 Screenshot of the Excel example                          Download  the SIP math Portfolio model

                               Screenshot of the Excel example

                      Download the SIP math Portfolio model

SIPmath™ Part 3: It's Done with Data Tables

                                Screenshot of the Excel example            Download  the model with two SIPs of 100,000 numbers

                              Screenshot of the Excel example

        Download the model with two SIPs of 100,000 numbers

SIPmath™ Part 4: More SIP math Examples (Central Limit Theorem, Lognormal distribution)

                                 Screenshot of the Excel example                                 Download  the SIP math Tutorial

                               Screenshot of the Excel example

                             Download the SIP math Tutorial