Đang chuẩn bị liên kết để tải về tài liệu:
Microsoft Excel 2010 Data Analysis and Business Modeling phần 6

2. Trong năm 1, 50 triệu $ trong vốn cho các dự án, và $ 20 triệu trong năm thứ 2.Nếu bạn không thể thực hiện một phần nhỏ của một dự án nhưng phải thực hiện hoặc tất cả hoặc không có một dự án, làm thế nào bạn có thể tối đa hóa NPV?Dự án 1 dự án 2 dự án 3 dự án 4 dự án 5 dự án 6 dự án 7 dự án 8 Dự án 9 | Chapter 42 Summarizing Data by Using Descriptive Statistics 345 The new Excel 2010 function RANK.AVG has the same syntax as the other RANK functions but in the case of ties RANK.AVG returns the average rank for all tied data points. For example since the two scores of 98 ranked third and fourth RANK.AVG returns 3.5 for each. I generated the average ranks by copying the formula RANK.AVG C4 C 4 C 62 0 from E4 to E5 E62. What is the trimmed mean of a data set Extreme skewness in a data set can distort the mean of the data set. In these situations people usually use median as a measure of the data set s typical value. The median however is unaffected by many changes in the data. For example compare the following two data sets Set 1 -5 -3 0 1 3 5 7 9 11 13 15 Set 2 -20 -18 -15 -10 -8 5 6 7 8 9 10 These data sets have the same median 5 but the second data set should have a lower typical value than the first. The Excel TRIMMEAN function is less distorted by extreme values than the AVERAGE function but it is more influenced by extreme values than the median. The formula TRIMMEAN range percent computes the mean of a data set after deleting the data points at the top percent divided by 2 and bottom percent divided by 2. For example applying the TRIMMEAN function with percent 10 converts the mean after deleting the top 5 percent and bottom 5 percent of the data. In cell F3 of the file Trimmean.xlsx the formula TRIMMEAN C4 C62 .10 computes the mean of the scores in C4 C62 after deleting the three highest and three lowest scores. The result is 90.04. In cell F4 the formula TRIMMEAN C4 C62 .05 computes the mean of the scores in C4 C62 after deleting the top and bottom scores. This calculation occurs because .05 59 2.95 would indicate the deletion of 1.48 of the largest observations and 1.48 of the smallest. Rounding off 1.48 results in deleting only the top and bottom observations. See Figure 42-7. When I select a range of cells is there an easy way to get a variety of .