+ Reply to Thread
Results 1 to 2 of 2

Thread: election statistics question

  1. #1
    Points: 4,931, Level: 44
    Level completed: 91%, Points required for next Level: 19

    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    election statistics question




    looking at the new jersey 2005 election... i want to see if counties with a higher percentage of "over 65" people correlate to either a higher dem or higher rep voting percentage. i have all the raw numbers, i am using excel. i might have just answered my own question, do i use correlation function? but i'd like an explanation of the math behind whatever function it is that i should use. i took intro to stats a few years ago.

  2. #2
    TS Contributor
    Points: 17,636, Level: 84
    Level completed: 58%, Points required for next Level: 214
    JohnM's Avatar
    Posts
    1,948
    Thanks
    0
    Thanked 6 Times in 5 Posts

    Ben,

    In order to use the CORREL function (correlation function in Excel), make sure that you have two columns of data, with each row representing a county:

    column 1 --> for each county, the percentage of voters over 65 years of age
    column 2 --> for each county, the percentage of democrat votes

    Assuming %dem + %repub = 1, it would be redundant to have a third column with % republican votes.

    The CORREL function will tell you an index of the strength of the relationship between the two variables, from -1 (strong negative relationship) to +1 (strong positive relationship). Close to 0 indicates little if any relationship.

    If you square the result from CORREL, you get the coefficient of determination, or the percentage of variance in one variable "explained" by the variance in the other.

    There are a whole slew of sites that go into regression / correlation in detail. A good one is HyperStat (ch 15):

    http://davidmlane.com/hyperstat/

+ Reply to Thread

           




Similar Threads

  1. Can stats solve this local election question?
    By WendyE in forum Statistics
    Replies: 3
    Last Post: 03-07-2010, 05:47 PM
  2. Setting up a database for election results
    By ajb1970 in forum Statistics
    Replies: 5
    Last Post: 11-17-2009, 05:25 PM
  3. election question
    By 99.nine in forum Statistics
    Replies: 0
    Last Post: 05-27-2008, 05:14 PM
  4. Election year and market performance
    By karate718 in forum Statistics
    Replies: 0
    Last Post: 01-15-2008, 11:41 AM
  5. Results of election
    By joejohn in forum Statistics
    Replies: 1
    Last Post: 10-27-2006, 05:15 PM

Posting Permissions

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






Advertise on Talk Stats