The data set shown below gives the calories and salt content in 17 brands of meat hot dogs

Question # 00022785 Posted By: expert-mustang Updated on: 08/12/2014 01:58 AM Due on: 08/12/2014
Subject Business Topic General Business Tutorials:
Question
Dot Image
Question: The data set shown below gives the calories and salt content in 17 brands of meat hot dogs.

a) 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.

b) Insert the plot your created into a word document. Discuss the scatter plot and regression line. Are their outliers? Does your correlation coefficient support your analysis? Does it tell you anything else?

c) If there is an outlier remove the outlier from the data set and repeat the previous two parts.

d) Can you conclude that hot dogs with more calories will have more sodium (i.e. discuss correlation and causation)?
Dot Image
Tutorials for this Question
  1. Tutorial # 00022102 Posted By: expert-mustang Posted on: 08/12/2014 01:59 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Calories and salt content in 17 brands of meat hot dogs Solution Paper...
    Attachments
    Calories_and_salt_content_in_17_brands_of_meat_hot_dogs_Solution_Paper.docx (27.96 KB)
    Scatter_Plot_of_calories_and_salt_content.xlsx (16.99 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    sh...74 Rating The experts do a wonderful job 06/27/2015

Great! We have found the solution of this question!

Whatsapp Lisa