Top-rated Data Science tutor in Canada

The Student and Tutor discussed mean, median, and mode and how outliers affect these measures, especially in skewed data. The Student practiced creating pivot tables and charts in Excel to analyze sales data, calculate average units sold, and determine the best and worst-selling brands. They also looked at the coefficient of variation to assess sales consistency and will work on creating a dashboard in the next session.

The session involved using Excel to calculate daily revenue, analyze errors in predicted vs. actual demand, identify stockouts, and utilize Power Pivot tables for data summarization. The Student practiced using IF and VLOOKUP functions to determine prices based on dates and calculating revenue, and also learned to create pivot tables and analyze standard deviation to determine consistent and inconsistent products.. A follow-up session was scheduled to continue working on the Power Pivot table task.

Lata assisted a student from Marshall University in Huntington in resolving conditional formatting errors in an Excel spreadsheet. They addressed issues with conflicting rules and rule precedence, focusing on how to manage and delete rules to achieve the desired formatting outcome. The student plans to work on new projects and will reach out for shorter, focused lessons as needed.

Lata and Rita collaborated on an Excel lesson, where they focused on rebuilding a dashboard. Their work involved mastering COUNTIF and COUNTIFS formulas to track task progress using multiple criteria. Rita specifically honed her skills in correcting cell references and developing a pie chart to visually represent task distribution across different project phases. They have scheduled their next lesson to further their work in Excel, with a possibility of introducing PowerPoint.

Lata mentored Scott on data visualization in Excel, guiding him through chart selection and customization for effective data storytelling. Scott actively practiced creating various charts and applying Excel techniques to enhance his data presentation skills. They concluded by discussing ongoing support and scheduling their next lesson.

Shubham and Rohan collaborated on an Excel assignment, specifically task 4.1, which focused on advanced data analysis techniques. Their work involved mastering scenario management, constructing data tables, and generating insightful charts. To analyze profit per hour under various conditions, they effectively employed Excel's Scenario Manager, Solver, and pivot tables, supplementing their efforts with guidance from a video. While navigating the assignment, they encountered difficulties with formatting and the precise setup of data tables, and even pinpointed potential inaccuracies in the provided answer key. Ultimately, their diligent efforts resulted in a commendable score of 93 out of 100.