+ Reply to Thread
Results 1 to 3 of 3

Incorrect calculatons in data analysis

  1. #1
    Registered User
    Join Date
    09-12-2013
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    2

    Incorrect calculatons in data analysis

    Hi everyone! Has anyone previously come across issues with statistical analysis in data analysis? Most of the tests are working fine but for some of the t-tests the t-statistic is calculated incorrectly and sometimes reports a positive t-statistic when it should be a negative number. I'm wondering if there is a setting somewhere that could impact this, or something about the format of the raw data? It's strange because most of the tests are 100% fine... Would appreciate any input or suggestions if there are any experts out there. Cheers.

  2. #2
    Forum Contributor
    Join Date
    03-03-2005
    Posts
    315

    Re: Incorrect calculatons in data analysis

    Katherine,

    Attach your worksheet. Have never encountered this problem.


    David

  3. #3
    Registered User
    Join Date
    09-12-2013
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Incorrect calculatons in data analysis

    Hi David,
    The attached files are a t-test done on my machine (t-test incorrect) and the same test, same data, from my classmate (t-test correct). I was the only one that got different numbers in the output. Also the t-test mean (done in data analysis plus) that reported a positive t-statistic which should have been negative (the mean is less than the hypothesised mean). That one was easy for me to pick up an error but not so easy to see that something was wrong with the t-test without calculating the whole thing by hand to check!
    Thanks
    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)

Similar Threads

  1. Replies: 2
    Last Post: 06-28-2013, 08:43 AM
  2. Data Analysis- advanced pivot functions for employee analysis
    By Dsankie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-10-2013, 12:30 AM
  3. Data line is incorrect when there is two lines of data
    By KanBama in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-05-2012, 09:50 AM
  4. Msgbox if data is incorrect
    By worecx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2011, 05:41 AM
  5. [SOLVED] Analysis ToolPak installed but no Data Analysis option
    By Eric Stephens in forum Excel General
    Replies: 3
    Last Post: 02-02-2005, 06:06 PM

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