question help please

Excel File Edit View Insert Format Tools Data Window Help 16% Tue 10:57 AM Q AutoSave . OFF 1 Assignment1_Data Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X AA 2g Wrap Text v Insert v BI UV FY Delete v Paste Merge & Center v % 19 Conditional Format Cell Format v Sort & Find & deas Sensitivity Formatting as Table Styles Filter Select C1 X V fx THE CENTRE TESTS EXACTLY 20 DRIVERS IN ANY GIVEN WEEK A B C D K L M N P Q R S T U v W X Y Z AA Drivers THE CENTRE TESTS EXACTLY 20 DRIVERS IN ANY GIVEN WEEK 1 Week # Passed W N Problem3_Data Problem4_Data A Problem5_Data + - + 100% L 4 OCT 27i Excel File Edit View insert Format Tools Data Window Help 0 Am . {a} E (5 . i=3 Assignment'LDala Home Insert Draw Page. Layout Formulas Data Review View _ Tell me Lilv D11" THE CENTRE TESTS EXACTLY 20 DRIVERS IN ANY GIVEN WEEK Create a frequency chart (also known as the frequency distribution or the histogram) for the data. Does the chart resemble a Binomial distribution? Why or why not? How can one visually distinguish a Binomial distribution from other distributions (for example, a normal curve can be seen as being a symmetric smooth curve shaped like a bell)? Beyond visual inspection, what tests must be done to check for Binomial distribution? a. Please Note: You will need to repurpose & reorganize the data and develop appropriate intervals for creating the frequency distribution or the histogram. Make your own assumptions as to how you would divide the data into specific intervals and measure the frequencies. b. Marks distribution: i. Creation of frequency intervals and the frequency chart (3 points) ii. Visual interpretation of the frequency chart (resembles Binomial distribution or not) (2.5 points) iii. Calculation of expected frequencies (5 points) iv. Calculation of Chi-square values (critical and calculated Chi-Squares) and interpretation of results (2.5 points) Assuming a Ringwu distribu data (please note that this assum in may or