发帖
雷达卡
| 有一投資組合, 其中台積電佔50%, 聯電佔30%, 華邦電佔20%, 若今日收盤時台積電漲2%, 聯電漲1%, 華邦電跌3%, | ||||||||||||||
| 則投資組合漲跌幅為多少? (請用Excel設公式計算出答案) | ||||||||||||||
| Question 2: | ||||||||||||||
| Please refer to the following chart: | ||||||||||||||
| (1) Calculate the percentage of monthly sales growth in 2010 (MoM Change%), | ||||||||||||||
| (2) Draw a line chart with monthly sales growth (%) of each product. | ||||||||||||||
| Sales of consumer electronics in 2010 (units) | ||||||||||||||
| ||||||||||||||
| Jan. | Feb. | Mar. | Apr. | May | June | July | Aug. | Sep. | Oct. | Nov. | Dec. | |||
| TV | 5 | 5 | 3 | 4 | 2 | 2 | 2 | 4 | 3 | 5 | 5 | 6 | ||
| Refrigerator | 7 | 6 | 7 | 4 | 3 | 4 | 3 | 3 | 1 | 6 | 5 | 6 | ||
| Washer | 10 | 10 | 7 | 9 | 9 | 8 | 7 | 5 | 4 | 5 | 6 | 4 | ||
| Air-conditioner | 2 | 1 | 4 | 7 | 11 | 11 | 13 | 14 | 12 | 9 | 3 | 2 | ||
京公网安备 11010802022788号
