Box Plot Practice
Example: Consider the following data set
5 20 27' 35 45
12 22 28 35 47
15 25 30 40 50
15 25 30 41 53
18 25 3 2 45 55
a) What isthe minimum?
5
b) Find the lower quartile cfw_rst quartile) (21. cfw_This is the 25th percentile)
P 25 _
Nm(+l
COL 110P Homework 1
Due Sunday February 7, 2016 at the beginning of class (first five minutes).
Name: _Solution_
ID: _
1. For each of the following, state whether the data is qualitative or quantitative. Then
Midterm Exam Review
Units included in the Midterm exam are:
Unit 1, Unit 2, Unit 3 (until computing Percentiles and Quartiles)
Question1: Sara asked her family members to state the time (in minutes) they spend
Percentiles
1. Consider the following data set: cfw_18, 41, 50, 6, 13, 91, 32, 23.
First, order the data from smallest to largest: 6, 13, 18, 23, 32, 41, 59, 91
a) Find the 25th percentile.
=
!
!"
+1 =
!"
!"
8 + 1 = 2.2
1) Range, Mean, and Median:
Summary of Unit 2 (COL110P)
Definition
Range
The difference (distance)
between the maximum and
the minimum.
Mean
It is the average of the data.
We will always find data on
Box Plot Practice
1. On a test of 100 points
bl
d)
f)
Are the grades evenly spread out across the whole range of data?
No
Where is the data close together? Where is it spread out?
The data is most close together between Q1 and median
The data is most sp
COL 110P Quiz 2
Name: _Answers_
ID: _
Question 1: A student took 6 tests and scored the following: , , , , ,
a) Find the mean score.
!
!"!"!"!"!"!"
=
=
= 88
!
!
b) Find the median score.
First
COL 110P Quiz 2
Name: _Answers_
ID: _
Question 1: A student took 6 tests and scored the following: , , , , ,
a) Find the mean score.
!
!"!"!"!"!"!"
=
=
= 66.17
!
!
b) Find the median score.
Firs
Practice Quiz
Unit 1+2
Instructor: Dr Saima Akhund
1
Multiple Choice/ Fill in the blanks/True or False:
1. Which of the following statements describes a mental benefit of physical activity?
a) Physical activity can enhance body shape
b) Physical activity
COL110P Percentages Practice
Percent Part / Percent of:
1. What percent of 65 is 13?
!"
!"
100 = 20%
2. What is 35% of 82?
0.3582 = 28.7
3. 42 is 60% of what number?
60% = 42
0.6 =
COL 110P Quiz 1
Name: _Answers_
ID: _
1. For each of the following, state whether the data is Qualitative or Quantitative. Then state the
type of chart that best represents the data.
a. A teacher divides s
COL 110P Quiz 1
Name: _Answers_
ID: _
1. For each of the following, state whether the data is Qualitative or Quantitative. Then state the
type of chart that best represents the data.
a. A nursery counts th
These are the results of four tests for a class
of COL 110 students. Each test is out of a
Total (using the
Total (by adding Excel function,
maximum of 100.
Max
Samira
Hind
Shaikha
Khawla
Salma
Rabea
Nada
Marwa
Badriya
Muna
Maisoona
Layla
Hawaa
Amina
Asma
Lesson 3 Excel Functions
We can find the excel functions from Home Editing AutoSum OR FormulasInsert Function OR from fx near to the formula bar
Selecting a range of contiguous (together) and noncontiguous (apart) cells:
Contiguous: selecting cells toge
Unit 2: Basic Math & Formulas (PC)
Math operations:
Brackets
Exponents
Multiplication/Division ( Start by first coming)
Addition/Subtraction
Start by equal sign before any formula
Relative Cell Referencing:
To generalize a formula, type it in the form
Formulas
=
Order of Operations
Brackets
( )
Exponentiation
^
Division
/
Multiplication
*
Addition
+
Subtraction

Create a formula in the green cell in Column F that will give
the correct answer to the formula shown in Column E.
93*2 =
3 Correct
(93)*2