Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default t-test for paired means

im using day customers purchases and evening customer purchases and i want to
determine if evening customers puchase, on average, more than day customers..
i did a t test two tail but i just need to clarify what the numbers actually
mean and how they can help me?? can anybody help??????
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 762
Default t-test for paired means

agarcia -

You may need to provide more information if you want some assistance.

If you have complete data for day purchases and for evening purchases, use
the AVERAGE function to compute each mean.

If you have a sample of values from each group, then a t test may be
appropriate, but only if you have a random sample.

In any case, it is unlikely that you have "paired" values, so if you are
testing random samples you would use either t-Test: Two-Sample Assuming
Equal Variances or t-Test: Two-Sample Assuming Unequal Variances.

For more information, you could browse to www.google.com and search for "two
sample t test" (without the quotes). Or, if you are sure you want to use
Excel, search for "two sample t test excel" (without the quotes).

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"agarcia" wrote in message
...
im using day customers purchases and evening customer purchases and i want
to
determine if evening customers puchase, on average, more than day
customers..
i did a t test two tail but i just need to clarify what the numbers
actually
mean and how they can help me?? can anybody help??????



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate mean of test scores from rows of test answers RiotLoadTime Excel Discussion (Misc queries) 1 July 26th 06 05:14 PM
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria Sam via OfficeKB.com Excel Worksheet Functions 2 March 20th 06 02:29 AM
hi i would like to know what this means } [email protected] New Users to Excel 1 February 24th 06 09:30 PM
paired bar chart abj2 Excel Discussion (Misc queries) 2 June 2nd 05 07:58 PM
how to flip paired data in a table, so last pair appears at top o. jim mcgrath New Users to Excel 1 December 21st 04 12:32 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"