Wednesday, January 8, 2014

A High School counselor is conducting a study to help establish guidelines for recommending the number of hours a student should work during the...

It is really pretty easy to create a scatter plot graph using either Microsoft Excel or Google Sheets.  I would use Google Sheets as it is easier to access and share (not to mention it is free to use.)  A good educator or counselor is able to utilize the technology that is available and would probably use one of these two applications.  Open the spreadsheet software and place the data for GPA in one column...

It is really pretty easy to create a scatter plot graph using either Microsoft Excel or Google Sheets.  I would use Google Sheets as it is easier to access and share (not to mention it is free to use.)  A good educator or counselor is able to utilize the technology that is available and would probably use one of these two applications.  Open the spreadsheet software and place the data for GPA in one column and then the data for hours worked on the second column.  Place titles at the top of each column so that they show up on the graph.  To create a chart, highlight all of your data and click on the 'insert chart' icon in the menu.  It is also very easy to add the best fit line under the 'advanced settings' menu of your chart.  I have attached the results of this  process to the answer and you can estimate that a student that works 22.5 hours will be likely to perform at a 2.0 GPA.  I would caution that this is a relatively low sample size to draw any real conclusions from.  

No comments:

Post a Comment

Is Charlotte Bronte's Jane Eyre a feminist novel?

Feminism advocates that social, political, and all other rights should be equal between men and women. Bronte's Jane Eyre discusses many...