FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use any statistical software to produce results QUESTION 1 The data is given in a attached file called HRSTA82_2020_Ass1_Q4_Data (Beer.sav ). The dataset was created

Use any statistical software to produce results

QUESTION 1

The data is given in a attached file called HRSTA82_2020_Ass1_Q4_Data (Beer.sav ). The dataset was created by Karl Wuensch. We would like to

find the indicators that influence customers when purchasing beer. Two hundred customers from two cities were asked to rate on a scale of 0 - 100 how important each considers each of seven qualities when deciding whether or not to buy the six pack:

  • low COST of the six pack
  • high SIZE of the bottle (volume)
  • high percentage of ALCOHOL in the beer
  • the REPUTATion of the brand
  • the COLOR of the beer
  • nice AROMA of the beer
  • and good TASTE of the beer
  • SES is socioeconomic status
  • Group determines the city
  • SES is socioeconomic status (higher values would equate with higher status) and group refers to either two cities A and B

(a) Do overall reliability testing of the instrument and comment.

(b) make a factor analysis of the data, label the factors and interpret it (give only the final output).

(c) Calculate the reliability of each factor and interpret it.

(d) Calculate the composite variable for each factor using the average and make a descriptive analysis of each composite variables using numerical techniques and graphical techniques.

(e) Interpret the descriptive statistics ensuring you comment on the centrality, dispersion and normality of the composite variable.

(f) Do comparative analysis by testing whether the mean of all the composite variables differ by : (i) Group and (ii) SES

(Ensure that you draw error bars, and for SES do posthoc analysis using Tukeys b if variances across group are equal or Games-Howell test if the homogeneity of variance assumption is violated. Note: If the assumption of homogeneity of variance is violated, then we use Welch robust test for equality of means)

??

