Ict applications Assignment

Part 1: Excel Formulas – 30% (12 Unique Formulas)

Select a dataset from https://www.kaggle.com/ that includes numeric data suitable
for formula application. Use at least 12 unique Excel formulas to analyse the data.

You can visit Kaggle and browse through categories to select a dataset that you find most appropriate. Here are some direct links to get you started.

•  General Data Analysis Datasets
• Beginner-Friendly Datasets

• When searching for your dataset on Kaggle use the filter to find .xlsx files.

  Requirements

  • Create 12 Unique Excel Formulas.
  • Include a variety of functions such as statistical, logical, text, date/time, and lookup/reference formulas.
  • Provide a brief description of each formula’s purpose and how it contributes to your analysis.
  • The descriptions should be completed in the Excel document where you create your formulas and also discussed in your presentations.
  • Ensure each formula is correctly applied and that the results are clearly presented.