ExcelL2_C3_A3 - 2 Yes No 2-day rental 8.40 16.80 CV-1019...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Vantage Video Rentals Classic Video Collection StockNo Title Year Genre StockDate Director_Fname Director_Lname Copies VHS DVD Category CostPrice Total Cost   Action  Average   24.30  CV-1005 Breakfast at Tiffany's 1961  Comedy  11/1/2006  Blake    Edwards  1  Yes   No   7-day rental   4.88   4.88  1953  Comedy  9/5/2006  Charles    Lamont  2  Yes   No   7-day rental   5.87   11.74  CV-1009 The Odd Couple 1968  Comedy  2/15/2007  Gene    Saks  4  Yes   Yes   2-day rental   4.95   19.80    Comedy  Average   12.14  CV-1006 Gone with the Wind 1939  Drama  11/29/2006  Victor    Fleming  4  Yes   No   7-day rental   8.22   32.88  CV-1007 Doctor Zhivago 1965  Drama  12/8/2006  David   Lean  4  Yes   No   7-day rental   5.63   22.52  CV-1018 To Kill a Mockingbird 1962  Drama  2/12/2008  Robert   Mulligan 
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2 Yes No 2-day rental 8.40 16.80 CV-1019 Bonnie and Clyde 1967 Drama 1/15/2009 Arthur Penn 2 No Yes 2_day rental 9.12 18.24 CV-1013 Cool Hand Luke 1967 Drama 10/23/2007 Stuart Rosenberg 5 Yes Yes 2-day rental 5.42 27.10 Drama Average 23.51 CV-1011 A Christmas Carol 1951 Family 7/18/2007 Brian Hurst 4 Yes Yes 2-day rental 5.88 23.52 CV-1002 Miracle on 34th Street 1947 Family 9/15/2006 George Seaton 8 Yes No 2-day rental 7.55 60.40 Family Average 41.96 Horror Average 15.08 Musical Average 25.60 Thriller Average 32.70 War Average 21.04 Grand Average 23.32...
View Full Document

Ask a homework question - tutors are online