image text in transcribed
Code COST SIZE ALCOHOL REPUTAT COLOR AROMA TASTE SES 1 90.00 80.00 70.00 20.00 50.0 70.0 60.00 2 75.00 95.00 100.00 50.00 55.0 40.0 65.00 3 10.00 15.00 20.00 85.00 40.0 30.0 50.00 4 100.00 70.00 50.00 30.00 75.0 60.0 80.00 5 20.00 10.00 25.00 35.00 30.0 35.0 45.00 6 50.00 100.00 100.00 30.00 90.0 75.0 100.00 7 5.00 15.00 15.00 75.00 20.0 10.0 25.00 8 65.00 30.00 35.00 80.00 80.0 60.0 90.00 9 95.00 95.00 100.00 0.00 80.0 70.0 95.00 10 85.00 80.00 70.00 40.00 60.0 50.0 65.00 11 0.00 0.00 20.00 30.00 80.0 90.0 100.00 12 10.00 25.00 10.00 100.00 50.0 40.0 60.00 13 80.00 70.00 50.00 50.00 40.0 20.0 50.00 14 25.00 35.00 30.00 40.00 45.0 30.0 65.00 15 5.00 10.00 15.00 65.00 50.0 65.0 85.00 16 20.00 5.00 10.00 40.00 60.0 50.0 95.00 17 70.00 60.00 70.00 75.00 10.0 15.0 25.00 18 50.00 15.00 20.00 50.00 10.0 5.0 50.00 19 75.00 50.00 95.00 40.00 0.0 0.0 40.00 20 15.00 10.00 25.00 30.00 95.0 80.0 100.00 21 80.00 90.00 100.00 50.00 20.0 #NULL! 40.00 22 90.00 80.00 70.00 20.00 50.0 70.0 60.00 23 75.00 95.00 100.00 50.00 55.0 40.0 65.00 24 10.00 15.00 20.00 85.00 40.0 30.0 50.00 25 100.00 70.00 50.00 30.00 75.0 60.0 80.00 26 20.00 10.00 25.00 35.00 30.0 35.0 45.00 27 50.00 100.00 100.00 30.00 90.0 75.0 100.00 28 5.00 15.00 15.00 75.00 20.0 10.0 25.00 29 65.00 30.00 35.00 80.00 80.0 60.0 90.00 30 95.00 95.00 100.00 0.00 80.0 70.0 95.00 31 85.00 80.00 70.00 40.00 60.0 50.0 65.00 32 0.00 0.00 20.00 30.00 80.0 90.0 100.00 33 10.00 25.00 10.00 100.00 50.0 40.0 60.00 34 80.00 70.00 50.00 50.00 40.0 20.0 50.00 35 25.00 35.00 30.00 40.00 45.0 30.0 65.00 36 5.00 10.00 15.00 65.00 50.0 65.0 85.00 37 20.00 5.00 10.00 40.00 60.0 50.0 95.00 38 70.00 60.00 70.00 75.00 10.0 15.0 25.00 39 50.00 15.00 20.00 50.00 10.0 5.0 50.00 40 75.00 50.00 95.00 40.00 0.0 0.0 40.00 41 15.00 10.00 25.00 30.00 95.0 80.0 100.00 42 80.00 90.00 100.00 50.00 20.0 #NULL! 40.00 43 90.00 80.00 70.00 20.00 50.0 70.0 60.00 44 75.00 95.00 100.00 50.00 55.0 40.0 65.00 Group 2 1 4 3 4 3 2 6 2 2 8 5 1 3 7 7 0 2 0 8 0 2 1 4 3 4 3 2 6 2 2 8 5 1 3 7 7 0 2 0 8 0 2 1 1 1 2 2 1 1 1 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 1 2 2 1 1 1 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 1 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 10.00 100.00 20.00 50.00 5.00 65.00 95.00 85.00 0.00 10.00 80.00 25.00 5.00 20.00 70.00 50.00 75.00 15.00 80.00 90.00 75.00 10.00 100.00 20.00 50.00 5.00 65.00 95.00 85.00 0.00 10.00 80.00 25.00 5.00 20.00 70.00 50.00 75.00 15.00 80.00 90.00 75.00 10.00 100.00 20.00 15.00 70.00 10.00 100.00 15.00 30.00 95.00 80.00 0.00 25.00 70.00 35.00 10.00 5.00 60.00 15.00 50.00 10.00 90.00 80.00 95.00 15.00 70.00 10.00 100.00 15.00 30.00 95.00 80.00 0.00 25.00 70.00 35.00 10.00 5.00 60.00 15.00 50.00 10.00 90.00 80.00 95.00 15.00 70.00 10.00 20.00 50.00 25.00 100.00 15.00 35.00 100.00 70.00 20.00 10.00 50.00 30.00 15.00 10.00 70.00 20.00 95.00 25.00 100.00 70.00 100.00 20.00 50.00 25.00 100.00 15.00 35.00 100.00 70.00 20.00 10.00 50.00 30.00 15.00 10.00 70.00 20.00 95.00 25.00 100.00 70.00 100.00 20.00 50.00 25.00 85.00 30.00 35.00 30.00 75.00 80.00 0.00 40.00 30.00 100.00 50.00 40.00 65.00 40.00 75.00 50.00 40.00 30.00 50.00 20.00 50.00 85.00 30.00 35.00 30.00 75.00 80.00 0.00 40.00 30.00 100.00 50.00 40.00 65.00 40.00 75.00 50.00 40.00 30.00 50.00 20.00 50.00 85.00 30.00 35.00 40.0 75.0 30.0 90.0 20.0 80.0 80.0 60.0 80.0 50.0 40.0 45.0 50.0 60.0 10.0 10.0 0.0 95.0 20.0 50.0 55.0 40.0 75.0 30.0 90.0 20.0 80.0 80.0 60.0 80.0 50.0 40.0 45.0 50.0 60.0 10.0 10.0 0.0 95.0 20.0 50.0 55.0 40.0 75.0 30.0 30.0 60.0 35.0 75.0 10.0 60.0 70.0 50.0 90.0 40.0 20.0 30.0 65.0 50.0 15.0 5.0 0.0 80.0 #NULL! 70.0 40.0 30.0 60.0 35.0 75.0 10.0 60.0 70.0 50.0 90.0 40.0 20.0 30.0 65.0 50.0 15.0 5.0 0.0 80.0 #NULL! 70.0 40.0 30.0 60.0 35.0 50.00 80.00 45.00 100.00 25.00 90.00 95.00 65.00 100.00 60.00 50.00 65.00 85.00 95.00 25.00 50.00 40.00 100.00 40.00 60.00 65.00 50.00 80.00 45.00 100.00 25.00 90.00 95.00 65.00 100.00 60.00 50.00 65.00 85.00 95.00 25.00 50.00 40.00 100.00 40.00 60.00 65.00 50.00 80.00 45.00 4 3 4 3 2 6 2 2 8 5 1 3 7 7 0 2 0 8 0 2 1 4 3 4 3 2 6 2 2 8 5 1 3 7 7 0 2 0 8 0 2 1 4 3 4 2 2 1 1 1 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 1 2 2 1 1 1 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 1 2 2 1 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 50.00 5.00 65.00 95.00 85.00 0.00 10.00 80.00 25.00 5.00 20.00 70.00 50.00 75.00 15.00 80.00 90.00 75.00 10.00 100.00 20.00 50.00 5.00 65.00 95.00 85.00 0.00 10.00 80.00 25.00 5.00 20.00 70.00 50.00 75.00 15.00 80.00 90.00 75.00 10.00 100.00 20.00 50.00 5.00 65.00 100.00 15.00 30.00 95.00 80.00 0.00 25.00 70.00 35.00 10.00 5.00 60.00 15.00 50.00 10.00 90.00 80.00 95.00 15.00 70.00 10.00 100.00 15.00 30.00 95.00 80.00 0.00 25.00 70.00 35.00 10.00 5.00 60.00 15.00 50.00 10.00 90.00 80.00 95.00 15.00 70.00 10.00 100.00 15.00 30.00 100.00 15.00 35.00 100.00 70.00 20.00 10.00 50.00 30.00 15.00 10.00 70.00 20.00 95.00 25.00 100.00 70.00 100.00 20.00 50.00 25.00 100.00 15.00 35.00 100.00 70.00 20.00 10.00 50.00 30.00 15.00 10.00 70.00 20.00 95.00 25.00 100.00 70.00 100.00 20.00 50.00 25.00 100.00 15.00 35.00 30.00 75.00 80.00 0.00 40.00 30.00 100.00 50.00 40.00 65.00 40.00 75.00 50.00 40.00 30.00 50.00 20.00 50.00 85.00 30.00 35.00 30.00 75.00 80.00 0.00 40.00 30.00 100.00 50.00 40.00 65.00 40.00 75.00 50.00 40.00 30.00 50.00 20.00 50.00 85.00 30.00 35.00 30.00 75.00 80.00 90.0 20.0 80.0 80.0 60.0 80.0 50.0 40.0 45.0 50.0 60.0 10.0 10.0 0.0 95.0 20.0 50.0 55.0 40.0 75.0 30.0 90.0 20.0 80.0 80.0 60.0 80.0 50.0 40.0 45.0 50.0 60.0 10.0 10.0 0.0 95.0 20.0 50.0 55.0 40.0 75.0 30.0 90.0 20.0 80.0 75.0 10.0 60.0 70.0 50.0 90.0 40.0 20.0 30.0 65.0 50.0 15.0 5.0 0.0 80.0 #NULL! 70.0 40.0 30.0 60.0 35.0 75.0 10.0 60.0 70.0 50.0 90.0 40.0 20.0 30.0 65.0 50.0 15.0 5.0 0.0 80.0 #NULL! 70.0 40.0 30.0 60.0 35.0 75.0 10.0 60.0 100.00 25.00 90.00 95.00 65.00 100.00 60.00 50.00 65.00 85.00 95.00 25.00 50.00 40.00 100.00 40.00 60.00 65.00 50.00 80.00 45.00 100.00 25.00 90.00 95.00 65.00 100.00 60.00 50.00 65.00 85.00 95.00 25.00 50.00 40.00 100.00 40.00 60.00 65.00 50.00 80.00 45.00 100.00 25.00 90.00 3 2 6 2 2 8 5 1 3 7 7 0 2 0 8 0 2 1 4 3 4 3 2 6 2 2 8 5 1 3 7 7 0 2 0 8 0 2 1 4 3 4 3 2 6 1 1 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 1 2 2 1 1 1 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 1 2 2 1 1 1 2 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 95.00 85.00 0.00 10.00 80.00 25.00 5.00 20.00 70.00 50.00 75.00 15.00 80.00 90.00 75.00 10.00 100.00 20.00 50.00 5.00 65.00 95.00 85.00 0.00 10.00 80.00 25.00 5.00 20.00 70.00 50.00 75.00 15.00 80.00 90.00 75.00 10.00 100.00 20.00 50.00 5.00 65.00 95.00 85.00 0.00 95.00 80.00 0.00 25.00 70.00 35.00 10.00 5.00 60.00 15.00 50.00 10.00 90.00 80.00 95.00 15.00 70.00 10.00 100.00 15.00 30.00 95.00 80.00 0.00 25.00 70.00 35.00 10.00 5.00 60.00 15.00 50.00 10.00 90.00 80.00 95.00 15.00 70.00 10.00 100.00 15.00 30.00 95.00 80.00 0.00 100.00 70.00 20.00 10.00 50.00 30.00 15.00 10.00 70.00 20.00 95.00 25.00 100.00 70.00 100.00 20.00 50.00 25.00 100.00 15.00 35.00 100.00 70.00 20.00 10.00 50.00 30.00 15.00 10.00 70.00 20.00 95.00 25.00 100.00 70.00 100.00 20.00 50.00 25.00 100.00 15.00 35.00 100.00 70.00 20.00 0.00 40.00 30.00 100.00 50.00 40.00 65.00 40.00 75.00 50.00 40.00 30.00 50.00 20.00 50.00 85.00 30.00 35.00 30.00 75.00 80.00 0.00 40.00 30.00 100.00 50.00 40.00 65.00 40.00 75.00 50.00 40.00 30.00 50.00 20.00 50.00 85.00 30.00 35.00 30.00 75.00 80.00 0.00 40.00 30.00 80.0 60.0 80.0 50.0 40.0 45.0 50.0 60.0 10.0 10.0 0.0 95.0 20.0 50.0 55.0 40.0 75.0 30.0 90.0 20.0 80.0 80.0 60.0 80.0 50.0 40.0 45.0 50.0 60.0 10.0 10.0 0.0 95.0 20.0 50.0 55.0 40.0 75.0 30.0 90.0 20.0 80.0 80.0 60.0 80.0 70.0 50.0 90.0 40.0 20.0 30.0 65.0 50.0 15.0 5.0 0.0 80.0 #NULL! 70.0 40.0 30.0 60.0 35.0 75.0 10.0 60.0 70.0 50.0 90.0 40.0 20.0 30.0 65.0 50.0 15.0 5.0 0.0 80.0 #NULL! 70.0 40.0 30.0 60.0 35.0 75.0 10.0 60.0 70.0 50.0 90.0 95.00 65.00 100.00 60.00 50.00 65.00 85.00 95.00 25.00 50.00 40.00 100.00 40.00 60.00 65.00 50.00 80.00 45.00 100.00 25.00 90.00 95.00 65.00 100.00 60.00 50.00 65.00 85.00 95.00 25.00 50.00 40.00 100.00 40.00 60.00 65.00 50.00 80.00 45.00 100.00 25.00 90.00 95.00 65.00 100.00 2 2 8 5 1 3 7 7 0 2 0 8 0 2 1 4 3 4 3 2 6 2 2 8 5 1 3 7 7 0 2 0 8 0 2 1 4 3 4 3 2 6 2 2 8 1 1 2 2 1 2 2 2 1 1 1 2 1 1 1 2 2 1 1 1 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 1 2 2 1 1 1 2 1 1 2 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 10.00 80.00 25.00 5.00 20.00 70.00 50.00 75.00 15.00 80.00 90.00 75.00 10.00 100.00 20.00 50.00 5.00 65.00 95.00 85.00 0.00 10.00 80.00 25.00 5.00 20.00 70.00 50.00 75.00 15.00 80.00 90.00 75.00 10.00 100.00 20.00 50.00 5.00 65.00 95.00 85.00 0.00 10.00 80.00 25.00 25.00 70.00 35.00 10.00 5.00 60.00 15.00 50.00 10.00 90.00 80.00 95.00 15.00 70.00 10.00 100.00 15.00 30.00 95.00 80.00 0.00 25.00 70.00 35.00 10.00 5.00 60.00 15.00 50.00 10.00 90.00 80.00 95.00 15.00 70.00 10.00 100.00 15.00 30.00 95.00 80.00 0.00 25.00 70.00 35.00 10.00 50.00 30.00 15.00 10.00 70.00 20.00 95.00 25.00 100.00 70.00 100.00 20.00 50.00 25.00 100.00 15.00 35.00 100.00 70.00 20.00 10.00 50.00 30.00 15.00 10.00 70.00 20.00 95.00 25.00 100.00 70.00 100.00 20.00 50.00 25.00 100.00 15.00 35.00 100.00 70.00 20.00 10.00 50.00 30.00 100.00 50.00 40.00 65.00 40.00 75.00 50.00 40.00 30.00 50.00 20.00 50.00 85.00 30.00 35.00 30.00 75.00 80.00 0.00 40.00 30.00 100.00 50.00 40.00 65.00 40.00 75.00 50.00 40.00 30.00 50.00 20.00 50.00 85.00 30.00 35.00 30.00 75.00 80.00 0.00 40.00 30.00 100.00 50.00 40.00 50.0 40.0 45.0 50.0 60.0 10.0 10.0 0.0 95.0 20.0 50.0 55.0 40.0 75.0 30.0 90.0 20.0 80.0 80.0 60.0 80.0 50.0 40.0 45.0 50.0 60.0 10.0 10.0 0.0 95.0 20.0 50.0 55.0 40.0 75.0 30.0 90.0 20.0 80.0 80.0 60.0 80.0 50.0 40.0 45.0 40.0 20.0 30.0 65.0 50.0 15.0 5.0 0.0 80.0 #NULL! 70.0 40.0 30.0 60.0 35.0 75.0 10.0 60.0 70.0 50.0 90.0 40.0 20.0 30.0 65.0 50.0 15.0 5.0 0.0 80.0 #NULL! 70.0 40.0 30.0 60.0 35.0 75.0 10.0 60.0 70.0 50.0 90.0 40.0 20.0 30.0 60.00 50.00 65.00 85.00 95.00 25.00 50.00 40.00 100.00 40.00 60.00 65.00 50.00 80.00 45.00 100.00 25.00 90.00 95.00 65.00 100.00 60.00 50.00 65.00 85.00 95.00 25.00 50.00 40.00 100.00 40.00 60.00 65.00 50.00 80.00 45.00 100.00 25.00 90.00 95.00 65.00 100.00 60.00 50.00 65.00 5 1 3 7 7 0 2 0 8 0 2 1 4 3 4 3 2 6 2 2 8 5 1 3 7 7 0 2 0 8 0 2 1 4 3 4 3 2 6 2 2 8 5 1 3 2 1 2 2 2 1 1 1 2 1 1 1 2 2 1 1 1 2 1 1 2 2 1 2 2 2 1 1 1 2 1 1 1 2 2 1 1 1 2 1 1 2 2 1 2 225 226 227 228 229 230 231 5.00 20.00 70.00 50.00 75.00 15.00 80.00 10.00 5.00 60.00 15.00 50.00 10.00 90.00 15.00 10.00 70.00 20.00 95.00 25.00 100.00 65.00 40.00 75.00 50.00 40.00 30.00 50.00 50.0 60.0 10.0 10.0 0.0 95.0 20.0 65.0 50.0 15.0 5.0 0.0 80.0 #NULL! 85.00 95.00 25.00 50.00 40.00 100.00 40.00 7 7 0 2 0 8 0 2 2 1 1 1 2 1

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

