please assist in answering question 5 using the data below

B C D E F G H Random Num! Brand weight weight ( Yes=1, 0% disc 5% disc 10% disc 15% disc 20% disc 25% disc N 0.4463561 M 463 1 0 0 0 0.4109845 M 492 0.2151631 M 470 0.3822087 L 490.5 0.693369 M 473.5 0.7993945 M 453 0.8480528 510.5 0.2973575 497 10 0.9604609 M 488 11 0.0969486 -E 481 12 0.8492289 546.5 13 0.5265204 M 488.5 14 0.1172636 477 15 0.4208603 M 495.5 16 0.2511653 464.5 17 0820588 494.5 18 0.9557911 494 19 0.9268483 503.5 20 0.022233 494.5 21 0.7088609 M 475 22 0.1979563 M 495.5 23 0.313582 M 513.5 24 0.2196191 M 493 25 0.3876329 M 504.5 26 0.1793167 M 467.5 27 0.1106939 500 28 0.8492153 M 475 29 0.5618826 M 483.5 30 0.2904072 456.5 31 0.0136973 M 470.5 32 0.7763442 M 510.5 33 0.3317692 M 502 34 0.5319067 M 457 35 0.2146601 M 518 36 08421438 500 ooooooooooooooooooooooooooocom 37 03767304 M 490.5 38 0.3721431 528 39 0.3934535 M 502.5 40 0.2239655 M 512 41 0.6057091 479 OH OOH OH OH OOH OH OOHH HOOOOOOOOOOHOOOOOH HOOOOOHOOHHOOHOOONOOOOOHPOP NOOOOOONOONONE 42 0.9264108 M 495 43 0.6330331 M 441.5 44 0.9232249 M 177.5 45 0.3731925 M 464.5 46 0.1154295 M 483.5 47 0.2359457 M 453 48 0.268606 M 531.5 49 0.7740186 M 498.5 50 0.3881323 M 491 51 0461765 516 52 0.4447111 M 485 53 0.9163098 M 496 54 0.8103768 M 4645 55 0.0151198 565 56 0.1502833 538 57 0.6327291 M 475.5 58 0.8577971 L 500 59 0.5242345 527.5 60 0.2521685 M 495.5 61 0.720557 508.5 62 0.6851614 M 526 63 0.8488458 r 480.5 64 0.3287371 M 507 65 0.2600515 M 510.5 66 0.2902289 L 493.5 67 0.2314528 500 68 0.7179776 M 495.5 69 0.8370557 4975 70 08277847 495.5 71 0.2670881 490.5 72 0.2628151 460.5 73 0.5699799 486.5 74 0.0119642 M 488 75 0.176902 521.5 76 04084251 M 491.5 77 0.2647803 496.5 78 0.1082739 M 496 79 0.3180211 M 486.5 80 04011168 M 483 81 0.9887771 M 473_| |_ Section B: Intermediate level Analysis 5. Potential Demand for the new brand (brand N) A. Complete the following table Number of customers who Proportion of customers who said they will buy the new said they will buy the new product product B. Use Excel to: (i) construct a scatter plot of the discount offered and the proportion of customers who said that they will buy the new brand (brand N) if they are offered the stated discounts (ii) fit a \"least squares line\" on the graph (iii) display the equation of the least squares line (iv) display the value of R-squared Place your graph here C. Is there any relationship between discount offered and potential demand for brand N? If so, explain the type of relationship. Your answer should also include an interpretation of the output (Intercept, slope and R-squared}. Answer here D. What discount should be offered to customers if the producer of the new brand (brand N, wants to capture 25% of the existing market? Answer here/