You have one opportunity to upload files for this quiz. Showing detailed work and writing detailed explanations is required.
This quiz contains one question with multiple parts. You do not need to do any hand computations. You will be using excel and word to answer this question. Upload both your word and excel documents.
The data set shown below gives the calories and salt content in 17 brands of meat hot dogs.
- Enter the data set into excel. Using excel perform a least squares regression on the data set. Use Sodium as the y variable and Calories as the x variable. Make a scatter plot with the regression line plotted as well. Using excel compute the correlation coefficient.
- Insert the plot your created into a word document. Discuss the scatter plot and regression line. Are their outlines? Does your correlation coefficient support your analysis? Does it tell you anything else?
- If there is an outline remove the outline from the data set and repeat the previous two parts.
- Can you conclude that hot dogs with more calories will have more sodium (i.e. discuss correlation and causation)?