Jump to Last Post 1-8 of 8 discussions (8 posts)
  1. Whitney05 profile image85
    Whitney05posted 10 years ago

    My statistics homework is giving me a headache!

    Anyone know how to do correlation matrixes in excel?
    How about mutiple regression models?

    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. vreccc profile image60
    vrecccposted 10 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.


  3. Whitney05 profile image85
    Whitney05posted 10 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. Inspirepub profile image75
    Inspirepubposted 10 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.


  5. Whitney05 profile image85
    Whitney05posted 10 years ago

    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. About-The-Home profile image60
    About-The-Homeposted 10 years ago

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

  7. buckywildcat profile image60
    buckywildcatposted 10 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:

    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.

  8. Maddie Ruud profile image76
    Maddie Ruudposted 10 years ago

    My dad's an econometrician, so by all rights I ought to be able to answer your question, but unfortunately, I'm not the right person to ask.  I was very ill in highschool and missed the entire second half of my junior year.  Don't ask me how I passed AP Statistics with a C, having done no homework and never showing up...


This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

Show Details
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)