Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

One and Two tailed T-Test

Posted on 2014-02-11
1
Medium Priority
?
298 Views
Last Modified: 2014-03-06
Hi

I have two data sets. I want to compare between them to see how match are they closer than each other. I am using T-test. But I am really confused what shall I use, one or two tail. Also, shall I use equal variance or unequal' variance?

the two data sets attached to this question
To-EE.xlsx
0
Comment
Question by:amq10
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 24

Accepted Solution

by:
Steve earned 2000 total points
ID: 39849937
The two data sets you have there are non-normal (they are skewed).
To perform a Two Sample T test you would need to normalise the data first.
Most likely with these skewed data points you would use a Poisson transformation.

Once the data is transformed you should be able to quantify how different these two set are.

I have attached analysis to show how skewed the two data sets are.
To-EE.xlsx
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question