WEEK 6 DATA ANALYSIS
nmonfort
week6---data_analysis.docxDATA IS ATTACHED IN EXCEL FILE
· Exercise A2: Analyze the data for DoW #6 in your calculator or on an applet. Record your answers in your journal:
· What are the variables? Are they quantitative or categorical?
· Create a scatterplot for the data in DoW #6, with the variable People Per TV on the x-axis.
· Describe the relationship you see in the data (if any).
· Are there any points on the scatterplot that do not seem to follow the general trend of the data? If so, what are they and why do they seem “different”?
· Exercise B4: Calculate the correlation coefficient for DoW #6.
· Interpret this correlation coefficient in the context of the DoW. How does it compare to your response to Exercise A2?
· In Exercise A2 you identified possible outliers in this data. Does removing these points from the data set affect the correlation coefficient? Note: you should save the file under a different name BEFORE you remove possible outliers.
· Interpret the correlation coefficient in the context of DoW #6.
· Exercise E1: Return to your work for DoW #6
· Add a best fit line to the scatter plot you made in Exercise A2. Record the equation of this line. What do x and y represent in this equation? Here's a video tutorial for doing this in excel.
· Add a Least Squares Regression line to the scatter plot you made in Exercise A2. Record the equation for this line. How does it compare to the line you placed? A video tutorial for doing this in excel is also available.
Exercise E5: Return to our original question for DoW #6: Is there a relationship between life expectancy and the number of people per TV for a country? Consider the analyses you have completed for the DoW in Investigations 1 and 2. Now it’s time to interpret the analyses. How does the data answer this question? How do the tools we’ve used support this answer? What questions do you have about this analysis? Write at least three summary statements interpreting DoW#6, supported with facts from the data and analyses.
