Data preparation is important steps in effective data analytics. Data are rarely in a ready to use form and format.In fact, they often come in to projects a lot like the provided data. Using these data, please prepare the following:Download In fact, they often come in to projects a lot like the provided data. Using these data, please prepare the following:

Microsoft Excel spreadsheet that includes:

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

I do not understand how to take the raw data and clean it up in excel, what are the steps

										Total NPV Lift	$0.00
					price	28000	incentive	1000
	df	0.097			cost	24000	inflation	0.05								Low		High
					compprob	0.24							newbuy	newbuy	0.35	1.7		9.9
					fractionbuy	0.31				Basenpv			newcomp	newcomp	0.32	5.1		13		New NPV
		Base Case		loyalprob	0.69				$0.00			newloyal	newloyal	0.8	5		13.9		$0.00
		Year	Ford	Comp	Fusion who buy Fusion	Comp who Buy Fusion	Fusion who buy comp	Comp who buy Comp	Profit per car	Profit		Year	Ford	Comp	Fusion who buy Fusion	Comp who Buy Fusion	Fusion who buy comp	Comp who buy Comp	Profit per car	Profit
		1										1
		2										2
		3										3
		4										4
		5										5
		6										6
		7										7
		8										8
		9										9
		10										10
		11										11
		12										12
		13										13
		14										14
		15										15
		16										16
		17										17
		18										18
		19										19
		20										20
		21										21