Question

In: Statistics and Probability

Final_exam assignment_grade Tutorial_attend 100 90 5 100 75 5 90 75 5 85 85 5 85...

Final_exam assignment_grade Tutorial_attend
100 90 5
100 75 5
90 75 5
85 85 5
85 100 5
80 95 5
70 80 5
60 95 5
60 80 5
55 95 5
55 25 4
50 80 5
45 90 5
40 65 5
40 65 4
35 0 3
30 70 4
30 55 4
25 85 5
25 90 4
15 5 3
15 80 5
15 50 5
15 45 3
5 75 3
5 70 4
100 100 5
95 75 5
90 100 5
85 85 5
80 95 5
70 45 5
70 100 5
65 90 5
60 100 5
55 65 4
55 90 5
55 80 4
50 50 5
45 50 4
45 75 3
40 75 5
40 70 5
35 90 4
30 95 5
30 55 5
25 75 4
25 20 3
25 65 2
15 60 4
15 60 4
15 80 5
10 55 4
10 80 2
0 0 2
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.612917385
R Square 0.375667721
Adjusted R Square 0.351654941
Standard Error 22.82783542
Observations 55
ANOVA
df SS MS F Significance F
Regression 2 16305.00365 8152.501823 15.64449105 4.79524E-06
Residual 52 27097.72363 521.1100697
Total 54 43402.72727
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -35.7528379 15.54695813 -2.299667729 0.025513459 -66.95009176 -4.555584041 -66.95009176 -4.555584041
assignment_grade 0.218051561 0.153416203 1.421307252 0.161197169 -0.089800572 0.525903695 -0.089800572 0.525903695
Tutorial_attend 15.33752081 4.29606168 3.570135151 0.000778134 6.716842368 23.95819925 6.716842368 23.95819925

7. Using your multiple regression results to predict Final_exam for a student with the mean assignment_grade and tutorial_attend equal to (i) 2 tutorials, (ii) 3, (iii) 4 and (iv) 5 tutorials. (Hint this means you will have 4 distinct predictions for Final_exam) Carefully interpret your results.

Solutions

Expert Solution

In order to predict finall exaam score we need value of assignment grade and tutorial attend. Here you provide values for tutorial attend. So we cant predict the finall exaam score.

We can only predict the effect of tutorial attended on finall exaam score.

i. For 2 tutorials:

Finall exaam score is on an average increased by 15.34 * 2= 30.68 if a student attend 2 tutorials while the assignment grades are keep constant.

ii. For 3 tutorials:

Finall exaam score is on an average increased by 15.34 * 3= 46.02  if a student attend 3 tutorials while the assignment grades are keep constant.

iii. For 4 tutorials:

Finall exaam score is on an average increased by 15.34 * 4= 61.36 if a student attend 4 tutorials while the assignment grades are keep constant.

iv. For 5 tutorials:

Finall exaam score is on an average increased by 15.34 * 5 = 76.7 if a student attend 5 tutorials while the assignment grades are keep constant.


Related Solutions

