Quantitative Business Analysis QBA 120 Study Guide - Midterm Guide: Combinatorics, Collectively Exhaustive Events, And1
13 Dec 2016
School
Department
Professor
Document Summary
=countif(variable, string), where the variable is the defined range and the string is the parameter you are trying to count. Can use =count(range) to get the number of observations. In determining the class interval size, we want to show the most information possible. A larger range will have lesser specificity, but if the range gets too small the curve will become too flat. To set class intervals: =countif(variable, >= &(lower) countif(variable, In excel: =average(variable: the median of a quantitative data set is the middle number when the measurements are arranged in ascending/descending order. To calculate, if n is odd, the median is the middle number after sorting, but if n is even, the median is the average of the middle two numbers. In excel: =median(variable: skewness: a data set is said to be skewed if one tail of the distribution has more extreme observations than the other tail, a symmetric distribution. Median = mean: a right skewed distribution.
