Slide 1

Slide 2 Jeopardy Moving Around Formulas Mean, Median, Mode, Range Final Jeopardy Function Words Mixed Bag $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Slide 3 The word PRICE is located in which cell? $ 100 Click my picture to see the answer Slide 4 Click my picture to return to the Jeopardy Game Board $ 100 C2 Slide 5 What does the gray box do for a spreadsheet when it is clicked? $ 200 Click my picture to see the answer Slide 6 It selects the entire spreadsheet. This is especially useful when changing the format for the whole spreadsheet. Examples: changing every column or row to the same width or height, making every cell centered, or a making every cell have the same font size or text color, etc. $ 200 Click my picture to return to the Jeopardy Game Board Slide 7 $ 300 Click my picture to see the answer The Format Cells window below is set up to express what type of number? How many decimal places will be shown? Slide 8 The number will be a percentage and it will show 2 decimal places. $ 300 Click my picture to return to the Jeopardy Game Board Slide 9 What is the cell address where you would find the actual expense for publicity? $ 400 Click my picture to see the answer Slide 10 $ 400 Click my picture to return to the Jeopardy Game Board E11 Slide 11 $ 500 Click my picture to see the answer What does a number in parentheses mean? Slide 12 $ 500 Click my picture to return to the Jeopardy Game Board It represents a negative number. Slide 13 Every formula in an Excel spreadsheet starts with what symbol? $ 100 Click my picture to see the answer Slide 14 $ 100 Click my picture to return to the Jeopardy Game Board An = sign. Slide 15 The class assignment was to find the ratio of shoe size divided by height of each student. What would be the formula that would find Cindy s ratio in the spreadsheet below? $ 200 Click my picture to see the answer Slide 16 $ 200 Click my picture to return to the Jeopardy Game Board =H5/I5 Slide 17 $ 300 Click my picture to see the answer What is the formula that will calculate the mean for the basketball player in the spreadsheet below? Slide 18 $ 300 Click my picture to return to the Jeopardy Game Board =average(B35:B39) Slide 19 $ 400 Click my picture to see the answer Chelsie wanted to find the range of x s crossed out with her classmates right hand. What would the formula be that would do this? Slide 20 $ 400 Click my picture to return to the Jeopardy Game Board =max(L5:L23)-min(L5:L23) Slide 21 $ 500 Click my picture to see the answer What is the formula that will place the actual income ($106,600) in cell D22? What is the formula that will place the actual expenses ($17,400) in cell D23? Slide 22 $ 500 Click my picture to return to the Jeopardy Game Board =E8 =E17 Slide 23 $ 100 Click my picture to see the answer What number would be the result of using the following formula in the spreadsheet above? =H5+I5 Slide 24 $ 100 Click my picture to return to the Jeopardy Game Board =H5+I5 the resulting number would be 13. Slide 25 $ 200 Click my picture to see the answer What number would be the result of using the following formula in the spreadsheet above? =max(H4:H9) Slide 26 $ 200 Click my picture to return to the Jeopardy Game Board =max(H4:H9) the resulting number would be 22. Slide 27 $ 300 Click my picture to see the answer To find the total projected expenses on this spreadsheet, the following formula would be written: = ( ) Finish the formula by using a math function and finding what goes inside the parentheses. Slide 28 $ 300 Click my picture to return to the Jeopardy Game Board =sum(B3:B8) Slide 29 $ 400 Click my picture to see the answer What formula is found in cell F7? Slide 30 $ 400 Click my picture to return to the Jeopardy Game Board =E7-D7 Slide 31 $ 500 Click my picture to see the answer What are the formulas that would find the median and mode for the shoe size data? Slide 32 $ 500 Click my picture to return to the Jeopardy Game Board Formula for median: =median(A2:A19) Formula for mode: =mode(A2:A19) Slide 33 $ 100 Click my picture to see the answer What is the range for the arm span data? Slide 34 $ 100 Click my picture to return to the Jeopardy Game Board 46 = 190 - 144 Slide 35 $ 200 Click my picture to see the answer What is the mode for the shoe size data? Slide 36 $ 200 Click my picture to return to the Jeopardy Game Board Size 9? Slide 37 $ 300 Click my picture to see the answer What is the mean for the height data? Round your answer to the nearest 10th. Slide 38 $ 300 Click my picture to return to the Jeopardy Game Board Mean 164.7 Slide 39 $ 400 Click my picture to see the answer The following are math scores from the last quiz: 82, 94, 88, 46, 91, 92, 86, 93, 85 Which average would BEST fit the data? Mean or Median and why? Slide 40 $ 400 Click my picture to return to the Jeopardy Game Board The following are math scores from the last quiz: 82, 94, 88, 46, 91, 92, 86, 93, 85 Which average would BEST fit the data? Mean or Median and why? The median would be the best fit for this data. The score of 46 will affect the mean more than it will affect the median. When calculating the median, counting up from the low of 46, the median will be unaffected by the low score. The mean will be pulled lower by the 46. Slide 41 $ 500 Click my picture to see the answer Find the sum of the mean, median and mode for this set of data. 8 10 3 11 3 Slide 42 $ 500 Click my picture to return to the Jeopardy Game Board Find the sum of the mean, median and mode for this set of data. 8 10 3 11 3 Mean: 355=7 Median: 8 7+8+3 = 18 Mode: 3 Slide 43 $ 100 Click my picture to see the answer Which variable is the dependent variable? Slide 44 $ 100 Click my picture to return to the Jeopardy Game Board Height - the dependent variable is always located on the y-axis. Slide 45 $ 200 Click my picture to see the answer What is the x-scale? What is the y-scale? Slide 46 $ 200 Click my picture to return to the Jeopardy Game Board What is the x-scale?2 What is the y-scale?5 x-scale y-scale Slide 47 $ 300 Click my picture to see the answer Which of the following statement(s) are true? (none of these statements might be true, or all of them might be true) a.As arm span increases, height decreases b.As arm span increases, height increases c.As arm span decreases, height decreases d.As arm span decreases, height increases Slide 48 $ 300 Click my picture to return to the Jeopardy Game Board Statements b and c are correct. a.As arm span increases, height decreases b.As arm span increases, height increases c.As arm span decreases, height decreases d.As arm span decreases, height increases Slide 49 $ 400 Click my picture to see the answer Sometimes we say the median will fall on one of the pieces of data and sometimes it will fall in between two pieces of data. How can you tell when it is going to fall on or in between pieces of data? Slide 50 $ 400 Click my picture to return to the Jeopardy Game Board If a set of data contains an ODD number of pieces of data, the median will fall ON one of the numbers. If a set of data contains an EVEN number of pieces of data, the median will fall in between two of the numbers. Slide 51 $ 500 Click my picture to see the answer Janey wanted to average 90% on her math tests. So far she has a 83%, 92%, 80% and a 95% on her first 4 tests. What does she need to score on the last test to average 90%? Slide 52 $ 500 Click my picture to return to the Jeopardy Game Board To average 90% on 5 tests, Janey needs 450 points (5 x 90). So far Janey has accumulated 350 points. Therefore she needs 100 points on the last test to average 90%. Slide 53 For your Final Jeopardy question, you may risk $0 up to the total amount of money accumulated. Write down how much you want to risk. Click my picture to see the FINAL JEOPARDY question. Slide 54 Final Jeopardy Click my picture to see the answer What math term would you use to describe a set of data that has a lot of high values, a lot of low values and some values in the middle? We would describe this set of data as being very __ __ __ __ __ __ __. Slide 55 Final Jeopardy Answer Click my picture to return to the Jeopardy Game Board What math term would you use to describe a set of data that has a lot of high values, a lot of low values and some values in the middle? We would describe this set of data as being very D I V E R S E.