数据可视化分析（Excel 2016+Tableau）（第2版）【习题参考答案】 第3章第6题

大地公司某品牌计算机设备全年销量统计表,,,,,,,,

店铺,季度,商品名称,销售量,单价,销售额,,商品名称,销售额

上地店,1季度,笔记本,180,4552.3112,819416.016,,笔记本,16980120.78

上地店,2季度,笔记本,140,4552.3112,637323.568,,台式机,19723138.83

上地店,3季度,笔记本,220,4552.3112,1001508.464,,鼠标,1080453.184

上地店,4季度,笔记本,280,4552.3112,1274647.136,,打印机,9416558.481

上地店,1季度,台式机,247,3861.2253,953722.6491,,键盘,1840283.16

上地店,2季度,台式机,230,3861.2253,888081.819,,,

上地店,3季度,台式机,285,3861.2253,1100449.211,,,

上地店,4季度,台式机,293,3861.2253,1131339.013,,,

上地店,1季度,鼠标,516,109.5461,56525.7876,,,

上地店,2季度,鼠标,748,109.5461,81940.4828,,,

上地店,3季度,鼠标,654,109.5461,71643.1494,,,

上地店,4季度,鼠标,700,109.5461,76682.27,,,

上地店,1季度,键盘,686,175.3987,120323.5082,,,

上地店,2季度,键盘,531,175.3987,93136.7097,,,

上地店,3季度,键盘,581,175.3987,101906.6447,,,

上地店,4季度,键盘,711,175.3987,124708.4757,,,

上地店,1季度,打印机,500,1150.4653,575232.65,,,

上地店,2季度,打印机,428,1150.4653,492399.1484,,,

上地店,3季度,打印机,548,1150.4653,630454.9844,,,

上地店,4季度,打印机,597,1150.4653,686827.7841,,,

西直门店,1季度,笔记本,200,4552.3112,910462.24,,,

西直门店,2季度,笔记本,150,4552.3112,682846.68,,,

西直门店,3季度,笔记本,250,4552.3112,1138077.8,,,

西直门店,4季度,笔记本,300,4552.3112,1365693.36,,,

西直门店,1季度,台式机,260,3861.2253,1003918.578,,,

西直门店,2季度,台式机,243,3861.2253,938277.7479,,,

西直门店,3季度,台式机,362,3861.2253,1397763.559,,,

西直门店,4季度,台式机,377,3861.2253,1455681.938,,,

西直门店,1季度,鼠标,538,109.5461,58935.8018,,,

西直门店,2季度,鼠标,565,109.5461,61893.5465,,,

西直门店,3季度,鼠标,566,109.5461,62003.0926,,,

西直门店,4季度,鼠标,750,109.5461,82159.575,,,

西直门店,1季度,键盘,597,175.3987,104713.0239,,,

西直门店,2季度,键盘,502,175.3987,88050.1474,,,

西直门店,3季度,键盘,682,175.3987,119621.9134,,,

西直门店,4季度,键盘,712,175.3987,124883.8744,,,

西直门店,1季度,打印机,503,1150.4653,578684.0459,,,

西直门店,2季度,打印机,443,1150.4653,509656.1279,,,

西直门店,3季度,打印机,430,1150.4653,494700.079,,,

西直门店,4季度,打印机,585,1150.4653,673022.2005,,,

亚运村店,1季度,笔记本,210,4552.3112,955985.352,,,

亚运村店,2季度,笔记本,170,4552.3112,773892.904,,,

亚运村店,3季度,笔记本,260,4552.3112,1183600.912,,,

亚运村店,4季度,笔记本,320,4552.3112,1456739.584,,,

亚运村店,1季度,台式机,336,3861.2253,1297371.701,,,

亚运村店,2季度,台式机,315,3861.2253,1216285.97,,,

亚运村店,3季度,台式机,357,3861.2253,1378457.432,,,

亚运村店,4季度,台式机,377,3861.2253,1455681.938,,,

亚运村店,1季度,鼠标,648,109.5461,70985.8728,,,

亚运村店,2季度,鼠标,619,109.5461,67809.0359,,,

亚运村店,3季度,鼠标,509,109.5461,55758.9649,,,

亚运村店,4季度,鼠标,506,109.5461,55430.3266,,,

亚运村店,1季度,键盘,674,175.3987,118218.7238,,,

亚运村店,2季度,键盘,553,175.3987,96995.4811,,,

亚运村店,3季度,键盘,650,175.3987,114009.155,,,

亚运村店,4季度,键盘,766,175.3987,134355.4042,,,

亚运村店,1季度,打印机,406,1150.4653,467088.9118,,,

亚运村店,2季度,打印机,424,1150.4653,487797.2872,,,

亚运村店,3季度,打印机,462,1150.4653,531514.9686,,,

亚运村店,4季度,打印机,577,1150.4653,663818.4781,,,

中关村店,1季度,笔记本,230,4552.3112,1047031.576,,,

中关村店,2季度,笔记本,180,4552.3112,819416.016,,,

中关村店,3季度,笔记本,290,4552.3112,1320170.248,,,

中关村店,4季度,笔记本,350,4552.3112,1593308.92,,,

中关村店,1季度,台式机,261,3861.2253,1007779.803,,,

中关村店,2季度,台式机,349,3861.2253,1347567.63,,,

中关村店,3季度,台式机,400,3861.2253,1544490.12,,,

中关村店,4季度,台式机,416,3861.2253,1606269.725,,,

中关村店,1季度,鼠标,586,109.5461,64194.0146,,,

中关村店,2季度,鼠标,643,109.5461,70438.1423,,,

中关村店,3季度,鼠标,582,109.5461,63755.8302,,,

中关村店,4季度,鼠标,733,109.5461,80297.2913,,,

中关村店,1季度,键盘,754,175.3987,132250.6198,,,

中关村店,2季度,键盘,527,175.3987,92435.1149,,,

中关村店,3季度,键盘,768,175.3987,134706.2016,,,

中关村店,4季度,键盘,798,175.3987,139968.1626,,,