There are more datas

fx . B D E 1 Amount Gender Brand image Price discount 2 225 3 4 342 392 375 5 475 7 125 8 558 358 Female Male Male Male Male Female Male Female Female Male Male Female Female Female Male Male 325 10 11 12 192 342 442 -1,057 0,476 0,038 0,695 2,009 -1,713 0,914 0,695 1,133 -1,057 0,476 1,352 0,257 1,571 -0,838 -0,838 1,352 0,695 -0,181 0,914 -1,276 0,914 Shopping style Often; what's on sale Biweekly; in bulk Biweekly; in bulk Biweekly; in bulk Often; what's on sale Weekly, similar items Weekly, similar items Often; what's on sale Often; what's on sale Biweekly; in bulk Biweekly; in bulk Often; what's on sale Weekly; similar items Often; what's on sale Biweekly; in bulk Often; what's on sale Weekly; similar items Weekly, similar items Weekly; similar items Weekly; similar items Often, what's on sale Often; what's on sale -1,327 -1,683 -0,792 -1,327 -1,327 1,346 0,633 -1,327 -0,436 -0,614 -0,258 -2,218 -0,970 -0,792 0,099 0,455 -0,436 -0,970 -1,505 -0,258 0,990 -2,218 13 14 15 442 492 242 16 17 225 18 308 Female Female 475 19 20 242 Female 21 592 125 22 Female Male Female 23 575 fx . B C D E 23 575 24 225 25 142 26 425 475 0,914 -0,838 -1,713 2,009 -0,181 0,257 1,790 27 28 275 29 442 30 0,038 31 225 492 292 375 32 Female Male Male Female Female Female Male Female Male Female Female Male Male Female Male Female Female Male Female 33 175 -2,218 1,346 1,346 -0,080 -0,970 0,990 -0,970 0,455 -0,258 0,811 -0,436 1,346 -1,683 0,099 0,633 -0,258 0,455 -0,436 -1,861 -0,792 -0,792 0,455 0,633 Often; what's on sale Biweekly; in bulk Weekly; similar items Weekly, similar items Often; what's on sale Weekly, similar items Biweekly; in bulk Weekly, similar items Biweekly; in bulk Biweekly; in bulk Biweekly; in bulk Weekly, similar items Biweekly; in bulk Often; what's on sale Often; what's on sale Weekly, similar items Biweekly; in bulk Often; what's on sale Weekly; similar items Biweekly; in bulk Weekly, similar items Biweekly; in bulk Biweekly; in bulk 35 225 36 408 37 408 0,695 -1,276 1,790 -1,276 0,476 -0,181 0,038 1,133 1,133 1,352 1,790 0,038 -0,619 0,914 0,914 38 358 39 342 492 40 41 392 42 392 Male 43 242 Male Female 44 375 45 425 Male fx A B O D E 46 242 Female Female 47 525 48 375 Female Male 49 575 50 392 -0,619 0,257 0,914 -0,619 0,038 0,914 0,038 -0,619 2,009 1,571 51 358 52 325 53 Male Male Female Female Female Female Male Male 208 54 592 55 408 56 275 -0,838 258 57 58 0,811 0,099 -0,258 -1,327 -0,080 -0,436 -1,505 2,237 -0,614 -0,436 -0,614 -0,080 -0,258 1,524 -1,683 -2,218 1,524 -2,218 1,346 -0,080 0,099 -0,614 0,633 Weekly, similar items Often; what's on sale Weekly, similar items Biweekly; in bulk Often; what's on sale Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Weekly; similar items Weekly, similar items Biweekly; in bulk Biweekly; in bulk Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Often; what's on sale Weekly, similar items Often; what's on sale Often; what's on sale Weekly; similar items Weekly, similar items -0,838 -0,619 -1,713 325 Male 59 125 Male 60 392 0,038 61 575 Male Male Female 62 358 63 325 Female 64 408 1,352 0,695 1,133 1,133 -0,838 1,571 0,038 1,133 65 Female Male Female 225 68 492 67 392 Female 68 475 Female fx A B D E 68 475 Female 1,133 69 492 70 175 71 208 72 442 2,009 -1,276 -0,838 0,257 -1,276 1,352 -0,181 73 175 74 275 75 325 542 Female Male Male Female Male Male Female Female Male Male Female Male Female Male Female 76 77 1,133 242 0,038 78 142 -1,276 79 242 0,633 -1,327 1,881 1,524 -1,149 0,990 -0,970 1,346 0,633 1,168 0,990 -1,327 0,990 -0,970 0,811 0,990 1,168 0,455 0,633 -0,436 1,346 -0,614 -2,040 Weekly, similar items Biweekly; in bulk Often; what's on sale Often; what's on sale Weekly, similar items Often; what's on sale Often; what's on sale Weekly; similar items Often; what's on sale Often; what's on sale Often; what's on sale Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Weekly; similar items Often; what's on sale Weekly; similar items Biweekly; in bulk Weekly; similar items Weekly, similar items Often; what's on sale Biweekly; in bulk 80 208 81 475 82 342 275 83 84 -0,838 -0,181 -0,181 -0,619 0,257 -0,619 0,038 -0,181 -0,400 -0,838 0,476 -0,838 275 Male Female 85 225 86 225 87 292 Male Female Female Male 88 275 558 89 90 492 Male fx . B D E 89 558 90 492 91 342 92 375 93 292 0,476 -0,838 -0,181 -0,619 -1,713 0,695 -0,400 0,914 -0,619 94 492 95 Male Male Female Female Male Male Female Female Female Female Male Female Male Male 625 96 375 97 242 98 525 99 175 100 242 -0,614 -2,040 -0,970 0,099 -0,080 -1,505 0,455 -0,436 1,168 -0,436 0,990 -2,040 0,277 -0,436 0,633 1,524 -0,258 -0,258 1,881 0,633 1,702 0,811 -1,505 Often; what's on sale Biweekly; in bulk Weekly; similar items Biweekly; in bulk Weekly; similar items Biweekly; in bulk Often; what's on sale Biweekly; in bulk Weekly, similar items Often; what's on sale Weekly; similar items Weekly; similar items Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Often; what's on sale Biweekly; in bulk Often, what's on sale Often; what's on sale Weekly, similar items Biweekly; in bulk Biweekly; in bulk 101 225 102 408 103 192 Female 104 142 105 -1,276 0,695 0,476 0,038 -0,838 -1,057 -0,181 0,476 -1,276 -0,181 -1,713 -1,057 -0,838 175 106 158 107 Male Male Male Female Male Female Female Male 175 108 225 109 192 110 192 111 492 fx A B 110 112 113 114 115 116 117 119 120 121 122 128 192 492 258 342 242 425 325 225 292 242 258 175 125 125 208 175 575 342 192 508 208 275 225 225 292 175 124 125 125 Female Male Female Female Male Female Male Male Female Female Male Male Male Male Female Female Female Female Female Female Female Female Female Female Female Female Male Male Male Female Male Male Female Female Male 127 128 -1,057 -0,838 -0,619 0,476 -1,057 0,695 0,914 0,257 -0,619 0,038 0,038 -1,057 -1,276 -1,057 -0,161 -1,713 2,009 0,476 -1,057 1,133 -0,619 -0,400 0,257 -1,495 -0,619 -1,275 -0,181 -0,181 0,476 -0,161 -0,838 2,666 -1,057 1,133 0,695 E Biweekly; in bulk Biweekly; in bulk Weekly, similar items Biweekly; in bulk Often; what's on sale Biweekly, in bulk Often; what's on sale often; what's on sale Often; what's on sale Often; what's on sale Often; what's on sale Weekly, similar items Weekly, similar items Often; what's on sale Often; what's on sale Often; what's on sale Biweekly; in bulk Biweekly; in bulk Weekly; similar items Often; what's on sale Often; what's on sale often; what's on sale Weekly; similar items Often; what's on sale Often; what's on sale often; what's on sale Biweekly, in bulk Weekly, similar items Biweekly; in bulk Often; what's on sale Biweekly; in bulk Biweekly; in bulk Often; what's on sale Often; what's on sale Biweekly: in bulk 0,811 -1,505 0,099 -1,327 0,099 -0,080 -0,436 0,811 -1,327 1,168 1,168 1,702 0,277 0,099 0,990 0,099 0,277 -0,614 1,346 0,277 0,633 1,168 0,811 0,811 -1,327 1,168 0,277 -0,258 -0,080 0,099 1,346 0,990 1,346 0,277 -0,080 129 150 151 132 133 134 155 155 308 137 188 159 140 275 425 158 158 625 192 505 392 141 142 143 fx B 144 145 145 392 405 225 125 392 292 147 149 150 175 151 405 152 342 153 192 158 154 155 442 155 375 157 225 475 158 159 325 160 161 256 208 592 Male Male Female Female Male Female Female Male Female Female Female Male Female Female Male Female Male Female Female Male Male Male Female Male Female Male Male Female Female Female Female Male Male Female Female 0,695 1,133 0,595 -1,495 0,695 -0,619 - 1,276 1,133 -0,619 1,790 -1,713 1,790 0,914 -0,838 2,009 0,038 -0,181 -0,619 2,009 0,257 -0,838 -1,057 1,571 -1,713 0,038 -1,057 -0,181 1,133 0,038 0,038 0,038 -0,838 1,352 -0,619 -0,400 -0,080 -0,436 1,168 1,346 -0,050 -1,327 0,990 -0,970 0,811 -1,327 0,990 -0,970 1,524 0,455 -1,327 -1,505 -0,614 2,237 -0,614 0,633 -0,614 -0,255 -0,436 -1,851 -1,327 0,099 -0,258 -0,436 0,277 -1,327 0,277 -1,327 0,990 0,099 -0,436 Biweekly; in bulk Biweekly; in bulk Often; what's on sale Biweekly; in bulk Biweekly; in bulk Biweekly; in bulk Often; what's on sale Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Biweekly; in bulk Weekly, similar items Weekly, similar items Biweekly, in bulk Often; what's on sale Biweekly; in bulk Often; what's on sale Often; what's on sale Biweekly; in bulk Weekly, similar items Biweekly; in bulk Weekly, similar items Biweekly; in bulk Often; what's on sale Biweekly; in bulk Weekly, similar items Often; what's on sale Biweekly; in bulk Weekly, similar items Weekly; similar items Often; what's on sale Biweekly; in bulk Biweekly; in bulk Often: what's on sale 162 165 475 164 275 165 166 167 175 405 125 168 325 258 169 170 275 171 542 173 174 175 306 325 325 305 608 375 508 176 177 178 c. Healthy Food Co. wants to evaluate their marketing strategy. Use the data on Healty Food Co.xlsx and prepare a report to Healthy Food Co. 1. You have to analyze the data using appropriate statistical tests. a. Use computers whenever you can b. Be careful you need to prepare some variables first c. Be careful you may need to change the way data is presented (e.g. change the columns to rows, sort data, and recode data (Based on how you are going to calculate, these actions may be needed. Different treatments are necessary for Calculator, Excel, and SPSS etc. 2. Prepare Tables to represent your findings. Use the below Tables as examples a. Tables must have numbers and titles b. Variable names must be clear c. Use three digits 3. Write your managerial report a. Use full sentences b. No bullets acceptable (they belong to presentations! Base your ideas on statistical findings d. Give reference to Tables (e.g. See Table 1, as can been from Table 3), when you are discussing the related findings e. Do not use generic sentences and names while discussing your answers (e.g. independent variable has affect... variables are related...) Give specific variable names. f. Include necessary numbers (e.g. means, statistics, p values... etc.) in your sentences even if you have reported in the Tables. Reader should be able to easily follow what you are discussing (e.g. product is preferred more compared to product (Ma=3.25; Mg=2.68; t=14.25; p=0.00)] g Base your decisions on sound reasons h. Use a=0.05 or -0.01 as necessary Cue: 1. Assume normal distribution for metric data. 2. When the population variation is not known t distribution should be used. 3. Test the effect of gender, brand image, price discount and interaction of brand image and price discount on amount spent. Test if amount spent changes with respect to shopping style. Test if amount spent changes with respect to gender. Test if there is some kind of association between gender and shopping styles. fx . B D E 1 Amount Gender Brand image Price discount 2 225 3 4 342 392 375 5 475 7 125 8 558 358 Female Male Male Male Male Female Male Female Female Male Male Female Female Female Male Male 325 10 11 12 192 342 442 -1,057 0,476 0,038 0,695 2,009 -1,713 0,914 0,695 1,133 -1,057 0,476 1,352 0,257 1,571 -0,838 -0,838 1,352 0,695 -0,181 0,914 -1,276 0,914 Shopping style Often; what's on sale Biweekly; in bulk Biweekly; in bulk Biweekly; in bulk Often; what's on sale Weekly, similar items Weekly, similar items Often; what's on sale Often; what's on sale Biweekly; in bulk Biweekly; in bulk Often; what's on sale Weekly; similar items Often; what's on sale Biweekly; in bulk Often; what's on sale Weekly; similar items Weekly, similar items Weekly; similar items Weekly; similar items Often, what's on sale Often; what's on sale -1,327 -1,683 -0,792 -1,327 -1,327 1,346 0,633 -1,327 -0,436 -0,614 -0,258 -2,218 -0,970 -0,792 0,099 0,455 -0,436 -0,970 -1,505 -0,258 0,990 -2,218 13 14 15 442 492 242 16 17 225 18 308 Female Female 475 19 20 242 Female 21 592 125 22 Female Male Female 23 575 fx . B C D E 23 575 24 225 25 142 26 425 475 0,914 -0,838 -1,713 2,009 -0,181 0,257 1,790 27 28 275 29 442 30 0,038 31 225 492 292 375 32 Female Male Male Female Female Female Male Female Male Female Female Male Male Female Male Female Female Male Female 33 175 -2,218 1,346 1,346 -0,080 -0,970 0,990 -0,970 0,455 -0,258 0,811 -0,436 1,346 -1,683 0,099 0,633 -0,258 0,455 -0,436 -1,861 -0,792 -0,792 0,455 0,633 Often; what's on sale Biweekly; in bulk Weekly; similar items Weekly, similar items Often; what's on sale Weekly, similar items Biweekly; in bulk Weekly, similar items Biweekly; in bulk Biweekly; in bulk Biweekly; in bulk Weekly, similar items Biweekly; in bulk Often; what's on sale Often; what's on sale Weekly, similar items Biweekly; in bulk Often; what's on sale Weekly; similar items Biweekly; in bulk Weekly, similar items Biweekly; in bulk Biweekly; in bulk 35 225 36 408 37 408 0,695 -1,276 1,790 -1,276 0,476 -0,181 0,038 1,133 1,133 1,352 1,790 0,038 -0,619 0,914 0,914 38 358 39 342 492 40 41 392 42 392 Male 43 242 Male Female 44 375 45 425 Male fx A B O D E 46 242 Female Female 47 525 48 375 Female Male 49 575 50 392 -0,619 0,257 0,914 -0,619 0,038 0,914 0,038 -0,619 2,009 1,571 51 358 52 325 53 Male Male Female Female Female Female Male Male 208 54 592 55 408 56 275 -0,838 258 57 58 0,811 0,099 -0,258 -1,327 -0,080 -0,436 -1,505 2,237 -0,614 -0,436 -0,614 -0,080 -0,258 1,524 -1,683 -2,218 1,524 -2,218 1,346 -0,080 0,099 -0,614 0,633 Weekly, similar items Often; what's on sale Weekly, similar items Biweekly; in bulk Often; what's on sale Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Weekly; similar items Weekly, similar items Biweekly; in bulk Biweekly; in bulk Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Often; what's on sale Weekly, similar items Often; what's on sale Often; what's on sale Weekly; similar items Weekly, similar items -0,838 -0,619 -1,713 325 Male 59 125 Male 60 392 0,038 61 575 Male Male Female 62 358 63 325 Female 64 408 1,352 0,695 1,133 1,133 -0,838 1,571 0,038 1,133 65 Female Male Female 225 68 492 67 392 Female 68 475 Female fx A B D E 68 475 Female 1,133 69 492 70 175 71 208 72 442 2,009 -1,276 -0,838 0,257 -1,276 1,352 -0,181 73 175 74 275 75 325 542 Female Male Male Female Male Male Female Female Male Male Female Male Female Male Female 76 77 1,133 242 0,038 78 142 -1,276 79 242 0,633 -1,327 1,881 1,524 -1,149 0,990 -0,970 1,346 0,633 1,168 0,990 -1,327 0,990 -0,970 0,811 0,990 1,168 0,455 0,633 -0,436 1,346 -0,614 -2,040 Weekly, similar items Biweekly; in bulk Often; what's on sale Often; what's on sale Weekly, similar items Often; what's on sale Often; what's on sale Weekly; similar items Often; what's on sale Often; what's on sale Often; what's on sale Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Weekly; similar items Often; what's on sale Weekly; similar items Biweekly; in bulk Weekly; similar items Weekly, similar items Often; what's on sale Biweekly; in bulk 80 208 81 475 82 342 275 83 84 -0,838 -0,181 -0,181 -0,619 0,257 -0,619 0,038 -0,181 -0,400 -0,838 0,476 -0,838 275 Male Female 85 225 86 225 87 292 Male Female Female Male 88 275 558 89 90 492 Male fx . B D E 89 558 90 492 91 342 92 375 93 292 0,476 -0,838 -0,181 -0,619 -1,713 0,695 -0,400 0,914 -0,619 94 492 95 Male Male Female Female Male Male Female Female Female Female Male Female Male Male 625 96 375 97 242 98 525 99 175 100 242 -0,614 -2,040 -0,970 0,099 -0,080 -1,505 0,455 -0,436 1,168 -0,436 0,990 -2,040 0,277 -0,436 0,633 1,524 -0,258 -0,258 1,881 0,633 1,702 0,811 -1,505 Often; what's on sale Biweekly; in bulk Weekly; similar items Biweekly; in bulk Weekly; similar items Biweekly; in bulk Often; what's on sale Biweekly; in bulk Weekly, similar items Often; what's on sale Weekly; similar items Weekly; similar items Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Often; what's on sale Biweekly; in bulk Often, what's on sale Often; what's on sale Weekly, similar items Biweekly; in bulk Biweekly; in bulk 101 225 102 408 103 192 Female 104 142 105 -1,276 0,695 0,476 0,038 -0,838 -1,057 -0,181 0,476 -1,276 -0,181 -1,713 -1,057 -0,838 175 106 158 107 Male Male Male Female Male Female Female Male 175 108 225 109 192 110 192 111 492 fx A B 110 112 113 114 115 116 117 119 120 121 122 128 192 492 258 342 242 425 325 225 292 242 258 175 125 125 208 175 575 342 192 508 208 275 225 225 292 175 124 125 125 Female Male Female Female Male Female Male Male Female Female Male Male Male Male Female Female Female Female Female Female Female Female Female Female Female Female Male Male Male Female Male Male Female Female Male 127 128 -1,057 -0,838 -0,619 0,476 -1,057 0,695 0,914 0,257 -0,619 0,038 0,038 -1,057 -1,276 -1,057 -0,161 -1,713 2,009 0,476 -1,057 1,133 -0,619 -0,400 0,257 -1,495 -0,619 -1,275 -0,181 -0,181 0,476 -0,161 -0,838 2,666 -1,057 1,133 0,695 E Biweekly; in bulk Biweekly; in bulk Weekly, similar items Biweekly; in bulk Often; what's on sale Biweekly, in bulk Often; what's on sale often; what's on sale Often; what's on sale Often; what's on sale Often; what's on sale Weekly, similar items Weekly, similar items Often; what's on sale Often; what's on sale Often; what's on sale Biweekly; in bulk Biweekly; in bulk Weekly; similar items Often; what's on sale Often; what's on sale often; what's on sale Weekly; similar items Often; what's on sale Often; what's on sale often; what's on sale Biweekly, in bulk Weekly, similar items Biweekly; in bulk Often; what's on sale Biweekly; in bulk Biweekly; in bulk Often; what's on sale Often; what's on sale Biweekly: in bulk 0,811 -1,505 0,099 -1,327 0,099 -0,080 -0,436 0,811 -1,327 1,168 1,168 1,702 0,277 0,099 0,990 0,099 0,277 -0,614 1,346 0,277 0,633 1,168 0,811 0,811 -1,327 1,168 0,277 -0,258 -0,080 0,099 1,346 0,990 1,346 0,277 -0,080 129 150 151 132 133 134 155 155 308 137 188 159 140 275 425 158 158 625 192 505 392 141 142 143 fx B 144 145 145 392 405 225 125 392 292 147 149 150 175 151 405 152 342 153 192 158 154 155 442 155 375 157 225 475 158 159 325 160 161 256 208 592 Male Male Female Female Male Female Female Male Female Female Female Male Female Female Male Female Male Female Female Male Male Male Female Male Female Male Male Female Female Female Female Male Male Female Female 0,695 1,133 0,595 -1,495 0,695 -0,619 - 1,276 1,133 -0,619 1,790 -1,713 1,790 0,914 -0,838 2,009 0,038 -0,181 -0,619 2,009 0,257 -0,838 -1,057 1,571 -1,713 0,038 -1,057 -0,181 1,133 0,038 0,038 0,038 -0,838 1,352 -0,619 -0,400 -0,080 -0,436 1,168 1,346 -0,050 -1,327 0,990 -0,970 0,811 -1,327 0,990 -0,970 1,524 0,455 -1,327 -1,505 -0,614 2,237 -0,614 0,633 -0,614 -0,255 -0,436 -1,851 -1,327 0,099 -0,258 -0,436 0,277 -1,327 0,277 -1,327 0,990 0,099 -0,436 Biweekly; in bulk Biweekly; in bulk Often; what's on sale Biweekly; in bulk Biweekly; in bulk Biweekly; in bulk Often; what's on sale Biweekly; in bulk Often; what's on sale Often; what's on sale Often; what's on sale Biweekly; in bulk Weekly, similar items Weekly, similar items Biweekly, in bulk Often; what's on sale Biweekly; in bulk Often; what's on sale Often; what's on sale Biweekly; in bulk Weekly, similar items Biweekly; in bulk Weekly, similar items Biweekly; in bulk Often; what's on sale Biweekly; in bulk Weekly, similar items Often; what's on sale Biweekly; in bulk Weekly, similar items Weekly; similar items Often; what's on sale Biweekly; in bulk Biweekly; in bulk Often: what's on sale 162 165 475 164 275 165 166 167 175 405 125 168 325 258 169 170 275 171 542 173 174 175 306 325 325 305 608 375 508 176 177 178 c. Healthy Food Co. wants to evaluate their marketing strategy. Use the data on Healty Food Co.xlsx and prepare a report to Healthy Food Co. 1. You have to analyze the data using appropriate statistical tests. a. Use computers whenever you can b. Be careful you need to prepare some variables first c. Be careful you may need to change the way data is presented (e.g. change the columns to rows, sort data, and recode data (Based on how you are going to calculate, these actions may be needed. Different treatments are necessary for Calculator, Excel, and SPSS etc. 2. Prepare Tables to represent your findings. Use the below Tables as examples a. Tables must have numbers and titles b. Variable names must be clear c. Use three digits 3. Write your managerial report a. Use full sentences b. No bullets acceptable (they belong to presentations! Base your ideas on statistical findings d. Give reference to Tables (e.g. See Table 1, as can been from Table 3), when you are discussing the related findings e. Do not use generic sentences and names while discussing your answers (e.g. independent variable has affect... variables are related...) Give specific variable names. f. Include necessary numbers (e.g. means, statistics, p values... etc.) in your sentences even if you have reported in the Tables. Reader should be able to easily follow what you are discussing (e.g. product is preferred more compared to product (Ma=3.25; Mg=2.68; t=14.25; p=0.00)] g Base your decisions on sound reasons h. Use a=0.05 or -0.01 as necessary Cue: 1. Assume normal distribution for metric data. 2. When the population variation is not known t distribution should be used. 3. Test the effect of gender, brand image, price discount and interaction of brand image and price discount on amount spent. Test if amount spent changes with respect to shopping style. Test if amount spent changes with respect to gender. Test if there is some kind of association between gender and shopping styles