Category: Data Analysis
-
DCOUNT Function in Excel
DCOUNT Function in Excel Purpose:DCOUNT counts the number of numeric values in a column (field) of a database that meet specific criteria. Syntax: Sample Real-World Dataset (Employee Sales Data) Use this dataset in Excel (Range: A1:F16) EmpID Name Department City Salary Sales 101 Amit Sales Delhi 45000 120 102 Neha HR Mumbai 38000 0 103
-
Excel Functions for Data Analytics 2026
Here is the compiled list categorized by analytical purpose: 1. Database Functions (D-Functions)Specifically designed for statistical analysis of structured tables/databases . 2. Lookup & Reference FunctionsEssential for scenario analysis and dynamic data retrieval . 3. Statistical & Aggregation FunctionsCore descriptive statistics and conditional math . 4. Logical FunctionsConditional branching and error handling . 5. Text & String Manipulation FunctionsData
-
ML projects Ideas
Solid ideas that make students pay attention. 1. “FoodFresh” – Predict Whether Vegetables Are Fresh or Spoiled (Image ML) Why it works Food is universal. Students instantly get it — no deep theory needed. Core idea Use a tiny image dataset (fresh vs spoiled tomatoes, potatoes, apples).Train a small CNN (or MobileNet) to classify fresh
-
IN NLP – NER
Named Entity Recognition (NER): This is a subtask of information extraction that involves locating and classifying named entities in unstructured text into predefined categories. Examples of categories: Person names, organizations, locations, dates, quantities, and monetary values. How it works: NER systems are trained to recognize these entities and sort them into a helpful classification system. Applications: It helps businesses