Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Analytics
- /
- Stat Procs
- /
- Correlation

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 04-11-2019 01:09 PM
(883 views)

Hello,

I have three variables a,b, and c. Variable c is obtained by dividing a by b and multiplying by 100, in other words c=a/b*100.

Can I calculate a correlation or even a linear regression where the dependent variable is c and the explanatory variable is b; given that variable b was involved in calculating variable c? variables a and b are measured in a continuous scale.

Appreciate your help.

6 REPLIES 6

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Yes, you can calculate a correlation.

Yes, you can calculate a regression.

Why don't you give it a try?

--

Paige Miller

Paige Miller

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

@Jep wrote:

Since we really know nothing about the problem, and we also don't know what use the correlation/regression will be put to, the answer is: "It depends".

--

Paige Miller

Paige Miller

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

I hope a scatter plot of (a[i], b[i]) shows a quadratic relationship that passes near the origin. That is what your model says:

Find the least-squares values (beta0, beta1)such that

100*a[i] / b[i] ~ beta0 + beta1 * b[i]

or

a[] ~ gamma0*b[i] + gamma1*b[i]^2

Thus your model assumes a quadratic relationship (no intercept) between a and b. IMHO, it would be clearer to drop c and write the model as

MODEL a = b b*b;

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

You can calculate a correlation between any numeric variables that have 2 or more pairs of values.

The interpretation may be pretty difficult if there isn't much of a natural relationship such a number of hairs on your head and your first grade teachers dress size.

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. **Registration is now open through August 30th**. Visit the SAS Hackathon homepage.

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.