Select Page

Step 1. Place your order

Fill in the order form and provide all details of your assignment.

Step 2. Make Payment

Choose the payment system that suits you most.

Step 3. Receive your paper

Once your paper is ready, we will email it to you.

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

by | Nov 10, 2022 | Excel | 0 comments

 

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

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.

 

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Affordable

Only pay once! Clear pricing system with no hidden fees, direct line to your writer, 24/7 customer support.

Quality

Our reputation is built on delivering top-quality papers. No matter how small the task, we give customers our best.

Timely

Missed due dates can result in a serious loss of marks. We strive to finish everything with time to spare.