Results 1 to 37 of 37

Creating a zero inflated poisson in excel

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-13-2016
    Location
    Kenya
    MS-Off Ver
    Excel 2010
    Posts
    321

    Creating a zero inflated poisson in excel

    In trying to develop a model in excel to predict football outcomes (1X2,Over/Under,Both Teams to Score/Both Teams not to score), I realized that the probability of draws and the probability of zero is underestimated when using Poisson Distribution. But after doing some search online, I kept coming across suggestions that using the zero-inflated Poisson can improve the accuracy of the results.

    Question:
    Is it possible to create a zero-inflated Poisson in Excel? I will appreciate all the help I can get.

    Attached is my workbook:

    Poisson.xlsxPoisson.xlsx

    Note: Data in workbook obtained from below website:

    https://www.sbo.net/strategy/footbal...-distribution/
    Last edited by gko_87; 05-22-2017 at 05:39 AM.
    OnditiGK

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. in excel there are function of POISSON, how can we use in access?
    By isaacwel01 in forum Access Tables & Databases
    Replies: 4
    Last Post: 10-30-2015, 12:12 PM
  2. [SOLVED] Bivariate Poisson VBA
    By clattenburg cake in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-24-2015, 10:30 PM
  3. Inflated Header - How do I get rid of it?
    By escadi in forum Excel General
    Replies: 5
    Last Post: 03-06-2014, 08:28 AM
  4. [SOLVED] Poisson distribution
    By hnasir in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-19-2012, 03:47 PM
  5. Poisson Distribution--Help
    By neocube in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2011, 07:24 AM
  6. modelling bivariate zero-inflated poisson
    By ryusukekenji in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2009, 05:41 PM
  7. File Size Inexplicably Inflated - 30 megs
    By Mark in forum Excel General
    Replies: 4
    Last Post: 04-14-2005, 01:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1