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.

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.  check with your instructor if you have questions about the format of the document. 3. Put your name on the document.  If you worked in a group, also list the names of the other students in the group. Part 1:  Data Representation Choose a scenario to complete.  If the project is completed by a group, each person should work on a different scenario. 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 by 47 students on Quiz 1 Scores Frequency 1  13 2 12 3 15 4 5 5 2 A-3)  Find the mean, median, and n (the number of data values) for the data in A-2. 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 by 64 students on Quiz 2 Scores Frequency 1  3 2 28 3 6 4 15 5 12 B-3)  Find the mean, median, and n (the number of data values) for the data in B-2. 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 by 53 students on Quiz 3. Scores Frequency 1 8 2 10 3 17 4 10 5 8 C-3)  Find the mean, median, and n (the number of data values) for the data in C-2. C-4)  Label the graph as approximately symmetric, skewed left, or skewed right. Part 2:  Short-Answer Questions 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. Provide an example of a real-life situation where the information could be misleading because the data is skewed to the left or right. 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 show sufficient thought, effort, and research. Resources: Excel (There are many free online tutorials for Excel.) Finding the mean of a table of data:  See the example on page 215 in the textbook. Finding the median of a table of data:   1) Find

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer