Auditors for the Military Airlift Command (MAC) are checking the arrival times of the three charter airlines they used in the Pacific last year. Branflake Airways flew 135 flights and was late 78 times. Flying Armadillo Airlines flew 94 flights and was late 35 times. Air Idaho flew 115 flights, with 51 late arrivals. Construct a cross-tabulation table (that shows both column-percentages and observed frequencies) in Microsoft Word (or by hand) to represent these data

Make frequency tables for the following data sets. Include columns for relative and cumulative frequency. Also, make a bar graph for the frequency. A website that reviews recent movies lists 5 five-star films (the highest rating), 15 four-star films, 15 three-star films, 10 two-star films, and 5 one-star films.

Create a side-by-side boxplot for vitamin D level vs. NewAge and a side- by-side boxplot for vitamin D level vs. country. Create a scatterplot to show the relationship between vitamin D level and Age. Compare these two side-by-side boxplots and the scatterplot and explain your findings. • Note: Write appropriate captions for the tables, graphs, and outputs.

Calculate the difference between List Price and Sale Price for each condominium by creating a new column and use the Data Analysis Toolpak Descriptive Statistics for that new column for Gulf View. Gulf View Condominiums List Price Sale Price Days to Sell 478.0 474.0 133 394.0 329.0 85 537.0 532.0 82 542.5 543.5 91 353.9 314.9 132 553.0 506.0 74 143.9 168.0 197 201.0 224.0 59 962.0 919.0 91 317.0 324.0 117 328.0 291.0 95 883.0 823.0 277 965.0 1012.0 103 470.0 421.0 61 298.0 290.0 43 362.0 361.0 47 319.0 301.0 93 524.0 469.0 159 434.0 370.0 158 683.0 680.0 153 409.0 405.0 18 681.0 656.0 6 321.0 314.0 140 412.0 393.0 89 366.0 344.0 105 474.0 493.0 43 906.0 871.0 125 444.0 468.0 170 415.0 426.0 212 259.0 225.0 99 647.0 633.0 85 611.0 594.0 90 352.0 321.0 98 596.0 579.0 34 319.0 288.0 139 190.0 219.0 53 379.0 394.0 148 450.0 429.0 49 488.0 455.0 85 443.0 423.5 156