Sensory report from data

Generate a sensory analysis report from raw data. Please generate the same report as shown as a sample lab report.

Apple Juice Ballot
October 2023
Panelist: ______
Sample code: ________
Date __________
Appearance
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
Aroma
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
Flavor
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
15 Point Scale with 0.5 Increments
Sensory Analysis Center
Apple Juice Ballot
October 2023
Mouthfeel
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
Texture
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
Residual (aftertaste)
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
______________
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 13.5 14 14.5 15
15 Point Scale with 0.5 Increments
Sensory Analysis Center
Sample Report (Only for reference)
Introduction to Descriptive Analysis:
Objective:
1. To become familiar with methods used for term generation
2. To become familiar with the criteria for including terms in a descriptive ballot
3. To become familiar with descriptive analysis data collection and analysis
Background:
To get familiar with the basic steps of descriptive analysis by evaluating three different apple
juice products using appropriate references.
•
•
•
Sample 506 – Motts’ 100% Apple Juice, filtered
Sample 713 – Great Value/ Any store brand Apple Juice
Sample 248 – RW Knudsen Organic Apple Juice
Data of 3 panelists is collected and used for data analysis and drawing results.
Materials Required:
•
•
•
•
•
•
•
RW Knudsen Organic Apple Juice, 32 fl. oz. (1 bottle)
Motts’ 100% Apple Juice, filtered 64 fl. oz. (1 bottle)
Great Value 100% Apple Juice/any store brand, 64 fl. oz. (1 bottle)
3.25 oz. cups (or any other sizes that you have) for sample serving
Cups for rinse water
Spring water or other odorless water of higher purity.
Napkins, spill control, and cleanup supplies
Methods/procedure:
The procedure is divided into 2 parts as follows,
Part I Term Generation
In this part, the two products below are used to generate the descriptive terms for the
products. The samples are presented to each panelist in the same order.
o
o
Sample 506 – Motts’ 100% Apple Juice, filtered
Sample 248 – RW Knudsen Organic Apple Juice
Different attributes identified by the panelists from the two samples are noted down.
The panel leader collects the terms each panelist generated, during which redundant,
vague, or hedonic terms will be eliminated upon the agreement of all the panelists. The
term list will be expanded and refined during the discussion after tasting the second
sample. The definitions of the terms should be clarified in this step.
Predefined scale: 15-point intensity scale with 0.5 increments is used. The anchor terms
for the scales on the ballots would be: 0 (none) to 15 (extremely high).
Sample Report (Only for reference)
Part II Descriptive Evaluation
In this part, the terms generated from part I will be used to evaluate 3 products. Samples
must be coded by 3-digit random numbers as suggested below,
o
o
o
Sample 506 – Motts’ 100% Apple Juice, filtered
Sample 713 – Great Value/ Any store brand Apple Juice
Sample 248 – RW Knudsen Organic Apple Juice
The three samples and three evaluation ballots are shared with each panelist in randomized
order, along with references and ref/def sheet.
Panelists evaluate each sample independently on the evaluation ballot. Panelists evaluate
one sample at a time for all the attributes on the ballots.
the data on paper ballots are copied into an excel sheet. Each panelists’ data are treated for
one given sample as a replication. Therefore, each sample should have 3 replications in the
end.
Sample Report (Only for reference)
Data analysis & discussion: Anova
The panelists data is used for running Anova analysis to find out the significant differences between the
products for all the attributes.
Summary (LS means) – Sample:
Appearance(app) attributes
App-Clarity
App-Color
11.500 a
6.100 c
8.733 b