有一投資組合, 其中台積電佔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 |