+ Reply to Thread
Results 1 to 5 of 5

Thread: Multiple Regression Equation Analysis for Percentage?

  1. #1
    Points: 13, Level: 1
    Level completed: 25%, Points required for next Level: 37

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Multiple Regression Equation Analysis for Percentage?




    Hi,

    I am hoping someone can help me understand something. I have the following multiple regression equation (note thse numbers are just an example and not the actual equation).

    Forecasted sales = 2000+17(x1)+65(X2)-34(x3)

    Sales is forecasted in 1000's.

    x1 = sq feet
    x2 = % of people with no cars
    x3 = gender

    my values are:

    x1 = 120
    x2 = 44%
    x3 = male (0)

    My problem is i don't understand how i can use the % of people with no cars in this equation? Would I do .65(.44) or would it be 65%(44%)? I understand that we are saying for each additional percentage we can expect sales to increase by 65%. Can someone please help me understand how to figure this out?

    Thank you.

  2. #2
    Devorador de queso
    Points: 95,819, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    Posting AwardCommunity AwardDiscussion EnderFrequent Poster
    Dason's Avatar
    Location
    Tampa, FL
    Posts
    12,935
    Thanks
    307
    Thanked 2,629 Times in 2,245 Posts

    Re: Multiple Regression Equation Analysis for Percentage?

    Please only post a topic once. I deleted your other thread. Thank you.
    I don't have emotions and sometimes that makes me very sad.

  3. #3
    Points: 13, Level: 1
    Level completed: 25%, Points required for next Level: 37

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Multiple Regression Equation Analysis for Percentage?

    Sorry about that, I posted in the other thread and then realized there was a sep. regression thread. My apologies.

  4. #4
    Devorador de queso
    Points: 95,819, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    Posting AwardCommunity AwardDiscussion EnderFrequent Poster
    Dason's Avatar
    Location
    Tampa, FL
    Posts
    12,935
    Thanks
    307
    Thanked 2,629 Times in 2,245 Posts

    Re: Multiple Regression Equation Analysis for Percentage?

    No worries.

    To answer your question... we can't answer your question. It entirely depends on if the variable was coded with 44% as .44 or if it was coded as 44 when the model was fit. This isn't information we have. Regardless the 66 will stay as a 66 though so it will either be 66*(.44) or 66*(44)

    My guess would be that it was coded with 44% as 44 though.
    I don't have emotions and sometimes that makes me very sad.

  5. The Following User Says Thank You to Dason For This Useful Post:

    abe333200 (11-02-2013)

  6. #5
    Points: 13, Level: 1
    Level completed: 25%, Points required for next Level: 37

    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Multiple Regression Equation Analysis for Percentage?


    I attached my actual data, I apologize I should have done this before but I wasn't sure if it was frowned upon. Was my interpretation for that variable correct? For each additional percentage we would expect sales to increase by 65%? The reason I ask is because when solving my equation I'm not sure if I should simply add up my data and that is my forecasted sales, or if I should add up my data excluding the percentage, then multiply my forecasted sales by that percentage, and add that amount to my sales. Thanks again for the help I really appreciate it.
    Attached Files

+ Reply to Thread

           




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