Problem $1$: Conduct a Pareto analysis for the number of minutes that flights are late in the Atlanta Airline Data Excel file.

Interpret the results $(10$ pts $).$

Problem $2$: Use Excel's filtering capability in the Purchase Orders Excel file to extract:

a$.$ all orders for control panels $(5$ pts $).$

b$.$ all orders for quantities of less than $500$ units $(5$ pts $).$

c$.$ all orders for control panels with quantities of less than $500$ units $(10$ pts $).$

Problem $3$: Modify the data in the Credit Risk Data Excel file using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $\backslash (\backslash$$ $250\backslash ),$ medium if at least $\backslash (\backslash$$ $250\backslash )$ but less than $\backslash (\backslash$$ $2000\backslash ),$ and high otherwise $(20$ pts$).$

Problem $4$: For the Bicycle Inventory Excel file, write a logical IF function that enters "Markdown" in column H if the purchase cost is less than $\backslash (\backslash$$ $100\backslash )$ and the selling price is at least $\backslash (\backslash$$ $125\backslash )$; if not, then enter a blank $(20$ pts$).$