Bazne funkcije i IF funkcija

# Bazne funkcije i IF funkcija - 13 The average age of all...

This preview shows pages 1–2. Sign up to view the full content.

0

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Tree Height Age Yield Profit Height =Apple >10 <16 =Pear Tree Height Age Yield Profit Apple 18 20 14 105 Pear 12 12 10 96 Cherry 13 14 9 105 Apple 14 15 10 75 Pear 9 8 8 76.8 Apple 8 9 6 45 BAZNE FUNKCIJE 1 This function looks at the records of apple trees between a height of 10 and 16 and counts how many of the Age fields in those records contain numbers. (1) 1 This function looks at the records of apple trees between a height of 10 and 16 and counts how many of the Profit fields in those records are not blank. (1) 105 The maximum profit of apple and pear trees. (105) 75 The minimum profit of apple trees over 10 in height. (75) 225 The total profit from apple trees. (225) 35 The total profit from apple trees with a height between 10 and 16. (75) 140 The product of the yields from apple trees with a height greater than 10. (140) 12 The average yield of apple trees over 10 feet in height. (12)
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 13 The average age of all trees in the database. (13) 2.9664793948 The estimated standard deviation in the yield of apple and pear trees if the data in the database is only a sample of the total orchard population. (2.97) 2.6532998323 The true standard deviation in the yield of apple and pear trees if the data in the database is the entire population. (2.65) 8.8 The estimated variance in the yield of apple and pear trees if the data in the database is only a sample of the total orchard population. (8.8) 7.04 The true variance in the yield of apple and pear trees if the data in the database is the entire orchard population. ( 7.04) Returns the #NUM! error value because more than one record meets the criteria. IF FUNKCIJA 3 3 3 5 4 nemam sve ocjene!...
View Full Document

## Bazne funkcije i IF funkcija - 13 The average age of all...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online