The Excel file HATCO consists of data related to predicting the level of business (Usage Level)

obtained from a survey of purchasing managers of customers of an industrial supplier, HATCO.

The following are the independent variables.

• Delivery Speed-amount of time it takes to deliver the product once an order is confirmed..

Price Level-perceived level of price charged by product suppliers.

• Price Flexibility-perceived willingness of HATCO representatives to negotiate price on all

types of purchases.

•Manufacturing Image-overall image of the manufacturer or supplier.

.

• Overall Service-overall level of service necessary for maintaining a satisfactory relationship

between supplier and purchaser.

• Sales Force Image -overall image of the manufacturer's sales force.

• Product Quality-perceived level of quality of a particular product.

.

Size of Firm-size relative to others in this market (0=small; 1= large).

Responses to the first seven variables were obtained using a graphic rating scale, where a 10-cm

line was drawn between endpoints labeled "poor" and "excellent." Respondents indicated their

perceptions using a mark on the line, which was measured from the left endpoint. The result was a

scale from 0 to 10 rounded to one decimal place. Using the tools in this chapter, conduct a

complete analysis to predict Usage Level. Be sure to investigate the impact of the categorical

variable Size of Firm (coded as 0 for small firms and 1 for large firms) and possible interactions.

Also stratify the data by firm size to account for any differences between small and large firms.

Write up your results in a formal report to HATCO management.

REQUIRED:

Analysis of the excel data attached with formulas,

calculations and graphs. And a report of the results.