Q6 Spin Out

Play the interactive Quizlet Game: Direct Link

Part 1 Collect data

1.1. Spinner Operator-

• Look under the online spinner and set the Number of Sectors to 5 (one for each color).
• The owner told you he sells an average of 10 Slushies each hour on the weekend.
• Enter the number 10 in the Spins box.
• Click on "spin" button to carry out this Experiment to see the results for Round 1.

• Analyst: Look at the Column titled Theoretical %, why do you think they are all the same % at the start of this experiment?
  • Notice the Count column on the spinner shows how many times the spinner landed on a particular color sector.
  • It shows the Experimental % of your spin
  • It also shows the Theoretical % for a single spin of a single color (or 1 out of 5 chances to get any one color)
  • Are your results experimental %'s different than the theoretical ones?
  • Why do you think they are different or the same?

1.2 Spreadsheet Operator: Record the Round 1 results

• Record the results for Round 1 in the Problem One section of the spreadsheet, (as called off by the spinner partner if working with one). An example is shown below.
• Remember to RESET the spinner after each Round of 10 spins.
• Continue to do Round 2 and Round 3, recording the results after your spins.

• Notice that the totals area automatically calculated for you. You will learn about formulas in the next part.

1.3 Problem 2.

• The Slushie company owner told you that he sells between 700 to 1000 each week.
• Repeat the experiment, but this time you choose the number of spins for each round to approximate his weekly sales (max is 1000).
• Type the number of spins you have decided to use in the spreadsheet for Problem 2.
• Set your spinner so that in 3 rounds of spins it will add up to your sales projection.
• Record the data after each of the 3 rounds of spins. 

Reflection Questions:

• Look at your results from 30 spins in Problem 1, and the results from your Problem 2. What differences do you notice?
• What if you recommend if you only looked at your first set of spin data?
• Did more spins change what you would recommend?
• Make a list of things that can be misleading or wrong with data you see in ads on TV, in posters, or other locations. Is it misleading at times?

Continue to the Formulas section below.

Part 2 Formulas

Your next step is to use a formula so the spreadsheet will add up the totals for you in the Totals row in Round 2. You can do this by using the SUM function below.

Example: The formula used for Problem 1 in cell C8 to add Cells C5 + C6 + C7

2.1 In the spreadsheet, in Problem 2, put your cursor in the Totals Row under the Blue column (cell C20 in the example used).

2.2 Using the spreadsheet provided for this activity, type this formula into the cell    =sum(C17:C19)  
Notice the Google helper sometimes suggests a formula for you.

• The = sign lets the spreadsheet know you want to enter a formula.
• The word sum will add up the cells you indicate
• The : (colon) between the cells indicates to add up everything between the first cell you select (C17), and the last cell (C19) selected.

Press enter and if you did it correctly you will see the total. Google sheets also will let you know if you made an error and try to suggest a correct formula.

• When you are done, put your cursor back in the cell and see the formula appear on the formula bar above the spreadsheet.

2.3 POWER SHORTCUT: Filling the formula across to other cells in the row.

• Once you have successfully entered the formula, select the cell once more. Look closely for the large square in the lower right corner of the cell.

• When you put your cursor carefully over the corner square (it's called a fill handle) your mouse will become a large cross hair, click with your mouse and DRAG across to the right to the last column to total and let up on the mouse. It will fill the sum formula across to the others.

2.4 Calculating the Experimental % figures for your data

• For both of the Problem 1 and Problem 2 data sets there is a row for calculating the Experimental % of times the spinner landed on each color. You will be able to compare these figures with the Theoretical %.
• The challenge is to see how close or different your data is.
• Put your cursor in the Problem 1 Experimental % cell under Blue (cell C11 in our example).
• To calculate this, you are going to create a formula to divide the total number of spins for each color by the total number of spins done in all three rounds (30).  Try this formula   =C8/30 (in cell C11).
• Then use the fill handle technique and drag it across the other cells! How close are your Experimental percents to the Theoretical ones?

Challenge:

• Create a similar formula for Problem 2, but this time you won't be dividing by 30, divide by the total number of spins you did for all three rounds.

Continue to Part 3, Charts and Graphs

Part 3

This is a fun part but watch carefully and be ready to experiment. We will use the Google Explore feature to open graphing options after we select the cells to graph.

1. Start by copying the color section names and paste them into the cells below the Totals for Problem 1 so that it looks like this. The purpose is to put the labels right below the data for the chart we will create.
   Looks like this now:
    
2. Put your cursor in the total for Blue and drag across and down so that you have highlighted all the totals and names of the colors on the spinner (Cells C8 through G9 in our example)
   
3. Then use the Insert menu>Chart.
   Yes you could also use the Explore button (bottom right of the spreadsheet page) and scroll down through the different graph options (line, bar, circle)
4. Select the pie chart, and if you scroll down you will see a 3D version.
5. Close the Explore window using the X
6. Select one of the slices (double-click) and on the Pie Slice customize menu change the color to the appropriate color for the data it represents. You only need a single click to select each sector to change their colors. Do this for each slice.
7. On the right Chart editor menu, select Pie chart if it isn't already opened down and select Slide Label. It will be on None, but change it to Percentage.
8. Next select Legend in the Editor window and change the Position that says Auto to None. This cleans up look of the chart.
9. Close the customize window.
10. Click on the chart and notice the three gray dots in the top right corner of your chart and notice the options
11. Select Copy Chart
12. Go to the tab titled Recommendation and paste (right-click copy or ctrl-v)
13. resize it so that it fits into the large square provided
14. Type in a recommendation based on your data.
15. Return to the Experiment sheet and select the chart, use the 3 dots and delete the chart.
16. You will do the same for Problem 2, but this time select the cells, and use the Insert>Chart menu
17. Double-Click on each sector to change the colors to match your data again.
18. Change the Labels to show Percentage (it takes some searching)
19. Copy the chart and paste it on the Recommendation sheet page
20. Resize it to fit
21. Write your recommendations to the Slushie Company based on this data, and explain why this might be different from your first recommendation.

Whew! Congratulations with creating your charts!