Share
Explore BrainMass

# Correlation

I need help in doing these 2 equations step-by-step or if it is done in excel could you please explain how?

-------------------------------------------------

#1

For the last 6 years, I have kept fairly detailed data on wind speed and the resultant hull speed of my sailboat. Here is the windspeed-hullspeed data

* Find the correlation.
* Then for X = 20 kts find Y'

Wind Speed ( in knots 1kt = 1.1mph ) Hull speed ( in kts )

4 3
5 3
7 4
9 5
11 5
12 6
14 7
15 7

-------------------------------------------------

#2

Here is some data regarding our passenger numbers by year

year passengers carried ( in millions)
1998 38
1999 41
2000 43
2001 40
2002 48
2003 51

* Find the correlation.
* Find the Estimate Y' for T= 2005.

#### Solution Preview

I did these problems in Excel (it's pretty tedious to calculate correlations by hand). To find the correlation in Excel, use the =PEARSON() function. the name of the function comes from the face that the correlation coefficient is also called the Pearson correlation coefficient. Type =PEARSON() into any cell, then between ...

\$2.19