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 sk
ewed 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.