Please answer the question in word doc file . I add some analyze data to support you. Moreover I add excel data and JMP data to solve the question.
1) Suppose a company recently hired a well-known speaker to give a seminar to its employees about Business Ethics in Data Mining. The senior managers thought the seminar was enlightening, but wanted to gauge how the other employees felt about the seminar. A short 10 question survey was given to each employee after the seminar was over and they were to respond with 5 point Likert Scale response (1=Strongly Disagree; 2=Disagree; 3=Neutral; 4=Agree; 5=Strongly Agree). The survey had the following questions: · Q1. I learned a lot from the ‘Business Ethics in Data Mining’ seminar. · Q2. I will use the information I learned in the seminar in my job · Q3. I hope the same speaker can return and give seminars on other topics. · Q4. I think the ‘Business Ethics in Data Mining’ seminar was useless. · Q5. I hope my I get the chance to attend other seminars on this topic. · Q6. I would recommend the ‘Business Ethics in Data Mining’ seminar to others. · Q7. During the seminar, I caught myself day-dreaming and thinking about other things. · Q8. I felt the ‘Business Ethics in Data Mining’ seminar was worth my time. · Q9. I was impressed by the speaker’s seminar on ‘Business Ethics in Data Mining’ · Q10. The speaker was engaging, informative, and knowledgeable. Use “Final Exam data_question 1.jmp” to answer the following questions: a) There is probably some multi-collinearity in this data, since many of the survey questions will generate similar responses from the employees. Check the correlation matrix and comment about which questions are strongly correlated. Then, use the appropriate Factor Analysis to write out the equations to combine the 10 survey questions into Factors. Use only the Questions with Loadings greater than 0.40. b) Comment on how the questions that are combined with each other. Intuitively, does it make sense to combine the questions as suggested by the Factor Analysis? c) You should notice that Q4 and Q7 have negative Loading values. Comment on why you think this is happening. 2) A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking relate to the risk of strokes. Assume that the following data are a portion from this study. Risk is interpreted as the probability (times 100) that the patient will have a stroke over the next 10-year period. The patient is a smoker if Smoker = 1 and not a smoker if Smoker=0. Risk Age Pressure Smoker 12 57 152 0 24 67 163 1 13 58 155 0 56 86 177 1 a) Look at the output for the following two regression models that relate the risk of stroke to the person’s age, blood pressure, and smoking status. Write out the ‘best’ regression model. Use that model for the remaining questions. b) Solve the equation to find the slope coefficient on Blood Pressure for a non-smoker. c) What is the probability of a stroke over the next 10 years for John Doe, a 68 year-old smoker who has a blood pressure of 175? d) Are they any high leverage points that we should be concerned about? Use the portions of the JMP Regression output (below and on next page) to answer the following questions: 3. The data in “Cluster Analysis_Mobile phone survey.xls” contains several demographic variables as well as seven variables measuring attitudes towards mobile phones, where respondents were asked to give their degree of agreement/disagreement with the following statements: · Technology is fascinating · I am often surprised by the size of bills · I find it difficult to determine best deal · I spent a lot of time shopping for best deal · I closely monitor the time I spend on the phone · Cost is a factor when deciding where to SMS or phone · I try to keep calls short and to the point The scale used was: Perform a Cluster Analysis on this dataset to see if the Mobile phone customers can be segmentated into different market populations. Create a summary of the unique aspects of each of the clusters. Examine alternative cluster analysis solutions. Generally it is useful to explore solutions with fewer clusters than those that are automatically suggested. Come up with evocative names for each of the clusters (e.g., "The big talkers"). 4. A paint manufacturer wishes to validate its advertisement statement that a gallon of its paint covers on average more than 400 square feet. An independent testing laboratory is hired to evaluate the advertisement statement based on fifty 1-gallon cans of paint randomly selected from the manufacturer’s warehouse. (Data is not shown, but use JMP output to answer these questions) a. What is the research hypothesis that the manufacturer wants to test? Write out the null and alternative hypothesis being tested b. Is this data skewed left, skewed right, or symmetric? c. Using the appropriate test for the research hypothesis, what can the paint manufacturer claim about the advertisement of covering at least 400 square feet? 5. A large Toyota car dealership offers purchasers of new Toyota cars the option to buy their used car as part of a trade-in. In particular, a new promotion promises to pay high prices for used Toyota Corolla cars for purchasers of a new car. The dealer then sells the used cars for a small profit. To ensure a reasonable profit, the dealer needs to be able to predict the price that the dealership will get for the used cars. For that reason, data were collected on all previous sales of used Toyota Corollas at the dealership. The data include the sales price and other information on the car, such as its age, mileage, fuel type, engine size, etc. A portion of the data set is shown below. For this problem, let’s consider building a Two-Way ANOVA model to predict the price of the used car based on the Age of the car (less than 2 years old vs. more than 2 years old) and the Horsepower (90 vs 110 vs 192). Ignore the rest of the data, for the purpose of this problem. Output from JMP is found below. a. This is a replicated Two-way ANOVA problem. Are you able to estimate the interaction of the two Factors? b. List the two Factors (A and B) and the number of levels of each c. Using the JMP output, what can we conclude about the main effect of Age, main effect of Horsepower, and interaction of Age*Horsepower? If applicable, write each of these conclusions in a sentence and report the corresponding p-value. d. In a sentence or two, interpret the interaction plot. (i.e. What insight do you gain from this plot?) e. If you were employed at this dealership, what would be your recommendation for the combination of Age and Horsepower levels that will sell at the highest average price of used Toyota Corollas? (could be more than 1 correct answer) f. If you were employed at this dealership, what would be your recommendation for the combination of Age and Horsepower levels that will sell at the lowest average price of used Toyota Corollas? (could be more than 1 correct answer) g. Interpret the 95% confidence interval for the difference in used Corolla price for cars with 90 Horsepower that are less than 2 years old compared to cars with 192 Horsepower that are more than 2 years old. h. If the next customer wants to trade-in their used Toyota Corolla that is 4 years old with 192 Horsepower, predict the car’s price that the dealership should be able to sell this car. Data IDQ1Q2Q3Q4Q5Q6Q7Q8Q9Q10Q11Q12Q13Q14Q15Q16Q17Q18 8841655325544240609221 881112213421375801121 713155322443210407221 7141628442445209905121 715165633544333601121 87511221241145401221 413164623422227251121 7941624232232246101121 9441658134425102105121 94514511112125601221 102516363121311208401121 10221632322234410701221 91116543232244356011221 842112521544225401121 844156345212310651221 893151521454133855221 89416163134532510951221 10341652212353560909221 1035137422411210301221 11721655111233350301121 11741652311254320701221 6941652255312231011121 1314154211423260709211 231112324344460701221 23516342334421106501121 5511655312522110701221 552165534552435601121 55516262143422107501121 1321633124231220801111 114516242355555158151121 483162632121117751221 4811636124143457701121 482145213455550701211 54515551222133104011121 54115551122221107511211 5421625154213374151111 16921555211455215805211 160516342115112403759121 16021635212423215751221 1543112213543121201121 154414213222312301221 16241655531111120405221 573166513442321551121 5751665231222210701121 163315422222320101121 168316252113142106201121 168111222234235201121 15131542124445910601121 11651654322223322011221 116111215515136101221 1162155424223414301121 10121652434443412601121 8641655514221210801221 8611635144231330701121 385165634344210301221 381112244232270601221 382112422142120701221 81316561251443809801121 811152214122220751111 4116165435523410901121 119316782125222209751121 1195162621445514010803121 99215583133434257153221 9931623122243365506121 373167631422431001051121 375142412355320609121 541716383233232256101221 5417165343221915209221 1101165422542142006109121 1105162323452114101121 5331646141242106251121 5931646243342202501121 5911624232221183509121 12131623411541310703121 47316342232223259801221 4741623214112265101121 12031669135555250901121 1204164322242423010606121 1205161434444446010406121 1202163311144448010301221 96416532425542501001221 102516363121311208401121 10221632322234410701221 6251633555521264809121 142314312231123101121 1374164221232311007309121 1375161435354211351121 641162551352513601121 5721655321231349831221 12611654231551540829121 126215541111231244011121 78116442111121106501121 7821655211115115301221 70316442214553705101121 9031644322345425701121 20116752251222255251121 16412813223310201221 7731646224421220401121 66116543123522208301221 6621554145525251051221 66511331322210401121 3111634255522111011221 264162431933223010104121 2651623512223310603221 744122215135120809121 74515542114324158011221 282163422442416551121 28415432343111052011221 285113531511220651221 83416163322542104101121 8351626551551150415121 8311552115121220504111 6721635522542110601221 67416553444553108153121 675139123233207101221 21115321111214301121 24165523522224401121 13221665352511150709121 17051655325244312651121 1332112222144355601121 13341653525111520601221 1491143212242440701211 1492113122411115601221 1481152212222215601221 1482113323222210601221 29111355155545401221 294156335424321601121 2551626434223215623121 68115562254392202011121 6821656532421212404221 6851626312425220651121 127516261223442258806121 7216134454242105104221 39316663329335010656121 395155314142320751221 4551452244425209251221 1442115332344125505121 144314654151253421221 34316431324222307307121 3411624334224215319221 3421614342242420606221 611653221554510601221 611134335553100801221 332113212241215401121 335153311221146601121 12411221552115405221 124112452244120405121 12416632134111165101211 1241654111343215801121 931112425441210401221 932113322442420701221 1361113211222220601221 136416174111112307201221 491113124222170701221 495113211333310801121 3011122124233509101221 302112212444215601121 1611113334335421651221 161211222451114203121 16131634321215110601221 1614157213225106501211 1615112424414110101121 463164622443421010601121 46412732222445701221 42416462332442108401121 40315543242130401121 6031646232232250801221 7221553123411101511121 12321635522222215605221 3211624211453412901221 3231623112343220701111 6551624512453328904121 651144545344209504121 158116243444554206151121 565152534442110301121 1751522112444100855221 611623224411470601221 63167434443234109121 65153222222210501121 9831673324332308809121 1061655922421225505221 10921623212123110709221 10931675211153220605111 10951654212222415509221 13011624511232530901221 1304156434322350751121 15711653933229240409221 15731673142225420601121 1574165424151125609221 504112521441110803221 505112211211115504221 3621625225232154159121 1134155654333334601221 113516362214552206751221 1051162623225521062011121 17011652312333520801221 213166755455920104121 215146212142120201221 3521443214414307101221 95316562142112307101121 955113222211148809121 801115222222230501221 80316765235413258805121 8051555535522202109121 15321655241211130451221 156116643244343104401221 15631625145411110301121 15651624533425101901221 1381161322212225309221 104316531122323157501221 104416442233253157751121 8531639323543425806112 8541653312443425611222 85513724551210101212 8511616135555510010801122 883163922211115409212 88513921345540604112 88216133233341010954122 1353152731121410301212 1355165622122225351122 87115722122240501212 87212712233410301212 7641572243224251001122 76512711234332401212 41412724423345551212 7921667223324436501112 7931657221133325606122 943166634454920251212 10231649231535308706212 10211636551252110201222 9151517412242210505222 84312332545440901212 84512731125120301212 8951623532244303209222 1033163713455310301222 10311667211345109904112 1032166925251110301122 117316371215553407701112 117513831233530401212 692162645244420101222 6931637234334210451212 63116461324455599956112 6321667212244107603112 6331574125321099103212 634161732445550201222 6351656312434510601212 131216262354242109701122 13131647222233458751112 13151636222241486701222 2331647315441108801112 234126133211104201212 55412623411110401212 13112821223430501212 13316794222441061001112 13412624155540401212 1141162733444420301212 11431677315111104301112 114412631155550202212 48412631124135403212 48516671121211059011112 5431676241144104601112 54415582525111331011212 169316471152555010951122 169415634211910201212 16031649421555209904112 1604126443445448301212 15451659243334125801112 162115924341511301212 162216695112552010985112 16231637243324208956112 162513732412220351212 5721627215511103501112 5741666442441123011122 16351627412522207601112 16841578132111101505112 1682161721232220401112 151412734343320209212 116313735513910201212 1164162752111910209112 823157211411447309112 8241617312112122506212 1013157232223413503222 101412745321210101212 863153731114220301212 865137542411112501112 38314752123443205212 3841627511255409606112 8151628211253105751122 2000291691582234212099109212 2000291691618422444308904112 20002916913822125310203112 43125312111140601212 1194126522212210901212 119112742123410751212 99116664323332127655122 99415553133424106201222 3741657345431204101212 12216285122494010801112 12213722322520704212 122147111555207011222 1221617451259104801212 11031574112443099301212 11041628311255204991112 12931571123121295010212 12941627322454208901112 1295165655555552097510112 5731572122453157304112 57412742124446605212 53412711121110509212 59412721294410501112 121216173125251410801112 121415732425440201222 47212633323446505222 47516473232444010701112 471162531222330659122 12011532224422606109222 963163712555310201212 96513823155210209222 961165725251511401212 9621656352232220401222 5731677512145306601112 57412651431310401212 57516262122555010901112 10231647231535308706212 10211636551252110201222 62116242224232599306122 62216473411111021001112 62312623342330201212 14241626241135207501112 14251262121251099011212 6431637223414139756112 64416575135111082011212 64513915512510201222 573155821112310401212 574161822444422687.51222 5711628212254205501212 1263158521222103104212 12651628222223106906112 78315855132510301212 78416182111555010306112 331572111111057010212 3412724112510301212 701162731121112403212 7021618322335207901112 70412745221110405212 904127133444358401112 2041654432452430701212 2051627234444236601112 51315741213110101212 5141627245424126953112 515154112121350851122 14416191253451108501112 14515591142444128301212 77412943232115401212 66415951154220609222 31412911354224603212 262158331444204801112 26312955555550301212 74312911244133301212 2831648322245208904112 571162814251910629212 5731649323333408901112 57412651251510301112 5751624312344177901122 83316793323434081003112 8321629323333303601112 6711629424424245601212 6731639324224235151122 22154211321106253112 25139222212104010212 13211638443425204011212 170313852252220301222 17041628213223116506212 133316382115121099906112 149314823234540701222 14941628112444209904112 149513921554520654122 1483149221213103301212 14841627431345206901112 1485139333415109901222 2921648212215108801112 2931636112425106251212 2531678354521102654112 25412624111310401212 68412634341225603212 1271129334543209903212 12731678123323138901122 1274124313222220601212 71166944234520504112 7312655455441601212 7416285541151099905212 391148252411118901112 45112622332332309122 4521618223332156151122 144416593335554199201212 1445139211544261153112 3441628442424203503222 34513955155510301112 6114934111110205212 611627322221107956112 61139355542202011122 3311628323333106806112 333138322232129901212 1241629511559208954122 9331538352552207101222 9341618422424208801122 136315394142151051001112 492159212422103011222 493158312332107301122 3031594214451010901112 42512933223425401212 4041638322232240702112 147114442442243503212 14721668234433105801112 147415834143530501212 723166912211136401112 7241556343544512011212 72512932944420401212 123316485115551081001112 1234126222355220603222 123516245435552107101122 18312421221140701212 184162623211120401222 185154943232220304122 32212642422920401212 32415842422910401212 3251648212215108801112 65412652242520401212 15821678231223206605112 1584126234243202101212 56312832142420401212 56415844242110109212 5611629311555106804112 1721619221241101101112 1731676144455468801112 1741558342542102810222 62163934255210109112 9821652323532250401222 9841629432125108986112 10613915421312205212 1094162932213122503212 1303118132522101011222 130512922121112401212 1654128423555213501212 16551646121222138909112 9241292254111395010212 925159515511551001212 57315285224441047011222 5741618334555219951122 57516565222252108751122 5711626411324105901222 5721626241223104851112 157516272133242308409212 501163813221416551222 5021658112215113204222 36116453324551010991122 3631678111525203211112 36416292934455010706212 11331649122211128904212 11321615344512212801222 1702163931114330401212 214165932421510301212 11312933233430401212 114158341232204101212 351165955444410705212 35415953224420303212 9511556342211173151222 804155911352150301222 15331639211232309801112 15621659233444453501112 138216763324442107506112 138312642232122205222 104512953343320501212 5313945411110201112 54165935142210301212 5514434323212301212 1354161844151313451213 91316283254443257301213 69513834221223101223 4512811255551501223 5751658442245208951223 313152844232120221123 742162833221210309123 23163821152540513223 60412844242320309223 72116292324111356905213 65316792541143308301113 98516561223555358601223 1061639544244420405213 1053159222332402011223 170313831331310305223 1704162911512118302213 95216294125244207501123 553166932145310601114 1695128522219102011224 133513953341410205224 35313955222210109224 153513932123320301214 Variable Labels and Codes IDIID - Interviewer Identification Q1Does respondent have a mobile phone?{1 = Yes, 2 = No} Q2Work status{1=Student; 2=Homemaker; 3=Retired; 4=Not Working; 5=Part-time worker; 6=Full time worker; 7=Don't Know/Refused} Q3Occupation{1=Manager/administrator; 2=Professional;; 3=Associate Professional; 4=Tradesperson; 5=Clerical, sales and services; 6=Production/transport worker; 7= Labourer and related worker; 8=Don't know/refused} Q4Age{2=16-19 yrs; 3=20-24 yrs; 4=25-29 yrs; 5=30-34 yrs; 6=35-44 yrs; 7=45-54 yrs; 8=55-64 yrs; 9=65 and over}... Q5Technology fascinating{1 = Strongly agree; 2 = Agree a little; 3 = Neither; 4 = Disagree a little; 5 = Strongly Disagree; 9 = DON'T KNOW} Q6Surprised by bill size{1 = Strongly agree; 2 = Agree a little; 3 = Neither; 4 = Disagree a little; 5 = Strongly Disagree; 9 = DON'T KNOW} Q7Difficult to determine best deal{1 = Strongly agree; 2 = Agree a little; 3 = Neither; 4 = Disagree a little; 5 = Strongly Disagree; 9 = DON'T KNOW} Q8Spent a lot of time shopping for best deal{1 = Strongly agree; 2 = Agree a little; 3 = Neither; 4 = Disagree a little; 5 = Strongly Disagree; 9 = DON'T KNOW} Q9Closely monitors time on phone{1 = Strongly agree; 2 = Agree a little; 3 = Neither; 4 = Disagree a little; 5 = Strongly Disagree; 9 = DON'T KNOW} Q10Cost is a factor when deciding to SMS or phone{1 = Strongly agree; 2 = Agree a little; 3 = Neither; 4 = Disagree a little; 5 = Strongly Disagree; 9 = DON'T KNOW} Q11Calls kept short and to the point{1 = Strongly agree; 2 = Agree a little; 3 = Neither; 4 = Disagree a little; 5 = Strongly Disagree; 9 = DON'T KNOW} Q12How many SMS sent in typical week Q13Average monthly bill{1=Less that $10 a month; 2=$10-$19 a month; 3=$20-$29 a month; 4=$30-$39 a month; 5=$40-$49 a month; 6=$50-$74 a month; 7=$75-$99 a month; 8=$100-$149 a month; 9=$150-$199 a month; 10=$200 or more a month; 99=DON'T KNOW) Q14Proportion of calls that are business Q15Where was phone bought from?{1= Specialist phone store; 2=Phone company over the internet; 3=phoned by a phone company; 4=specialized electronics store; 5=Major Retailer; 6=My employer; 7=Internet; 8=Internet Café; 9=Family/Friend; 10=Door-to-door salesman; 11=Other} Q16Gender{1 = Male; 2 = Female} Q17Has children{1 = Yes, 2 = No} Q18Marital status{1 = Single; 2 = Married; 3 = Separated/Divorced; 4 = Widowed} Sheet3