• 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
  • About Us
  • Prices
  •  
     

    Have a Question?

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

    Home >> tutorial

    tutorial

    X12-ARIMA in NumXL Techinal Note

    Starting with version 1.57, NumXL will support U.S. Census X12-ARIMA modeling including seasonal adjustment, trend filtering, and model identification and forecasting.

    In this paper, we will go over the approach followed by NumXL to implement this model. read more

    Regression stability Test

    This is the fourth entry in our regression analysis and modeling series. In this tutorial, we continue the analysis discussion we started earlier and leverage an advanced technique –regression stability test - to help us detect deficiencies in the selected model, and thus the reliability of the forecast.

    Again, we will use a sample data set gathered from 20 different sales persons. The regression model attempts to explain and predict weekly sales for each salesperson (dependent variable) using two explanatory variables: intelligence (IQ) and extroversion. read more

    Influential Data Analysis

    This is the third entry in our regression analysis and modeling series. In this tutorial, we continue the analysis discussion we started earlier by leveraging a more advanced technique – influential data analysis - to help us improve the model, and, as a result, the reliability of the forecast. read more

    Stepwise Regression in Excel

    This is the second entry in our regression analysis and modeling series. In this tutorial, we continue the analysis discussion we started earlier and leverage an advanced technique – stepwise regression - to help us find an optimal set of explanatory variables for the model. read more

    Kernel Density Estimation (KDE) Tutorial

    In this tutorial, we’ll carry on the problem of probability density function inference, but using another method: Kernel density estimation. read more

    Principal Component Analysis (PCA)

    Tutorial: principal component analysis in ExcelThis is the first entry in what will become an ongoing series on principal component analysis in Excel (PCA). In this tutorial, we will start with the general definition, motivation and applications of a PCA, and then use NumXL to carry on such analysis. Next, we will closely examine the different output elements in an attempt to develop a solid understanding of PCA, which will pave the way to a more advanced treatment in future issues. read more

    X-12-ARIMA

    In this tutorial, we’ll demonstrate the steps to compute seasonal adjusted time series using the functions NumXl and X12 ARIMAi in Excel. read more

    Module 3 - Smoothing

    In this module, we will walk you through time series smoothing in Excel using NumXL functions and tools. For sample data, we’ll use the S&P 500 weekly closing prices between January 2009 and July 2012. read more

    Generalized Linear Models (GLM)

    The generalized linear model (GLMi) is a flexible generalization of ordinary linear regression. By allowing the linear model to be related to the response variable via a link function, GLM in Excel generalizes linear regression. It also allows the magnitude of the variance of each measurement to be a function of its' predicted value. read more

    Forecasting

    To perform a forecast using NumXL, select the cell of the model's table (i.e. AirLine). Click on the "Forecast" icon in the toolbar. The forecast wizard will pop up. Select the realized observations (i.e. tail points of your sample data), and the forecast horizon in units of steps. read more

    123next ›last »

    • 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
     

    • 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