Would someone complete this assignment?

The details of the assignment are in the attachment. It includes a formula. Please include any sources used.
assignment.docx

Unformatted Attachment Preview

Prior to attempting this Discussion activity, it is strongly recommend that you
watch the three videos about Mean, Median and Mode, Correlation and
Causality and Hypothesis testing and p-values
Correlation is a term used to define the relationship between two data sets
that are linked together. Correlation values range from -1 to 1. A number
close to 1 indicates strong correlation, a zero indicates no correlation (data
not linked) and a number close to -1 indicates negative correlation. See below
for additional definition.
?
1 indicates a perfect positive correlation
?
0 indicates no correlation
?
-1 is a perfect negative correlation.
The formula for computing correlation is given below.
The data below shows the sales of popsicles with respect to the temperature.
At 75 degrees Fahrenheit the sales of popsicles amounted to $200m. Colum1
Temp Mean = (x –
Sales in $ (y –
(x-x1)(y-
Sum of
=x
x1
x1)
=y
y1)
Square(x-x1)
75
83.75
-8.75
200
80
83.75
-3.75
300
85
83.75
1.25
95
83.75
11.25
83.75
y1)
–
Sum of
Square(y y1)
1203.125 76.5625
18906.25
-37.5
140.625
14.0625
1406.25
350
12.5
15.625
1.5625
156.25
500
162.5
1828.125 126.5625
337.5
137.5
SUM 3187.5
218.75
26406.25
46875
10253906.25
SQRT
3202.172114
COR
0.995418074
is the temperature column and column 4 is the sales column.
The correlation computation shows a strong positive relationship between
temperature and the sales of popsicles. For this Discussion, you do not have
to manually compute the correlation.Watch this video and use Microsoft Excel
to compute the correlation coefficient for the data below. The table
represents dummy data collected by students for a capstone study to
establish some type of relationship between marijuana and longevity. The
first row represents the number of times an individual smoked marijuana in a
week. The second row is the age the individual; passed away. Note that this is
dummy data and has no significance.
Marijuana smoking in a
week
Longevity
5 10 15 11 22 4 23 8 17
80 81 68 72 58 81 65 84 85
Now, use Excel to graph the data above (click here for video Instruction). Can
you conclude from your data sample that longevity is related to marijuana
smoking? Explain your conclusion? State the null hypothesis if you were trying
to establish a relationship between marijuana smoking and longevity?
…
Purchase answer to see full
attachment