QMB 3200 Exam 1 (1)

QMB 3200 Exam 1

Frequency Distribution - ANS-=COUNTIF

Reative Frequency - ANS-= Frequency Distribution / Total

Cumulative Frequency - ANS-Add up the relative frequency from low to high. Should
add add up to 100%

Create Histogram - ANS-Highlight Data > Insert > Charts

Method to determine # of classes in a frequency distribution - ANS-2^k > n
k = number of classes
n = number of data points

Estimated Class Width - ANS-= ( Maximum Data Value - Minimum Data Value) / k

Find frequencies with class widths - ANS-Highlight data > insert > pivot table
1) Move to rows and values,
2) Right click on pivot table
3) Click group and change to size of class width

How to create a Pareto Chart with Ogive - ANS-Highlight y axis column, relative, and
cumulative data (skip frequency) > Insert > chart > cluster column chart > right click
change chart type> series 2: change to line chart

Ogive - ANS-cumulative relative frequency as a line on Pareto chart

Calculate Weighted Mean - ANS-= multiple the values by there frequencies. Add them
all up to get a weighted total.
weighted mean = weighted total / actual total

Calculate Mean - ANS-=AVERAGE

Calculate Median - ANS-=MEDIAN

Calculate Mode - ANS-=MODE