Does Siksha Sarovar have an AI chatbot to answer student doubts?

Yes. Siksha Sarovar has a built-in AI Assistant chatbot accessible from a floating button on every page. It understands English, Hindi and Hinglish, handles typos (for example 'pyhtion' or 'certifecate'), and indexes 165+ destinations including every course, lesson, BCA subject, school chapter, competitive exam topic, FAQ and tool. Most queries return direct link cards in under 5 milliseconds. An AI fallback is available for novel questions.

Can I ask the SikshaSarovar chatbot questions in Hindi or Hinglish?

Absolutely. The chatbot is built specifically for Indian students — natural Hinglish queries like 'kaise milega certificate', 'free hai kya', 'pyhtion ke datatype kaha hai', 'kaha se shuru karu' are first-class citizens. The matcher strips Hindi filler words and routes you to the right course, lesson or page.

Is the SikshaSarovar AI chatbot free to use?

Yes. The chatbot is 100% free, requires no signup, and is available on every page. It runs locally in your browser for the vast majority of queries — there is no API cost or usage limit. The optional 'Ask AI' fallback for advanced coding questions uses the Pro AI Tutor.

Is Siksha Sarovar really free?

Yes. Every course, lesson, quiz, online compiler, and notes download is free to use without an account. We offer an optional Pro pass that unlocks longer AI tutor sessions, larger compiler quotas and priority support, but it is not required to learn from the platform. The educational content itself stays free.

Do I need to sign in to use the courses?

No. You can browse any course, read all lessons, run code in the compiler and take quizzes without signing in. Google Sign-In is purely optional and is used only to save your progress, quiz scores and certificate eligibility across devices. We never request access to Gmail, Drive, Calendar, Contacts, or any sensitive Google data.

Are the certificates from Siksha Sarovar recognised?

Our certificates are a record of completion that you can share on LinkedIn or attach to applications, but Siksha Sarovar is an independent platform — not a UGC-recognised university or board. We are upfront about that. The certificate is most useful as a verifiable signal that you have completed the curriculum, not as a substitute for a degree.

Which courses are best for BCA and MCA students?

Our University Curriculum section covers the YMCA BCA/MCA syllabus subject-by-subject — Data Structures, DBMS, Web Based Programming, Computer Networks, Operating Systems, Software Engineering, Data Warehousing and more. Each subject is broken down into the same units your university teaches, with previous year question papers where available.

Can I use Siksha Sarovar to prepare for SSC, UPSC, Banking or Railway exams?

Yes. The Competitive section has dedicated tracks for SSC (CGL, CHSL, MTS), UPSC, IBPS/SBI Banking, RRB Railways and defence exams (NDA, CDS, AFCAT). Topics include quantitative aptitude, reasoning, English grammar, general knowledge and current affairs, written specifically for the Indian exam pattern.

What languages does the online compiler support?

The Siksha Sarovar online compiler supports C, C++, Python, Java, PHP, JavaScript, C# and SQL. The compiler runs your code in a sandboxed environment using Judge0, returns the standard output and error stream, and supports stdin so you can test interactive programs. There is no installation — everything runs in your browser.

How is my personal data handled by Siksha Sarovar?

We follow data minimisation: we collect only what is needed (email, name, profile picture from Google sign-in, and your learning progress). Data is stored on Supabase with HTTPS in transit. We do not sell user data, and we do not use it to train AI models. You can request deletion at any time by emailing contact@sikshasarovar.com — see our Privacy Policy for the full details.

Who founded Siksha Sarovar?

Siksha Sarovar was founded by Rohit Kumar, who serves as CEO and Head Developer. Rohit built the platform to provide free, structured education to students across India — covering programming courses, university notes, school study material and competitive exam preparation.

Practical 9: Statistical Functions in MS-Excel – 30 Operations — Statistical Analysis using Excel Lab Notes

Theoretical Questions

Q1: Importance of IT Tools in Data Processing IT tools (like MS-Excel, Python, R) automate repetitive calculations, reduce human errors, process large datasets quickly, and generate visual reports. Manual analysis is time-consuming and error-prone; computerized analysis provides speed, accuracy, and repeatability.

Q2: Statistics – Definition & Applications Statistics is the science of collecting, organizing, analyzing, interpreting, and presenting data. Applications: Business (sales forecasting), Economics (GDP analysis), Education (student performance), Healthcare (clinical trials).

Q3: Skills for Statistical Data Work

Data collection: surveys, sensors, databases
Classification: grouping into categories/frequency tables
Analysis: applying statistical measures
Interpretation: drawing meaningful conclusions
Good data characteristics: accuracy, completeness, relevance, timeliness, consistency

Q4: Statistical Functions in MS Excel Excel provides built-in functions for: AVERAGE, MEDIAN, MODE, STDEV, VAR, COUNT, MAX, MIN, RANK, PERCENTILE, LARGE, SMALL, COUNTIF, SUMIF, AVERAGEIF — making statistical analysis accessible without programming.

---

Dataset: Student Marks (30 Students)

S.No	Name	Marks	S.No	Name	Marks
1	Aman	85	16	Simran	79
2	Priya	72	17	Deepak	66
3	Rohit	91	18	Meena	90
4	Neha	60	19	Arjun	45
5	Vikas	98	20	Tanvi	81
6	Riya	74	21	Kunal	77
7	Karan	82	22	Ankita	69
8	Anjali	52	23	Sumit	88
9	Sanjay	77	24	Divya	75
10	Pooja	89	25	Harsh	63
11	Amit	65	26	Ishita	92
12	Sunita	93	27	Nikhil	58
13	Dev	73	28	Kajal	84
14	Kavita	58	29	Lokesh	70
15	Rahul	86	30	Mansi	95

(Marks stored in column C, rows 2–31. Use C2:C31 in all formulas.)

---

30 Statistical Functions

1.  =AVERAGE(C2:C31)                              → Average marks
2.  =MAX(C2:C31)                                  → Highest marks
3.  =MIN(C2:C31)                                  → Lowest marks
4.  =SUM(C2:C31)                                  → Total marks
5.  =COUNT(C2:C31)                                → Total students
6.  =MEDIAN(C2:C31)                               → Median marks
7.  =MODE(C2:C31)                                 → Mode (most frequent)
8.  =STDEV(C2:C31)                                → Standard Deviation
9.  =VAR(C2:C31)                                  → Variance
10. =COUNTIF(C2:C31,">75")                        → Students scoring > 75
11. =COUNTIFS(C2:C31,">=60",C2:C31,"<=80")       → Students scoring 60–80
12. =RANK(C2,C$2:C$31,0)  [drag down]            → Rank of each student
13. =MAX(C2:C31)-MIN(C2:C31)                      → Range (highest - lowest)
14. =AVERAGE(LARGE(C2:C31,{1,2,3,4,5}))          → Average of top 5 marks
15. =LARGE(C2:C31,2)                              → Second highest mark
16. =SMALL(C2:C31,2)                              → Second lowest mark
17. =COUNTIF(C2:C31,"<70")                        → Students scoring < 70
18. =COUNTIF(C2:C31,">80")/COUNT(C2:C31)*100     → % students scoring > 80
19. =SUMIF(C2:C31,">80")                          → Sum of marks above 80
20. =AVERAGEIF(C2:C31,">70")                      → Average of marks above 70
21. =LARGE(C2:C31,3)                              → Third highest mark
22. =SMALL(C2:C31,3)                              → Third lowest mark
23. =COUNTIF(C2:C31,75)                           → Students scoring exactly 75
24. =SUMIF(C2:C31,"<"&AVERAGE(C2:C31))           → Sum of marks below class avg
25. =AVERAGEIF(C2:C31,"<70")                      → Average of marks below 70
26. =COUNTIF(C2:C31,">"&AVERAGE(C2:C31))         → Students above class avg
27. =AVERAGE(C2:C31+5)  [Ctrl+Shift+Enter]       → New avg after 5 bonus marks
28. =MAX(C2:C31)+3                                → New highest after +3 bonus
29. =COUNTIF(C2:C31,"<60")/COUNT(C2:C31)*100     → % students below 60
30. =SUM(LARGE(C2:C31,{1,2,3}))                  → Total marks of top 3 students