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.

The price is based on these factors:

Academic level

Number of pages

Urgency

Basic features

- Free title page and bibliography
- Unlimited revisions
- Plagiarism-free guarantee
- Money-back guarantee
- 24/7 support

On-demand options

- Writer’s samples
- Part-by-part delivery
- Overnight delivery
- Copies of used sources
- Expert Proofreading

Paper format

- 275 words per page
- 12 pt Arial/Times New Roman
- Double line spacing
- Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
## Recent Comments