Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Excel file Chipotle provided in the corresponding assignment link consists of data related to predicting the level of business ( Usage Level ) obtained

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra

Authors: Cynthia Y Young

4th Edition

1119320682, 9781119320685

More Books

Students also viewed these Mathematics questions