To insert and format a scatter plot displaying the two variables for age and number of hours slept every night, follow these steps:
1. Open the Data Analysis workbook and go to the Survey Results tab.
2. Select the column with the data for age by clicking on the column heading.
3. While holding the Ctrl key, select the column with the data for number of hours slept every night.
4. Go to the Insert tab on the Ribbon.
5. Click on the Scatter or Scatter with Straight Lines chart type in the Charts group.
6. Choose the first scatter chart option (usually the default one) from the drop-down menu.
7. A scatter plot will appear on the worksheet.
8. Right-click on any data point on the scatter plot and select Add Trendline from the context menu.
9. In the Format Trendline pane that opens on the right side of the worksheet, choose the options you prefer, such as the type of trendline (linear, polynomial, etc.) and the display of the equation and R-squared value.
10. Adjust the formatting of the scatter plot and the trendline as desired, such as the color, size, and axis labels.
11. Save your work.
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.
1 answer
1 answer