Font size
WorksheetsGroup 5 Presentation Quiz
Total questions: 20
Worksheet time: 10mins
What is the first step required to create a table or graph in Microsoft Excel
Enter the data collected into MS Excel
Click Insert Chart
Create a frequency distribution table
Highlight the data you want in your chart
Qualitative data's main function is to provide a thorough comprehension of _____ phenomenon under scrutiny
a Specific
various ideas of a
The standard deviation can be used as a substitute for the mean when describing data as they provide the same analysis.
TRUE
FALSE
If outliers are present, which of the following measures of central tendency is most suitable?
Mean and mode
Median only
Mode and median
None of the above
Mode only
Select all that applies: The standard deviation is important because...
It allows the researcher to calculate the mean
It allows the researcher to calculate the extent of deviation
It allows the researcher to know if errors are present
Information on a Bar graph can be analyzed using the measures of central tendency
True
False
Select the BEST response.
Bivariate Analysis is conducted using
2 independent variables
One Independent variable
One dependent variable
One independent and one dependent variable
Which chart is MOST SUITABLE for representing students' favourite colour ?
Histogram
Bar graph
Line graph
scatter diagram
Charts can be edited by going to the “Edit” tab
True
False
How many steps are there in conducting a quantitative analysis of qualitative data?
None
1
2
3
Which of the following is the correct order in which to conduct a quantitative analysis of qualitative data?
Organize; Read and Code; Present and Interpret
Organize; Code and Present; Interpret and Read
Read; Organize and Code; Present and Interpret
Code; Organize and Read; Interpret and Present
Select the Bivariate questions
What is the relationship between Ice cream sales and daily temperature?
What is the relationship between weight and calorie intake?
Is grade influenced by hours studied and class attendance?
Does occupation influence age of marriage?
Select the Univariate Questions
How many students are age 21 and over?
What is the least preferred ice cream flavour?
When do students do laundry?
Which course do students participate in most?
Calculate the mean: 10,5,10,20,15
10
5
12
6
What is the MEDIAN: 2,4,6,8,10
6
7
3
8
What is the MODE: 10,5,15,0,10,5,10,15
10
5
15
0
Which term best describes "the way values are distributed around a central value'?
Mode
Median
Dispersion
Mean
The main purpose of conducting Univariate Analysis is to describe data and find _____ within the data
Patterns
Attributes
Relationships
Observations
Scatter diagrams and regression analysis is used for which type of analysis
Univariate
Bivariate
Both
None
Which of the following analyzes the pie chart?
Majority of income is spent on housing
Savings received the lowest portion of income
Income is divided into 5 spending categories
Each month, 15% of income is used to repay loans such as student loans, car loans and mortgage.
