Results 1 to 2 of 2

Thread: Multiple regression - data organization

  1. #1 Multiple regression - data organization 
    Forum Freshman
    Join Date
    Mar 2012

    I need to setup multiple regression model for estimating trousers' prices based on their attributes. I have data for period 2001-2005 for 130 trousers. Not all of the trousers were available during this period. I also need to include GDP in the model for every observed year.

    I'm confused with this: e.g. trousers A were available in year 2001 and 2002 and trousers B in 2002 and 2003. I have columns in Excel designating all relevant attributes and GDP for certain year for every trousers. GDP was different for every year.

    How should I organize the best my data in Excel in order to perform regression? Should I first enter the data for for all available trousers models in 2001 with corresponding GDP (last column), and then data below for 2002 with corresponding GDP, etc.?

    I mean domething like this:

    Model | Year | Attribute1 | GDP
    AAAAA | 2001 | aaaaaaaa | 2,000,000
    BBBBB | 2001 | bbbbbbbb | 2,000,000
    AAAAA | 2002 | aaaaaaaa | 2,500,000
    BBBBB | 2002 | bbbbbbbb | 2,500,000

    Many thanks.


    Reply With Quote  


  3. #2  
    Forum Freshman Anathema's Avatar
    Join Date
    Mar 2014
    I honestly have no idea... but I'm very curious to find out whether GDP is correlated with any of the trouser attributes

    Reply With Quote  

Similar Threads

  1. Confounders in multiple regression (SPSS)
    By isdatzo in forum Mathematics
    Replies: 0
    Last Post: March 12th, 2014, 11:19 AM
  2. Replies: 0
    Last Post: December 23rd, 2011, 10:30 AM
  3. Research Organization- Help!
    By TexasTechRaider in forum Earth Sciences
    Replies: 0
    Last Post: December 14th, 2011, 09:57 PM
  4. Please hlep me in (Data preparation for data mining )
    By nadia in forum Computer Science
    Replies: 3
    Last Post: December 22nd, 2008, 02:56 PM
  5. Perceptual organization
    By randynewman666 in forum Behavior and Psychology
    Replies: 3
    Last Post: August 31st, 2008, 12:18 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