Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Need help - simple statistics question

Simple question - need an urgent reply. I had a group of 52 panelists sample
and rate 2 separate products. Now I want to know if the mean ratings for the
2 products are significantly different. Do I use a paired or unpaired
t-test? Thanks in advance for any help.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 82
Default Need help - simple statistics question

On Feb 13, 8:23*pm, Pizza wrote:
* Simple question - need an urgent reply. I had a group of 52 panelists sample
and rate 2 separate products. Now I want to know if the mean ratings for the
2 products are significantly different. Do I use a paired or unpaired
t-test? Thanks in advance for any help.


If you want to get a fast reply, you should better to post to a
statistic group in Google not here
Choose a group from one of the following listing:
http://groups.google.com/groups/dir?...&q=statistics&
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,805
Default Need help - simple statistics question

Paired t-test.

However Rasoul is right... this is not the right forum for this question.

"Rasoul Khoshravan" wrote:

On Feb 13, 8:23 pm, Pizza wrote:
Simple question - need an urgent reply. I had a group of 52 panelists sample
and rate 2 separate products. Now I want to know if the mean ratings for the
2 products are significantly different. Do I use a paired or unpaired
t-test? Thanks in advance for any help.


If you want to get a fast reply, you should better to post to a
statistic group in Google not here
Choose a group from one of the following listing:
http://groups.google.com/groups/dir?...&q=statistics&

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default Need help - simple statistics question

On Feb 13, 9:36*am, Rasoul Khoshravan wrote:
If you want to get a fast reply, you should
better to post to a statistic group in Google


Ordinarily, I would agree with you. But in my experience, some of the
people in these Excel forums are much more helpful than the people in
the sci.stat.* newsgroups.
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default Need help - simple statistics question

Sheeloo wrote on Fri, 13 Feb 2009 09:58:11 -0800:

However Rasoul is right... this is not the right forum for
this question.


"Rasoul Khoshravan" wrote:


On Feb 13, 8:23 pm, Pizza wrote:
Simple question - need an urgent reply. I had a group of
52 panelists sample and rate 2 separate products. Now I
want to know if the mean ratings for the 2 products are
significantly different. Do I use a paired or
unpaired t-test? Thanks in advance for any help.


If you want to get a fast reply, you should better to post to
a statistic group in Google not here Choose a group from one
of the following
listing: http://groups.google.com/groups/dir?...%3D46406&q=sta
tistics&


I think an appropriate group might have been suggested for a rather
simple question but it have been better answered by scanning an
elementary book on statistics. Posing the question in a ng. might
produce both help and rude comments.
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Need help - simple statistics question



"Pizza" wrote:

Simple question - need an urgent reply. I had a group of 52 panelists sample
and rate 2 separate products. Now I want to know if the mean ratings for the
2 products are significantly different. Do I use a paired or unpaired
t-test? Thanks in advance for any help.



Since I am using Excel Analysis Pak, I automatically went here for advice.
Consulted several textbooks, but they were not clear as far as the example I
cite. I'm doing this type of analysis for the 1st time and want to be sure
it's correct.In the past folks here have been more than happy to answers
questions - sorry if I inconvenienced anyone!!!







  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Need help - simple statistics question



"joeu2004" wrote:

On Feb 13, 9:36 am, Rasoul Khoshravan wrote:
If you want to get a fast reply, you should
better to post to a statistic group in Google


Ordinarily, I would agree with you. But in my experience, some of the
people in these Excel forums are much more helpful than the people in
the sci.stat.* newsgroups.


Indeed - Thank You!
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default Need help - simple statistics question

Pizza wrote on Fri, 13 Feb 2009 10:45:03 -0800:

On Feb 13, 9:36 am, Rasoul Khoshravan
wrote:
If you want to get a fast reply, you should
better to post to a statistic group in Google


Ordinarily, I would agree with you. But in my experience,
some of the people in these Excel forums are much more
helpful than the people in the sci.stat.* newsgroups.


I'm surprised that no one suggested using Excel help. There is a
considerable amount of material available by asking help on statistical
tests, especially "About statistical analysis tools".

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default Need help - simple statistics question

On Feb 13, 10:43*am, Pizza wrote:
Consulted several textbooks, but they were not
clear as far as the example I cite. *I'm doing
this type of analysis for the 1st time and want
to be sure it's correct.


Which I thought was self-evident from the way you asked your question.


sorry if I inconvenienced anyone!!!


No apology needed. IMHO, anyone "inconvenienced" by a question posted
here and unwilling to offer a constructive response is not obligated
to read it, much less respond to it.

Sometimes, vectoring a person to another newsgroup or RTFM is the
right thing to do. But I don't think your inquiry rose to that
level. It was straight-forward and well-asked (succinct), and it
demonstrated a modicum of knowledge.
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default Need help - simple statistics question

On Feb 13, 10:17*am, "James Silverton"
wrote:
I think an appropriate group might have been suggested
for a rather simple question but it have been better
answered by scanning an elementary book on statistics.
Posing the question in a ng. might produce both help
and rude comments.


This is the sort of non-constructive response that I expect to see in
the sci.stat.* newsgroups.

You are not obligated to respond to questions that you think are
"dumb", especially if you can only think of "rude comments" to make.


  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default Need help - simple statistics question

joeu2004 wrote on Fri, 13 Feb 2009 11:54:06 -0800 (PST):

On Feb 13, 10:17 am, "James Silverton"
wrote:
I think an appropriate group might have been suggested
for a rather simple question but it have been better
answered by scanning an elementary book on statistics.
Posing the question in a ng. might produce both help
and rude comments.


This is the sort of non-constructive response that I expect to
see in the sci.stat.* newsgroups.


Don't be ridiculous! It's a fair warning not a protest.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

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
IF formula-simple question; simple operator Rich D Excel Discussion (Misc queries) 4 December 6th 07 03:36 PM
Statistics StudentSimple Graph Template? Larry Excel Worksheet Functions 0 July 21st 06 06:48 PM
Very simple question. Fenneth Excel Discussion (Misc queries) 3 April 19th 06 07:53 PM
Statistics/Charting Question - Please Help!! elfmajesty Excel Discussion (Misc queries) 2 January 13th 06 07:59 PM
Simple Simple Excel usage question BookerW Excel Discussion (Misc queries) 1 June 23rd 05 10:06 PM


All times are GMT +1. The time now is 12:56 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"