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

profileguru2009
 (Not rated)
 (Not rated)
Chat

     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)?    

      Calories Sodium (mg)   173 458   191 506   182 473   190 545   172 496   147 360   146 387   139 386   175 507   136 393   179 405   153 372   107 144   195 511   135 405   140 428   138 339    

    • 8 years ago
    The regression equation is y = -91.1853 + 3.2117x ...
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      Thedatasetshownbelowgivesthecaloriesandsaltcontentin17brandsofmeathotdogs..xls