1. For the variables Shipping Costs and Customer Segment, produce a frequency table and appropriate chart to describe the data. Place both within the Word file. ( 6 marks)
2. Calculate and explain a 95% confidence interval for the average sales amount of orders for the home office customers only. Show Excel output and explanation in Word file. (6 marks)

3. It is often felt that the order priority of critical would have higher shipping costs than an order of low priority. Investigate this contention by carrying out an appropriate hypothesis test using Excel. State null and alternate hypotheses, and give Excel output to verify your conclusion. Assume equal variances. Place hypotheses, Excel output and conclusion in the Word File. (8 marks)

4. You will investigate the relationship between the sales in dollars and the order quantity. In excel you will undertake a full regression analysis,

a. including a scatter diagram,

b. an estimate of the linear regression model

c. stating the coefficients of correlation and determination and what they mean in relation to this case

d. a test of the hypothesis that there is no linear relationship between sales and the order quantity for an order. State hypotheses, values and conclusion. (2 + 2 + 3 + 3 = 10 marks)

PLEASE ANSWER FAST

Share - 11 - AA 47 O v - 5 Part B Data File Excel Tusharjoitely File Home Insert Draw Page Layout Fomulas Data Review View Help Tell me what you want to do . Calibri ab Wrap Text General ED AutoSurm - Paste Fill BIU - > .nan A- Merge & Center - % Conditional Format as Cell Insert Delete Format Sort & Find & 00.0 Formatting Table Styles Clear - Filter - Select Clipboard Font 5 Alignment Nurnber 19 Styles Cells Editing J19 A C D E G H J L M N o R s T V w Order ID Order PriorityOrder Quantity Sales Ship Modepine Cos Region fustomer Segmen Days.toshi 2 10505 1 20 $172.33 1 $5.74 w Corporate 2 Order ID Order Priorityrder duantit Sales 3 3456 0 Ship Mode Shipping cos Region stomer SermDays to ship 16 $3,833.37 15.81 w Home Office 2 15206 4 42 $1,750.51 1 $4.20 438140 w 1 1 Carcerate 45 $341.39 1 $ $6.16 W Smal B.ciness 18658 0 49 $14.346.73 1 $10.99 w 20486 3 42 Home Office 2 $153.98 1 $0.20 El Lupurale 1 35556 2 35 $71.61 1 6 35349 Crosle 2 25 $4.99 1 2 $174.03 $5.74 W Consumer 2 41539 3 41 $2.361.71 1 $8.99 w . 71099 2 49 Consumer 12 $12.90 1 $0.70 E Smol Barness 37299 3 25 $12.343.07 30.4 $9.29 w A 8 1.1432 3 12 2 Consumer 3 $75.42 50.85 F Corporate 2 10343 2 18 $1,21.04 1 $4.45 3 9 52929 F Consumer 2 19 $ $53.94 1 $1.25 w Smal B.chess 1 325 3 17 $100.95 10 40543 $3.37 E 1 Consumer 4 23 $258.74 1 $5.22 1 E Some Office 35622 3 $ 1 1131550 $13539 4 $9.65 W 11 35 1 $268.35 1 $3.GE $ w Consumer 1 12293 3 31 $283.17 1 $1.39 E Home Office 1 12 47459 20 $197.21 1 $1.49 E Home Office 1 31030 3 43 $20.894.83 2 E $8.05 13 26679 4 2 $1,491.831 $8.99 F Consumer Corporate 3 37891 3 14 $163.16 1 S6. F Small Rusie 2 3 14 4017 7 $375.57 1 $6.11 E Consumer 0 54882 + 17 $36.29 1 $0.49 E 155133 Consumer 3 2 41 $159.26 1 $0.50 E Home Office 1 42051 1 36 3 $188.14 1 $5.4 16 27904 E $450.59 1 Small Busines $9.99 W Consumer 1 45248 2 $154.85 1 $5.13 E Corporate 3 2 1770 23 $140.03 1 $5.08 $ W Smol.iness 1 40134 1 1 $9.73 1 $4.72 w Small Busines 10 4R512 0 47 $148.2 3 PRAR 50.81 wanium 3 0 1674 20 1 $1,954.48 1 $4.62 F 7 1930:00 Small Busine 1 $225.45 1 $9.54 W5mal B.ciness 2 32198 2 21 1 $5.53 E 0 2042/ 4 Consumer 20 $241.92 1 $2.27 W Sms 2 18851 0 5 2 $13127 $4,35 21 32500 3 E Home Office 1 $261.38 1 $8.74 E Corporate 2 29318 0 21 $2,954.14 $11.20 E 1 2253443 4 Corporate 23 -- $1.477.03 1 $4.02 W Corums 1 28754 2 30 23 $295.22 1 W 11815 1 22 $0.99 2 $851.271 Home Office $7.4 F Carme 2 40951 4 40 $901.12 1 SR.17 F Corporate 3 24 15428 4 30 $1,444.96 3 $4.00 w Smal B.ciness 1 36577 + 20 $7,497.08 $4.12 254281 2 E Small Busines 3 $3249 1 $1.39 1 L ES Smal.es 2 494/9 2 45 $5.625.00 2 $5.30 E 26 23558 1 17 Consumer 17 $579.71 2 $5.51 E Home Office 30626 4 23 $220.82 3 $1.09 E 3 Corporate 1 2754225 14 $321.21 1 $1.99 W w Smol Barness 2 30057 3 20 3 74 1223 E 12 $10.02 $1.93 $513.741 av $1.13 Corporate F 2 Corporate 1 50854 3 4 27 $137.50 1 $4.95 F Cargorate 29 51008 0 3 20 $209.GG 1 $4.59 E Consumer 2 30 35360 4 4 $1.00 1 $6.28 Cupurale 2 31 6432 30 $311.08 1 $4,50 E Corporata 2 32 347 2 29 szxo.03 1 $5.03 W Corporate 3 11 51200 2 19 $1,617.88 1 $5.50 $ w Small Busines 3 34 10210 0 10 $707.34 1 $5.52W Corporate 1 25 22149 12 $48.24 1 $1.01 Smal Bress 5 Data description Data 4) Select destination and press ENTER or choose Paste Windows in Workspace Type here to search O 16-37 ? ENG 16-11-2020 4 + 63% Share - 11 - AA 47 O v - 5 Part B Data File Excel Tusharjoitely File Home Insert Draw Page Layout Fomulas Data Review View Help Tell me what you want to do . Calibri ab Wrap Text General ED AutoSurm - Paste Fill BIU - > .nan A- Merge & Center - % Conditional Format as Cell Insert Delete Format Sort & Find & 00.0 Formatting Table Styles Clear - Filter - Select Clipboard Font 5 Alignment Nurnber 19 Styles Cells Editing J19 A C D E G H J L M N o R s T V w Order ID Order PriorityOrder Quantity Sales Ship Modepine Cos Region fustomer Segmen Days.toshi 2 10505 1 20 $172.33 1 $5.74 w Corporate 2 Order ID Order Priorityrder duantit Sales 3 3456 0 Ship Mode Shipping cos Region stomer SermDays to ship 16 $3,833.37 15.81 w Home Office 2 15206 4 42 $1,750.51 1 $4.20 438140 w 1 1 Carcerate 45 $341.39 1 $ $6.16 W Smal B.ciness 18658 0 49 $14.346.73 1 $10.99 w 20486 3 42 Home Office 2 $153.98 1 $0.20 El Lupurale 1 35556 2 35 $71.61 1 6 35349 Crosle 2 25 $4.99 1 2 $174.03 $5.74 W Consumer 2 41539 3 41 $2.361.71 1 $8.99 w . 71099 2 49 Consumer 12 $12.90 1 $0.70 E Smol Barness 37299 3 25 $12.343.07 30.4 $9.29 w A 8 1.1432 3 12 2 Consumer 3 $75.42 50.85 F Corporate 2 10343 2 18 $1,21.04 1 $4.45 3 9 52929 F Consumer 2 19 $ $53.94 1 $1.25 w Smal B.chess 1 325 3 17 $100.95 10 40543 $3.37 E 1 Consumer 4 23 $258.74 1 $5.22 1 E Some Office 35622 3 $ 1 1131550 $13539 4 $9.65 W 11 35 1 $268.35 1 $3.GE $ w Consumer 1 12293 3 31 $283.17 1 $1.39 E Home Office 1 12 47459 20 $197.21 1 $1.49 E Home Office 1 31030 3 43 $20.894.83 2 E $8.05 13 26679 4 2 $1,491.831 $8.99 F Consumer Corporate 3 37891 3 14 $163.16 1 S6. F Small Rusie 2 3 14 4017 7 $375.57 1 $6.11 E Consumer 0 54882 + 17 $36.29 1 $0.49 E 155133 Consumer 3 2 41 $159.26 1 $0.50 E Home Office 1 42051 1 36 3 $188.14 1 $5.4 16 27904 E $450.59 1 Small Busines $9.99 W Consumer 1 45248 2 $154.85 1 $5.13 E Corporate 3 2 1770 23 $140.03 1 $5.08 $ W Smol.iness 1 40134 1 1 $9.73 1 $4.72 w Small Busines 10 4R512 0 47 $148.2 3 PRAR 50.81 wanium 3 0 1674 20 1 $1,954.48 1 $4.62 F 7 1930:00 Small Busine 1 $225.45 1 $9.54 W5mal B.ciness 2 32198 2 21 1 $5.53 E 0 2042/ 4 Consumer 20 $241.92 1 $2.27 W Sms 2 18851 0 5 2 $13127 $4,35 21 32500 3 E Home Office 1 $261.38 1 $8.74 E Corporate 2 29318 0 21 $2,954.14 $11.20 E 1 2253443 4 Corporate 23 -- $1.477.03 1 $4.02 W Corums 1 28754 2 30 23 $295.22 1 W 11815 1 22 $0.99 2 $851.271 Home Office $7.4 F Carme 2 40951 4 40 $901.12 1 SR.17 F Corporate 3 24 15428 4 30 $1,444.96 3 $4.00 w Smal B.ciness 1 36577 + 20 $7,497.08 $4.12 254281 2 E Small Busines 3 $3249 1 $1.39 1 L ES Smal.es 2 494/9 2 45 $5.625.00 2 $5.30 E 26 23558 1 17 Consumer 17 $579.71 2 $5.51 E Home Office 30626 4 23 $220.82 3 $1.09 E 3 Corporate 1 2754225 14 $321.21 1 $1.99 W w Smol Barness 2 30057 3 20 3 74 1223 E 12 $10.02 $1.93 $513.741 av $1.13 Corporate F 2 Corporate 1 50854 3 4 27 $137.50 1 $4.95 F Cargorate 29 51008 0 3 20 $209.GG 1 $4.59 E Consumer 2 30 35360 4 4 $1.00 1 $6.28 Cupurale 2 31 6432 30 $311.08 1 $4,50 E Corporata 2 32 347 2 29 szxo.03 1 $5.03 W Corporate 3 11 51200 2 19 $1,617.88 1 $5.50 $ w Small Busines 3 34 10210 0 10 $707.34 1 $5.52W Corporate 1 25 22149 12 $48.24 1 $1.01 Smal Bress 5 Data description Data 4) Select destination and press ENTER or choose Paste Windows in Workspace Type here to search O 16-37 ? ENG 16-11-2020 4 + 63%