• NumXL shopping Cart
  •  
    NumXL for Microsoft Excel makes sense of time series analysis:

    • Build, validate, rank models, and forecast right in Excel
    • Keep the data, analysis and models linked together
    • Make and track changes instantly
    • Share your results by sending just one file

    >>Read More


    | Free Trial
  • Home
  • Products
  • Tips & Demos
  • Support
    • Documentation
    • Blog
    • FAQ
    • Library
    • Service Level Agreement
    • Thank you
    • Beta Program
    • Resources
  • About Us
  • Prices
  •  
     

    Have a Question?

    Phone: +1 (888) 427-9486
    +1 (312) 257-3777
    Contact Us

    Home >> Support >> Documentation >> NumXL >> Reference Manual >> Utilities >> MV_OBS

    MV_OBS

    Calculates the number of non-missing observations in a data set (X and Y).

    Syntax

    MV_OBS(X, Mask, Y)

    X
    is the input (explanatory) variables of the data set (two dimensional array of cells, where each column corresponds to a variable).

    Mask
    is the boolean array to choose the input variables in the set. If missing, all variables in X are included.

    Y
    is the dependent variable data set (one dimensional array of cells).

    Remarks

    1. In case of a missing mask input, all variables in X are considered.
    2. In case the number of the size of the mask array is smaller than the number of variables in X, the array is appeded with ones to match X.
    3. In case the number of the size of the mask array is greater than the number of variables in X, the excess elements are dropped/ignored.

    Examples

    References

    • Hamilton, J .D.; Time Series Analysis , Princeton University Press (1994), ISBN 0-691-04289-6
    • Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0-471-690740

    External Links

    • What to do About Missing Values in Time Series Cross-Section Data , James Honaker and Gary King, American Journal of Political Science

    ‹ HASNAupMV_VARS ›

    • Download Sites - NumXL
    Try our full-featured product free for 14 days

    Download NumXL Free 30-day Trial

    Help desk

    Questions?
    Request a feature?
    Report an issue?

    » Go to your help desk «

    Or email us:
    support@numxl.com

    • NumXL 1.65 (HAMMOCK) Está Aquí!
      05/18/2017 - 21:31
    • NumXL 1.65 (HAMMOCK) is Here!
      05/18/2017 - 21:14
    • NumXL 1.64 (TURRET) is here
      12/25/2016 - 13:12

    ARIMA ARMA Forecast Getting Started goodness of fit LLF SARIMA scenario simulation statistical test tutorial user's guide
    more tags
     

    • Support
    • FAQ
    • Demos & Tutorials
    • Documentation
    • Help Desk

    • Resources
    • Order Help

    • About Spider
    • Contact Spider
    • Corporate Information
    • Legal Information
    • Partners

    Follow Us

    Contact | Glossary | Sitemap | Blog | Links
    © 2008-2018 Spider Financial | Disclaimer | Terms of Use | Privacy Policy | Trademarks & Copyrights