MGF2106 (Survey of Mathematics): Statistics Worksheet Purpose: Work as a group to complete various tasks related to data and statistics, helping each other to understand and answer the questions. Assignment: Complete the worksheet, using the Discuss

MGF2106 (Survey of Mathematics):  Statistics Worksheet

Purpose:  Work as a group to complete various tasks related to data and statistics, helping
each other to understand and answer the questions.

Assignment:  Complete the worksheet, using the Discussion Board in Falcon Online to work as
a group.  Compile the various parts of the worksheet into a single document which is submitted
to the Dropbox in Falcon Online.

Format for Dropbox Submission:
1. The submission should be a single document formatted as .docx, .doc, .rtf, or .pdf.
2. The submission should be typed.  If there are parts of the assignment that need to
be drawn by hand, they should be done neatly, scanned, and included in the final
submission.
3. List the names of the students in the group at the beginning of the document.

Part 1:  Data Representation

Each group member should choose a scenario to complete.  It is not necessary to complete the
leftover scenario(s) if there are not enough members in the group.

Scenario A: 
 
 
 
A-1)  Use Excel (or similar software) to create a vertical bar graph for the following data
obtained when 20 people were asked about their breakfast preference.
Oatmeal and Fruit 4 people
Eggs 5 people
Toast 1 person
Cereal 8 people
No breakfast 2 people
A-2)  Use Excel (or similar software) to create a histogram for the grades earned on
Quiz 1.
Scores Frequency
1 - 2 2
3 - 4 6
5 - 6 10
7 - 8 5
9 - 10 4

 A-3)  Find the mean, median, and sample size for the grades.

 A-4)  Label the graph as approximately symmetric, skewed left, or skewed right.

Scenario B: 
 
 
B-1)  Use Excel (or similar software) to create a vertical bar graph for the following data
obtained when 20 people were asked about their doughnut preference.
Plain 3 people
Chocolate Covered 5 people
Glazed 7 people
Crème Filled 1 person
Jelly Filled 4 people

B-2)  Use Excel (or similar software) to create a histogram for the grades earned on
Quiz 2.
Scores Frequency
1 - 2 4
3 - 4 12
5 - 6 6
7 - 8 5
9 - 10 2

 B-3)  Find the mean, median, and sample size for the grades.

 B-4)  Label the graph as approximately symmetric, skewed left, or skewed right.

Scenario C: 
 
 
 
C-1)  Use Excel (or similar software) to create a vertical bar graph for the following data
obtained when 20 people were asked about their transportation to work or school.
Car 8 people
SUV 5 people
Truck 4 people
Motorcycle 1 person
Other 2 people
 
C-2)  Use Excel (or similar software) to create a histogram for the grades earned on
Quiz 3.
Scores Frequency
1 - 2 1
3 - 4 4
5 - 6 6
7 - 8 10
9 - 10 3

 C-3)  Find the mean, median, and sample size for the grades.

 C-4)  Label the graph as approximately symmetric, skewed left, or skewed right.

Scenario D: 
 
 
D-1)  Use Excel (or similar software) to create a vertical bar graph for the following data
obtained when 20 people were asked about their cookie preference.
Chocolate Chip 8 people
Oatmeal 3 people
Sugar 4 people
Peanut Butter 3 person
Shortbread 2 people

D-2)  Use Excel (or similar software) to create a histogram for the grades earned on
Quiz 4.
 
 
Scores Frequency
1 - 2 5
3 - 4 11
5 - 6 7
7 - 8 3
9 - 10 1
 D-3)  Find the mean, median, and sample size for the grades.

 D-4)  Label the graph as approximately symmetric, skewed left, or skewed right.
Part 2:  Short-Answer Questions

Work together to answer the following questions, using the material from part 1 for reference.
Write the answers with complete sentences.
 
1. What is the difference between a bar graph and a histogram?
2. How are the mean and median related when a graph is skewed left?
3. How are the mean and median related when a graph is skewed right?
4. How are the mean and median related when a graph is approximately symmetric?
5. Based on the provided data and the answers to numbers 2-4, do any of the quizzes
seem unfair?  Why or Why Not?
6. Are there real-life situations where the information could be misleading because the
data is skewed to the left or right?  Provide an example.


Part 3:  Impact Question

Provide an example, or examples, of how the concepts covered in this assignment could be
applied in life or future career choices.  The answer should be discussed among the group
members and show sufficient thought, effort, and research.