Excel Hw 5

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

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

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.

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

View Full Document
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

## This note was uploaded on 09/18/2011 for the course STAT 2610 taught by Professor Syvantek during the Spring '08 term at Auburn University.

### 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
Ask a homework question - tutors are online