Movie Step #2- Stem and Leaf

Rubric Requirements:

II. Stem & Leaf Plot     15 Points                                                                          

 

Creating Your Stem and Leaf

1)    You are going to have to analyze your numbers in your spreadsheet. Choose 1 column of data to make your stem and leaf over. When making a stem and leaf you want smaller numbers so you may have to drop of zeros. off larger numbers to make the stem and leaf.

For example, the budget may have 175,000,000. Drop off the zeros (000,000) and just use the 175. You can put millions in title and key to represent the 6 zeros your dropped.  

2) Once you have selected a column, highlight it, copy it and paste into column D in a new tab. (You can see we copy/pasted Budget into column D.)

3) In cell A1, type in your title that tells what data you are using. (May need to have millions as part of title if you dropped of zeros.)  

4) Make a T Bar using the border button.  Use common sense. You are going to need to think on this one.

5) Fill in numbers from high to low or low to high. Tens and hundreds places go on the left (stem side). Ones goes on the right (leaf side). Use commas to separate your ones places. (You can see we have 2 numbers in the 50s, so we have 2 zeros on the right side separated by commas.)

6)   Type a key to tell what the numbers on the stem and leaf represent. (Remember is you dropped the zeros off to add them in the key. Ex. 16/0=175,000,000)

7) On the tab at the bottom, rename the tab StemLeaf . Right-click on the tab at bottom of page (Sheet 2) and go to rename. Type in StemLeaf.

Now, return to the HomePage and go to the next step.