be quick plz.

1. (a) What are different techniques used to measure data spread/dispersion? Comment about their consistency from model validation viewpoint. Apply these data spread techniques to manually calculate them in Microsoft Excel sheet and draw their corresponding figures (if any) with their corresponding calculations. (b) Describe importance of data transformation? For the data given below, which transformation technique is best suited to make the data normalized? Show calculations for that specific type of transformation in excel sheet and its corresponding graph drawn in Origin Pro (pasted in Excel sheet). 26.02 20.72 27.46 105 256.3 81.52 35.58 134.58 36.64 41.1 54.8 102.62 22.94 21.48 26.64 35.84 47.12 48.32 178.84 23.86 172.24 177.1 104 154.86 61.26 81.3 108.18 69.36 36.66 43.38 186 41.7 29.1 45.54 31.5 158.6 174.1 77.72 1. (a) What are different techniques used to measure data spread/dispersion? Comment about their consistency from model validation viewpoint. Apply these data spread techniques to manually calculate them in Microsoft Excel sheet and draw their corresponding figures (if any) with their corresponding calculations. (b) Describe importance of data transformation? For the data given below, which transformation technique is best suited to make the data normalized? Show calculations for that specific type of transformation in excel sheet and its corresponding graph drawn in Origin Pro (pasted in Excel sheet). 26.02 20.72 27.46 105 256.3 81.52 35.58 134.58 36.64 41.1 54.8 102.62 22.94 21.48 26.64 35.84 47.12 48.32 178.84 23.86 172.24 177.1 104 154.86 61.26 81.3 108.18 69.36 36.66 43.38 186 41.7 29.1 45.54 31.5 158.6 174.1 77.72