A company wants to optimize their product portfolio and use Marketing Analytics to help them do so.

What type of test would someone need to determine the following and how would you analyze it using excel:

a) How important is each of the product features (Price, Weight, Length, Moisture) to the customers?

b) Which of the following 4 product configurations is the most attractive to customers?

A: Medium weight, super dry, exact length, medium price

B: Heavy, a little damp, long, cheap

C: Light, semi dry, long, expensive

D: Light, super dry, exact length, cheap

c) How big an impact does beam length and moisture level have on the weight of the wood beams?

d) In terms of the moisture (%) of the products originating from Norrskog and Callans, what relevant conclusions can be made about the differences and similarities in terms of:

a) Stability of the data?

b) Distribution of the data?

c) Central tendency?

d) Spread?

e) The capability of delivering a moisture level of max. 20%?

e) How much off from the correct length are the products from each of the 4 different sawmills?

f) Are there any significant differences between sawmills in terms of how much off their products are in length? And if so, what are those differences?

\f\f