1. An updated worksheet that transforms the provided data into data that are ready for pivot table analysis.

I am not sure how to transform this data...

Comments Share File Home Insert Page Layout Formulas Data Review View Help _ AutoSum X Cut Calibri 11 A 2b Wrap Text General Normal Bad Good AY O Fill Sort & Find & LG Copy nsert Delete Format Analyze Conditional Format as Paste A Merge & Center $ % " Neutral Calculation Check Cell Table v Filter * Select Formatting Clear Data Format Painter Cells Analysis Number Styles Editing Undo Clipboard Font Alignment J17 : X V fx S U V W Z AA AB AC D E F G H M N O P Q R Total NPV Lift $0.00 price 28000 incentive 1000 0.097 cost 24000 inflation 0.05 Low High 0.24 newbuy newbuy 0.4 1.7 9.9 compprob Basenpv newcomp newcomp 0.31 5.1 13 New NPV fractionbuy 0.31 loyalprob 0.69 $0.00 newloyal newloyal 0.75 13.9 $0.00 Base Case Comp Fusion Comp Fusion Comp Fusion Comp Fusion who who Buy who buy who buy Profit per who buy who Buy who buy who buy Profit per Fusion Fusion comp Comp car Profit 8 Ford Comp buy Fusion Fusion comp Comp car Profit Year Ford Comp 0 1 1 GEO 5 New NPV-Base NPV JaUPw 6 $0.00 7 8 9 10 16 o o o o o o o o o o o o o O O O O O O O O 17 18 19 20 21 22 23 17 24 18 25 19 26 20 27 21