topic Re: Pearson Correlation test? in New SAS User

Pearson Correlation test?

Pixydust12 — Mon, 29 Nov 2021 07:40:33 GMT

I have two data sets and I want to see if they are related. I want to know if the air pollution levels by county (data set one) are related to number of poultry farms by county (data set two). This would be a Pearson correlation, correct?

Re: Pearson Correlation test?

MarkusWeick — Mon, 29 Nov 2021 09:08:06 GMT

Yes, Pearson Correlation ist an important step. But you should also do scatter-plot, as the relation could be non-linear.

Cheers, Markus

Re: Pearson Correlation test?

sbxkoenk — Mon, 29 Nov 2021 09:28:36 GMT

Hello,

You need one dataset with 3 columns (and not two datasets --> merge them by county).

County = ID-variable
pollution level (col1)
number of poultry farms (col2)

As said by @MarkusWeick , you first need to graph / plot your data to get better insights on the analysis that might be appropriate.

Pearson correlation can be interesting but it is only measuring linear correlation indeed.

You can try a simple linear regression as well, but maybe a spline fits the data better?

Thanks,

Koen

Re: Pearson Correlation test?

Pixydust12 — Tue, 30 Nov 2021 17:10:49 GMT

Hi Markus,
So once I do a scatter plot and I see that the relationship is not linear, does that sufficiently answer my research question (To evaluate if air pollution levels are greater in counties near poultry farms), or should I do another test?

Re: Pearson Correlation test?

MarkusWeick — Tue, 30 Nov 2021 17:19:10 GMT

Hi Pixydust,

depends on the image you see. Maybe you'll find another hypothesis for the relation.

Would you like to share the plot?

Cheers

Markus

Re: Pearson Correlation test?

sbxkoenk — Tue, 30 Nov 2021 17:31:13 GMT

Hello @Pixydust12 ,

The relationship might be non-linear in any direction of course.

Air pollution levels can be greater in counties near poultry farms.

Air pollution levels can be smaller / lower in counties near poultry farms.

The plot will tell you (if not looking like a random scatter), but the plot should support an hypothesis test or a small model that "proves" this.

Koen

Re: Pearson Correlation test?

Pixydust12 — Tue, 30 Nov 2021 17:52:58 GMT

Question: Would I graph or use a scatter plot? I know air pollution levels are a continuous variable, but is number of poultry farms in each county continuous or discrete?

Re: Pearson Correlation test?

Pixydust12 — Tue, 30 Nov 2021 18:33:38 GMT

My code:

proc sgplot data=Iowa;
reg x=Poultry_Farms y=Air_Pollution/ clm cli;
run;

Should I even do a scatter plot since one variable is continuous and one is discrete? I think I'm confusing myself. My goal is to see if there is a correlation between the two.

Re: Pearson Correlation test?

MarkusWeick — Wed, 01 Dec 2021 08:23:03 GMT

Hello @Pixydust12 ,

That's the plot I asked for. Its no problem to mix contineous and discrete value. To me it looks as there is no relationship. Correspondingly the correlation coefficient should be close to zero.

Cheers Markus

Re: Pearson Correlation test?

Pixydust12 — Wed, 01 Dec 2021 16:43:52 GMT

Hi Mark,
Last question. If I have 5 years worth of air pollution data, but only 1 year worth of poultry farms, could I compare the mean air pollution to poultry farms with a Pearson Correlation? The scatter plot above is an example of the mean levels for the past 5 years and the # of poultry farms for one year.

Re: Pearson Correlation test?

MarkusWeick — Wed, 01 Dec 2021 18:36:38 GMT

Hello @Pixydust12 ,

I would assume the number of poultry farms to be rather stable. So taking the 5 years mean for the air polution should be ok. But to be on the safe side (if there is a safe side in statistics), I would also do the plot for the correspondig 1year data of air polution.

Cheers Markus