![monet83](/avatars/9.jpg)
monet83
25.02.2020 •
Mathematics
Are the marks one receives in a course related to the amount of time spent studying the subject? To analyze this mysterious possibility, a student took a random sample of 10 students who had enrolled in an accounting class last semester. He asked each to report his or her mark in the course and the total number of hours spent studying accounting. These data are listed here.
Marks
Time Spent Studying
77
40
63
42
79
37
86
47
51
25
78
44
83
41
90
48
65
35
47
28
Enlarge Table
a.
Calculate the covariance.
b.
Calculate the coefficient of correlation.
c.
What do the statistics calculated above tell you about the relationship between marks and study time?
A. First, do the calculations for covariance and coefficient of correlation using only Excel's add/Sum, subtract, multiply, divide functions (OK, use ^2 (to square a number) )
B. Then calculate the covariance and coefficient of correlation using Excel's CORREL and COVAR functions
C. What do the statistics calculated above tell you about the relationship between marks and study time?
Solved
Show answers
More tips
- C Computers and Internet Which Phone is Best for Internet Surfing?...
- F Food and Cooking Everything You Need to Know About Pasta...
- C Computers and Internet How to Choose a Monitor?...
- S Style and Beauty How to Get Rid of Peeling Nails: Natural Remedies...
- S Science and Technology Understanding Magnetic Storms: A Guide to This Natural Phenomenon...
- F Family and Home What is Most Important in Men s Lives?...
- G Goods and services Which TV is better - LCD or Plasma?...
- C Computers and Internet Are there special gaming mice?...
- G Goods and services LED-подсветка в LCD-телевизорах: 5 причин, почему она лучше других технологий...
- C Computers and Internet Keep Your Mouse Pad Clean: The Right Way to Clean It?...
Answers on questions: Mathematics
- M Mathematics Question: Is the figure a polygon? Is it convex or concave? Not a polygon, convex Not a polygon Polygon, concave Polygon, convex...
- M Mathematics ¡¡ANSWER MY QUESTION FIRST¡¡ Can you help me with these questions, please?...
- M Mathematics Lines Line A E and Line G H are parallel in the image below. The image will be used to prove that the sum of the measures of the interior angles of Triangle C G H...
- M Mathematics Which of the statements below is a true statement about irrational numbers? A.Irrational numbers are numbers whose decimal equivalent is repeating and non-terminating....
- M Mathematics Price of car-15,000 Interest rate- 8% Time- 5 years Or. Price of car-15,000 Interest rate- 7%. Time- 6 years What’s the best choice ? 1 or 2...
- M Mathematics 3.) The graph of /(x) is given below. What is the value of /(-3)? fix) a. -4 b. -2 c. 2. d. 6 what is the value of f(-3)...
- M Mathematics Which of the following is a perfect square trinomial? A. x + 10x + 20 B.x?+ 10x + 50 C.x + 10x + 25 D.x? + 5x + 10...
- M Mathematics Ts. Factor the following trinomial. 5x2 + 39x -8 Factors:...
- M Mathematics Write an equation in slope intercept form that has a slope of -8 and a y-intercept of 12...
- M Mathematics −2(x+1/4)+1=5 PLEASE HELP...
Ответ:
a) 98.522
b) 0.881
c) The correlation coefficient and co-variance shows that there is positive association between marks and study time. The correlation coefficient suggest that there is strong positive association between marks and study time.
Step-by-step explanation:
a.
As the mentioned in the given instruction the co-variance is first computed in excel by using only add/Sum, subtract, multiply, divide functions.
Marks yTime spent xy-ybarx-xbar(y-ybar)(x-xbar)
77 405.1 1.36.63
63 42-8.9 3.3-29.37
79 377.1 -1.7-12.07
86 4714.1 8.3117.03
51 25-20.9 -13.7286.33
78 446.1 5.332.33
83 4111.1 2.325.53
90 4818.1 9.3168.33
65 35-6.9 -3.725.53
47 28-24.9-10.7266.43
Co-variance=886.7/(10-1)
Co-variance=886.7/9
Co-variance=98.5222
The co-variance computed using excel function COVARIANCE.S(B1:B11,A1:A11) where B1:B11 contains Time x column and A1:A11 contains Marks y column. The resulted co-variance is 98.52222.
b)
The correlation coefficient is computed as
(y-ybar)^2(x-xbar)^2
26.01 1.69
79.21 10.89
50.41 2.89
198.81 68.89
436.81 187.69
37.21 28.09
123.21 5.29
327.61 86.49
47.61 13.69
620.01 114.49
sum(y-ybar)^2=1946.9
sum(x-xbar)^2=520.1
The correlation coefficient computed using excel function CORREL(A1:A11,B1:B11) where B1:B11 contains Time x column and A1:A11 contains Marks y column. The resulted correlation coefficient is 0.881.
c)
The correlation coefficient and co-variance shows that there is positive association between marks and study time. The correlation coefficient suggest that there is strong positive association between marks and study time. It means that as the study time increases the marks of student also increases and if the study time decreases the marks of student also decreases.
The excel file is attached on which all the related work is done.
Ответ: