+ Reply to Thread
Results 1 to 2 of 2

Thread: Cumulative Scores

  1. #1
    Registered User
    Join Date
    09-16-2011
    Location
    Oklahoma City
    MS-Off Ver
    Excel 2010
    Posts
    1

    Cumulative Scores

    I'm trying to calcualte the cumulative score for taste tesing cards.

    Scale 1 2 3 4 5
    Reponses 14 11 9 5 4

    How would this be calculated?

  2. #2
    Valued Forum Contributor MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    5,318

    Re: Cumulative Scores

    Hi TerriAnn and welcome to the forum,

    See the attached that has a Sum formula and a second column to show how you might do Cumulative Scores.

    It would seem to me you'd want average score and standard deviation from responses, but I'm not doing this problem.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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.2.0