G163/STA1625 Section 01 Essential Statistics and Analytics (5.5 Weeks) - Online Plus - 2022 Spring Quarter Term 1Module 02 Assignment - Graphs and MeasuresModule 02 Assignment - Graphs and MeasuresModule 02 Content

1. Overview

Data can be collected from many different sources. In this assignment, you will perform a short survey of 10 people. From this data, you will create a frequency chart, histogram, and pie chart. You will also perform several statistical calculations.

1. Instructions

1. Part One - Survey Data

For this assignment, you will need to ask 10 people the following 5 questions and record their answers in an Excel spreadsheet:

• What is their first name?
• What is their age?
• Are they currently a student?
• How many hours of sleep do they average in a night?
• What is their favorite ice cream flavor?

Please Note: Some of the data collected will be used in the following module assignments. Make sure to ask all five questions and record all the data for each question.

1. Part Two - Graphs & Calculations

After you collect data from 10 people on the 5 questions above, complete the following in the same Excel spreadsheet used to collect the data:

• Create two frequency charts:
• The first frequency chart will be for their favorite ice cream flavor.
• The second frequency chart will be for their age and should contain between 5 and 10 class intervals.
• Create a histogram for age.
• Label the axes, title, and bars.
• Create a pie chart for favorite ice cream flavor.
• Label the key and percentage of each section.
• Calculate the following statistical values on the age variable:
• Measures of center - mean, median, mode, and midrange.
• Measures of variation - range and standard deviation.

1. Part Three - Presentation

After you have created your graphs and performed your calculations, create a presentation with the following information on each slide:

• Slide 1: Title slide with assignment title, name, course, date, instructor name.
• Slide 2: Provide a copy of the raw data in table format collected from 10 people.
• Slide 3: Copy and paste your two frequency charts.
• Slide 4: Copy and paste your histogram.
• What conclusions can you draw?
• Slide 5: Copy and paste your pie chart.
• What conclusions can you draw?
• Slide 6: Share the measures of center for age.
• What are your interpretations?
• Slide 7: Share the measures of variation for age.
• What are your interpretations?
• Slide 8: Conclusion - Summarize the data you collected.
• Were there any interesting outcomes you weren't expecting?
• Was there any data that was helpful to draw further conclusions?
• What benefits did you gain from visualizing the data?
• What benefits did you gain from performing statistical calculations on the data?