+ Reply to Thread
Results 1 to 10 of 10

Thread: I need help with my regression analysis for research capstone.

  1. #1
    Points: 146, Level: 2
    Level completed: 92%, Points required for next Level: 4

    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Unhappy I need help with my regression analysis for research capstone.




    Hi all,

    I'm new to regressions and also new to posting here.

    My topic is: How have E-books Affected College Textbook Prices?

    My hypothesis is:
    H0: The CPI for college textbooks will fall with the introduction of the e-book because increased innovation and competition causes an increase in supply causing prices to fall.

    H1: The CPI for college textbooks is unaffected by the introduction of the e-book.
    (I can change my alternative and probably will since my r2 is >80% as of now...)

    I have basically no idea how to do regressions so I used a online helper and I came up with this:

    My dependent variable (x) is the CPI for College Textbooks by the BLS from 2001 to 2016 separated by year.

    My independent variable (y) is the # of ebooks sold from 2001 to 2016 separated by year.

    Which gave me these results:

    Name:  Screen Shot 2017-03-22 at 1.26.56 PM.jpg
Views: 73
Size:  9.4 KB


    What I'm trying to figure out is what does all of this mean? My p val is <.0001 which is good I think but I need help putting what all of this info means in words?

    Also, I have other variable (control variables I'm guessing?) such as the Consumer Price Index for College Tuition and Fees, GDP, and Higher ED Enrollment among other things and I want them to be a part of the regression. The prob is I don't know how to add them into it!!!

    Any help is appreciated.

    Thank you so much an advance!

    PS I have the data in excel and can include also.

  2. #2
    TS Contributor
    Points: 14,811, Level: 78
    Level completed: 91%, Points required for next Level: 39
    Miner's Avatar
    Location
    Greater Milwaukee area
    Posts
    1,171
    Thanks
    34
    Thanked 405 Times in 363 Posts

    Re: I need help with my regression analysis for research capstone.

    The null hypothesis would be no relationship between x and y. The alternate hypothesis is that there is a relationship between x and y. The p-value is the probability that you would see these results assuming the null hypothesis is true. A p-value of <0.0001 would be extremely unlikely, so you would reject the null hypothesis in favor of the alternate that there is a relationship between x and y.

  3. The Following User Says Thank You to Miner For This Useful Post:

    tlowe (03-22-2017)

  4. #3
    Points: 146, Level: 2
    Level completed: 92%, Points required for next Level: 4

    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: I need help with my regression analysis for research capstone.

    Does any of that make sense? I don't even know if I set up my regression right. Can we email or something I can't DM!

  5. #4
    TS Contributor
    Points: 18,889, Level: 87
    Level completed: 8%, Points required for next Level: 461
    CowboyBear's Avatar
    Location
    New Zealand
    Posts
    2,062
    Thanks
    121
    Thanked 427 Times in 328 Posts

    Re: I need help with my regression analysis for research capstone.

    I've deleted OP's duplicate post.
    Matt aka CB | twitter.com/matthewmatix

  6. #5
    Points: 1,741, Level: 24
    Level completed: 41%, Points required for next Level: 59

    Posts
    230
    Thanks
    37
    Thanked 68 Times in 59 Posts

    Re: I need help with my regression analysis for research capstone.

    Quote Originally Posted by Miner View Post
    The null hypothesis would be no relationship between x and y. The alternate hypothesis is that there is a relationship between x and y. The p-value is the probability that you would see these results or more extreme results assuming the null hypothesis is true. A p-value of <0.0001 would be extremely unlikely, so you would reject the null hypothesis in favor of the alternate that there is a relationship between x and y.
    Only added a few words to your post

  7. The Following User Says Thank You to ondansetron For This Useful Post:

    Miner (03-23-2017)

  8. #6
    TS Contributor
    Points: 14,811, Level: 78
    Level completed: 91%, Points required for next Level: 39
    Miner's Avatar
    Location
    Greater Milwaukee area
    Posts
    1,171
    Thanks
    34
    Thanked 405 Times in 363 Posts

    Re: I need help with my regression analysis for research capstone.

    Quote Originally Posted by tlowe View Post
    Also, I have other variable (control variables I'm guessing?) such as the Consumer Price Index for College Tuition and Fees, GDP, and Higher ED Enrollment among other things and I want them to be a part of the regression. The prob is I don't know how to add them into it!!!

    PS I have the data in excel and can include also.
    If you are trying to use Excel for your analysis, I believe that it can only handle one IV at a time. Do you have access to any statistical software?

    Attaching data is always helpful.

  9. #7
    Points: 146, Level: 2
    Level completed: 92%, Points required for next Level: 4

    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: I need help with my regression analysis for research capstone.

    Quote Originally Posted by Miner View Post
    If you are trying to use Excel for your analysis, I believe that it can only handle one IV at a time. Do you have access to any statistical software?

    Attaching data is always helpful.
    Thank you for the response!

    I have SAS University on my computer but not sure how to put this data into it.

    I have attached my dataset as well. CPI text is my dependent and # of ebooks in mill is my independent. I just want to make sure I ran the regression right.

    Also, I want to be able to add in those other datasets too but I also have no idea how!

    Any help is awesome... Thanks!

    TANNERDATA1.xlsx

  10. #8
    Points: 146, Level: 2
    Level completed: 92%, Points required for next Level: 4

    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: I need help with my regression analysis for research capstone.

    Moderator has to approve my post?

  11. #9
    Points: 1,741, Level: 24
    Level completed: 41%, Points required for next Level: 59

    Posts
    230
    Thanks
    37
    Thanked 68 Times in 59 Posts

    Re: I need help with my regression analysis for research capstone.

    Quote Originally Posted by Miner View Post
    If you are trying to use Excel for your analysis, I believe that it can only handle one IV at a time. Do you have access to any statistical software?

    Attaching data is always helpful.
    Although I would recommend an actual stats package also, I just double checked to confirm that Excel can handle multiple IVs. For the X-variable range, just highlight the entire matrix of x-values and it will take each column in the range as it's own variable.

  12. The Following User Says Thank You to ondansetron For This Useful Post:

    Miner (03-23-2017)

  13. #10
    Points: 146, Level: 2
    Level completed: 92%, Points required for next Level: 4

    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: I need help with my regression analysis for research capstone.


    Here is the data and what I came up with....

    If someone could check it and let me know what I did wrong that would be great.

    My dependent variable (x) is the CPI for College Textbooks by the BLS from 2001 to 2016 separated by year.

    My independent variable (y) is the # of ebooks sold (in millions) from 2001 to 2016 separated by year.


    New hypothesis:

    H0: The CPI for college textbooks is unaffected by the introduction of the e-book.

    H1: The CPI for college textbooks will fall with the introduction of the e-book because increased innovation and competition causes an increase in supply causing prices to fall.

    Click image for larger version

Name:	Screen Shot 2017-03-22 at 1.26.56 PM.jpg
Views:	8
Size:	9.4 KB
ID:	6538

    TANNERDATA1.xlsx

+ Reply to Thread

           




Tags for this 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