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.
Step 6: Analyze the data and answer the following questions:
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.
Can you help me I need three more subject like these
height
number of siblings
number of times per month they go to the movies
age
hours of sleep they get each night (on average)
Sure, here are three additional subjects for a survey:
1. Monthly income
2. Level of education completed
3. Number of times per week they exercise.
Can you help me I need three more basic subject for a survey like these...
height
number of siblings
number of times per month they go to the movies
age
hours of sleep they get each night (on average)
Sure, here are three more basic subjects for a survey:
1. Favorite color
2. Favorite type of food
3. Method of transportation used for daily commute.
Can you help me I need three more basic subject for a survey like these...
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…”).
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?
Can you shorten these?
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?
1. Daily cups of coffee/tea consumed:
2. Books read in the past month:
3. Weekly hours spent on social media:
To complete your portfolio project and create a scatter plot displaying the variables for age and number of hours slept every night, follow these steps:
Step 1: Create the survey
1. Open a new Microsoft Word document and save it as "Survey" in your Unit 4 folder.
2. Create an eight-question survey that asks for specific information as listed in the instructions.
- The required questions are: height, number of siblings, number of times per month they go to the movies, age, and hours of sleep they get each night.
- You can create three additional questions of your choice.
3. Make sure to save the document when you are finished.
Step 2: Create the database
1. Click on the provided link to access the Portfolio workbook and save it as "Data Analysis" in your Unit 4 folder.
2. Open the workbook and select the "Survey Results" tab.
3. Create a heading or field name in each column that represents each question from your survey (e.g., Age, Height, etc.).
Step 3: Conduct the survey
1. Ask at least 10 friends or family members to answer your survey questions.
2. Collect their responses by jotting them down in a notebook or on a piece of paper.
Step 4: Enter the survey results into the database
1. Open the "Survey Results" tab in the workbook.
2. Enter the responses for each person's answers on the survey, making sure each row represents one person's answers for every question.
- Enter the responses in the appropriate column according to the questions from your survey.
Step 5: Insert and format the scatter plot
1. Select the columns with the data for age and hours slept (in the "Survey Results" tab).
2. Go to the "Insert" tab in Microsoft Excel and click on "Scatter" in the "Charts" group.
3. Choose the scatter plot option that best suits your needs.
4. Once the scatter plot is inserted, select the plot area, right-click, and choose "Add Trendline" from the context menu.
- This will add a trendline to the scatter plot, showing the general direction of the data points.
5. Format the scatter plot as desired, including labeling the axes, adding a title, and adjusting other formatting options to make it clear and visually appealing.
Following these steps will allow you to create a scatter plot displaying the variables for age and number of hours slept every night using the survey results you collected.