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.
Instructions
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.
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.
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?
0 comments