不同群体女士对不同年轻化酒体的偏好管理数据

分析不同群体女士对不同年轻化黄酒酒体的评鉴评分结果，进而得出相应的偏好结论，为年轻化黄酒产品开发方向提供依据。一、采集调查对象对10种测试酒体的品评打分，记录每个调查对象的年龄和打分结果。
二、将调查对象按照年龄分成20-30周岁、31-40周岁、41周岁以上三组，分别统计每个年龄组内的调查对象数量。
三、分别计算10种测试酒体的所有调查对象品评打分平均分，即将每个调查对象的打分结果求平均。同时计算平均偏差，即将每个调查对象的打分结果与平均分的差值求绝对值，然后求平均。
四、对每个年龄组内的10种测试酒体调查对象品评打分平均分进行排名，按照得分由高到低进行排列，并赋予排名值10-1分。计算每种测试酒体的加权排名值，即将每个年龄组内的排名值乘以权重1/3，然后求和。根据加权排名值进行排序，得出10种测试酒体的加权得分值排序。
结合各酒体平均偏差数值，判断各酒体的欢迎程度及评价争议。通常情况下，平均得分较高且平均偏差较小的酒体会被认为是受欢迎且评价一致的。

This study aims to analyze the tasting score results of female participants from different groups towards 10 types of youth-oriented rice wine samples, and derive corresponding preference conclusions to provide a basis for the development direction of youth-focused rice wine products.

1. Collect the tasting scores given by survey participants for the 10 test rice wine samples, and record the age and score data of each participant.
2. Divide all survey participants into three age groups: 20-30 years old, 31-40 years old, and over 41 years old, and count the number of participants in each age group respectively.
3. Calculate the average score of all survey participants for each of the 10 test rice wine samples: specifically, compute the mean of the scores provided by all participants for each individual sample. Meanwhile, calculate the average deviation: take the absolute value of the difference between each participant's score and the average score of the corresponding sample, then compute the average of these absolute differences.
4. Rank the average tasting scores of the 10 test samples within each age group in descending order of scores, and assign ranking values ranging from 10 to 1. Calculate the weighted ranking value for each test sample by multiplying the ranking value from each age group by a weight of 1/3, then summing these products. Sort the 10 test samples based on their weighted ranking values to obtain the final weighted score ranking.

Combine the average deviation values of each rice wine sample to judge the popularity and evaluation controversy of each sample. Generally, rice wine samples with higher average scores and smaller average deviations are considered popular and have consistent evaluative feedback.

搜集汇总

数据集介绍

特点

该数据集包含214条记录，涵盖20-41岁以上女性对10种年轻化黄酒的评分数据，通过年龄分组统计和加权排名分析产品偏好，用于指导黄酒产品开发方向。