Page 231 of 241 12 Creating and customizing pivot charts 2 13 Using slicers and timeline for interactive analysis 2 IV Data Analysis Technique 7 15 14 Descriptive statistics (mean, median, mode, standard deviation) 1 15 Correlation and regression analysis with example, Data analysis tools (Solver, Analysis ToolPak) 2 16 Scenario analysis and what-if analysis (Goal Seek, Data Tables, Scenario Manager) 2 17 Introduction to DAX (Data Analysis Expressions) for complex calculations (Concept Only) 2 V Practical Applications 30 1 1. Implement filter and sort operations. 2. Perform basic Arithmetic operations (Sum, Difference, Product, Divides) 3.
Using a dataset of student grades in different subjects, calculate the average grade, highest grade (MAX), lowest grade (MIN), and the total number of grades recorded (COUNT). 4. Create a spreadsheet with a list of full names in one column. Use text functions to separate the first names and last names into two new columns. 5. Create a spreadsheet with a list of dates of birth and names. Using the appropriate date and time functions, calculate each person's current age. 6. Perform Logical function on a given dataset. 7. Using a dataset of students' information, create a bar chart to visualize the data. Customize the chart with titles, axis labels, and different colours for each bar. 8.
A list of 15 students with their hours of study per week and their corresponding exam scores, Use the CORREL function to Calculate the correlation coefficient. 7