Excel Hw 5 - Analysis for glossy types For both flat and...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
STAT 2610 EXCEL HOMEWORK #5 ANSWER KEY DUE 11/17/09 Analysis for flat types For both flat and glossy types of cellophane the relationship between leadtime and number of rolls ordered is negligible or non-existent. This is illustrated by the nearly horizontal regression line fitted to the scatterplots. The r 2 values for flat and glossy are respectively .0235 and .0177 respectively, yielding corresponding correlations of 0.153 and -.133. The negative correlation for glossy relates to the negative slope of the associated regression line. We interpret the r 2 values for flat and glossy as follows: flat – 2.4% of the sample variation in leadtimes is explained by number of rolls ordered; glossy – only 1.8% of the sample variation in leadtimes is explained by number of rolls ordered. These interpretations are consistent with those illustrated by the scatterplots.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Analysis for glossy types For both flat and glossy types of cellophane the relationship between leadtime and width of rolls ordered is fairly strong and positive. This is illustrated by the reasonably tight scatter of regression line fitted to the scatterplots and the positive slope of the lines. The r 2 values for flat and glossy are respectively .5943 and .6331 respectively, yielding corresponding correlations of 0.771 and .796. We interpret the r 2 values for flat and glossy as follows: flat 77.1% of the sample variation in leadtimes is explained by width of the rolls ordered; glossy 79.6% of the sample variation in leadtimes is explained by width of the rolls ordered. These interpretations are consistent with those illustrated by the scatterplots....
View Full Document

Page1 / 3

Excel Hw 5 - Analysis for glossy types For both flat and...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online