Milk and money datasetIndividual Assignment

This data set relates to the case Milk and Money , Case #5-407-754 . ©2008 by the Kellogg School of Management, Northwestern University. This case was prepared by Charlotte Snyder, Patrick Johnston '04, and Professor Karl Schmedders. Cases are developed solely as the basis for class discussion. Cases are not intended to serve as endorsements, sources of primary data, or illustrations of effective or ineffective management. To order copies or request permission to reproduce materials, call 847-491-5400 or e-mail [email protected]. No part of this publication may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of the Kellogg School of Management.

SUMMARY OUTPUT Regression Statistics Multiple R 0.99739015 R Square 0.9947871 Adjusted R Sq 0.9697871 Standard Erro 0.96812409 Observations 41 ANOVA df SS MS F Significance F Regression 1 7154.39493 7154.39493 7633.27415 2.36819E-46 Residual 40 37.4905698 0.93726424 Total 41 7191.8855 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 0 #N/A #N/A #N/A #N/A #N/A Class IV 1.03504451 0.01184687 87.3686108 2.7597E-47 1.0111011 1.05898793 RESIDUAL OUTPUT Observation redicted Mailbo Residuals 1 11.3544383 0.2855617 2 12.6378935 -0.38789349 3 14.5941276 -0.28412762 4 15.0805985 1.95940146 5 15.0081454 2.28185458 6 14.2008107 1.9391893 7 13.7764425 -0.09644245 8 12.8966546 0.54334538 9 13.4555787 0.57442134 10 13.2589202 0.4110798 11 13.8074938 1.03250621 12 13.8902974 0.92970265 13 12.9587573 1.47124271 14 13.1864671 0.68353292 15 13.1036635 0.71633648 16 13.0519113 0.8180887 17 12.627543 0.44245695 18 12.7620988 0.24790117 19 13.6315362 -0.21153622 20 13.9109982 -1.16099824 21 14.231862 -0.74186204 22 14.0869558 -0.53695581 23 13.3520742 -0.4420742 24 13.0105095 0.11949048 25 12.627543 0.30245695 26 11.4889941 0.13100592 27 11.0542754 -0.06427539 28 10.7230611 -0.21306114

29 10.6920098 -0.49200981 30 10.5781549 -0.34815491 31 10.5678045 -0.56780447 32 11.0128736 -0.52287361 33 11.4889941 -0.18899408 34 11.9133623 -0.37336233 35 12.534389 -0.71438904 36 12.7310475 -0.6010475 37 12.9691077 -0.66910774 38 13.1554157 -0.15541575 39 14.1904603 -0.40046026 40 16.6849175 -2.13491753 41 19.1276226 -2.78762258