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]
2 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]2 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
laura decides to walk to her job. she walks 1 1\2 miles in 3\5 hour. what is laura's walking rate? laura's job is 4 1\2 miles aw
Nuetrik [128]
To find the rate in miles per hour, divide the miles by the hours.

(1 1/2 miles)/(3/5 hour) =

= 3/2 miles * (5/3 hour)

= 5/2 mph

= 2 1/2 mph

Her walking rate is 2 1/2 mph.

(4 1/2 miles) / ( 2 1/2 mph) =

= 9/2 miles / (5/2 mph)

= 9/2 * 2/5 hours

= 9/5 hours

= 1 4/5 hours

From 9:00 a.m. to 11 a.m., she has 2 hours, but she only needs 1 4/5 hours to walk, so she will make it to work on time.
4 0
3 years ago
Write each fraction as a decimal use bar note if nessasary
weeeeeb [17]

Answer:

i think its .625

Step-by-step explanation:

all you need to do to make a fraction into a decimal is divide the nominator by the denominator

5 0
3 years ago
Find all real zeros of t<br>f(x)=x-14x² + 47x-18​
BabaBlast [244]

Answer:

x=3/7 and x= 3

Step-by-step explanation:

First simplify:

-14 x^2 +48x -18

divide everything by -2

-2(7 x^2 -24x +9) (Multiply the leading coefficient 7 by the constant 9)

-2 (x^2 -24x +63)

-2 [(x-3)(x-21)] Now divide the 7 that you multiplied earlier from 3 and 21

-2 [(x-3/7)(x-21/7)]

-2 [(7x-3)(x-3)]

Hence, the zeroes are 3/7 and 3

Hope this helps!

If you think I helped, Please mark brainliest! Would really appreciate!

4 0
2 years ago
Janae found PointA located at ,(-2,5) and c is located at (6,1) . What would be the x coordinate of point b that bisects A and C
Alexxandr [17]

A point that bisects a segment would be its midpoint. This is a case where the vocabulary  (bisect as opposed to midpoint) makes it harder.

To find the midpoint, we use the midpoint formula. The midpoint formula is:

midpoint = (x₁ + x₂/2, y₁ + y/2). To find it, you add the x coordinates and then divide them by 2. Repeat for the y coordinates.

x: (-2 + 6)/2 = 4/2 = 2

y: (5 +1)/2 = 6/2 = 3


Thus the point B bisecting AC is at (2, 3).

8 0
2 years ago
Solve 5y + 9 &lt;4<br> The solution is
zavuch27 [327]

Answer:

y< -1

Step-by-step explanation:

5 0
3 years ago
Read 2 more answers
Other questions:
  • If y=3x + 2, find the value of y when x = -3
    12·2 answers
  • Use special right triangles to solve for the value of x.
    6·2 answers
  • Single bottles are sold for $1.25. A six pack is sold for $7.20. A twelve pack is sold for $13.80 and a case of 24 bottles is so
    8·1 answer
  • If the subspace of all solutions of Ax 0 has a basis consisting of vectors and if A is a ​matrix, what is the rank of​ A
    12·1 answer
  • What is 25% of 400 5% of 20
    13·1 answer
  • Can you please help me with number 2
    10·2 answers
  • Jo bought a used car for $6000 and paid a 15% deposit. How much did he still have to pay?
    5·1 answer
  • A boy at an amusement park has 65 ride tickets. Each ride on the roller coaster costs 7 tickets. After riding the roller coaster
    8·1 answer
  • Pleaseee helppp yalllll
    9·1 answer
  • Solve for the measure of angle G in degrees.....
    9·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!