Using Google Sheets to Answer Questions

264 views
Skip to first unread message

CG

unread,
Oct 14, 2020, 2:51:19 AM10/14/20
to Discussion forum for Statistics for Data Science I
I am using Google Sheets to find answers to questions that have tabulated data.

Steps followed:
1. open the pdf version of the questions.
2. Copy the table by highlighting 
3. Paste Special in Google sheets 
4. Use Data>>Split Text to Columns
5. Select space as the separator.
6. sanitise the data and check for any differences




Statistics 1 Support 1

unread,
Oct 14, 2020, 2:46:28 PM10/14/20
to CG, Discussion forum for Statistics for Data Science I
Hello, 

Though it is a good thing that you found a way to solve it using Google sheets, it is not advisable to use google sheets to solve the problems as it not only won't improve your problem solving skills, also you will find it extremely difficult in qualifier exam where you won't be having access to Google Sheets. Also, use the calculator provided in WIndows OS as TCS calculator is similar to this calculator.

Best,
Ram,
Statistics-1 Course Support Instructor.

--
You received this message because you are subscribed to the Google Groups "Discussion forum for Statistics for Data Science I" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ma1002-discus...@nptel.iitm.ac.in.
To view this discussion on the web visit https://groups.google.com/a/nptel.iitm.ac.in/d/msgid/ma1002-discuss/0038c78d-7dea-4acb-8090-9ab48cac66b6o%40nptel.iitm.ac.in.


--
Thanks,
Ram,
Statistics-1 course support team,
IIT Madras Online BSc Programme.

CG

unread,
Oct 15, 2020, 3:00:52 AM10/15/20
to Discussion forum for Statistics for Data Science I, cheria...@gmail.com
Thanks for the heads-up Ram. 

I assumed that google sheets/spreadsheet access would be given since there are so many tutorial video lectures about using it. 



On Thursday, October 15, 2020 at 12:16:28 AM UTC+5:30, Statistics 1 Support 1 wrote:
Hello, 

Though it is a good thing that you found a way to solve it using Google sheets, it is not advisable to use google sheets to solve the problems as it not only won't improve your problem solving skills, also you will find it extremely difficult in qualifier exam where you won't be having access to Google Sheets. Also, use the calculator provided in WIndows OS as TCS calculator is similar to this calculator.

Best,
Ram,
Statistics-1 Course Support Instructor.

On Wed, Oct 14, 2020 at 12:21 PM CG <cheri...@gmail.com> wrote:
I am using Google Sheets to find answers to questions that have tabulated data.

Steps followed:
1. open the pdf version of the questions.
2. Copy the table by highlighting 
3. Paste Special in Google sheets 
4. Use Data>>Split Text to Columns
5. Select space as the separator.
6. sanitise the data and check for any differences




--
You received this message because you are subscribed to the Google Groups "Discussion forum for Statistics for Data Science I" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ma1002-...@nptel.iitm.ac.in.
Reply all
Reply to author
Forward
0 new messages