Can you help me?
Portfolio Instructions: Part 1
Follow the steps below to complete your portfolio project. You will create your own survey, and then conduct your survey by asking at least 10 people to respond to it. To understand all of the elements included in the portfolio item, click on the link below to access the Data Analysis rubric.
Mouse icon Data Analysis Rubric
Step 1: Create an eight-question survey in a Microsoft® Word document:
Open a new Microsoft Word document, and save it as Survey in your Unit 4 folder.
Create an eight-question survey that you will test with your friends and family. Your survey must ask for certain information (listed below), but you can make up an additional three questions. Your survey should ask the people in your sample for the following information:
height
number of siblings
number of times per month they go to the movies
age
hours of sleep they get each night (on average)
Ask three more questions of your choice—be creative! Just make sure that you are asking questions whose answers are numbers (for example, your question may start with “How much…” or “How many…”).
Make sure that you save your document when you are finished.
Step 2: Create a database where you will enter your data:
Click on the link below to access the Portfolio workbook. Save it as Data Analysis in your Unit 4 folder.
Mouse icon Portfolio
Select the tab titled Survey Results. Type a one-word heading or field name in each column that represents each question (for example, Age, Height, Weight, etc.).
Step 3: Conduct your survey:
Ask your friends or family members to answer your survey. You can ask your respondents questions in person, over the phone, or via e-mail. Jot down their answers in a notebook or on a piece of scrap paper.
Step 4: Enter the results of you survey into your database, making sure each row represents one person’s answers for every question on the survey.
Step 5: Insert and format a scatter plot displaying the two variables for age and number of hours slept every night.
Select the columns with the data for age and hours slept, and then insert a scatter plot. When you are done, insert a trend line into your scatter plot.
9 answers
What is the average height of the people in your sample?
What is the median number of siblings in your sample?
What is the mode for the number of times per month your sample goes to the movies?
What is the range of ages in your sample?
What is the standard deviation for the hours of sleep per night in your sample?
Is there a correlation between age and the number of hours slept per night? If so, describe the correlation.
What insights did you gain from conducting this survey?
Step 7: Create a one-page report summarizing your findings:
Using the data and analysis from Step 6, create a one-page report summarizing your findings. Be sure to include the scatter plot with trend line. Use proper grammar, spelling, and punctuation. Save your report as Survey Report in your Unit 4 folder.
height
number of siblings
number of times per month they go to the movies
age
hours of sleep they get each night (on average)
1. Monthly income
2. Level of education completed
3. Number of times per week they exercise.
height
number of siblings
number of times per month they go to the movies
age
hours of sleep they get each night (on average)
1. Favorite color
2. Favorite type of food
3. Method of transportation used for daily commute.
height
number of siblings
number of times per month they go to the movies
age
hours of sleep they get each night (on average)
Ask three more questions of your choice—be creative! Just make sure that you are asking questions whose answers are numbers (for example, your question may start with “How much…” or “How many…”).
1. How many cups of coffee or tea do you consume in a day?
2. How many books have you read in the past month?
3. How many hours per week do you spend on social media?
Sure, here are three creative questions whose answers are numbers:
1. How many cups of coffee or tea do you consume in a day?
2. How many books have you read in the past month?
3. How many hours per week do you spend on social media?
2. Books read in the past month:
3. Weekly hours spent on social media: