Jane has just started a job at a local shoe retailer. One of her first tasks was to compile the above worksheet, showing the first quarter. Her boss has reviewed the worksheet and asked her to add some functions and formulas to the worksheet.
-What formula would yield the correct results for cell C18?
Definitions:
Approximate Class Width
An estimated value for the range of each category in a frequency distribution.
Frequency Distribution
A summary of how often different values occur within a dataset, often represented in a table or graph.
Quantitative Data
Numerical data that quantifies an object or event, which can then be subjected to statistical analysis.
Range
The difference between the highest and lowest values in a set of data.
Q1: #3<br>A)Counts all Inspector IDs that contain the
Q5: In a scatter chart and a bubble
Q23: Invalid cell reference<br>A)######<br>B)#N/A<br>C)#VALUE!<br>D)#DIV/0!<br>E)#NAME?<br>F)#REF!<br>G)#NUM!
Q26: A data list that categorizes values you
Q48: A(n) _ in Excel always begins with
Q60: The Switch Row/Column button provides settings for
Q98: When you write a VLOOKUP formula, you
Q111: The _ Paste option button pastes only
Q117: _ is/are third in the order of
Q119: You can use the _ logical functions