數(shù)據(jù)可視化分析（Excel 2016+Tableau）（第2版）【習(xí)題參考答案】 第3章第6題

大地公司某品牌計算機設(shè)備全年銷量統(tǒng)計表,,,,,,,,

店鋪,季度,商品名稱,銷售量,單價,銷售額,,商品名稱,銷售額

上地店,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,,,

中關(guān)村店,1季度,筆記本,230,4552.3112,1047031.576,,,

中關(guān)村店,2季度,筆記本,180,4552.3112,819416.016,,,

中關(guān)村店,3季度,筆記本,290,4552.3112,1320170.248,,,

中關(guān)村店,4季度,筆記本,350,4552.3112,1593308.92,,,

中關(guān)村店,1季度,臺式機,261,3861.2253,1007779.803,,,

中關(guān)村店,2季度,臺式機,349,3861.2253,1347567.63,,,

中關(guān)村店,3季度,臺式機,400,3861.2253,1544490.12,,,

中關(guān)村店,4季度,臺式機,416,3861.2253,1606269.725,,,

中關(guān)村店,1季度,鼠標,586,109.5461,64194.0146,,,

中關(guān)村店,2季度,鼠標,643,109.5461,70438.1423,,,

中關(guān)村店,3季度,鼠標,582,109.5461,63755.8302,,,

中關(guān)村店,4季度,鼠標,733,109.5461,80297.2913,,,

中關(guān)村店,1季度,鍵盤,754,175.3987,132250.6198,,,

中關(guān)村店,2季度,鍵盤,527,175.3987,92435.1149,,,

中關(guān)村店,3季度,鍵盤,768,175.3987,134706.2016,,,

中關(guān)村店,4季度,鍵盤,798,175.3987,139968.1626,,,