File Home Insert Page Layout Formulas Data Review View Help Tell Cut Calibri 11 AA Wrap Text Copy 4 Paste BI U- EXENE A Merge & Center Format Painter Clipboard Font Alignment A1 Employee A B C D E F G H 1 Employee Gender Years Experience Education Own PC PC Knowledge This is ficti 2 1 Female 15 3 2 Male 12 4 3 Male 8 5 4 Male 18 6 5 Male 13 7 6 Male 8 8 7 Male 8 9 8 Male 11 10 9 Male 14 11 10 Male 17 12 11 Male 8 22427342223 No 1 No 3 Yes 3 No 2 1 No 2 Yes 3 Yes 4 Yes 2 No 2 No 1 Yes 4 13 12 Male 6 3 Yes 4 14 13 Female 15 2 No 2 15 14 Male 10 14 No 3 16 15 Male 11 3 Yes 3 17 16 Male 11 18 17 Female 7 19 18 Male 13 20 19 Female 14 21 20 Male 8 12324 NO 2 No B No 3 No 2 Yes 4 22 21 Male 10 2 No B 2B 22 24 25 26 22 Male 10 3 Yes 2 23 Female 5 3 Yes 3 24 Male 8 5 Yes 5 25 Male 12 27 26 Male 11 23 No 2 Yes 28 27 Male 12 4. No 4 29 28 Male 10 B 30 29 Female 7 LE 30 Male 13 322 No No Yes mm 23 3 Data 31 Male 8 3 32 Male 18 3 mm No No 33 Male 10 4 Yes 34 Male 35 Male 36 Male 11 37 Female 38 Male 39 Male 40 Female 41 Male 4∞∞ 6929 3 Yes 8 2 Yes 42454 3 No 3 8 3 No 2 4 Yes 5 2 No 3 12 3 No 1 3 Yes 4 B 42 Male 13 4 43 Male 15 -5 44 Male 14 46 45 Female 47 46 Female 13 48 47 Male 49 48 Female 50 49 Female 51 50 Female 10 52 51 Female 53 52 Male 54 53 Male 11 55 54 Male 56 55 Female 57 56 Male 58 57 Male 59 58 Male 60 59 Female 10 61 60 Female 35483984000 86789T09 42432 33 34 3 3 2 133 mm m m Yes 3 No 2 Yes 3 No 3 No TA Yes No No 5 3 No B No B B Yes No 2 Yes No D Yes No 3 Yes 3 No 2 3 No 4344454NT + Data 62 61 Female 9 2 No 3 63 62 Female 6 3 Yes 3 64 63 Female 00 2 No 3 f 65 64 Male 12 S Yes 4 66 65 Male 8 4 Yes 5 67 66 Male 11 1 No 2 68 67 Male 7 3 Yes 5 69 68 Male 11 4 Yes 2 70 69 Female 11 3 No 2 71 70 Female 12 5 No 4 72 71 Male 12 73 72 Female 292 2 No 2 3 No 2 74 73 Female 9 3 Yes 2 75 74 Female 10 76 75 Male 15 1 No 2 2 Yes 3 77 76 Female 9 4 No 3 78 77 Male 11 2 No 3 79 78 Male 8 B No 4 80 79 Female 5 4 Yes 81 80 Male 10 4 Yes 82 81 Male 11 83 82 Male 11 22 Yes 3 No 3 333 mm 84 85 86 87 88 89 90 91 a חי Data E N
I need some assistance solving Part B of this question. Refer to the excel data in the image provided to answer Part B. SoftBus Company sells PC equipment and customized software to small companies to help them manage their day-to-day business activities. Although SoftBus spends time with all customers to understand their needs, the customers are eventually on their own to use the equipment and software intelligently. To understand its customers better, SoftBus recently sent questionnaires to a large number of prospective customers. Key personnel—those who would be using the software—were asked to fill out the questionnaire. SoftBus received 82 usable responses, as shown in the file. You can assume that these employees represent a random sample of all of SoftBus's prospective customers. SoftBus believes it can afford to spend much less time with customers who own PCs and score at least 4 on PC Knowledge. Let's call these the "PC-savvy" customers. On the other hand, SoftBus believes it will have to spend a lot of time with customers who do not own a PC and score 2 or less on PC Knowledge. Let's call these the "PC-illiterate" customers, SoftBus believes its profit from each prospective customer depends on the customer's level of PC knowledge. It divides the customers into three classes: PC-savvy, PC-illiterate, and all others. As a rough guide, SoftBus figures it can gain profit P1 from each PC-savvy customer, profit P3 from each PC-illiterate customer, and profit P2 from each of the others. a. What values of P1, P2, and P3 seem reasonable? For example, would you expect P1 < P2 < P3 or the opposite? P1 > P2 > P3 (is the correct answer) Now, answer part B. b. Using a profit P1 of $5,000, a profit P2 of $4,500, and a profit P3 of $4,000, calculate a 95% confidence interval for the mean profit per customer that SoftBus can expect to obtain. (Round your answers to one decimal place.) Lower Limit = Upper Limit =
Step by step
Solved in 2 steps
