A food products company believes that storing frozen foods at low temperatures for several weeks might cause
Question:
A food products company believes that storing frozen foods at low temperatures for several weeks might cause a noticeable weight loss in the product. Some data were collected to test this belief, as summarized in the table below:
a. Explore the possibility of a linear relation between percentage weight loss and weeks in storage. Does there seem to be a strong linear relationship, based on a scatter plot and the correlation?
b. Build a linear model to represent the relation between storage time and weight loss. What weight loss would the model predict for this product if it were stored at low temperatures for 28 weeks? For 52 weeks?
c. As an alternative way of building the model, suppose we measure excess storage time as weeks beyond 24, along with weight loss in percentage above 1 percent. (In other words, subtract 24 from the data on weeks stored and 1.01 from the data on weight loss.) Find the coefficients of the linear model corresponding to this alternative specification of the variables. How do they compare to the coefficients in (b)?
Step by Step Answer:
Management Science The Art Of Modeling With Spreadsheets
ISBN: 9780470530672
3rd Edition
Authors: Stephen G. Powell, Kenneth R. Baker