Mortgage Car 0 O 1 1 mo O 1 0 0 0 0 0 0 0 N 0 0 1 9 1 0 0 0 0 1 XYZ COMPANY CONSUMER DATASET1 Customer No Age Gender Income Status Children 1 48 1 17546 0 1 2 40 0 30085.1 1 3 3 51 1 16575.4 2 0 4 23 1 20375.4 1 3 5 57 1 50576.3 0 6 57 1 37869.6 1 2 7 22 0 8877.07 0 0 8 58 0 24946.6 1 0 9 37 1 25304.3 1 10 54 0 24212.1 1 2 11 66 1 59803.9 0 12 52 1 26658.8 0 0 13 44 1 15735.8 1 1 14 66 1 55204.7 1 1 15 36 0 19474.6 2 0 16 38 1 22342.1 1 0 17 37 1 17729.8 1 2 18 46 1 41016 1 0 19 62 1 26909.2 1 20 31 0 22522.8 1 0 21 61 0 57880.7 2 2 22 50 0 16497.3 1 2 23 54 0 38446.6 1 24 27 1 15538.8 0 25 22 0 12640.3 2 1 1 0 1 1 1 0 1 1 1 0 1 0 1 0 0 0 1 0 0 0 0 0 0 NO ON 1 1 1 0 Data Preparation: Field/Variable Char/Boolean Value Gender: Male (M) 1 1 Female (F) 0 Status: Single 0 Married 1 Divorced 2 Car: Yes 1 No 0 Mortgage Yes 1 No 0 C. Make an analysis of the skewness of the result. (5 marks) Day 1 Day 2 Day 3 Day 4 Day 5 Week 1 16 15 19 18 25 Week 2 15 19 18 21 23 Week 3 20 27 22 23 23 Week 4 22 21 33 28 19 Week 5 18 18 16 20 32 Week 6 26 29 31 33 35 Week 737 33 34 25 27 Week 8 24 21 28 30 35 Week 9 25 39 36 32 38 Week 10 19 24 29 33 36 Week 11 39 42 45 41 38 Week 12 41 40 37 35 33 skewness of the data is 0.161023 Q2: Afghanistan Mean 436.4138 6 Median Range Variance Standard Deviation 86912 6008913 2451.354 max 57186 min -29726 Q3 a. trendline and equation 70000 60000 50000 M 40000 30000 20000 Axis Title 10000 -500000 -10000 500000 1000000 1500000 2000000 2500000 3000000 3500000 -20000 -30000 -40000 Axis Title b. S New_cases 1200 1000 y = 14.557x R2 = 0.8509*** 800 600 400 200 0 1234567891012149478901234982296B338383894123456785655345668$66634567