Fox Module 12: Statistical inference for multiple regression HW


Fox Module 12: Statistical inference for multiple regression HW

Author
Message
Jeffryfl
Junior Member
Junior Member (10 reputation)Junior Member (10 reputation)Junior Member (10 reputation)Junior Member (10 reputation)Junior Member (10 reputation)Junior Member (10 reputation)Junior Member (10 reputation)Junior Member (10 reputation)Junior Member (10 reputation)

Group: Forum Members
Posts: 11, Visits: 1
Im not really sure how to do part D. Is it different than part A? With the information given, I just dont understand
smh1021
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Posts: 9, Visits: 1

When looking for the p-value for the F-statistic, do you use the p-value column in Excel that corresponds to the intercept, x1, or x2 or do you use the cell labeled Significance F?


lms0123
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: Forum Members
Posts: 6, Visits: 46
I am using Excel's Toolpack Regression data analysis tool and the "Observations" are one less than the actual. I tried using it on this homework as well as Module 11 and I am not getting the correct results. Has anyone else had this problem? I'm worried because the next module specifically states to use software to run the regression and I'm afraid my results will not be correct.

EDIT: Nevermind the header needs to be included.
Edited 12 Years Ago by lms0123
Adversely Selected
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: Forum Members
Posts: 2, Visits: 38
I'm not sure what others have done, but this is what I did:

For part B I used what I got in excel from homework 9:
TSS = 59.8696
RegSS = 52.1604
RSS = 7.7092

C: df for RSS = 7, df for RegSS = 2

D: F0 = (RegSS/2) / (RSS/7) = 23.681

E: using excel =FDIST(23.681,2,7) = 0.000766
GO
Merge Selected
Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

  • Login with twitter
  • Login with twitter
Select a Forum....







































































































































































































































Neas-Seminars

Search