Sensory Analysis: Mean Scores and Sample Comparisons

Aug 5, 2025, 4:42 PM

Sensory Analysis.xlsx

Missing file

Please analysis data this document.Also give mean value

Key Findings from the sensory data

Overall mean scores (across all 150 observations):
AttributeMean score
Appearance3.85
Aroma3.99
Taste3.92
Mouth Feel3.83
Overall Acceptability3.96
These values are on the usual 1–5 hedonic scale, so everything lies close to the positive side of the scale.
By sample code (averaged over the 30 panelists):
SampleAppearanceAromaTasteMouth FeelOverall Accept.
2743.904.033.903.934.07
3163.903.973.873.834.03
5174.104.204.033.874.03
6393.373.603.473.403.40
7484.004.134.334.134.27
• Sample 748 stands out as the most liked overall (highest overall-acceptability 4.27) and also scores the best for Taste and Mouth Feel.
• Sample 517 achieves the highest Aroma score (4.20) and shares a high overall acceptability.
• Sample 639 consistently scores the lowest on every attribute.

Visual insight

You should now see two interactive bar charts:
  1. Overall Mean Sensory Scores – a single bar for each attribute.
  2. Mean Sensory Scores by Sample Code – grouped bars so you can visually compare samples across attributes.
Feel free to hover over bars to inspect exact values or to zoom in/out.
Would you like to:
  • Compare samples with statistical tests (e.g.�a0ANOVA)?
  • Look at the distribution of scores for each attribute?
  • Explore panelist-wise behaviour?
Just let me know!

Please give it with t statistic & p value

It looks like the notebook session was restarted, so the dataframe df that we created earlier disappeared from memory.
When I tried to run the t-tests I therefore referenced a variable that no longer exists and Python raised a NameError.
I then tried to reload the workbook (Sensory Analysis.xlsx) from disk, but the file is not present in the current working directory of this (fresh) session, so a FileNotFoundError was raised as well.
How to continue:
  1. Please re-upload the Sensory Analysis spreadsheet (or let me know its exact filename/path).
    – As soon as the file is available I will reload it and run the requested pairwise Welch t-tests, reporting both t statistics and p-values and visualising the results in a heat-map.
  2. Alternatively, if you only want the formulae or example output, let me know and I can illustrate the process without re-executing the data.
Just tell me how you’d like to proceed and I’ll pick it up from there!
It looks like our notebook session restarted, so the dataframe df has been cleared from memory. When I attempted to reload the file Sensory Analysis.xlsx the system could not find it in the current working directory, triggering the FileNotFoundError you saw.
Next step
• Please re-upload the spreadsheet (or confirm its exact name/path).
• As soon as the file is available again I will run the pair-wise Welch t-tests you requested and give you the full table of t-statistics and p-values, plus a heat-map that highlights any significant differences.
Let me know when the file is ready (or if you prefer a different analysis)!
Get started with Vizly