Question

In: Statistics and Probability

For 5 students, scores on a math test (X) and statistics (Y) are given as follows:...

For 5 students, scores on a math test (X) and statistics (Y) are given as follows:

X: 95 85 80 70 55

Y: 85 75 70 75 65

a) Fit the regression line b) Test the model c) Find the 90% Confidence Interval? d) For a student who has a math score 75, estimate her/his statistics grade?

Solutions

Expert Solution

Given Information:

Y X
85 95
75 85
70 80
75 70
65 55

The regression analysis is performed in excel under Data Analysis at 10 percent level of significance and output obtained is:

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.85115355
R Square 0.724462366
Adjusted R Square 0.632616487
Standard Error 4.495118818
Observations 5
ANOVA
df SS MS F Significance F
Regression 1 159.3817204 159.3817204 7.887804878 0.0673751
Residual 3 60.61827957 20.20609319
Total 4 220
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 90.0% Upper 90.0%
Intercept 42.12365591 11.52651268 3.654501331 0.035380767 5.441148236 78.80616359 14.99758245 69.24972938
X Variable 1 0.413978495 0.147400753 2.808523612 0.0673751 -0.055116487 0.883073476 0.067090953 0.760866037

a) The fitted regression line is:

b) Since the pvalue for slope is 0.0673751 which is less than 0.10 and also the pvalue for intercept is 0.035380767 which is also less than 0.10. So the conclusion is null hypothesis is retained for both slope and intercept and they are not significant at 10 percent level of significance.

c) The 90% Confidence interval is shown below:

Confidence Interval Lower 90.0% Upper 90.0%
Intercept 14.99758245 69.24972938
Slope 0.067090953 0.760866037

d) For a student who has a math score 75, his/her estimated statistics grade is calculated as:

For a student who has a math score 75, his/her estimated statistics grade is 73.17204304

  


Related Solutions

For 5 students, scores on a math test (X) and statistics (Y) are given as follows:...
For 5 students, scores on a math test (X) and statistics (Y) are given as follows: X: 95 85 80 70 55 Y: 85 75 70 75 65 a) Fit the regression line b) Test the model c) Find the 90% Confidence Interval? d) For a student who has a math score 75, estimate her/his statistics grade?
A certain test preparation course is designed to improve students' SAT Math scores. The students who...
A certain test preparation course is designed to improve students' SAT Math scores. The students who took the prep course have a mean SAT Math score of 526, while the students who did not take the prep course have a mean SAT Math score of 515. Assume that the population standard deviation of the SAT Math scores for students who took the prep course is 44.6 and for students who did not take the prep course is 45.2. The SAT...
The following data is the math test scores of students graduating from a particular high school....
The following data is the math test scores of students graduating from a particular high school. The government uses these scores to determine if there will be accreditation awarded. In order for this to occur the mean score must be above 780. A sample of students' scores is drawn at random and they take the test. The scores are in the following table and the population is considered a normal distribution. Test at the .01 level. 980 764 798 760...
The values given below shows the aptitude test scores, x, and the intelligence quotient (IQ), y,...
The values given below shows the aptitude test scores, x, and the intelligence quotient (IQ), y, for 9 people. x : 68, 72, 65, 70, 62, 75, 78, 64, 69 y : 90, 85, 88, 100, 105, 98, 70, 65, 72 Resolve problem and find the correlation coefficient using Spearman Rank Correlation. Interpret the result accordingly. (15 pts)
The Test results of the Business Statistics were published and the scores were as followed Students...
The Test results of the Business Statistics were published and the scores were as followed Students 12 14 10 13 17 12 11 15 Results 5 11 7 8 11 7 6 9 Only 2 decimal places Determine the α (alpha) Coefficient in the regression equation * 4 points Your answer Advise if increasing the number of students to 50 will improve the students’ test scores * 2 points Remain the same Increase Decrease Determine the β Coefficient in the...
Given the data on scores of students final grade in statistics (in percent) determine the following...
Given the data on scores of students final grade in statistics (in percent) determine the following statistics. 43 45 48 51 53 54 57 59 60 60 60 60 61 70 70 71 71 72 72 72 75 76 76 79 81 81 83 85 87 88 88 89 89 91 92 93 96 98 98 99 100 101 101 Assume students are only allowed to transfer the class if they receive a grade of 70 % or above. Use...
Given the data on scores of students final grade in statistics (in percent) determine the following...
Given the data on scores of students final grade in statistics (in percent) determine the following statistics. 43           45           48           51           53           54           57           59           60           60           60           60           61 70           70           71           71           72           72           72           75           76           76           79           81           81 83           85           87           88           88           89           89           91           92           93           96           98           98 99           100         101         101 1.       Create a relative frequency distribution table and histogram to determine the percentage of students getting a particular grade in statistics class. Do this by separating into 7 different classes by using 40’s, 50’s, 60’s, 70’s, 80’s, 90’s, 100’s. This will essentially be a table and graph of the probability distribution for final grade. 2.       Determine the following a.       What is the...
Using the scores of 30 students on a statistics test determine the range. 75 52 80...
Using the scores of 30 students on a statistics test determine the range. 75 52 80 96 65 79 71 87 93 95 69 72 81 61 76 86 79 68 50 92 83 84 77 64 71 87 72 92 57 98
AM -vs- PM Test Scores: In my PM section of statistics there are 30 students. The...
AM -vs- PM Test Scores: In my PM section of statistics there are 30 students. The scores of Test 1 are given in the table below. The results are ordered lowest to highest to aid in answering the following questions. index 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 score 44 48 50 52 55 60 61 64 64 65 66 67 68 71 75 index 16 17 18 19 20 21 22...
AM -vs- PM Test Scores: In my PM section of statistics there are 30 students. The...
AM -vs- PM Test Scores: In my PM section of statistics there are 30 students. The scores of Test 1 are given in the table below. The results are ordered lowest to highest to aid in answering the following questions. index 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 score 43 48 50 52 55 60 61 61 64 65 66 67 68 71 75 index 16 17 18 19 20 21 22...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT