🔹 Different Conditions ke According Result Analysis kya hai?

Iska matlab hai different situations ya conditions ke basis par result ko calculate aur compare karna.

Simple words mein:

Agar input values ya conditions change ho jayein, to final result par kya effect padega — iska analysis karna Result Analysis kehlata hai.

Excel mein iska use mainly What-If Analysis, Scenarios, formulas aur data analysis ke through kiya jata hai.

1. Simple Example

Maan lijiye ek business ki sales aur expenses alag-alag situations mein change hote hain.

Formula:

Profit = Sales - Expenses

Yahan hum dekh sakte hain ki sales condition change hone par profit bhi change ho raha hai.

2. Result Analysis ka Purpose

Different conditions ke according result analysis ka purpose hota hai:

• 📊 Different results compare karna
• 🔍 Changes ka effect samajhna
• 💰 Financial planning karna
• 📈 Business performance analyze karna
• 🎯 Target achieve karne ki planning karna
• ⚠️ Risk aur possible outcomes samajhna
• 🧠 Better planning ke liye data use karna

3. Conditions kaise ho sakti hain?

Conditions business ya situation ke according different ho sakti hain.

Example:

Sales:

• Low Sales
• Normal Sales
• High Sales

Expenses:

• Low Expenses
• Normal Expenses
• High Expenses

Salary:

• Current Salary
• 10% Increase
• 20% Increase

Discount:

• 5%
• 10%
• 20%

4. Business Example

Suppose ek shop ka:

Sales = ₹2,00,000

Expenses = ₹1,50,000

Therefore:

Profit = Sales - Expenses

Result:

₹50,000 Profit

Ab agar expenses increase ho jayein:

Is analysis se clearly pata chalta hai ki expenses badhne par profit decrease ho raha hai.

5. Scenario Based Result Analysis

Excel ke Scenario Manager ka use karke different conditions ko compare kiya ja sakta hai.

Example:

Low Sales
Normal Sales
High Sales

Har scenario mein input values different hongi aur Excel final result ko calculate karega.

Example:

Low Sales → Profit ₹10,000
Normal Sales → Profit ₹30,000
High Sales → Profit ₹50,000

6. Goal Seek ke through Analysis

Kabhi-kabhi humein target result already pata hota hai aur hum find karna chahte hain ki us target ko achieve karne ke liye input value kya honi chahiye.

Example:

Target Profit:

₹50,000

Question:

₹50,000 profit achieve karne ke liye sales kitni honi chahiye?

Excel mein Goal Seek ka use karke required sales find ki ja sakti hai.

7. Data Table ke through Analysis

Data Table ka use bhi different input values ke against results compare karne ke liye kiya ja sakta hai.

Example:

Isse input aur output ke relationship ko easily analyze kiya ja sakta hai.

8. Practical Applications

💰 Financial Analysis

Income, expenses, profit aur savings ka analysis.

📈 Sales Analysis

Different sales targets ka result compare karna.

👨‍💼 Salary Analysis

Salary changes ka total payroll par effect.

🛒 Discount Analysis

Different discounts ke baad revenue/profit check karna.

🏢 Business Planning

Different business conditions mein expected results analyze karna.

📦 Inventory Planning

Demand change hone par stock requirements analyze karna.

9. Important Excel Tools

Different conditions ke according result analysis mein commonly ye tools use hote hain:

⭐ Exam Points

• Different conditions ke according result analysis ka matlab different inputs/situations ke effect ko final result par analyze karna hai.
• Ye What-If Analysis ka important concept hai.
• Scenario Manager multiple situations compare karne ke liye use hota hai.
• Goal Seek target result ke liye required input find karta hai.
• Data Table different input values ke corresponding results compare karta hai.
• Business, finance, sales aur planning mein iska practical use hota hai.