The Excel file Chipotle provided in the corresponding assignment link consists of data related to predicting the level of business (Usage Level) obtained from a survey of purchasing managers of Chipotle. Chipotle has many suppliers and the data has survey of them. The following are the independent variables.
X1: Delivery Speed ?amount of time it takes to deliver the product once an order is confirmed.
X2: Price Level ?perceived level of price charged by product suppliers.
X3: Price Flexibility ?perceived willingness of Chipotle representatives to negotiate price on all types of purchases.
X4: Manufacturing Image ?overall image of the manufacturer or supplier.
X5: Overall Service ?overall level of service necessary for maintaining a satisfactory relationship between supplier and purchaser.
X6: Sales Force Image ?overall image of the manufacturer's sales force.
X7: Product Quality ?perceived level of quality of a particular product.
X8: Size of Firm ?size relative to others in this market (0 = small; 1 = large) .
The result was a scale from 0 to 10 rounded to one decimal place.
Using the statistical tools in this chapter (multiple regression modeling and categorical regression modeling), conduct a completeanalysisto predict "Usage Level".Be sure to investigate the impact of the categorical variable Size of Firm (coded as 0 for small firms and 1 for large firms) and possible interactions. Also stratify the data by firm size to account for any differences between small and large firms. Write up your results and recommendations in a formal report to Chipotle management in another Excel Tab in the same Excel file.You will submit an Excel Spread Sheet, xsl or xsls.
B115 A B C D E F G H I J K L M N O P A W N - Respondent Perceptions Purchaser CharacteristicPurchase Outcome X1 X2 X3 X4 X5 X6 X7 X8 X9 5 Delivery speedPrice levelPrice flexibilityManufacturing imageOverall serviceSalesforce imageProduct quality Size of firm Usage level 4.1 0.6 6.9 4.7 2.4 2.3 5.2 32 1.8 3 6.3 6.6 2.5 8.4 43 8 3.4 5.2 5.7 6 4.3 2.7 8.2 48 9 2.7 7.1 5.9 1.8 2.3 7.8 32 10 6 0.9 9.6 7.8 3.4 4.6 4.5 58 11 1.9 3.3 7.9 4.8 2.6 1.9 9.7 45 12 4.6 2.4 9.5 6.6 3.5 4.5 7.6 46 13 1.3 4.2 6.2 5.1 2.8 2.2 6.9 44 14 5.5 1.6 9.4 4.7 3.5 7.6 15 4 3.5 6.5 6 3.7 3.2 8.7 54 16 2.4 1.6 8.8 4.8 2 2.8 5.8 17 3.9 2.2 9.1 4.6 3 2.5 8.3 18 2.8 1.4 8.1 3.8 2.1 1.4 6.6 19 3.7 1.5 8.6 5.7 2.7 3.7 6.7 - o o - o 0 0 0 0 0 0 0 0 0 -0 0 -0 -0 -0- - -0 20 4.7 1.3 9.9 6.7 3 2.6 6.8 21 3.4 2 9.7 4.7 2.7 1.7 4.8 22 3.2 41 5.7 5.1 3.6 2.9 6.2 23 4.9 1.8 7.7 4.3 3.4 1.5 5.9 24 5.3 1.4 9.7 6.1 3.3 3.9 6.8 54 25 4.7 1.3 9.9 6.7 3 2.6 6.8 26 3.3 0.9 8.6 4 2.1 1.8 6.3 27 3.4 0.4 8.3 2.5 1.2 1.7 5.2 35 28 3 4 9.1 7.1 3.5 3.4 8.4 55 29 2.4 1.5 6.7 4.8 1.9 2.5 7.2 36 30 5.1 1.4 8.7 4.8 3.3 2.6 3.8 49 31 4.6 2.1 7.9 5.8 Activate Windows 3.4 2.8 4.7 49 32 24 15 6 6 4 8 19 5 72 36 Go to Settings to activate Windows. 4 Chipotle Hazir 0 % 110 - Pr E 1:01 AM 64OF Clear ~ ~ [) ENG 8/11/2021B115 fac A B C D E F G H J K L M N O P 31 4.6 2.1 7.9 5.8 3.4 2.8 4.7 49 32 2.4 1.5 6.6 4.8 1.9 2.5 7.2 36 33 5.2 1.3 9.7 6.1 3.2 3.9 6.7 54 34 3.5 2.8 9.9 3.5 3.1 1.7 5.4 49 35 4.1 3.7 5.9 5.5 3.9 3 8.4 46 36 3 3.2 6 5.3 3.1 3 8 37 2.8 3.8 8.9 6.9 3.3 3.2 8.2 53 38 5.2 2 9.3 5.9 3.7 2.4 4.6 60 39 3.4 3.7 6.4 5.7 3.5 3.4 8.4 47. 40 2.4 7.7 3.4 1.7 1.1 6.2 41 1.8 3.3 7.5 4.5 2.5 2.4 7.6 42 3.6 4 5.8 5.8 3.7 2.5 9.3 43 4 0.9 9.1 5.4 2.4 2.6 7.3 46 44 0 2.1 6.9 5.4 1.1 2.6 8.9 29 45 2.4 2 6.4 4.5 2.1 2.2 8.8 28 46 1.9 3.4 7.6 4.6 2.6 2.5 7.7 Do - - - o 0 0 - 0 0 - 0 0 0 - - - 0 - - - - 0 0 - - 0 0- 40 47 5.9 0.9 9.6 7.8 3.4 4.6 4.5 58 48 4.9 2.3 9.3 4.5 3.6 1.3 6.2 49 5 1.3 8.6 4.7 3.1 2.5 3.7 50 2 2.6 6.5 3.7 2.4 1.7 8.5 38 51 5 2.5 9.4 4.6 3.7 1.4 6.3 52 3.1 1.9 10 4.5 2.6 3.2 3.8 53 3.4 3.9 5.6 5.6 3.6 2.3 9.1 54 5 .8 0.2 8 8 4.5 3 2.4 6.7 55 5.4 2.1 8 3 3.8 1.4 5.2 56 3.7 0.7 8.2 6 2.1 2.5 5.2 57 2.6 4.8 8.2 5 3.6 2.5 9 58 4.5 4.1 6.3 5.9 4.3 3.4 8.8 50 59 2.8 2.4 6.7 4.9 2.5 2.6 9.2 60 3.8 0.8 8.7 2.9 1.6 2.1 5.6 39 61 2.9 2.6 7.7 2.8 3.6 7.7 Activate Windows 62 49 4 4 74 6 9 4 6 96 62 Go to Settings to activate Windows.B115 Jac A B C D E F G H J K L M N O P 61 2.9 2.6 7.7 7 2.8 3.6 7.7 47 62 4.9 4.4 7.4 6.9 4.6 4 9.6 62 63 5.4 2.5 9.6 5.5 4 3 7.7 65 64 4.3 1.8 7.6 5.4 3.1 2.5 4.4 46 65 2.3 4.5 8 4.7 3.3 2.2 8.7 50 66 3.1 1.9 9.9 4.5 2.6 3.1 3.8 54 67 5.1 1.9 9.2 5.8 3.6 2.3 4.5 60 68 4.1 1.1 9.3 5.5 2.5 2.7 7.4 69 3 3.8 5.5 4.9 3.4 2.6 6 36 70 1.1 2 7.2 4.7 1.6 3.2 10 40 71 3.7 1.4 9 4.5 2.6 2.3 6.8 45 72 4.2 2.5 9.2 6.2 3.3 3.9 7.3 59 73 1.6 4.5 6.4 5.3 3 2.5 7.1 46 74 5.3 1.7 8.5 3.7 3.5 1.9 4.8 58 75 2.3 3.7 8.3 5.2 3 2.3 9.1 49 76 3.6 5.4 5.9 6.2 4.5 2.9 8.4 - - o - 0 0 0 - 0 0 0 - 0 0 0 - - 0 - 0 0 - 0 0 0 0 -00-0 77 5.6 2.2 8.2 3.1 4 1.6 5.3 98 8 78 3.6 2.2 9.9 4.8 2.9 1.9 4.9 79 5.2 1.3 9.1 4.5 3.3 2.7 7.3 E 8 80 3 2 6.6 6.6 2.4 2.7 8.2 81 4.2 2.4 9.4 4.9 3.2 2.7 8.5 49 82 3.8 0.8 8.3 6.1 2.2 2.6 5.3 42 83 3.3 2.6 9.7 3.3 2.9 1.5 5.2 84 1.9 7.1 4.5 1.5 3.1 9.9 39 85 4.5 1.6 8.7 4.6 3.1 2.1 6.8 56 86 5.5 1.8 8.7 3.8 3.6 2.1 4.9 59 87 3.4 4.6 5.5 8.2 4 4.4 6.3 47.3 88 1.6 2.8 6.1 6.4 2.3 3.8 8.2 89 2.3 3.7 7.6 5 3 2.5 7.4 37 90 2.6 8.5 6 2.8 2.8 6.8 53 91 2.5 3.1 7 4.2 2.8 2.2 9 Activate Windows 92 2.4 2.9 8.4 5.9 27 2.7 6.7 51 Go to Settings to activate Windows. 4 ) Chipotle