+ Reply to Thread
Results 1 to 3 of 3

Data analysis, attempting to compare sets of data. Not sure if analysis exists.

  1. #1
    Registered User
    Join Date
    06-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Data analysis, attempting to compare sets of data. Not sure if analysis exists.

    testdata.xlsx

    Hi,

    Not sure if this is the correct forum for this question, so please remove if inappropriate. As it's a data analysis question maybe rather than an excel-specific one. However I’d appreciate any ideas.

    Top set of data shows how English, Maths and Science did against eachother.
    (So you can see maths has the worst lectures and tutorials)

    Bottom set of data shows individual subjects; how they did across all the questions.
    (So all students, across all subjects marked ‘tutorials’ favourably. Maths students answered most positively towards the questions about lectures and tutorials.)

    I’d like to find a way of comparing these two sets of data. Because whilst maths students themselves thought that generally their lectures and tutorials were the best bit about their course, those results are still the lowest when compared against the other two subjects.

    Do you know if there is any way of doing this?
    Thanks and again apologies if in the wrong place, just chucking it out there. Won't be offended if asked to remove.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,211

    Re: Data analysis, attempting to compare sets of data. Not sure if analysis exists.

    As you say, this is probably more of a statistics question than an Excel question.

    I haven't looked at your data in detail. My first thought is that perhaps an ANOVA test would be a suitable test to see if the means are actually different from each other. Excel has built in ANOVA tools, but I would first suggest you visit a statistics text or tutorial to understand how ANOVA works so you'll be able to interpret the results correctly. Here's one https://www.statisticssolutions.com/...nalyses/anova/

    Once you are satisfied that ANOVA is a suitable test, here's Excel's help file to explain how to perform an ANOVA analysis in Excel http://office.microsoft.com/en-us/ex...762.aspx?CTT=1
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Data analysis, attempting to compare sets of data. Not sure if analysis exists.

    Since it is just one dataset as far as I can see, I understand you want to combine the to perspectices (variations in scores within subject and within questions) in your analysis?
    One way is to use rank in both perspectives (instead of coloring), and create a table to visualize the combination of those.
    (See attached workbook)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1