Open the attached Excel sheet Heat.xls and use it to answer the following questions.
Watch the very helpful video on Filtering on Excel
Here is another video on Sorting and Cleaning Data
1) What is the average Established Count for Maryland, West Virginia and Pennsylvania in the areas of "Sawmills" and "Pulp Mills"?
Give value to 2 decimal places.
2) What is the minimum Established Count for Maryland, West Virginia and Pennsylvania in the areas of Saw Mills and Pulp Mills?
Give value to 2 decimal places.
3) What is the maximum Established Count for Maryland, West Virginia and Pennsylvania in the areas of Saw Mills and Pulp Mills?
Give value to 2 decimal places.
4) What is the Range in Established Count for Maryland, West Virginia and Pennsylvania in the areas of Saw Mills and Pulp Mills?
Give value to 2 decimal places.
5) What is the median in Established Count for New York and California in the areas of Industrial gases and Ethyl Alcohol?
Give value to 2 decimal places.
- Question Help:
- Written Example