Statistical Analysis using Excel Syllabus, Notes & PYQ for GGSIPU Bachelor of Computer Applications 2nd Sem
Bachelor of Computer Applications
Subjects
Choose your subject
Select a branch to change subjects.
Statistical Analysis using Excel
1Enter the marks of 20 students in the given order • Serial number • Name of the student • Name of the college • Class • Subject-1 • Subject-2 • Subject-3 • Subject-4. In separate columns, perform the following operations. Calculate the following: a. Total marks of all the subjects b. Percentage of marks for each of the students c. Allotment of grades based on the criterion • If the marks are more than 75% then the result is "Pass" else "Fail" d. Now in other column allot the grades based on the following criterion • If the marks are more than 90% then grade is "A" • If the marks are more than or equal to 75 and less than 90% then the grade is "B" else the grade is "C" provided that the result is "Pass"
2From the following table, calculate the following
City Number of Schools Number of candidates
New Delhi 300 30000
Mumbai 450 45000
Bengaluru 500 48000
Chennai 480 67000
Trivandrum 459 77000
• The average number of students in the entire distribution
• The standard deviation of the distribution
• The correlation coefficient between the number of schools and the number of candidates
• The regression equation between number of students and number of candidates
Subject Details
Lab CodeBCA 114, BCA116
Lab Credits1