UCF QMB 3200 UPDATED EXAMS TEST PAPER
QUESTIONS AND ANSWERS SURE A+
✔✔pie chart - ✔✔a visual display of frequency; relative frequency & percent frequency
distributions.
✔✔How would you create a bar chart in excel? - ✔✔a. Select any cell from A1 to A51.
b. Click the Insert tab from the Ribbon.
c. In Charts, click Recommended Charts
d. Click OK. [bar chart appears in a new worksheet]
✔✔What are the basic steps to using excel? - ✔✔Access the data, Functions &
formulas, Apply tools, Editing options
✔✔A frequency distribution with quantitative data mustdefine the classes for a
frequency distribution by: - ✔✔a. determine the number of non over-lapping
classes;
b. determine the width of each class;
c. determine the class limits.
✔✔Number of Classes - ✔✔Typically, between 5 and 20. Small datasets have less;
larger datasets have more.
,✔✔Width of the Class - ✔✔Generally, it should be the same for each class.
Approximate class width = (largest data value - smallest data value)/number of classes.
✔✔Class Limits - ✔✔Each data observation must only belong to one class.
✔✔Relative Frequency Distributions - ✔✔frequency of theclass/n
✔✔To construct a frequency distribution in excel - ✔✔we must group the rows.
✔✔What if a class has no data? - ✔✔[Excel automaticallyremoves these classes]
To change this:Click the Layout and Print tab
Choose show items with no data; click OK
✔✔Histogram - ✔✔A visual display of a frequency, relative frequency, or percent
frequency distribution, where the variable of interest is on the horizontal axis and the
frequency, relative frequency, or percent frequency is on the vertical axis.
✔✔A histogram shows - ✔✔shows the shape of the distribution of
the variable of interest.
A distribution is skewed if more of the data is either
to the left or right of the distribution.
✔✔How would we construct a histogram in excel? - ✔✔a. Select any cell in the pivot
table report (A3:B9)
b. Click Insert on the Ribbon.
c. In the Charts group, click Recommended
Charts
d. Click OK.
set the gap width to 0
✔✔Cumulative Distributions - ✔✔Presents the number of data items with values less
than or equal to the upper-class limit for each class
✔✔cumulative relative frequency distribution - ✔✔A cumulative relative frequency
distribution shows the proportion of data items with values less than or equal to the
upper limit of each class.
✔✔cumulative percent frequency distribution - ✔✔A cumulative percent frequency
distribution shows the percentage of data items with values less than or equal to the
upper limit of each class.
✔✔Crosstabulation: - ✔✔a tabular summary of data for twovariables (either categorical
or quantitative)
, EX: Suppose we have data from a sample of 300
restaurants on overall quality and the meal price.
(This allows us to see if there is a pattern the two
variables).
✔✔Scatter Diagram & Trendline: - ✔✔a scatter diagram is agraphical display of the
relationship between twoquantitative variables and a trendline provides
anapproximation (i.e. an estimate) of the relationship;which can be positive, negative or
none.
✔✔How would you create a scatter diagram in excel? - ✔✔a. Select cells B1:C11.
b. Click Insert on the Ribbon.
c. In the Charts group, click Insert Scatter (X,Y) or
Bubble chart (or Recommended Chart)
d. When the list of scatter subtypes appears, click
scatter.
e. In chart elements- Select the checkbox for Trendline.
✔✔Side-by-Side & Stacked Bar Charts - ✔✔These are extensions of a basic bar chart
as they are
used to display and compare two variables.
✔✔stacked bar chart - ✔✔A stacked bar chart has one bar broken into
segments of a different color showing the relative
frequency of each class.
✔✔Side by side bar chart - ✔✔A side-by-side bar chart depicts multiple bar charts
on the same display.
✔✔How would we construct a side by side bar chart in excel? - ✔✔c. In the Charts
group, click recommended charts
(preview)
d. Click OK
✔✔Mean (or average): - ✔✔is the average value for a variable and the sample mean is
denoted as ̅ 𝑥, and the population mean is denoted as 𝜇.
✔✔Σ - ✔✔The Sum symbol
✔✔𝑥𝑖 (x sub i) - ✔✔a piece of data in the data set
EX:12345- 4=xi
✔✔n and N - ✔✔n is the number of observations in a sample
N is the number of observations in a population
QUESTIONS AND ANSWERS SURE A+
✔✔pie chart - ✔✔a visual display of frequency; relative frequency & percent frequency
distributions.
✔✔How would you create a bar chart in excel? - ✔✔a. Select any cell from A1 to A51.
b. Click the Insert tab from the Ribbon.
c. In Charts, click Recommended Charts
d. Click OK. [bar chart appears in a new worksheet]
✔✔What are the basic steps to using excel? - ✔✔Access the data, Functions &
formulas, Apply tools, Editing options
✔✔A frequency distribution with quantitative data mustdefine the classes for a
frequency distribution by: - ✔✔a. determine the number of non over-lapping
classes;
b. determine the width of each class;
c. determine the class limits.
✔✔Number of Classes - ✔✔Typically, between 5 and 20. Small datasets have less;
larger datasets have more.
,✔✔Width of the Class - ✔✔Generally, it should be the same for each class.
Approximate class width = (largest data value - smallest data value)/number of classes.
✔✔Class Limits - ✔✔Each data observation must only belong to one class.
✔✔Relative Frequency Distributions - ✔✔frequency of theclass/n
✔✔To construct a frequency distribution in excel - ✔✔we must group the rows.
✔✔What if a class has no data? - ✔✔[Excel automaticallyremoves these classes]
To change this:Click the Layout and Print tab
Choose show items with no data; click OK
✔✔Histogram - ✔✔A visual display of a frequency, relative frequency, or percent
frequency distribution, where the variable of interest is on the horizontal axis and the
frequency, relative frequency, or percent frequency is on the vertical axis.
✔✔A histogram shows - ✔✔shows the shape of the distribution of
the variable of interest.
A distribution is skewed if more of the data is either
to the left or right of the distribution.
✔✔How would we construct a histogram in excel? - ✔✔a. Select any cell in the pivot
table report (A3:B9)
b. Click Insert on the Ribbon.
c. In the Charts group, click Recommended
Charts
d. Click OK.
set the gap width to 0
✔✔Cumulative Distributions - ✔✔Presents the number of data items with values less
than or equal to the upper-class limit for each class
✔✔cumulative relative frequency distribution - ✔✔A cumulative relative frequency
distribution shows the proportion of data items with values less than or equal to the
upper limit of each class.
✔✔cumulative percent frequency distribution - ✔✔A cumulative percent frequency
distribution shows the percentage of data items with values less than or equal to the
upper limit of each class.
✔✔Crosstabulation: - ✔✔a tabular summary of data for twovariables (either categorical
or quantitative)
, EX: Suppose we have data from a sample of 300
restaurants on overall quality and the meal price.
(This allows us to see if there is a pattern the two
variables).
✔✔Scatter Diagram & Trendline: - ✔✔a scatter diagram is agraphical display of the
relationship between twoquantitative variables and a trendline provides
anapproximation (i.e. an estimate) of the relationship;which can be positive, negative or
none.
✔✔How would you create a scatter diagram in excel? - ✔✔a. Select cells B1:C11.
b. Click Insert on the Ribbon.
c. In the Charts group, click Insert Scatter (X,Y) or
Bubble chart (or Recommended Chart)
d. When the list of scatter subtypes appears, click
scatter.
e. In chart elements- Select the checkbox for Trendline.
✔✔Side-by-Side & Stacked Bar Charts - ✔✔These are extensions of a basic bar chart
as they are
used to display and compare two variables.
✔✔stacked bar chart - ✔✔A stacked bar chart has one bar broken into
segments of a different color showing the relative
frequency of each class.
✔✔Side by side bar chart - ✔✔A side-by-side bar chart depicts multiple bar charts
on the same display.
✔✔How would we construct a side by side bar chart in excel? - ✔✔c. In the Charts
group, click recommended charts
(preview)
d. Click OK
✔✔Mean (or average): - ✔✔is the average value for a variable and the sample mean is
denoted as ̅ 𝑥, and the population mean is denoted as 𝜇.
✔✔Σ - ✔✔The Sum symbol
✔✔𝑥𝑖 (x sub i) - ✔✔a piece of data in the data set
EX:12345- 4=xi
✔✔n and N - ✔✔n is the number of observations in a sample
N is the number of observations in a population
