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
My project has me plotting points on an uneven paper. How do I do this?
AURORKA [14]
You can make up your own lines on the paper or just get a new sheet of blank paper or graphing paper
4 0
3 years ago
Read 2 more answers
tara needs 216 blocks. each box had 10 bags. each bag has 10blocks how many boxes bags and single blocks does she need to make 2
Fed [463]
2 boxes, 1 bag, and 6 blocks
4 0
3 years ago
Read 2 more answers
Let X denote the time from the present until the stock market hits 25,000. If X ≤ 1, you win $10, 000X. If X > 1, you win not
const2013 [10]

Answer: $6321

Step-by-step explanation:

Expected value is given as exactly what you might think it means intuitively, the return you can expect for some type of action.

The basic expected value formula is the probability of an event multiplied by the amount of times the event happens:(P(x) * n).

he formula for the Expected Value for a binomial random variable is:

P(x) * X.

X is the number of trials and P(x) is the probability of success.

The formula for calculating the Expected Value where there are multiple probabilities is:

E(X) = ∑X * P(X)

The equation is basically the same, but here you are adding the sum of all the gains multiplied by their individual probabilities instead of just one probability.

Calculating the expected value of winning as follows:

Given,

Fx= e^-x, x is greater or equal to 0

Now, P less than or equal to zero =

[-e^-x] ^1

e^-0 - e^-1

= 1 - e^-1

= 0.6321

and P(x>1) = 1-0.6321= 0.3679

Therefore,Let y= amount of winnings.

Based on the above given information,

y= $10000 0

P(y)= 0.6321 0.3679

The expected value of winning:

E(y) = ΣyP(y)

E(y) = 10000 × 0.6321 + 0 × 0.3679

E(y) = $6321

Therefore, the expected value of winning is $6321

5 0
3 years ago
It takes 58 pounds of seed to completely plant a 9-acre field. How many acres can be planted per pound of seed?
ozzi

Answer:

6 4/9

Step-by-step explanation:

You divide 58 and 8 and your answer would be 6.444444 repeating.

6 0
2 years ago
Rita earns $17.00 per hour. If she gets a 6% raise, what will be her new hourly wage?
ipn [44]

multiply 17 by 6%

17 * 0.06 = 1.02 increase

17 +1.02 = 18.02 new hourly wage

8 0
3 years ago
Other questions:
  • Find the unit rate with the second given unit in the denominator.
    7·2 answers
  • Here is another problem that i need help on 2/5 divided by 1/6
    8·2 answers
  • What is 7(5)-4x=51? Please
    15·2 answers
  • I’m confused on this question.<br> Please help.
    7·1 answer
  • 500 is reduced by 70% what remains
    8·2 answers
  • What is the value of 7 in number 3,407,215
    10·2 answers
  • Also (area O O O O O O​
    9·2 answers
  • 12. MULTIPLE CHOICE Brandon is watching a movie
    5·1 answer
  • 75,15,3 find the 6th term
    15·1 answer
  • Brandi started training with the track team five weeks ago. during the first week, she ran 0.5 miles at each practice. the next
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!