Share
Explore BrainMass

Perform simple regression analysis and calculate Durbin-Watson statistic

A freshly brewed shot of espresso has three distinct components: the heart, body, and crema. The separation of these three components typically lasts only 10 to 20 seconds. To use the espresso shot in making a latte, a cappuccino, or another drink, the shot must be poured into the beverage during the separation of the heart, body, and crema. If the shot is used after the separation occurs, the drink becomes excessively bitter and acidic, running the final drink. Thus, a longer separation time allows the drink-maker more time to pour the shot and ensure that the beverage will meet expectations. An employee at a coffee shop hypothesized that the harder the espresso grounds were tamped down into the portafilter before brewing, the longer the separation time would be. An experiment using 24 observations was conducted to test this relationship. The independent variable Tamp measures the distance, in inches, between the espresso grounds and the top of the portafilter (i.e., the harder the tamp, the greater the distance). The dependent variable Time is the number of seconds the heart, body, and crema are separated (i.e., the amount of time after the shot is poured before it must be used for the customer's beverage). The data are stored in Espresso.

a. Use the least-squares method to develop a simple regression equation with Time as the dependent variable and Tamp as the independent variable.
b. Predict the separation time for a tamp distance of 0.50 inch.
c. Plot the residuals versus the time order of experimentation. Are there any noticeable patterns?
d. Compute the Durbin-Watson statistic. At the 0.05 level of significance, is there evidence of positive autocorrelation among the residuals?
e. Based on the results of ( c ) and ( d ), is there reason to question the validity of the model?

Attachments

Solution Preview

Use the least-squares method to develop a simple regression equation with Time
as the dependent variable and Tamp as the independent variable.
Answer: we run the regression analysis in excel. I include the excel file. The regression equation is Time=17.08-5(Tamp)

b. Predict the separation time for a tamp distance of 0.50 inch.
Answer: when tamp=0.50, plug into regression equation to get ...

Solution Summary

The solution gives detailed steps on performing simple regression analysis, calculating Durbin-Watson statistic and checking validity of model using Excel.

$2.19