How To Make A Stem And Leaf Plot In Excel 2007 2010 & 2003

by

You can actually plot a stem and leaf graph in excel like the one below all you need is to write out your data and place the integers on the left side of the bars and the decimal places on the right if you have only integers without the decimal places,

you can represent them in a stem and leaf plot because the number 2 for instance is the same as 2.0

so if you have one or more 2s in your data, it should be represented like this 2 | 0 0 0 – the number of zeros represents the frequency of the number ‘2’ in your data.

Below is a distribution of video game ratings:

A)
36 | 0
38 | 0 0 0
39 | 0 0 0 0
40 | 0 0 0 0 0
41 | 0 0 0 0 0 0
42 | 0 0 0 0 0 0
43 | 0 0 0 0 0 0 0 0
44 | 0 0 0 0 0 0 0 0 0 0 0 0
45 | 0 0 0 0 0 0 0 0 0
46 | 0 0 0 0 0 0 0
47 | 0 0 0
48 | 0

B) The distribution of the video game composite rating appears
to be mound shaped or symmetric. This shows that the composite ratings are concentrated on the center.

C) From the stem and leaf above, it is obvious that the average composite rating is approximately 42, so the answer is yes we can say that almost all purchasers of the XYZ video game system are very satisfied.

  

   

Recommendations For You: