QMB 3200 EXPECTED QUESTIONS
COMPILED IN A SUMMARY FORM
Frequency Distribution definition
A tabular summary of data showing the number (frequency) of
observations in each of several nonoverlapping categories or
classes.
Relative Frequency Distribution definition
A tabular summary of data showing the fraction or proportion
of observations in each of several nonoverlapping categories or
classes.
percent frequency distribution definition
A tabular summary of data showing the percentage of
observations in each of several nonoverlapping classes.
How to construct a frequency distribution in Excel (softdrink
Excel)?
Select any cell in the data set (cells A1:A51), Click the Insert tab
on the Ribbon, In the Tables group click Recommended
PivotTables; a preview showing the frequency distribution
appears, Click OK; the frequency distribution will appear in a
new worksheet.
How to show relative and percent frequency in Excel (softdrink
Excel)?
,Create a formula that takes the frequency divided by the total
(i.e. =B4/$B$9, =B5/$B$9, etc.) for relative frequency. Percent
frequency takes Relative Frequency 100 (i.e. C4100). Use SUM
function at end to calculate total relative and percent frequency
What is a bar chart?
A graphical device for depicting categorical data that have been
summarized in a frequency, relative frequency, or percent
frequency distribution.
What is a pie chart?
A graphical device for presenting data summaries based on
subdivision of a circle into sectors that correspond to the
relative frequency for each class.
How do you create a bar chart in Excel (softdrink)
Select any cell in the data set (cells A1:A51), Click the Insert tab
on the Ribbon, In the Charts group click Recommended Charts;
a preview showing the bar chart appears, Click OK; the bar
chart will appear in a new worksheet (this creates a frequency
distribution at the same time).
What are some editing options within a bar chart?
Click chart title to change name, Click the Chart Elements
button (+) and add Axis Titles, Click horizontal and vertical axis
titles to change names, Right-click on any of the bars in the
chart, select Sort and click sort Largest to Smallest.
Class Midpoint definition
, the value halfway between the lower and upper class limits
How to create a frequency distribution without
Recommended Pivot Tables (audit)?
Select any cell in the data set (cells A1:A21), Click the Insert tab
on the Ribbon, In the Tables group click PivotTable, When the
Create PivotTable dialog box appears click Ok and a PivotTable
and PivotTable Fields task pane will appear in a new worksheet.,
In the PivotTable Fields task pane: Drag Audit Time to the ROWS
area and Drag Audit Time again to the VALUES area, Click on
Sum of Audit Time in the VALUES area, Select Value Field
Settings from the list of options that appears, When the Value
Field Settings dialog box appears: Under "Summarize value field
by" choose Count and click OK.
How do you group rows after creating a PivotTable (audit)?
Right-click A4 in the PivotTable or any other cell containing an
an audit time, choose Group from the list of options that
appears, When the Grouping dialog box appears: Enter 10 in
the "Starting at:" box, Enter 34 in the "Ending at:" box and click
OK.
How do you show data with no values in a PivotTable?
Right-click any cell in the Row Labels column of the PivotTable,
Click Field Settings, When the Field Settings dialog box appears:
Click the Layout and Print tab, Choose Show items with no data,
Click OK.
Dot plot definition
COMPILED IN A SUMMARY FORM
Frequency Distribution definition
A tabular summary of data showing the number (frequency) of
observations in each of several nonoverlapping categories or
classes.
Relative Frequency Distribution definition
A tabular summary of data showing the fraction or proportion
of observations in each of several nonoverlapping categories or
classes.
percent frequency distribution definition
A tabular summary of data showing the percentage of
observations in each of several nonoverlapping classes.
How to construct a frequency distribution in Excel (softdrink
Excel)?
Select any cell in the data set (cells A1:A51), Click the Insert tab
on the Ribbon, In the Tables group click Recommended
PivotTables; a preview showing the frequency distribution
appears, Click OK; the frequency distribution will appear in a
new worksheet.
How to show relative and percent frequency in Excel (softdrink
Excel)?
,Create a formula that takes the frequency divided by the total
(i.e. =B4/$B$9, =B5/$B$9, etc.) for relative frequency. Percent
frequency takes Relative Frequency 100 (i.e. C4100). Use SUM
function at end to calculate total relative and percent frequency
What is a bar chart?
A graphical device for depicting categorical data that have been
summarized in a frequency, relative frequency, or percent
frequency distribution.
What is a pie chart?
A graphical device for presenting data summaries based on
subdivision of a circle into sectors that correspond to the
relative frequency for each class.
How do you create a bar chart in Excel (softdrink)
Select any cell in the data set (cells A1:A51), Click the Insert tab
on the Ribbon, In the Charts group click Recommended Charts;
a preview showing the bar chart appears, Click OK; the bar
chart will appear in a new worksheet (this creates a frequency
distribution at the same time).
What are some editing options within a bar chart?
Click chart title to change name, Click the Chart Elements
button (+) and add Axis Titles, Click horizontal and vertical axis
titles to change names, Right-click on any of the bars in the
chart, select Sort and click sort Largest to Smallest.
Class Midpoint definition
, the value halfway between the lower and upper class limits
How to create a frequency distribution without
Recommended Pivot Tables (audit)?
Select any cell in the data set (cells A1:A21), Click the Insert tab
on the Ribbon, In the Tables group click PivotTable, When the
Create PivotTable dialog box appears click Ok and a PivotTable
and PivotTable Fields task pane will appear in a new worksheet.,
In the PivotTable Fields task pane: Drag Audit Time to the ROWS
area and Drag Audit Time again to the VALUES area, Click on
Sum of Audit Time in the VALUES area, Select Value Field
Settings from the list of options that appears, When the Value
Field Settings dialog box appears: Under "Summarize value field
by" choose Count and click OK.
How do you group rows after creating a PivotTable (audit)?
Right-click A4 in the PivotTable or any other cell containing an
an audit time, choose Group from the list of options that
appears, When the Grouping dialog box appears: Enter 10 in
the "Starting at:" box, Enter 34 in the "Ending at:" box and click
OK.
How do you show data with no values in a PivotTable?
Right-click any cell in the Row Labels column of the PivotTable,
Click Field Settings, When the Field Settings dialog box appears:
Click the Layout and Print tab, Choose Show items with no data,
Click OK.
Dot plot definition
