+ Reply to Thread
Results 1 to 2 of 2

How to put statistics into excel data analysis vs. putting data in?

  1. #1
    Registered User
    Join Date
    06-22-2016
    Location
    USA
    MS-Off Ver
    2011 (Mac)
    Posts
    1

    How to put statistics into excel data analysis vs. putting data in?

    I am given Statistics (i.e. a mean, standard dev, and number of participants in a trial) and I am trying to run a "t-Test: Two-Sample Assuming Unequal Variances" under the data analysis on Excel. However, Excel asks for data ranges. How can I input my statistics into a data analysis like that? Thank you.

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

    Re: How to put statistics into excel data analysis vs. putting data in?

    I would use the formulas described here: https://en.wikipedia.org/wiki/Studen...qual_variances
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Excel Statistics and Data Analysis
    By kwhelchel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2021, 08:07 AM
  2. Replies: 2
    Last Post: 06-28-2013, 08:43 AM
  3. Replies: 3
    Last Post: 05-10-2013, 07:20 AM
  4. Replies: 1
    Last Post: 07-20-2012, 06:55 AM
  5. Statistics and data analysis in Excel?
    By arapoi01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2012, 03:17 AM
  6. Data Analysis - Descriptive Statistics
    By TheRobsterUK in forum Excel General
    Replies: 0
    Last Post: 05-19-2011, 08:31 AM
  7. Doing statistics with data analysis add-in
    By Adversus in forum Excel General
    Replies: 0
    Last Post: 01-24-2008, 11:31 AM
  8. [SOLVED] statistics - data analysis tool
    By Neil Evans-Mudie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2005, 10:06 AM

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