Excel Problem Solver: Detect Fraud Using a Spreadsheet and Benford's Law

Поделиться
HTML-код
  • Опубликовано: 4 янв 2025

Комментарии • 59

  • @zackone6829
    @zackone6829 4 года назад +6

    Hey Geek! I just watched your video, amazing. Very informative and easy to follow. Many thanks.

  • @midlifecrisis920
    @midlifecrisis920 Год назад +1

    What a detailed explanation. Loved it!!

  • @thuglifebear5256
    @thuglifebear5256 4 года назад +20

    LOL this guy should jump on that Milwaukee/Philadelphia data ASAP, cos the media _definitely_ isn't gonna do it.

    • @magicskyfairy69
      @magicskyfairy69 4 года назад +5

      they'll never give him the data - none of us will ever get it, we'll just be told "Biden won" by the media, "and COPE! you lost fair and square! stop crying!" by the liberals.

    • @thelonecabbage7834
      @thelonecabbage7834 4 года назад +3

      @@magicskyfairy69 You mean the data that's publicly available at elections.wi.gov and electionreturns.pa.gov? Fool.

    • @magicskyfairy69
      @magicskyfairy69 4 года назад

      @@thelonecabbage7834 you're going to need a hell of a lot more than that to prove wrongdoing.

    • @thelonecabbage7834
      @thelonecabbage7834 4 года назад +3

      @@magicskyfairy69 I don't think you understood what I posted...

    • @coolpeopleit
      @coolpeopleit 4 года назад

      @@thelonecabbage7834 I am trying to find election results on the 2 sites you linked, but neither seem to have presidential results on them. The Wisconsin website only has results data up to August for the special election, and the PA website brings me to a page on 'ELECTION AND VOTER REGISTRATION QUESTIONS' whenever I click on the show election results button. I assume this a user based problem, could you direct me further?

  • @saurabh_arora
    @saurabh_arora Год назад +2

    Awesome explanation! 👍 I just want to ask how did you get that +/-(1/2n) in the formula of confidence interval? Does it really matter in case of a large sample size?

  • @carlosrvillegaschazaro1092
    @carlosrvillegaschazaro1092 4 года назад

    good video and good music at the end !!

  • @sachinsharma-de3vj
    @sachinsharma-de3vj 3 года назад +1

    can someone explain the upper and lower limit formula?
    Confidence Interval also have Std Deviation component, where in this formula it's gets incorporated??

  • @sophia212
    @sophia212 10 месяцев назад

    Hello, I am doing a report on Benford's Law that has to be 12 pages for highschool. Where did you get the trasaction amounts (the 6000 numbers) from? Are those able to be sent to me or is there a place where I can find them? I want to do a similar test to prove that Benford's law works to detect fraud. Thank you!

    • @spreadsheetgeek4070
      @spreadsheetgeek4070  10 месяцев назад

      Basically, I made up the data using random number generation then skewed it in the direction I wanted to simulate a single cashier who should be focused on.

  • @spreadsheetgeek4070
    @spreadsheetgeek4070  4 года назад +19

    If I was looking for election fraud I'd focus on precincts that saw a dramatic increase in turnout compared to 2016 and/or a dramatic shift in D/R vote %.

    • @doombybbr
      @doombybbr 4 года назад +3

      If I had the data I would actually go so far as to plot all previous vote % on each state and use that to find the standard deviation.
      Then apply benford to everywhere that sticks out.

    • @billyumbraskey8135
      @billyumbraskey8135 4 года назад

      ok, cool, please do. archive.is/JzxvI

    • @doombybbr
      @doombybbr 4 года назад

      @@billyumbraskey8135 Unfortunately, I am not a whiz at computers and have no idea how to handle files of those data types.

    • @jd8122
      @jd8122 4 года назад

      ruclips.net/video/7uhAn19V1EY/видео.html&ab_channel=RobertA.Bonavito%2CCPA

    • @thecommonsenseconservative5576
      @thecommonsenseconservative5576 4 года назад +1

      What if I find an influx of votes at the rate of 119,221 in 2 hours and 22 minutes but can't really tell who they were for. Even though the max vote tabulation per 13 hour day is 104,000. This is for Maricopa county in AZ

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

    Wonderful demo - would it be possible for you to share the excel template for educational purpose? Thanks

    • @spreadsheetgeek4070
      @spreadsheetgeek4070  3 года назад +1

      Please send an email with that request to sheettutor@gmail.com. Thanks.

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

    Make the countif criteria dynamic, have it refer to that cell.

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

    Can Benford's law be assistive in investigating fraud cases where fraudsters misused the Covid relief funds? Is there a pattern observed in cases already investigated?

  • @jeffgustafson4552
    @jeffgustafson4552 4 года назад

    So would a 300 mile river and a 3,000 mile river be in the same column?

    • @patstanton1885
      @patstanton1885 4 года назад

      Yes. The first digit is a 3 in both cases.

  • @harumih.3727
    @harumih.3727 Год назад +1

    I don't think that using "=1" is effective way because every time, you entered "=1" you have to change it to "=2" and "=3" etc. which is much time-consuming. I think that using a reference of the cell is more efficient. For example, when you are calculating the COUNT for the cell with a value of 1, you just simply reference a cell where "1" is entered. Then, for the cell below, simply copy the above formula, changing automatically the above referenced cell the next reference. I tested it myself. Instead of "=1" I entered "E3". Excel formula accordingly search the reference E3 to find the value, for example, and the next formula down the row of 4, Excel searches a value in the cell E4. This way, you wouldn't need to spend time to replace 1 with 2, and with 3, and with 4, and so on.

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

    Great!

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

    Can I buy this spreadheet from you? :)
    I dont have time, really..
    Or share pls

  • @juggernaut316
    @juggernaut316 4 года назад +4

    Why won't RUclips let me like the video?

  • @Kayne1b
    @Kayne1b 4 года назад +2

    SIMULATION CONFIRMED

  • @1234fsdfdsf
    @1234fsdfdsf 3 года назад

    Countif needs to be easier

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

    I am here after Netflix documentary