Using the data: Summated Rating = Independent Variable; Cost = Dependent Variabl
ID: 3269841 • Letter: U
Question
Using the data:
Summated Rating = Independent Variable; Cost = Dependent Variable
a. What is an appropriate null hypothesis for Regression Analysis?
b. What is the test
statistic (F) for the regression?
c. What is the value for
Significance F
for the regression?
d. What is your conclusion concerning the null hypothesis? Reject / Not Reject?
e. What is the value of the R Square?
f. What is the value of Multiple R?
g. What is the value of the slope?
h. What is the value of the y intercept?
Location Cost Food Décor Service Summated Rating Coded Location Bins Midpoints Center City 29 20 13 18 51 0 9.99 15 Center City 29 22 14 18 54 0 19.99 25 Center City 88 26 25 25 76 0 29.99 35 Center City 58 24 17 23 64 0 39.99 45 Center City 29 22 17 16 55 0 49.99 55 Center City 62 20 19 21 60 0 59.99 65 Center City 64 24 24 22 70 0 69.99 75 Center City 65 22 23 22 67 0 79.99 85 Center City 54 25 22 22 69 0 89.99 95 Center City 29 22 16 18 56 0 99.99 Center City 36 24 15 20 59 0 Center City 78 22 22 19 63 0 Center City 45 20 18 17 55 0 Center City 40 21 19 19 59 0 Center City 67 24 23 22 69 0 Center City 49 24 20 17 61 0 Center City 33 21 18 19 58 0 Center City 83 25 20 22 67 0 Center City 76 24 23 25 72 0 Center City 63 22 18 22 62 0 Center City 29 20 15 16 51 0 Center City 32 21 12 21 54 0 Center City 60 23 23 20 66 0 Center City 22 21 13 18 52 0 Center City 40 21 14 19 54 0 Center City 63 21 24 22 67 0 Center City 45 22 14 20 56 0 Center City 56 23 20 22 65 0 Center City 76 24 23 20 67 0 Center City 64 24 23 21 68 0 Center City 50 17 21 19 57 0 Center City 99 22 25 21 68 0 Center City 48 20 15 19 54 0 Center City 56 23 20 21 64 0 Center City 34 22 11 19 52 0 Center City 59 21 20 20 61 0 Center City 69 18 24 19 61 0 Center City 53 27 15 21 63 0 Center City 71 25 15 23 63 0 Center City 69 23 16 20 59 0 Center City 35 23 13 19 55 0 Center City 56 19 22 19 60 0 Center City 40 21 12 17 50 0 Center City 75 25 24 24 73 0 Center City 43 22 16 18 56 0 Center City 93 25 21 23 69 0 Center City 46 24 19 20 63 0 Center City 72 23 27 22 72 0 Center City 95 27 26 27 80 0 Center City 57 24 22 23 69 0 Metro Area 63 27 19 22 68 1 Metro Area 62 21 16 18 55 1 Metro Area 30 22 15 17 54 1 Metro Area 51 23 19 22 64 1 Metro Area 58 23 15 19 57 1 Metro Area 47 25 20 22 67 1 Metro Area 36 20 15 18 53 1 Metro Area 26 21 15 17 53 1 Metro Area 14 21 9 15 45 1 Metro Area 25 23 17 20 60 1 Metro Area 38 26 18 20 64 1 Metro Area 43 22 16 20 58 1 Metro Area 22 21 15 19 55 1 Metro Area 44 22 21 21 64 1 Metro Area 44 20 19 20 59 1 Metro Area 23 22 12 16 50 1 Metro Area 39 24 20 21 65 1 Metro Area 32 23 17 20 60 1 Metro Area 29 19 13 17 49 1 Metro Area 25 24 12 17 53 1 Metro Area 52 22 20 21 63 1 Metro Area 47 22 18 21 61 1 Metro Area 44 21 18 21 60 1 Metro Area 59 21 18 18 57 1 Metro Area 21 22 16 18 56 1 Metro Area 31 22 16 18 56 1 Metro Area 43 23 15 21 59 1 Metro Area 53 26 19 23 68 1 Metro Area 53 21 19 20 60 1 Metro Area 25 20 16 19 55 1 Metro Area 52 26 22 22 70 1 Metro Area 54 22 18 18 58 1 Metro Area 26 22 18 23 63 1 Metro Area 49 25 21 22 68 1 Metro Area 48 24 20 22 66 1 Metro Area 29 21 17 18 56 1 Metro Area 31 22 22 18 62 1 Metro Area 36 23 19 20 62 1 Metro Area 31 22 8 15 45 1 Metro Area 54 24 21 20 65 1 Metro Area 29 24 13 19 56 1 Metro Area 41 23 17 20 60 1 Metro Area 26 23 16 19 58 1 Metro Area 21 23 12 15 50 1 Metro Area 36 25 22 24 71 1 Metro Area 24 24 14 18 56 1 Metro Area 33 23 24 20 67 1 Metro Area 50 26 19 22 67 1 Metro Area 68 27 27 26 80 1 Metro Area 37 26 18 22 66 1Explanation / Answer
Data tab -> Data analysis toolpack -> Regression -> ok.
a)The appropriate null hypothesis for the regression analysis y=a+bx (where y = cost and x = summated rating) is :
H0 : b = 0, i.e H0 : slope = 0.
b) Test statistic F = MSReg / MSE,
where MSReg = regression sum of squares / 1
and MSE = error sum of squares / 98.
Here, F ~ F;1,98.
Here calculated F = 102.3274491.
c)Significance F = 6.78926E-17.
d) Here calculated F > significance F, so we reject the null hypothesis.
e)R square = 0.510801
f) Multiple R = 0.714703
g)Slope coefficient = 1.86859.
h) y-intercept = -66.4171.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.