# Statistics

1. 63
Whitney05posted 8 years ago

My statistics homework is giving me a headache!

Anyone know how to do correlation matrixes in excel?

I have 4 columns of data (year/age, city, price, miles)

I think I missed this in the lesson. :-( I don't have time to reread it all.

2. 60
vrecccposted 8 years ago

did you try Google? I was about to google this stuff for you, but then thought I would check with you first.

My wife is working on her MBA and we have worked together on some crazy Excel stuff. You don't even want to know. Good thing when I took statistics excel wasn't on the market yet.

Now.. I have to go find my hamster. He escaped again last night. Funny, my cats don't bother him. They chase him around but don't hurt him.

JOnathan

3. 63
Whitney05posted 8 years ago

Yea. :-( I haven't googled it yet. I tend not  to have the best look googling statistics help. I emailed the teacher about one assignment, so hopefully he'll get back to me because I think it will really help with both assignments.

I know how to do the concepts, but I have a chart of multiple data and I'm not sure how to compare it all, or really what to compare. I just did the price and miles, but then I'm not sure what the point of the rest of it was. I just hope my professor gets back to me in time.

I just hope I pass thie semester. I don't want to have to redo statistics 2.

Hamsters tend to go to dark warm places. I usually found mine in the close or curled under the freezer, as thewas a freezer in the bedroom at my boyfriend's place.

My dog is like that with my rats. She mother's them when they're out.

4. 85
Inspirepubposted 8 years ago

Hi, Whitney,

If you know how to do formulas in Excel, making a correlation matrix is just a long, tedious process of putting a formula in each cell. There is probably a pre-existing formula in the Excel pick list for correlation, so you just [aste it in each cell and point it at your data columns.

Set up 4x4, with your 4 variables on each side, each one correlates 1 with itself, and then work out correlations between the other pairs.

The two sides of the diagonal of 1s will be the same, so you only need to calculate one half.

Do you have to do it in Excel?

Because there are stats packages around that will do the lot at the push of a button.

Too long since I did stats in anger for me to have a recommendation out of the ones available now - we used a horrible old one on a mainframe when I was teaching at uni.

But I know there are some pretty useful ones around now.

Jenny

5. 63
Whitney05posted 8 years ago

Jenny,
The homework has to eb done in excel. I just gave up on the correlation matrix. I used the correlation tool, but it only compares two columns. I had no idea about the other columns. I didn't know how to do a matrix with it. I couldn't find it in the book either. I kind of gave up. I have a feeling I'm taking Statistics 2 again next semester. I need to go ahead and register for it and cancel it when I get my grades in.

Thanks for the help.

6. 61

98% of people can't understand statistics and I'm one of them, and like all good statistics that one's made up!

7. 60
buckywildcatposted 8 years ago

Hi Jenny -

You need to make sure you have the Analysis Tool Pack installed in Excel.  I think you go to Tools --> Add-ins (probably better instructions on microsoft's website).

Here is a link for a site with some good examples, maybe this will help:  http://www.inductive.com/help-doc-correl.htm#comp

The site is for some different software, but near the bottom they have some samples to create correlation matrices with more than two variables.

good luck.
bucky

8. 82