Statistics for Data Science 1 - W1_T3: Spreadsheet formulae

Welcome to Tutorial 3 of the course "Statistics for Data Science - I" by Prof. Andrew Thangaraj. Full Course: https://study.iitm.ac.in/ds/course_pages/BSMA1002.html Video Overview In this tutorial, you will learn how to perform efficient spreadsheet calculations using cell referencing and formulas in Google Sheets. Moving beyond manual computations, this session demonstrates how to manage financial data such as monthly interest and principal balances with ease. You’ll discover how to use the equals sign (=) to create formulas, reference specific cells (like B3 and C2), and apply the asterisk operator for multiplication. The video also covers the use of AutoFill to populate data quickly and introduces absolute cell referencing with the dollar sign, ensuring that key references like principal or interest rates remain fixed during formula replication. By the end of this tutorial, you’ll understand how to design dynamic and flexible spreadsheets where updates to a single input automatically reflect across all related calculations. About IIT Madras' online Bachelor of Science programme IIT Madras offers four-year BS programmes that aim to provide quality education to all, irrespective of age, educational background, or location. The BS programme has multiple levels, which provide flexibility to students to exit at any of these levels. Depending on the courses completed and credits earned, the learner can receive a Foundation Certificate from IITM CODE (Centre for Outreach and Digital Education), Diploma(s) from IIT Madras, or BSc/BS Degrees from IIT Madras. For more details, Visit: https://www.iitm.ac.in/academics/study-at-iitm/non-campus-bs-programmes #Spreadsheet #Excel #GoogleSheets #Formula #CellReferencing #AutoFill #AbsoluteReferencing #DollarSign #InterestCalculation #Principal #Finance #DataEntry #Tutorial #Software #Calculation #Cells #Data #Asterisk #Automation #IITMadras #OnlineLearning #Education #BSProgramme #StatisticsForDataScience #Analytics