Technology Institute Workshops
Movie Admission Price
Home
Workshop 1
Workshop 2
Workshop 3
Workshop 4
Workshop 5
Workshop 6
Workshop 7
Workshop 8
Workshop 9
Resources
Table of Activities

Create a Spreadsheet:

marque.gif

Year

Admission Price

1981

$2.78

1982

$2.94

1983

$3.15

1984

$3.36

1985

$3.55

1986

$3.71

1987

$3.91

1988

$4.11

1989

$4.45

1990

$4.75

1991

$4.89

1992

$5.05

 

  

  • According to the line, what is the average price of a theatre ticket this year?
  • According to the line what will the average movie price be in 2010?
  • Predict what the average price will be 30 years from now.

en00439_.gif

 
PreAlgebra and Algebra SOL
 
How could you use this with an online data base?
 

 
 
 
 
 
  1. Launch Excel
  2. Rename Sheet 1 to Ticket Data.
  3. Enter data.
  4. Using the Chart Wizard, create a scatter plot chart
  5. Make sure to Title your chart,under Legend tab uncheck "legend", explore Gridlines, etc. 
  6. Open chart in New Chart
  7. Right-click on Y-axis to change total dollars ($15)  and  increments of dollars (.50)
  8. Right-click on the X-axis to change the total of years (2010) and increments for years (5)
  9. Add line of best fit (Trendline)
  10. Print graph.(or wait and print final)
  11. Repeat step 7, but change the total years to 2034 and increments to 10.
  12. Print graph.

That's a wrap!