Notices
Results 1 to 2 of 2

Thread: Multiple regression - data organization

  1. #1 Multiple regression - data organization 
    Forum Freshman
    Join Date
    Mar 2012
    Posts
    29
    Hello,

    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.

    John


    Reply With Quote  
     

  2.  
     

  3. #2  
    Forum Freshman Anathema's Avatar
    Join Date
    Mar 2014
    Posts
    31
    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, 09:30 AM
  3. Research Organization- Help!
    By TexasTechRaider in forum Earth Sciences
    Replies: 0
    Last Post: December 14th, 2011, 08: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, 01:56 PM
  5. Perceptual organization
    By randynewman666 in forum Behavior and Psychology
    Replies: 3
    Last Post: August 31st, 2008, 12:18 PM
Bookmarks
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
  •