1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
podryga [215]
3 years ago
11

Are the marks one receives in a course related to the amount of time spent studying the subject? To analyze this mysterious poss

ibility, 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?
Mathematics
1 answer:
sertanlavr [38]3 years ago
7 0

Answer:

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 y Time spent x y-ybar x-xbar (y-ybar)(x-xbar)

77                    40 5.1         1.3 6.63

63                     42 -8.9            3.3 -29.37

79                     37 7.1            -1.7 -12.07

86                     47 14.1            8.3 117.03

51                    25 -20.9  -13.7 286.33

78                     44 6.1            5.3 32.33

83                      41 11.1            2.3 25.53

90                     48 18.1            9.3 168.33

65                     35 -6.9           -3.7 25.53

47                    28 -24.9 -10.7 266.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.

b)

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.

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.

Download xlsx
You might be interested in
What is the value of log625^5 converted to a fraction
Anettt [7]

Answer:

1/4

Step-by-step explanation:

625^x = 5

x = 1/4

8 0
3 years ago
Help!<br><br> <img src="https://tex.z-dn.net/?f=%5Csf%20%5Csqrt%7Bx-2%7D-x%3D-2" id="TexFormula1" title="\sf \sqrt{x-2}-x=-2" al
Gennadij [26K]

▪▪▪▪▪▪▪▪▪▪▪▪▪  {\huge\mathfrak{Answer}}▪▪▪▪▪▪▪▪▪▪▪▪▪▪

Let's solve for x :

  • \sqrt{x - 2}  - x =  - 2

  • \sqrt{x - 2}  = x - 2

  • 1 =  \dfrac{x - 2}{ \sqrt{x - 2} }

  • 1 =  \sqrt{x - 2}

  • x - 2 = 1

  • x = 3
4 0
3 years ago
Solve for X, will mark brainliest if right
Vitek1552 [10]

Answer:

<u>x = 8</u>

Step-by-step explanation:

The sides are in proportion.

  • \frac{RG}{FG} =\frac{SH}{FH}
  • 40 / 7x + 14 = 44 / 33 + 44
  • 40 / 7x + 14 = 44/77 = 4/7
  • 40(7) = 4(7x + 14)
  • 280 = 28x + 56
  • 10 = x + 2
  • <u>x = 8</u>
3 0
2 years ago
Steven has 1/3 of package of biscuit mix left.He will use equal para of the leftover mix to make three watches of biscuits. If h
Nuetrik [128]

Answer:

1/9

Step-by-step explanation:

(1/3)/3 = 1/9

3 0
2 years ago
Please help me with this homework
Tcecarenko [31]
The line is going downwards
Solution: negative slope
6 0
2 years ago
Read 2 more answers
Other questions:
  • By how many degrees did the direction of the boat change
    15·1 answer
  • NEED HELP PLEASE! WILL GIVE MEDAL:
    7·2 answers
  • River c is 500 miles longer than River d. The sum of their length is 5520 miles. What is the length for each river
    10·1 answer
  • Hamlet spins the spinner 13 times, and it stops at the letter R 9 times. If he spins the spinner a 14th time, what is the theore
    10·2 answers
  • I just want to check my answer, what is the slope of (-19, -6), (15,16)?
    15·1 answer
  • Mrs smith has 5 times as many markers as colored pencils. The total is 54. How many markers does she have?
    11·1 answer
  • 23 teachers at a school take the car to work. Some of the teachers
    15·2 answers
  • HELP ME PLEASE OMG PLEASE
    15·2 answers
  • Marcus can choose between a monthly salary of $1,250 plus 4.5% of sales or $2,400 plus 3%
    7·1 answer
  • Monique is going to give away 35% of her orange harvest to her neighbors. If she picked 480 oranges, how many will she be giving
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!