Temperature (x) 65 70 75 80 85 90 95 100 105 Number of ice cream cones...
Temperature (x) 65 70 75 80 85 90 95 100 105 Number of ice cream cones sold per hour (y) 8 10 11 13 12 16 19 22 23 Calculate the linear correlation coefficient r, for temperature (x) and number of ice cream cones sold per hour (y). (round to 3 decimal place) Is there a linear relation between the two variables x, and y? If yes, indicate if the relationship is positive or negative. (Hint : use the Critical...
Permissive Authoritative Authoritarian 70 70 55 90 80 80 90 90 75 90 70 67 M=85...
Permissive Authoritative Authoritarian 70 70 55 90 80 80 90 90 75 90 70 67 M=85 75 50 M=81 63 65 M=65 grand mean=75 Calculate your F ratio. [ If you could not answer any of the questions above about the SS and df values, go back now and make up numbers to fill in for those values then use those wrong numbers to find this F ratio. Those will be wrong, but this could be right based on those...
a. Sort the list A[ ]={ 20, 13,4, 34, 5, 15, 90, 100, 75, 102, 112,...
a. Sort the list A[ ]={ 20, 13,4, 34, 5, 15, 90, 100, 75, 102, 112, 1} using Insertion Sort and determine the total number of comparisons made (do not count swaps) b. Sort the list stated in 5a) but using Merge Sort
Sort the list A[ ]={ 20, 13,4, 34, 5, 15, 90, 100, 75, 102, 112, 1}...
Sort the list A[ ]={ 20, 13,4, 34, 5, 15, 90, 100, 75, 102, 112, 1} using Insertion Sort and determine the total number of comparisons made (do not count swaps) b.Sort the list stated in 5a) but using Merge Sort
Given: Butter Guns MC 0 100 1 90 2 75 3 55 4 30 5 0...
Given: Butter Guns MC 0 100 1 90 2 75 3 55 4 30 5 0 Complete the marginal cost column (MC). Identify the opportunity cost increasing butter production from 1 to 2 units on the graph. Graphically illustrate the Keynesian versus classical position of the economy and their respective opportunity costs (two graphs). Explain the policy implications of these two alternative assumptions of the economy (Per lesson notes).
Exam 1 Scores 91, 83, 75, 85, 90, 80, 67, 82, 88, 87, 95, 91, 73,...
Exam 1 Scores 91, 83, 75, 85, 90, 80, 67, 82, 88, 87, 95, 91, 73, 80, 83, 92, 94, 68, 75, 91, 79, 95, 87, 76, 91, 85, 59, 70, 69, 78 Dummy: 0, 0 What are the Hypothesis Statement? What is Ho? What is Ha? What is the P-Value? What is the Claim? What is the Decision Rule? (Hint: Do you reject or fail to reject the null hypothesis?) What is the Level of Significance? (Hint: α) What...
10? + 50? + 20? + 10? = 100 5? + 15? + 75? − 25?...
10? + 50? + 20? + 10? = 100 5? + 15? + 75? − 25? = 200 25a − 15? − 5? = 300 10? + 20? − 30? + 100? = 400 how to do flowchart using gauss elimination and lu decomposition method
10? + 50? + 20? + 10? = 100 5? + 15? + 75? − 25?...
10? + 50? + 20? + 10? = 100 5? + 15? + 75? − 25? = 200 25a − 15? − 5? = 300 10? + 20? − 30? + 100? = 400 how to write coding in matlab using lu decomposition
Calculate the sample correlation and covariance for (i) Final_exam and assignment_grade; (ii) Final_exam and Tutorial_attend; and...
Calculate the sample correlation and covariance for (i) Final_exam and assignment_grade; (ii) Final_exam and Tutorial_attend; and (iii) assignment_grade and Tutorial_ attend. Once again using Excel formulae without the use of Data Analysis Tool Pack very important the teacher wants us to use hand by hand using excel in a step by step manner: e.g. calculating the sample mean which would be sum (x) /n... we can't use excel formula that is (=covariance(A..) please show steps with snipping tool. Final_exam assignment_grade...
Calculate the sample correlation and covariance for (i) Final_exam and assignment_grade; (ii) Final_exam and Tutorial_attend; and...
Calculate the sample correlation and covariance for (i) Final_exam and assignment_grade; (ii) Final_exam and Tutorial_attend; and (iii) assignment_grade and Tutorial_ attend, Carefully interpret your results. Once again use Excel for these calculations using both methods i.e. Data Analysis Tool Pack (options covariance, correlation) and using Excel formulae without use of Data Analysis Tool Pack. (Hint- if you find a discrepancy in your answers between the 2 excel methods can you explain why?) Final_exam assignment_grade Tutorial_attend 100 90 5 100 75...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT