Using SAS to Examining Your Data

User Generated

Nxhabybxvln

Computer Science

Description

See the posted sample SAS Examining Your Data program, HBAT-tabs dataset, and SAS Examining Your Data output, for the analysis of X1-Customer Type along with X6-Product Quality and X7-E-Commerce.

Now perform a similar exploratory data analysis using X1-Customer Type as the Class Independent predictor variable and X8- Technical Support and X9- Complaint Resolution as the Dependent response variables, including assessment of basic descriptive statistics, normality, variance analysis and homoscedasticity / heteroscedasticity, relevant plots, and ANOVA analysis.

Provide a brief 3/4-1 page summary along with the program and output as an appendix.

Unformatted Attachment Preview

SAS Output The SAS System Obs X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 X11 X12 X13 X14 X15 X16 X17 X18 X19 X20 X21 X22 1 2 0 1 1 1 8.5 3.9 2.5 5.9 4.8 4.9 6.0 6.8 4.7 4.3 5.0 5.1 3.7 8.2 8.0 8.4 65.1 2 3 1 0 0 0 8.2 2.7 5.1 7.2 3.4 7.9 3.1 5.3 5.5 4.0 3.9 4.3 4.9 5.7 6.5 7.5 67.1 3 3 0 1 1 1 9.2 3.4 5.6 5.6 5.4 7.4 5.8 4.5 6.2 4.6 5.4 4.0 4.5 8.9 8.4 9.0 72.1 4 1 1 1 1 0 6.4 3.3 7.0 3.7 4.7 4.7 4.5 8.8 7.0 3.6 4.3 4.1 3.0 4.8 6.0 7.2 40.1 5 2 0 1 0 1 9.0 3.4 5.2 4.6 2.2 6.0 4.5 6.8 6.1 4.5 4.5 3.5 3.5 7.1 6.6 9.0 57.1 6 1 1 0 1 0 6.5 2.8 3.1 4.1 4.0 4.3 3.7 8.5 5.1 9.5 3.6 4.7 3.3 4.7 6.3 6.1 50.1 7 1 1 1 1 0 6.9 3.7 5.0 2.6 2.1 2.3 5.4 8.9 4.8 2.5 2.1 4.2 2.0 5.7 7.8 7.2 41.1 8 2 0 1 1 0 6.2 3.3 3.9 4.8 4.6 3.6 5.1 6.9 5.4 4.8 4.3 6.3 3.7 6.3 5.8 7.7 56.1 9 2 1 1 1 0 5.8 3.6 5.1 6.7 3.7 5.9 5.8 9.3 5.9 4.4 4.4 6.1 4.6 7.0 7.5 8.2 56.1 10 1 0 1 1 0 6.4 4.5 5.1 6.1 4.7 5.7 5.7 8.4 5.4 5.3 4.1 5.8 4.4 5.5 5.9 6.7 59.1 11 3 0 1 0 1 8.7 3.2 4.6 4.8 2.7 6.8 4.6 6.8 5.8 7.5 3.8 3.7 4.0 7.4 7.0 8.4 68.1 12 1 0 1 1 0 6.1 4.9 6.3 3.9 4.4 3.9 6.4 8.2 5.8 5.9 3.0 4.9 3.2 6.0 6.3 6.6 53.1 13 1 1 0 0 1 9.5 5.6 4.6 6.9 5.0 6.9 6.6 7.6 6.5 5.3 5.1 4.5 4.4 8.4 8.4 7.9 58.1 14 3 1 0 0 1 9.2 3.9 5.7 5.5 2.4 8.4 4.8 7.1 6.7 3.0 4.5 2.6 4.2 7.6 6.9 8.2 72.1 15 2 0 1 1 1 6.3 4.5 4.7 6.9 4.5 6.8 5.9 8.8 6.0 5.4 4.8 6.2 5.2 8.0 7.0 7.6 62.1 16 3 0 0 0 0 8.7 3.2 4.0 6.8 3.2 7.8 3.8 4.9 6.1 5.0 4.3 3.9 4.5 6.6 6.4 7.1 71.1 17 2 1 0 1 1 5.7 4.0 6.7 6.0 3.3 5.5 5.1 6.2 6.7 5.4 4.2 6.2 4.5 6.4 7.5 7.2 50.1 18 2 0 1 1 0 5.9 4.1 5.5 7.2 3.5 6.4 5.5 8.4 6.2 6.3 5.7 5.8 4.8 7.4 6.9 8.2 58.1 19 2 1 1 1 0 5.6 3.4 5.1 6.4 3.7 5.7 5.6 9.1 5.4 6.1 5.0 6.0 4.5 6.8 7.5 7.9 55.1 20 3 0 1 1 0 9.1 4.5 3.6 6.4 5.3 5.3 7.1 8.4 5.8 6.7 4.5 6.1 4.4 7.6 8.5 8.8 67.1 21 1 0 0 1 0 5.2 3.8 7.1 5.2 3.9 4.3 5.0 8.4 7.1 4.6 3.3 4.9 3.3 5.4 5.5 7.0 50.1 22 3 1 1 1 1 9.6 5.7 6.8 5.9 5.4 8.3 7.8 4.5 6.4 6.5 4.3 3.0 4.3 9.9 9.6 9.9 70.1 23 2 0 0 0 1 8.6 3.6 7.4 5.1 3.5 7.3 4.7 3.7 6.7 6.0 4.8 3.4 4.0 7.0 7.1 8.1 60.1 24 3 0 1 1 1 9.3 2.4 2.6 7.2 2.2 7.2 4.5 6.2 6.4 4.2 6.7 4.4 4.5 8.6 8.1 8.0 65.1 25 1 0 0 1 0 6.0 4.1 5.3 4.7 3.5 5.3 5.3 8.0 6.5 3.9 4.7 5.3 4.0 4.8 4.9 5.5 55.1 26 2 0 1 1 0 6.4 3.6 6.6 6.1 4.0 3.9 5.3 7.1 6.1 3.7 5.6 6.6 3.9 6.6 6.8 7.0 58.1 27 3 0 0 0 0 8.5 3.0 7.2 5.8 4.1 7.6 3.7 4.8 6.9 6.7 5.3 3.8 4.4 6.3 7.1 7.0 70.1 28 1 1 0 1 0 7.0 3.3 5.4 5.5 2.6 4.8 4.2 9.0 6.5 5.9 4.3 5.2 3.7 5.4 5.5 5.6 55.1 29 3 0 0 0 0 8.5 3.0 5.7 6.0 2.3 7.6 3.7 4.8 5.8 6.0 5.7 3.8 4.4 6.3 6.9 7.2 70.1 30 1 1 1 1 0 7.6 3.6 3.0 4.0 5.1 4.2 4.6 7.7 4.9 7.2 4.7 5.5 3.5 5.4 5.5 6.2 52.1 31 1 1 0 0 1 6.9 3.4 8.5 4.3 4.5 6.4 4.7 5.2 7.7 3.3 3.7 2.7 3.3 6.1 6.8 7.1 44.1 32 1 0 1 1 0 8.1 2.5 7.2 4.5 2.3 5.1 3.8 6.6 6.8 6.1 3.0 3.5 3.0 6.4 5.8 6.2 51.1 33 1 1 1 1 0 6.7 3.7 6.5 5.3 5.3 5.1 4.9 9.2 5.7 4.2 3.5 4.5 3.4 5.4 6.5 7.6 44.1 34 2 1 1 1 0 8.0 3.3 6.1 5.7 5.5 4.6 4.7 8.7 5.9 3.8 4.7 6.6 4.2 7.3 7.5 9.0 62.1 35 1 0 1 1 0 6.7 4.0 5.2 3.9 3.0 5.4 6.8 8.4 6.2 6.0 2.5 4.3 3.5 6.3 6.6 6.7 54.1 36 1 0 0 0 0 8.7 3.2 6.1 4.3 3.5 6.1 2.9 5.6 6.1 6.5 3.1 2.9 2.5 5.4 4.6 7.1 51.1 37 2 0 0 0 1 9.0 3.4 5.9 4.6 3.9 6.0 4.5 6.8 6.4 4.3 3.9 3.5 3.5 7.1 8.0 7.2 57.1 38 3 0 1 1 1 9.6 4.1 6.2 7.3 2.9 7.7 5.5 7.7 6.1 4.4 5.2 4.6 4.9 8.7 9.9 9.9 77.1 39 2 1 1 1 0 8.2 3.6 3.9 6.2 5.8 4.9 5.0 9.0 5.2 7.1 4.7 6.9 4.5 7.6 6.9 7.6 65.1 40 1 0 0 1 0 6.1 4.9 3.0 4.8 5.1 3.9 6.4 8.2 5.1 6.8 4.5 4.9 3.2 6.0 5.5 5.8 53.1 41 2 1 1 1 0 8.3 3.4 3.3 5.5 3.1 4.6 5.2 9.1 4.1 1.7 4.6 5.8 3.9 7.0 7.5 8.4 61.1 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output 42 2 1 0 0 1 9.4 3.8 4.7 5.4 3.8 6.5 4.9 8.5 4.9 6.2 4.1 4.5 4.1 7.6 8.0 7.9 61.1 43 3 0 1 0 1 9.3 5.1 4.6 6.8 5.8 6.6 6.3 7.4 5.1 4.1 4.6 4.6 4.3 8.9 7.8 7.6 72.1 44 2 1 1 1 1 5.1 5.1 6.6 6.9 4.4 5.4 7.8 5.9 7.2 5.2 4.9 6.3 4.5 7.6 7.9 8.4 55.1 45 3 1 0 0 0 8.0 2.5 4.7 7.1 3.6 7.7 3.0 5.2 5.1 3.9 4.3 4.2 4.7 5.5 5.6 6.5 65.1 46 2 0 1 1 0 5.9 4.1 5.7 5.9 5.8 6.4 5.5 8.4 6.4 5.1 5.2 5.8 4.8 7.4 8.6 7.7 58.1 47 3 1 0 0 1 10.0 4.3 7.1 6.3 2.9 5.4 4.5 3.8 6.7 3.7 5.0 4.0 3.5 7.1 8.8 8.0 67.1 48 2 1 1 1 0 5.7 3.8 6.8 7.5 5.7 5.7 6.0 8.2 6.6 4.8 6.5 7.3 5.2 7.6 7.6 7.1 60.1 49 3 0 0 1 1 9.9 3.7 3.7 6.1 4.2 7.0 6.7 6.8 5.9 7.2 4.5 3.4 3.9 8.7 8.1 8.5 67.1 50 3 1 1 0 1 7.9 3.9 4.3 5.8 4.4 6.9 5.8 4.7 5.2 3.6 4.1 4.2 4.3 8.6 7.8 7.6 61.1 51 1 0 1 1 0 6.7 3.6 5.9 4.2 3.4 4.7 4.8 7.2 5.7 5.3 4.0 3.6 2.8 5.4 7.5 7.2 48.1 52 3 1 0 0 0 8.2 2.7 3.7 7.4 2.7 7.9 3.1 5.3 5.3 5.0 4.5 4.3 4.9 5.7 7.1 8.2 67.1 53 3 0 1 1 1 9.4 2.5 4.8 6.1 3.2 7.3 4.6 6.3 6.3 9.2 4.7 4.6 4.6 8.7 9.0 9.0 66.1 54 1 1 0 0 1 6.9 3.4 5.7 4.4 3.3 6.4 4.7 5.2 6.4 4.4 3.2 2.7 3.3 6.1 7.0 7.2 44.1 55 2 1 1 1 0 8.0 3.3 3.8 5.8 3.2 4.6 4.7 8.7 5.3 4.2 4.9 6.6 4.2 7.3 8.1 8.1 62.1 56 3 1 0 0 0 9.3 3.8 7.3 5.7 3.7 6.4 5.5 7.4 6.6 5.9 4.1 3.2 3.4 7.7 7.6 8.9 59.1 57 2 0 1 1 1 7.4 5.1 4.8 7.7 4.5 7.2 6.9 9.6 6.4 7.4 5.7 6.5 5.5 9.0 7.9 8.8 74.1 58 3 1 0 0 0 7.6 3.6 5.2 5.8 5.6 6.6 5.4 4.4 6.7 6.4 4.6 3.9 4.0 8.2 7.5 7.5 58.1 59 3 1 0 0 0 10.0 4.3 5.3 3.7 4.2 5.4 4.5 3.8 6.7 4.5 3.7 4.0 3.5 7.1 6.5 7.0 67.1 60 3 1 1 1 0 9.9 2.8 7.2 6.9 2.6 5.8 3.5 5.4 6.2 7.0 5.6 4.9 4.0 7.9 8.5 8.5 61.1 61 3 0 0 0 0 8.7 3.2 8.4 6.1 2.8 7.8 3.8 4.9 7.2 4.5 5.4 3.9 4.5 6.6 6.9 7.2 71.1 62 2 0 1 1 1 8.4 3.8 6.7 5.0 4.5 4.7 5.9 6.7 5.1 4.2 2.7 5.0 3.6 8.0 7.6 8.8 63.1 63 1 0 0 0 1 8.8 3.9 3.8 5.1 4.3 4.7 4.8 5.8 5.0 7.2 4.4 3.7 2.9 6.3 5.5 8.0 44.1 64 1 0 1 1 0 7.7 2.2 6.3 4.5 2.4 4.7 3.4 6.2 6.0 4.7 3.3 3.1 2.6 6.0 6.0 8.1 47.1 65 1 0 1 1 0 6.6 3.6 5.8 4.1 4.9 4.7 4.8 7.2 6.5 3.9 3.5 3.6 2.8 5.4 6.9 7.1 48.1 66 2 1 1 1 0 5.7 3.8 3.5 6.7 5.4 5.7 6.0 8.2 5.4 5.0 4.7 7.3 5.2 7.6 6.9 9.0 60.1 67 2 1 0 1 0 5.7 4.0 7.9 6.4 2.7 5.5 5.1 6.2 7.5 6.4 5.0 6.2 4.5 6.4 5.6 6.2 50.1 68 2 1 0 1 1 5.5 3.7 4.7 5.4 4.3 5.3 4.9 6.0 5.6 2.5 4.5 5.9 4.3 6.1 6.3 8.2 48.1 69 1 1 1 1 0 7.5 3.5 3.8 3.5 2.9 4.1 4.5 7.6 5.1 5.2 4.0 5.4 3.4 5.2 5.8 5.8 51.1 70 2 0 1 1 0 6.4 3.6 2.7 5.3 3.9 3.9 5.3 7.1 5.2 5.5 4.7 6.6 3.9 6.6 6.6 8.0 58.1 71 3 0 0 1 0 9.1 4.5 6.1 5.9 6.3 5.3 7.1 8.4 7.1 5.7 5.4 6.1 4.4 7.6 7.5 7.7 67.1 72 1 1 0 0 1 6.7 3.2 3.0 3.7 4.8 6.3 4.5 5.0 5.2 2.5 2.9 2.6 3.1 5.8 6.0 7.0 43.1 73 2 0 1 1 0 6.5 4.3 2.7 6.6 6.5 6.3 6.0 8.7 4.7 6.3 4.6 5.6 4.6 7.9 6.6 7.9 66.1 74 3 0 1 1 1 9.9 3.7 7.5 4.7 5.6 7.0 6.7 6.8 7.2 4.6 4.1 3.4 3.9 8.6 8.8 9.8 66.1 75 2 0 1 1 1 8.5 3.9 5.3 5.5 5.0 4.9 6.0 6.8 5.7 3.6 4.4 5.1 3.7 8.2 7.0 8.4 65.1 76 3 0 0 0 0 9.9 3.0 6.8 5.0 5.4 5.9 4.8 4.9 7.3 7.6 3.1 4.3 3.8 7.1 6.6 8.9 63.1 77 1 0 0 1 1 7.6 3.6 7.6 4.6 4.7 4.6 5.0 7.4 8.1 6.6 4.5 5.8 3.9 6.4 6.9 7.5 49.1 78 2 1 0 0 1 9.4 3.8 7.0 6.2 4.7 6.5 4.9 8.5 7.3 2.4 4.3 4.5 4.1 7.6 7.3 8.0 61.1 79 3 0 0 0 1 9.3 3.5 6.3 7.6 5.5 7.5 5.9 4.6 6.6 3.1 5.2 4.1 4.6 8.9 7.3 8.1 72.1 80 1 1 1 1 0 7.1 3.4 4.9 4.1 4.0 5.0 5.9 7.8 6.1 3.5 2.6 3.1 2.7 5.7 5.8 7.6 44.1 81 3 0 1 0 0 9.9 3.0 7.4 4.8 4.0 5.9 4.8 4.9 5.9 6.9 3.2 4.3 3.8 7.1 7.9 8.8 63.1 82 3 0 0 0 0 8.7 3.2 6.4 4.9 2.4 6.8 4.6 6.8 6.3 5.1 4.3 3.7 4.0 7.4 7.3 8.0 68.1 83 2 0 0 0 1 8.6 2.9 5.8 3.9 2.9 5.6 4.0 6.3 6.1 4.0 2.7 3.0 3.0 6.6 6.1 8.5 53.1 84 1 1 0 1 0 6.4 3.2 6.7 3.6 2.2 2.9 5.0 8.4 7.3 6.5 2.0 3.7 1.6 5.0 5.1 6.5 37.1 85 2 0 0 0 1 7.7 2.6 6.7 6.6 1.9 7.2 4.3 5.9 6.5 4.1 4.7 3.9 4.3 8.2 7.5 7.7 52.1 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output 86 1 1 1 1 0 7.5 3.5 4.1 4.5 3.5 4.1 4.5 7.6 4.9 2.8 3.4 5.4 3.4 5.2 6.0 7.2 51.1 87 1 0 0 1 0 5.0 3.6 1.3 3.0 3.5 4.2 4.9 8.2 4.3 7.6 2.4 4.8 3.1 5.2 5.5 6.0 48.1 88 2 0 0 0 1 7.7 2.6 8.0 6.7 3.5 7.2 4.3 5.9 6.9 7.7 5.1 3.9 4.3 8.2 7.6 8.2 52.1 89 2 1 0 0 1 9.1 3.6 5.5 5.4 4.2 6.2 4.6 8.3 6.5 4.1 4.6 4.3 3.9 7.3 6.5 7.4 59.1 90 2 1 0 1 1 5.5 5.5 7.7 7.0 5.6 5.7 8.2 6.3 7.4 4.9 5.5 6.7 4.9 8.2 7.6 9.3 59.1 91 3 1 0 0 0 9.1 3.7 7.0 4.1 4.4 6.3 5.4 7.3 7.5 4.6 4.4 3.0 3.3 7.4 7.9 7.9 58.1 92 1 1 0 1 0 7.1 4.2 4.1 2.6 2.1 3.3 4.5 9.9 5.5 3.5 2.0 4.0 2.4 4.8 5.0 6.5 51.1 93 3 1 1 0 1 9.2 3.9 4.6 5.3 4.2 8.4 4.8 7.1 6.2 6.6 4.4 2.6 4.2 7.6 7.5 8.6 72.1 94 3 0 1 1 1 9.3 3.5 5.4 7.8 4.6 7.5 5.9 4.6 6.4 4.9 4.8 4.1 4.6 8.9 7.6 8.9 72.1 95 3 1 1 0 0 9.3 3.8 4.0 4.6 4.7 6.4 5.5 7.4 5.3 4.8 3.6 3.2 3.4 7.7 7.3 8.4 59.1 96 1 1 0 0 1 8.6 4.8 5.6 5.3 2.3 6.0 5.7 6.7 5.8 3.6 4.9 3.6 3.6 7.3 8.1 8.1 50.1 97 1 0 0 1 1 7.4 3.4 2.6 5.0 4.1 4.4 4.8 7.2 4.5 6.4 4.2 5.6 3.7 6.3 5.5 7.2 48.1 98 1 0 0 0 1 8.7 3.2 3.3 3.2 3.1 6.1 2.9 5.6 5.0 4.3 3.1 2.9 2.5 5.4 7.0 7.7 51.1 99 2 1 0 1 1 7.8 4.9 5.8 5.3 5.2 5.3 7.1 7.9 6.0 5.7 4.3 4.9 3.9 6.4 7.1 7.4 61.1 100 2 1 1 1 0 7.9 3.0 4.4 5.1 5.9 4.2 4.8 9.7 5.7 5.8 3.4 5.4 3.5 6.4 7.3 7.0 57.1 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output The SAS System The UNIVARIATE Procedure Variable: X6 (X6 - Product Quality) Moments N 100 Sum Weights 100 Mean 7.81 Sum Observations 781 Std Deviation 1.39627933 Variance 1.94959596 Skewness -0.2445019 Kurtosis -1.1318375 Uncorrected SS 6292.62 Coeff Variation 17.8780964 Corrected SS 193.01 Std Error Mean 0.13962793 Basic Statistical Measures Location Variability Mean 7.810000 Std Deviation 1.39628 Median 8.000000 Variance 1.94960 Mode 8.700000 Range 5.00000 Interquartile Range 2.55000 Note: The mode displayed is the smallest of 2 modes with a count of 6. Tests for Location: Mu0=0 Test Statistic Student's t t Sign M Signed Rank S p Value 55.93437 Pr > |t| = |M| = |S| D W-Sq A-Sq |t| = |M| = |S| D >0.1500 Cramer-von Mises W-Sq 0.089211 Pr > W-Sq 0.1523 Anderson-Darling A-Sq 0.529547 Pr > A-Sq 0.1696 Quantiles (Definition 5) Quantile HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] Estimate 100% Max 9.50 99% 9.50 95% 8.80 90% 8.70 75% Q3 7.60 50% Median 6.90 25% Q1 6.45 10% 6.10 5% 5.20 1% 5.00 0% Min 5.00 SAS Output Extreme Observations Lowest Stem 9 9 8 8 7 7 6 6 5 5 Highest Value X1 Obs Value X1 Obs 5.0 1 28 8.6 1 30 5.2 1 7 8.7 1 15 6.0 1 8 8.7 1 32 6.1 1 16 8.8 1 19 6.1 1 5 9.5 1 6 Leaf 5 # 1 Boxplot 0 6778 1 55667 0114 567777999 011444 4 1 5 4 9 6 02 ----+----+----+----+ 2 | | +-----+ | + | *-----* +-----+ | | Normal Probability Plot 9.75+ | | 8.25+ | | 6.75+ | | 5.25+ * ++ +++++ ** *+*++ *++++ ***** +**** ******* * **+***+ +++++ *++++* +----+----+----+----+----+----+----+----+----+----+ -2 -1 0 +1 +2 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output The SAS System The UNIVARIATE Procedure Variable: X6 (X6 - Product Quality) X1 - Customer Type=2 Moments N 35 Mean 7.24 Sum Weights 35 Sum Observations 253.4 Std Deviation 1.37203156 Variance 1.88247059 Skewness 0.01209312 Kurtosis -1.5552322 Uncorrected SS 1898.62 Coeff Variation 18.9507121 Corrected SS 64.004 Std Error Mean 0.23191566 Basic Statistical Measures Location Variability Mean 7.240000 Std Deviation 1.37203 Median 7.700000 Variance 1.88247 Mode 5.700000 Range 4.30000 Interquartile Range 2.70000 Tests for Location: Mu0=0 Test Statistic Student's t t Sign M Signed Rank S p Value 31.21825 Pr > |t| = |M| = |S| D 0.0199 Cramer-von Mises W-Sq 0.233492 Pr > W-Sq A-Sq |t| = |M| = |S| D 0.0157 Cramer-von Mises W-Sq 0.195472 Pr > W-Sq 0.0055 Anderson-Darling A-Sq 1.019777 Pr > A-Sq 0.0096 Quantiles (Definition 5) Quantile HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] Estimate 100% Max 5.60 99% 5.60 95% 4.90 90% 4.80 75% Q3 3.95 50% Median 3.60 25% Q1 3.30 10% 3.20 5% 2.50 1% 2.20 0% Min 2.20 SAS Output Extreme Observations Lowest Stem 5 5 4 4 3 3 2 2 Highest Value X1 Obs Value X1 Obs 2.2 1 20 4.5 1 4 2.5 1 12 4.8 1 30 2.8 1 2 4.9 1 5 3.2 1 32 4.9 1 16 3.2 1 26 5.6 1 6 Leaf 6 5899 012 55666667789 2222334444 58 2 ----+----+----+----+ # 1 Boxplot 0 4 3 11 10 2 1 | +-----+ *--+--* +-----+ | 0 Normal Probability Plot 5.75+ | | | | | | 2.25+ * +++++++ **+*+*++ ++***++ ********* ** ******* *+*++++ ++*++++ +----+----+----+----+----+----+----+----+----+----+ -2 -1 0 +1 +2 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output The SAS System The UNIVARIATE Procedure Variable: X7 (X7 - E-Commerce) X1 - Customer Type=2 Moments N 35 Mean 3.78 Sum Weights 35 Sum Observations 132.3 Std Deviation 0.65205557 Variance 0.42517647 Skewness 0.75034091 Kurtosis 0.9599249 Uncorrected SS Coeff Variation 514.55 17.2501474 Corrected SS 14.456 Std Error Mean 0.11021751 Basic Statistical Measures Location Variability Mean 3.780000 Std Deviation 0.65206 Median 3.700000 Variance 0.42518 Mode 3.600000 Range 2.90000 Interquartile Range 0.60000 Tests for Location: Mu0=0 Test Statistic Student's t t Sign M Signed Rank S p Value 34.29582 Pr > |t| = |M| = |S| D 0.0621 Cramer-von Mises W-Sq 0.165396 Pr > W-Sq 0.0151 Anderson-Darling A-Sq 0.947084 Pr > A-Sq 0.0161 Quantiles (Definition 5) Quantile HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] Estimate 100% Max 5.5 99% 5.5 95% 5.1 90% 4.9 75% Q3 4.0 50% Median 3.7 25% Q1 3.4 10% 3.0 5% 2.6 1% 2.6 0% Min 2.6 SAS Output Extreme Observations Lowest Highest Value X1 Obs Value X1 Obs 2.6 2 63 4.5 2 37 2.6 2 62 4.9 2 66 2.9 2 61 5.1 2 48 3.0 2 67 5.1 2 52 3.3 2 51 5.5 2 65 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output The SAS System The UNIVARIATE Procedure Variable: X7 (X7 - E-Commerce) X1 - Customer Type=2 Stem 54 52 50 48 46 44 42 40 38 36 34 32 30 28 26 Leaf 0 # 1 Boxplot 0 00 0 2 1 0 | | | | +-----+ | | *--+--* +-----+ | | | | 0 0 0000 0000000 0000000 0000 000 0 0 00 ----+----+----+----+ Multiply Stem.Leaf by 10**-1 1 1 4 7 7 4 3 1 1 2 Normal Probability Plot 5.5+ | | | | | | 4.1+ | | | | | | 2.7+ * + +++ * * +++ +++ * +++ +*+ +++* ++**** ***** ***** ****++ ***+++ * +++ +*++ * +*+ +----+----+----+----+----+----+----+----+----+----+ -2 -1 0 +1 +2 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output The SAS System The UNIVARIATE Procedure Variable: X7 (X7 - E-Commerce) X1 - Customer Type=3 Moments N 33 Sum Weights 33 Mean 3.55454545 Sum Observations Std Deviation 0.75170261 Variance 0.56505682 Skewness 0.78191588 Kurtosis 0.86858639 Corrected SS 18.0818182 Std Error Mean 0.13085463 Uncorrected SS 435.03 Coeff Variation 21.1476438 117.3 Basic Statistical Measures Location Variability Mean 3.554545 Std Deviation 0.75170 Median 3.500000 Variance 0.56506 Mode 3.000000 Range 3.30000 Interquartile Range 0.90000 Note: The mode displayed is the smallest of 2 modes with a count of 4. Tests for Location: Mu0=0 Test Statistic Student's t t Sign M Signed Rank S p Value 27.16408 Pr > |t| = |M| = |S| D >0.1500 Cramer-von Mises W-Sq 0.049979 Pr > W-Sq >0.2500 Anderson-Darling A-Sq 0.374365 Pr > A-Sq >0.2500 Quantiles (Definition 5) Quantile HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] Estimate 100% Max 5.7 99% 5.7 95% 5.1 90% 4.5 75% Q3 3.9 50% Median 3.5 25% Q1 3.0 10% 2.7 5% 2.5 SAS Output 1% 2.4 0% Min 2.4 Extreme Observations Lowest Highest Value X1 Obs Value X1 Obs 2.4 3 75 4.3 3 88 2.5 3 85 4.5 3 73 2.5 3 80 4.5 3 91 2.7 3 84 5.1 3 79 2.7 3 68 5.7 3 74 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output The SAS System The UNIVARIATE Procedure Variable: X7 (X7 - E-Commerce) X1 - Customer Type=3 Stem 5 5 4 4 3 3 2 2 Leaf 7 1 55 133 55677788999 000022224 55778 4 ----+----+----+----+ # 1 1 2 3 11 9 5 1 Boxplot 0 | | | +--+--+ +-----+ | | Normal Probability Plot 5.75+ | | | | | | 2.25+ * * ++++++ *+*+++++ ++*+**+ ********* *******+ *+***++ * *++++++ +----+----+----+----+----+----+----+----+----+----+ -2 -1 0 +1 +2 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output The SAS System The GLM Procedure Class Level Information Class X1 Levels 3 Values 123 Number of Observations Read 100 Number of Observations Used 100 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] SAS Output The SAS System The GLM Procedure Dependent Variable: X6 X6 - Product Quality Source DF Sum of Squares Mean Square F Value Pr > F Model 2 83.0775246 41.5387623 36.65 F 2 83.07752462 41.53876231 36.65 F 2 83.07752462 41.53876231 36.65 F 2 9.3543 4.6771 11.70 F 2 0.3095 0.1547 0.24 0.7855 97 62.0297 0.6395 Brown and Forsythe's Test for Homogeneity of X7 Variance ANOVA of Absolute Deviations from Group Medians Source X1 Error DF Sum of Squares Mean Square F Value Pr > F 2 0.2740 0.1370 0.60 0.5507 97 22.1396 0.2282 Bartlett's Test for Homogeneity of X7 Variance Source X1 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] DF Chi-Square Pr > ChiSq 2 0.6579 0.7197 SAS Output The SAS System The GLM Procedure X7 Level of X1 N Mean Std Dev 1 32 3.67500000 0.69976955 2 35 3.78000000 0.65205557 3 33 3.55454545 0.75170261 HBAT_Examine_Data_SAS_Output_Fa16.htm[9/26/2016 8:33:59 PM] *; *; * HBAT - Examining Your Data PROC Univariate; *; ods graphics on; *; options ls=80 ps=50 nodate pageno=1; *; * Input HBAT ; *; Data HBAT; Infile 'N:\BIA652D_Multivariate Data Analytics_2016_Fall\Class_04_Chap 2\HBAT_tabs.txt' DLM = '09'X TRUNCOVER; Input ID X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 X11 X12 X13 X14 X15 X16 X17 X18 X19 X20 X21 X22 X23; *; Data HBAT; Set HBAT (Keep = X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 X11 X12 X13 X14 X15 X16 X17 X18 X19 X20 X21 X22); Label X1 = 'X1 - Customer Type' X2 = 'X2 - Industry Type' X3 = 'X3 - Firm Size' X4 = 'X4 - Region' X5 = 'X5 - Distribution System' X6 = 'X6 - Product Quality' X7 = 'X7 - E-Commerce' X8 = 'X8 - Technical Support' X9 = 'X9 - Complaint Resolution' X10 = 'X10 - Advertizing' X11 = 'X11 - Product Line' X12 = 'X12 - Salesforce Image' X13 = 'X13 - Competitive Pricing' X14 = 'X14 - Warranty & Claims' X15 = 'X15 - New Products' X16 = 'X16 - Order & Billing' X17 = 'X17 - Price Flexibility' X18 = 'X18 - Delivery Speed' X19 = 'X19 - Customer Satisfaction' X20 = 'X20 - Likelihood of Recommending HBAT' X21 = 'X21 - Likelihood of Future Purchases from HBAT' X22 = 'X22 - Percentage of Purchases from HBAT'; *; Proc Print Data = HBAT; *; * Proc Univariate - All Metric Variables X6 - X22; *; * Only Var X6 X7 Illustrated ; *; Proc Univariate Data = HBAT Normal Plot; * Var X6 X7 X8 X9 X10 X11 X12 X13 X14 X15 X16 X17 X18 X19 X20 X21 X22; Var X6 X7; *; *; * Proc Univariate - By Nonmetric Variables X1-X5 for All Metric Variables X6 - X22; *; * Only Var X6 By X1 Illustrated ; *; Proc Sort Data = HBAT; By X1; *; Proc Univariate Data = HBAT Normal Plot; Var X6; By X1; ID X1; *; * Only Var X7 By X1 Illustrated ; *; Proc Sort Data = HBAT; By X1; *; Proc Univariate Data = HBAT Normal Plot; Var X7; By X1; ID X1; *; *; *; * GLM ANOVA Analysis ; *; * Only Var X6 By X1 Illustrated ; *; Proc GLM Data = HBAT; Class X1; Model X6 = X1; Means X1; Means X1 / hovtest = levene hovtest = bf hovtest = bartlett; *; *; * Only Var X7 By X1 Illustrated ; *; Proc GLM Data = HBAT; Class X1; Model X7 = X1; Means X1; Means X1 / hovtest = levene hovtest = bf hovtest = bartlett; *; *; *; * ods graphics off; *; *; Run; Quit; SAS Examining Your Data X8 X9 by X1_HW Due June 13th See the posted sample SAS Examining Your Data program, HBAT-tabs dataset, and SAS Examining Your Data output, for the analysis of X1-Customer Type along with X6-Product Quality and X7-E-Commerce. Now perform a similar exploratory data analysis using X1-Customer Type as the Class Independent predictor variable and X8- Technical Support and X9- Complaint Resolution as the Dependent response variables, including assessment of basic descriptive statistics, normality, variance analysis and homoscedasticity / heteroscedasticity, relevant plots, and ANOVA analysis. Provide a brief 3/4-1 page summary along with the program and output as an appendix. SAS Annotated Output Proc Univariate Below is an example of code used to investigate the distribution of a variable. We use the plots option on the proc univariate statement to produce the stem-and-leaf and normal probability plots shown at the bottom of the output. We will start by showing all of the unaltered output produced by this command, and then we will annotate each section. proc univariate data = "D:\hsb2" plots; var write; run; The UNIVARIATE Procedure Variable: write (writing score) Moments N 200 Sum Weights 200 Mean 52.775 Sum Observations 10555 Std Deviation 9.47858602 Variance 89.843593 Skewness -0.4820386 Kurtosis -0.7502476 Uncorrected SS 574919 Corrected SS 17878.875 Coeff Variation 17.9603714 Std Error Mean 0.67023725 Basic Statistical Measures Location Variability Mean 52.77500 Std Deviation 9.47859 Median 54.00000 Variance 89.84359 Mode 59.00000 Range 36.00000 Interquartile Range 14.50000 Tests for Location: Mu0=0 Test -Statistic-----p Value-----Student's t t 78.74077 Pr > |t| = |M| = |S| |t| Pr >= |M| Pr >= |S| t
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Content

Related Tags