Interview Question: Correlation in Excel

Sample Question #74 (programming – Excel VBA)

Write an Excel macro to read a data column from a worksheet named "Raw Data," another data column from another worksheet named "New Data," and then calculate the correlation between the two data series and put the answer in cell A1 of a new worksheet named "Result."

(Hint: in order to calculate the correlation between two data series, what must be true of the two series? In other words, before you start writing the code, think through the problem and try to identify any potential mathematical or logical issues.)

Advertisements
This entry was posted in Sample Qs. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s