Create a Scatter Diagram Using MS Excel 2007



This video shows how to create a scatter diagram in Microsoft Office Excel 2007. The data for this video can be obtained at my website:
http://statstutor.books.officelive.com/

11 thoughts on “Create a Scatter Diagram Using MS Excel 2007

  1. Not sure why you made the graph with 3 columns and two of them are the same. I guess it doesn't matter since they will just overlap each other when you plot them.

  2. Not sure if I did mine correctly. My study is different, with some of the X-values being either "0" or "1" as they are disease occurences (ex. 0 for No Diabetes, 1 for Diabetes).

    My graph then looks like a red line with all the blue ones lying on either 0 or 1. Maybe I need a different test?

Leave a Reply

Your email address will not be published. Required fields are marked *