IV illustrate

1, were: a high level of fruit orchards, the use of the number of years, yield and profit as shown in table statistics,

Figure 2

I hope to derive

(1) the number of species of apple tree height of 16 feet in between 10 ~

(2) apple and pear return value is the largest number of

(3) greater than 10 feet high minimum profit of apple trees is the number of

(4) the total profit of apple trees

(5) 10 feet high is greater than the average yield of apple trees

(6) of all species orchard average number of years

(7) apple and pear production in order to estimate the standard deviation, the true standard deviation, variance estimation, the true variance.

2, to solve these

(1) create a blank workbook or worksheet to data entry in Excel

Figure 3

(2) as a result of the need to solve first asked how many kinds of apple trees in the tree height between 10 to 16 feet, so the establishment of a high degree of query between 10 and 16

Figure 4

(3) the use of functions to meet the conditions for solving DCOUNT cell number to calculate the height of 16 feet in 10 types of apple trees. Formula: DCOUNT (A4: E10, "the use of the number of years", B1: G2), calculated to meet the conditions of an apple tree.