College Algebra

Authors: Margaret L. Lial, John Hornsby, David I. Schneider, Callie Daniels

12th edition

134697022, 9780134313795 , 978-0134697024

More Books

Students also viewed these Mathematics questions

Question

★★★★★
In 2016, Mandrake Motorcycles declared bankruptcy. Subsequently, it was determined that in fiscal 2015, the company produced more units than needed to fill pending orders. The result was a...

Answered: 1 week ago

Question

★★★★★
2. What advice do you have for Andersen about the use of the system for supervising, evaluating, and compensating his drivers and salespeople?

Answered: 1 week ago

Question

★★★★★
Effect of adjusting entries on the accounting equation Required Each of the following independent events requires a year-end adjusting entry. Show how each event and its related adjusting entry...

Answered: 1 week ago

Question

★★★★★
Please help me solve 6. (12 pts, 2 pts cach) The Graduate Record Exam (GRE) has a combined verbal and quantitative mean of 1000 and a standard deviation of 200. Scores range from 200 to 1600 and are...

Answered: 1 week ago

Question

★★★★★
On November 1,2010 , the comipany paid $2,000 in cash for a one-year insurance policy that ends on November 1, 2011. Record the adjusting entry on December 31, 2010. \begin{tabular}{|lc|} \hline...

Answered: 1 week ago

Question

★★★★★
3 4 5 6 7 In the World of Corporate Financial Analysis, one key concept that financial analyst need to develop and update at the end of every month when closing the book for the company is "Cost...

Answered: 1 week ago

Question

★★★★★
A group of researchers is interested in the effects of bullying throughout elementary school. They study first through sixth graders on the playground and note how many times each child is bullied by...

Answered: 1 week ago

Question

★★★★★
Factory Overhead Rate, Entry for Applying Factory Overhead, and Factory Overhead Account Balance The cost accountant for River Rock Beverage Co. estimated that total factory overhead cost for the...

Answered: 1 week ago

Question

★★★★★
Equivalent Units and Related Costs; Cost of Production Report; Entries Dover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the...

Answered: 1 week ago

Question

★★★★★
Account of: Ted Johnson (TJ02) - 2 Second Street, Byron Bay TRUST ACCOUNT LEDGER YOUR HOME REAL ESTATE PTY LTD Date (DD/MM/YYYY Description of matter (Type and Amount paid or received Receipt Number...

Answered: 1 week ago

Previous Question Next Question