Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Correlation?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
HotRod - 21 Nov 2006 16:57 GMT
I'm just starting my work on this so please go easy on me. I have a bunch of
data in front of me that will help me generate some answers in five
different categories. I have the ability to sort the data geographically,
gender, age etc. and was wondering if anyone could recommend or help me
determine/test if there is a correlation between certain groups? e.g.
females in different geographic areas? What would consist of a normal
correlation test?
Mike Middleton - 21 Nov 2006 21:30 GMT
HotRod  -

If you want to describe relationships among categorical data, you can use a
Pivot Table to get summary counts for two characteristics that will help you
to visually decide whether a relationship exists. For a "test," a chi-square
test of independence might be appropriate.

If the data are numerical, then you could start with an XY (Scatter) chart
to visually describe the relationship between two characteristics, and you
could use the correlation coefficient (worksheet function CORREL) as a
summary measure. For a "test," the Regression tool provides an F-test for
overall fit and t-stats for individual coefficients.

-  Mike
http://www.mikemiddleton.com

> I'm just starting my work on this so please go easy on me. I have a bunch
> of data in front of me that will help me generate some answers in five
[quoted text clipped - 3 lines]
> females in different geographic areas? What would consist of a normal
> correlation test?
HotRod - 22 Nov 2006 19:09 GMT
Mike
   Thanks I'll give these a shot and see what gets me the best results.
I've got some reading to do...

> HotRod  -
>
[quoted text clipped - 19 lines]
>> females in different geographic areas? What would consist of a normal
>> correlation test?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.