Please solve this question ASAP. I will surely Upvote your Answer. THANKYOU!
please also provide exel codes when ever possible
B D E F H Student demonstrates a level of knowledge of: out of 10 16 Worldwide, micro-finance loans serve almost 20 million people living in poverty, 74% of these clients are 7 women. Data shows that women tend to make their payments more reliably than men, but more s importantly, a loan in the hands of a woman has a better chance to change not just her life, but also to 9 improve her children's opportunities and her community's prosperity. An organization studying these 10 types of loans collected data from 159 randomly selected women using micro-finance for their 11 manufacturing or agricultural businesses to look at the relationship between the average monthly 12 revenues (in $US) for the businesses run by these women and the number of employees (both part-and 13 full-time), the age of the business, the number of previous micro-finance loans, and whether the 14 businesses were primarily selling locally or exporting their products. These data are shown below. 15 16 17 a. Based on these data, estimate the average monthly revenue of a business 18 with 6 employees that is 7 years old, has had 2 previous micro-finance loans, 19 and sells its products locally. 20 21 b. interpret the coefficient for the Exortor Local Sales variable: 22 23 24 25. What are the null and alternate hypotheses that would be used to testif the modelis significant overall 26 (Express symbolically it possible) 27 28 HR Ha 29 30 31 d. What is the e-value that would be used for the hypothesis test corresponding to the 32 hypotheses in parto? 33 34 e. What are the null and alternate hypotheses that would be used to determine if there is a significant 35 relationship between average monthly revenues and whether the business sells locally or exports its 36 products? (Express symbolically if possible) 37 H 38 He 39 40 . What is the p-value that would be used for the hypothesis test corresponding to the 41 hypotheses in parte? 42 13 A B C D E G H 13 Age of Business Export or Local Sales 1 in 13 Export or Local Sales Codes: 0 - Local Sales 1 - Export 1 0 000 N previous loans 1 7 1 2 2 5 5 1 3 2 3 3 OOOOOO 1 10 4 o 0 1 8 10 7 00 00 2 2 4 5 0 0 0 2 1 1 o 988 EBS BRRRRRRR Average Monthly Number of 44 Business Revenue Employees 45 1 2793 10 46 2 1912 7 47 3 2663 9 48 4 2389 9 49 5 2517 9 50 6 2793 10 51 2542 9 52 8 2420 10 9 2500 9 54 10 2440 55 11 2351 12 2651 57 13 2584 58 14 2195 59 15 2565 16 2762 10 61 17 3325 13 62 18 2054 19 2526 64 20 2637 10 65 21 1959 66 22 2855 10 67 23 2255 8 68 24 2655 69 25 2490 10 70 26 2523 7 27 2236 72 28 2396 29 2371 10 74 30 2097 31 2167 76 32 2447 10 33 2407 10 78 34 2347 79 35 2663 80 36 2702 10 81 37 2555 10 82 38 2662 10 83 39 2838 10 34 40 2645 10 QE 11 BA READMED 2 + 1 1 11 No 1 6 2 2 1 1 Mo 0900 600 Wooo 0 6 0 0 0 N on oma oma 99.9999999999 7 10 2 2 5 2 OOOOO 73 2 2. 2 2 4 8 12 6 4 2 CHO 1 1 4 2 9 7 7 3 2 2 1 1 1 1 G F G 10 1 5 3 10 3 2 41 42 43 44 45 46 47 48 49 50 51 52 53 54 in mm NN N 1 2 2 5 10 2 10 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 5 10 10 3 3 5 2 omocouco Oceau 10 5 2 10 2642 2203 2456 2324 2148 2617 2435 2564 2611 2398 2805 2517 2249 2503 2516 2438 2570 2778 2175 2463 2778 2335 2391 2754 2610 2173 2296 2257 2481 2462 2467 2718 2891 2147 2598 2092 2257 2715 2556 2554 2534 2367 2686 2368 BB8BEBEEE o coooooooooooooooooooooooo 9.9999 2 3 3 NW NW WNNN 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 4 2 10 10 109 110 111 112 113 114 115 116 117 118 119 120 121 122 3 1 2 0 2 10 4 1 9 10 9 9 8 9 10 NwNNNNNN 2 5 5 2 2 2 4 3 3 2 123 OOOOOOOOOO 124 125 6 7 10 126 127 128 10 5 7 1 4 E 3 1 000 000 mm 2691 3054 25 2610 136 157 138 139 140 141 192 143 544 144 145 146 147 148 149 150 151 152 09999999999 NWNW NNNNNNWww OOOOOOOOOOOO 5 10 EST 9 8 9 O 154 155 155 157 158 159 160 151 162 363 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 125 2 1 1 5. www.no 1 0 3 2 2401 2673 2274 2653 2272 2552 2610 2533 2256 2684 2263 D 9.99 3 1 0 1 0 0 1 165 166 167 168 5 1 1 O 0 0 O S 7 9 22 2 170 173 372 o 2 D READ ME Qu. 1 Qu. 2 Qu. Qu4 Qu A E 129 F 1 10 E 1 2 2 130 2 OO 10 1 1 5 1 173 174 175 176 177 178 179 180 181 182 183 184 185 131 132 133 134 135 136 137 138 139 140 141 142 10 10 10 1 10 3 0 11 1 0 10 3 186 B 2714 2410 2303 2615 2585 2028 2065 2671 2141 2403 3148 2178 2522 2204 2498 2705 2410 2661 2440 2342 2504 3059 2578 2500 2836 2560 2503 2788 2618 2022 2239 5 143 Ooo cooooooooooooooo 0 0 O oooo oo ooooo 144 10 PPW Tww 1 10 2 0 10 1 0 0 10 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 2 5 o 12 1 + 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 0 10 10 1 3 4 0 1 o 0 10 1 1 2 3 OO
