LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,441
Default Need statistics help!

Generally speaking, you need to:
Decide what your testers are going to test for, and how they will score it. For example, if you
were testing Pizza, you might have the panelists test the crust for lightness, crispness,
doughiness, etc; the sauce for saltiness, tomato flavor, spices; the topping for greasiness, taste,
stringiness....

You may want to train the panelists on how to differentiate between the qualities that you are
looking for.

1) Keep your testers in the dark about how many different products they are testing
2) Randomly present the products to the individials - sometimes product 1 first, other times product
2 first, and strive to keep the products consistent in their presentation
3) Repeat your tests, so that each individual "tests" each product multiple times
4) Hire a PhD Statistician......err,
4a) Look at the mean, variance, spread, standard deviation of your data, based on overall, each
judge, order presented, and over time. Look for trends, and then you need to decide what is
meaningful. For example, you could decide that the mean values need to differ by at least the
largest of the standard deviations, the mean values need to differ by the sum of the two different
standard deviations, etc.

Remember, there are liars, da*ned liars, and statisticians.

HTH,
Bernie
MS Excel MVP


"Pizza" wrote in message
...
I am running a test where a group of individuals will sample 2 products and
provide a preference for one or the other, as well as an overall rating for
each product.
Okay - what test will tell me a) that the preference rating indicates a
"true win" for one product or the other?; and, b) that the average overall
ratings for the 2 products are or are not significantly different?
I have some ideas, but would appreciate any help that's out there!!! THANKS!



 
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
statistics problem driller New Users to Excel 1 November 18th 06 04:55 PM
excel or access template/application for baseball statistics fkoskotas Excel Discussion (Misc queries) 1 May 9th 06 03:17 AM
excel and statistics functions sjvicker Excel Worksheet Functions 4 February 16th 06 03:51 AM
descriptive statistics - text in survey allen367 Excel Discussion (Misc queries) 1 January 17th 06 03:27 AM
Regression Statistics are returned as Rounded to 1 vs. several dec DWright Excel Worksheet Functions 2 September 9th 05 04:38 PM


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