# FIN 330 Hours spent studying Scatterplot Of Data Paper

User Generated

wrazvyyre90

## Description

Using Excel graph a scatterplot of the data. (4p)

Describe the type of correlation and interpret the correlation in the context of the data. Be specific in describing the magnitude, direction, and strength of the relationship.

Calculate the sample correlation coefficient for the data. (Pearson correlation coefficient between hours spent studying, x, and test score, y). (Round your final answer to three decimal places). (7p)

Show all work and outputs in excel as well as on each question. Can typed on word docs. The excel scatter plot must include all the outputs. All directions and questions are included in attachment below.

### Unformatted Attachment Preview

Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Hello buddy! I have attached the answer in a word document for you. Also, there is an outline. :) Let me know if you have any edits or have any questions.

Last Name 1

Name
Instructor's name
Course
Date
Homework #5 Statistics
The number of hours 9 students spent studying for a test and their scores on that test is
represented in the table below.
Hours spent studying, x
Test scores, y

0

2

4

5

5

5

6

7

8

40

51

64

69

73

75

93

90

95

Question 1
Using Excel graph a scatterplot of the data. (4p)
The scatterplot for the data is as shown below:

Scatter Plot
100
90
80

Test scores, y

70
60
50
40
30
20
10
0
0

1

2

3

4

5

6

Hours spent studying, x

7

8

9

Last Name 2

Question 2
Describe the type of correlation and interpret the correlation in the context of the data. Be
specific in describing the magnitude, direction, and strength of the relationship. (6p)
The data has a strong positive linear correlation which is indicated by increase in the value
of the Test scores (y-variable) as a result of the increase in the value of the hours spent
studying (x-variable). The magnitude of the correlation is given by the correlation
coefficient (r=0.9685). The correlation is positive since the y-values increase as the xvalues increase. The correlation is almost perfect as indicated by the plot with all points
lying almost on a straight line on a scatter diagram and hence the strength is a strong
correlation (r≈1).
Question 3
Calculate the sample correlation coefficient for the data. (Pearson correlation coefficient
between hours spent studying, x, and test score, y). (Round your final answer to three
decimal places). (7p)
The table below is used to calculate the sample correlation coefficient for the data:
x

Y

𝑥 − 𝑥̅

0

40

-4.667 -

𝑦 − 𝑦̅

(𝑥 − 𝑥̅ )(𝑦 − 𝑦̅)

(𝑥 − 𝑥̅ )2

(𝑦 − 𝑦̅)2

150.370

21.778

1038.272

56...

### Review

Anonymous
Really useful study material!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4