Results 1 to 14 of 14

Thread: Excel/numbers folks: I need halp

  1. #1
    Senior Member Zackk's Avatar
    Join Date
    Jan 2006
    Location
    Knoxville, Tennessee
    Posts
    10,110

    Excel/numbers folks: I need halp

    I'll try to make this brief. I've been doing research on suicide statistics over the past couple months. I'm doing this research for some very powerful elected officials, and if the math isn't accurate I'm screwed. To combat this, I'm going at the numbers from a few different angles to ensure accuracy and cover my ass.

    The math is simple. You take the number of suicides per county * 100,000, then divide that number by the County's population for that year. An example calculation would be (6 suicides * 100,000)/(55,000) to yield a rate of 10.9 Suicides per 100k people.

    I have this set up in excel (I'm using numbers on my mac), and in column B I have the raw suicide number. In column C I have the population. I basically need the write the simple equation to perform this simple math 66 times (66 counties in the state I'm doing research in). How do I go about doing this?

    Looks like this:

    X Parish | Raw Suicide | Total Pop |

    XYZ | 8 | 75215 |
    ABC | 27 | 112865 |



    See what I mean? I don't want to go through and punch in the calculations each time. I just want to create the formula, save it to hotkey Z or something, and pound out some numbers. I've search and searched and found nothing. A cookie for the winner.
    '10 Crystal Black Pearl Fit Sport 5MT
    '15 Mazda CX-5 GT AWD

  2. #2
    BOOM goes the dynamite! flipped cracka's Avatar
    Join Date
    Mar 2003
    Location
    in a van down by the rive
    Posts
    27,551
    =(B1*100000)/C1

    put that in the cell you want the total. then select it, go to the bottom right corner and drag down. it'll change the cell references for you.

    If your data start in the second row, just make them B2, C2.
    Last edited by flipped cracka; 04-27-12 at 01:31 PM.
    <- click me, i'm fun.

  3. #3
    Senior Member Zackk's Avatar
    Join Date
    Jan 2006
    Location
    Knoxville, Tennessee
    Posts
    10,110
    Quote Originally Posted by flipped cracka View Post
    =(B1*100000)/C1

    put that in the cell you want the total. then select it, go to the bottom right corner and drag down. it'll change the cell references for you.

    If your data start in the second row, just make them B2, C2.
    I might just be making a donation to your penis fund.

    Thanks a lot, broski.
    '10 Crystal Black Pearl Fit Sport 5MT
    '15 Mazda CX-5 GT AWD

  4. #4
    I got worms. 94civicEX's Avatar
    Join Date
    Jul 2000
    Location
    Utah
    Posts
    32,224
    Quote Originally Posted by flipped cracka View Post
    =(B1*100000)/C1

    put that in the cell you want the total. then select it, go to the bottom right corner and drag down. it'll change the cell references for you.

    If your data start in the second row, just make them B2, C2.
    I approve this message.
    99 Integra GSR
    06 TSX

    duck squad member #00003

  5. #5
    k three ifers k3ifers's Avatar
    Join Date
    Jun 2002
    Location
    Buffalo, NY
    Posts
    42,573
    damn, he beat me to the answer :o
    Nelson - "Keith, you're so cool!"

  6. #6
    The deer had to die! LT's Avatar
    Join Date
    Jun 2002
    Location
    Fussa, Japan
    Posts
    39,840
    I too had the answer.
    My sig was deleted?

  7. #7
    RB does men Skelly_GSR's Avatar
    Join Date
    Jan 2003
    Location
    Pittsburgh
    Posts
    11,990
    Quote Originally Posted by LT View Post
    I too had the answer.
    So did a 6 year old with common excel skills.

    No hate zackk :o

  8. #8
    Shake n Bake! DarkStarr's Avatar
    Join Date
    Feb 2006
    Location
    Pittsburgh, PA
    Posts
    11,757
    lulz

    too smart for his own good o:
    2007 Ducati 1098
    2011 Jeep GC Laredo

  9. #9
    Senior Member Zackk's Avatar
    Join Date
    Jan 2006
    Location
    Knoxville, Tennessee
    Posts
    10,110
    Alright, cacs. :o

    I've made my tables and now want to copy pasta my rates into a master sheet. When I go to copy it comes up blank, due to the variables in the math persistent to the location.

    What do.
    '10 Crystal Black Pearl Fit Sport 5MT
    '15 Mazda CX-5 GT AWD

  10. #10
    1991 Prelude Si 4WS
    Join Date
    Mar 2002
    Location
    Fremont, CA
    Posts
    457
    ='Sheet 2'!C2

    or whatever worksheet name and cell# you need

  11. #11
    Senior Member Zackk's Avatar
    Join Date
    Jan 2006
    Location
    Knoxville, Tennessee
    Posts
    10,110
    I figured it out.





    Dicks.
    '10 Crystal Black Pearl Fit Sport 5MT
    '15 Mazda CX-5 GT AWD

  12. #12
    k three ifers k3ifers's Avatar
    Join Date
    Jun 2002
    Location
    Buffalo, NY
    Posts
    42,573
    copy pasta
    Nelson - "Keith, you're so cool!"

  13. #13
    I got worms. 94civicEX's Avatar
    Join Date
    Jul 2000
    Location
    Utah
    Posts
    32,224
    Quote Originally Posted by Zackk View Post
    Alright, cacs. :o

    I've made my tables and now want to copy pasta my rates into a master sheet. When I go to copy it comes up blank, due to the variables in the math persistent to the location.

    What do.
    Paste Special; Values
    99 Integra GSR
    06 TSX

    duck squad member #00003

  14. #14
    The deer had to die! LT's Avatar
    Join Date
    Jun 2002
    Location
    Fussa, Japan
    Posts
    39,840
    I had the answer, but it was already said.
    My sig was deleted?

  15. #14
    Honda-Acura
    Honda S2000

    Honda-Acura

     

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
  •  

Honda and the Honda marquee are registered trademarks of the American Honda Motor Company, Inc. Neither American Honda Motor Company nor its subsidiaries or affiliates shall bear any responsibility for Honda-acura.net content, comments, or advertising. Honda-acura.net is not affiliated with American Honda Motor Company in any way. American Honda Motor Company does not sponsor, support, or endorse Honda-acura.net in any way. Copyright/trademark/sales mark infringements are not intended or implied.