Q: What is the formula for the frequency of a class interval in a frequency distribution?

$$\text{Frequency} = \text{Number of observations in the interval}$$

Question 1

Which of the following best describes a frequency distribution?

Accepted Answer

A summary of data that displays the number of observations in each distinct category or class.

Question 2

When constructing a frequency distribution for the 'Age' variable in Excel, which function is primarily used?

Accepted Answer

Pivot Table

Question 3

What is the main purpose of grouping the 'Age' variable into intervals when creating a frequency distribution?

Accepted Answer

To make the data more presentable and easier to interpret.

Question 4

Which of the following is NOT a step in creating a frequency distribution for 'Age' in Excel?

Accepted Answer

Using the SUM function to calculate total age.

Question 5

After creating a frequency distribution, which chart is most appropriate for visualizing the distribution of a continuous variable like 'Age'?

Accepted Answer

Histogram

Question 6

In Excel, what is the effect of reducing the gap between bars to zero when formatting a bar chart?

Accepted Answer

It transforms the bar chart into a histogram.

Question 7

Which of the following best describes discrete data?

Accepted Answer

Data that can take on a countable number of possible values.

Question 8

Suppose you have grouped ages into intervals of 10 years (e.g., 20-29, 30-39, etc.). If the frequency for the 30-39 interval is 5, what does this mean?

Accepted Answer

There are 5 individuals whose ages fall between 30 and 39.

Question 9

Which chart would best show the trend in 'Monthly_Earnings_KES' over time if you had a time variable?

Accepted Answer

Line chart

Question 10

If you want to compare the frequency of different education levels in the HR data, which chart would be most appropriate?

Accepted Answer

Bar chart

Question 11

Which of the following is a critical advantage of using graphs and charts in presentations?

Accepted Answer

They transform raw data into information that is easier to interpret.

Question 12

A frequency histogram is most useful for which type of data?

Accepted Answer

Continuous numerical data

Question 13

Which step in Excel allows you to summarize the number of occurrences for each value in a variable?

Accepted Answer

Changing the value field setting to COUNT in the Pivot Table.

Question 14

If you want to visualize the distribution of 'Absenteeism_Days' for employees, which chart would you use?

Accepted Answer

Histogram

Question 15

Which of the following is a plausible reason for grouping data into intervals when creating a frequency distribution?

Accepted Answer

To reduce the complexity and make patterns easier to see.

Question 16

What is the formula for the frequency of a class interval in a frequency distribution?

Accepted Answer

$$	ext{Frequency} = 	ext{Number of observations in the interval}$$

Question 17

Which of the following best describes the process of creating a histogram from a bar chart in Excel?

Accepted Answer

Reduce the gap between bars to zero to create adjacent bars.

Question 18

If you are analyzing the trend of 'Performance_Rating' over several years, which chart would you use?

Accepted Answer

Line chart

Question 19

Which of the following is a multi-step process for creating a frequency distribution for 'Age' in Excel?

Accepted Answer

Insert Pivot Table, drag 'Age' to ROWS, drag 'Age' to VALUES, change to COUNT, group into intervals.

Question 20

Why is it important to use both tables and graphs when presenting statistical data?

Accepted Answer

Tables provide detailed information, while graphs offer visual insights for easier interpretation.

Describing Data Using Tables, Graphs, and Charts

Study Guide - Practice Questions

Study Guide - Flashcards