Mathematics, 25.02.2020 21:53 dudeguy3593

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?

Answers: 1

Show answers

Answers

Answer from: kahliey

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:

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

$Covariance=\frac{sum[(y-ybar)(x-xbar)]}{n-1}$

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.

The correlation coefficient is computed as

$Correlation coefficient=r=\frac{sum[(y-ybar)(x-xbar)]}{\sqrt{sum[(x-xbar)]^2sum[(y-ybar)]^2} }$

(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

$Correlation coefficient=r=\frac{886.7}{\sqrt{520.1(1946.9)} }$

$Correlation coefficient=r=\frac{886.7}{\sqrt{1012582.69} }$

$Correlation coefficient=r=\frac{886.7}{1006.2717 }$

Correlation coefficient=r=0.881

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.

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.

Answer from: Quest

costs the what? what is the cost of the pants?

step-by-step explanation:

if it is $10, then the price is 14.

take 40% of the cost, and then add the cost.

40% of 10 = 4

4+10 = 14.

Answer from: Quest

answer: list the statements and i will follow up!

step-by-step explanation:

Another question on Mathematics

Mathematics, 21.06.2019 15:00

The diameter of a ball is 8 in. what is the volume of the ball? use 3.14 for pi. enter your answer as a decimal in the box. round only your final answer to the nearest hundredth.

Answers: 2

Answer

Mathematics, 21.06.2019 17:00

Asailor is looking at a kite. if he is looking at the kite at an angle of elevation of 36and the distance from the boat to the point where the kite is directly overhead is 40 feet, how high is the kite?

Answers: 3

Answer

Mathematics, 21.06.2019 18:30

Kayla wants to find the width, ab, of a river. she walks along the edge of the river 65 ft and marks point c. then she walks 25 ft further and marks point d. she turns 90° and walks until her location, point a, and point c are collinear. she marks point e at this location, as shown. (a) can kayla conclude that δ and δ are similar? why or why not? (b) suppose de = 15 ft. what can kayla conclude about the width of the river?

Answers: 2

Answer

Mathematics, 21.06.2019 19:00

Since opening night, attendance at play a has increased steadily, while attendance at play b first rose and then fell. equations modeling the daily attendance y at each play are shown below, where x is the number of days since opening night. on what day(s) was the attendance the same at both plays? what was the attendance? play a: y = 8x + 191 play b: y = -x^2 + 26x + 126 a. the attendance was never the same at both plays. b. the attendance was the same on day 5. the attendance was 231 at both plays on that day. c. the attendance was the same on day 13. the attendance was 295 at both plays on that day. d. the attendance was the same on days 5 and 13. the attendance at both plays on those days was 231 and 295 respectively.

Answers: 1

Answer

You know the right answer?

Are the marks one receives in a course related to the amount of time spent studying the subject? To...

Questions