+ Reply to Thread
Results 1 to 1 of 1

Thread: Best Way to Format an Excel Data Sheet for export to R.

  1. #1
    Points: 7, Level: 1
    Level completed: 13%, Points required for next Level: 43

    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Best Way to Format an Excel Data Sheet for export to R.




    Hi.

    I am conducting a multiple linear regression using Panel data for my finance honours research project.
    I have collected data for 100 stocks each month over 13 years for 6/7 explanatory variables.
    I have attached my spreadsheet in this post.

    My question is as follows:

    What is the best way of formatting the data in this excel spreadsheet so it can be exported to R? I (think) I need to remove the company names (the ticker symbols) and the dates and organise the data per variable? What is the best way of formatting excel so it can be exported to R?
    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