finish the excel work follow the requirements
Jason9876
mkt_202_final_fall_2016.xlsxMKT 202 Final Cover Page
| MKT 202 Quantitate Methods in Marketing | |
| Final Case Study- Autumn 2016 | |
| Possible Points: | 25 points / 25% of final grade |
| Grading Criteria: | Accuracy and Completeness |
| Due: Wednesday, November 16 by 11:59 pm | |
| Submit an electronic copy via the digital drop box D2L- Final Folder | |
| LATE SUBMISSIONS WILL NOT BE ACCEPTED | |
| Content Requirements: | |
| Problem 1- Hockey Salary Data | |
| Problem 2- Hot Dog Price Sensitivity Meter | |
| Problem 3- Budweiser Beer Scenario | |
| Problem 4- Jersey Sales | |
| Problem 5- Blackhawks Viewership | |
| Please complete the problems on their respective tabs in excel. If you need an additional tab, make sure it is clearly labeled. | |
| You must show your work to receive credit. Your numerical answers must be calculated using excel formulas to receive credit. | |
| You must use a PC and not an Apple to complete your final | |
| You may use your notes, past lab work and any statistics book to complete your final. | |
| This final is to be completed individually | |
| a | |
| Tues evening |
Hockey Salary Data
| 2013-14 NHL Salaries | Questions: | ||||||||
| Player | Team | Position | Salary | 1 | What is the mean salary for the hockey players listed? | ||||
| Shea Weber | NSH | D | $14,000,000 | 2 | What is the median salary for the hockey players listed? | ||||
| Ryan Suter | MIN | D | $12,000,000 | 3 | What is the mode of the salaries for the hockey players listed? | ||||
| Sidney Crosby | PIT | C | $12,000,000 | 4 | What is the minimum salary for the hockey players listed? | ||||
| Zach Parise | MIN | LW | $12,000,000 | 5 | What is the maximum salary for the hockey players listed? | ||||
| Eric Staal | CAR | C | $9,250,000 | 6 | Construct a Histogram with the minimum salary value being 0 and interval size being 100,000.Be sure your chart has proper labels and title. | ||||
| Alex Ovechkin | WSH | RW | $9,000,000 | 7 | Is the distribution of salaries skewed? If so, how is it skewed? | ||||
| Brad Richards | NYR | C | $9,000,000 | 8 | Is the kurtosis of the distribution of salaries leptokurtic, mesokurtic or platykurtic? | ||||
| Steven Stamkos | TBL | C | $8,000,000 | 9 | How many Left Wingers "LW" are contained in the data set? | ||||
| Zdeno Chara | BOS | D | $8,000,000 | 10 | What is the percentage of players that make $925,000 or less per year? | ||||
| Marian Hossa | CHI | RW | $7,900,000 | ||||||
| Rick Nash | NYR | LW | $7,800,000 | ||||||
| Duncan Keith | CHI | D | $7,650,000 | ||||||
| Mike Richards | LAK | C | $7,600,000 | ||||||
| Anze Kopitar | LAK | C | $7,500,000 | ||||||
| Evgeni Malkin | PIT | C | $7,500,000 | ||||||
| Henrik Zetterberg | DET | LW | $7,500,000 | ||||||
| Marian Gaborik | LAK | RW | $7,500,000 | ||||||
| Mikko Koivu | MIN | C | $7,290,000 | ||||||
| Brian Campbell | FLA | D | $7,142,857 | ||||||
| Alexander Semin | CAR | RW | $7,000,000 | ||||||
| Chris Pronger | PHI | D | $7,000,000 | ||||||
| Corey Perry | ANA | RW | $7,000,000 | ||||||
| Jonathan Quick | LAK | G | $7,000,000 | ||||||
| Mike Cammalleri | CGY | C | $7,000,000 | ||||||
| Pekka Rinne | NSH | G | $7,000,000 | ||||||
| Patrick Marleau | SJS | LW | $6,900,000 | ||||||
| Roberto Luongo | FLA | G | $6,714,000 | ||||||
| Drew Doughty | LAK | D | $6,700,000 | ||||||
| Pavel Datsyuk | DET | C | $6,700,000 | ||||||
| Dan Boyle | SJS | D | $6,666,666 | ||||||
| Cam Ward | CAR | G | $6,600,000 | ||||||
| Jay Bouwmeester | STL | D | $6,600,000 | ||||||
| Paul Stastny | COL | C | $6,600,000 | ||||||
| Jason Garrison | VAN | D | $6,500,000 | ||||||
| Jeff Carter | LAK | C | $6,500,000 | ||||||
| Jonathan Toews | CHI | C | $6,500,000 | ||||||
| Martin St. Louis | NYR | RW | $6,500,000 | ||||||
| Patrick Kane | CHI | RW | $6,500,000 | ||||||
| Patrick Sharp | CHI | LW | $6,500,000 | ||||||
| Ryan Getzlaf | ANA | C | $6,500,000 | ||||||
| Ryan O`Reilly | COL | C | $6,500,000 | ||||||
| Thomas Vanek | MTL | LW | $6,400,000 | ||||||
| Kari Lehtonen | DAL | G | $6,250,000 | ||||||
| Ryan Miller | STL | G | $6,250,000 | ||||||
| Daniel Sedin | VAN | LW | $6,200,000 | ||||||
| Henrik Sedin | VAN | C | $6,100,000 | ||||||
| Alex Burrows | VAN | RW | $6,000,000 | ||||||
| James Wisniewski | CBJ | D | $6,000,000 | ||||||
| Joe Thornton | SJS | C | $6,000,000 | ||||||
| Jordan Eberle | EDM | RW | $6,000,000 | ||||||
| Jordan Staal | CAR | C | $6,000,000 | ||||||
| Kimmo Timonen | PHI | D | $6,000,000 | ||||||
| Mike Green | WSH | D | $6,000,000 | ||||||
| Milan Michalek | OTT | LW | $6,000,000 | ||||||
| Nicklas Backstrom | WSH | C | $6,000,000 | ||||||
| Niklas Kronwall | DET | D | $6,000,000 | ||||||
| Scott Hartnell | PHI | LW | $6,000,000 | ||||||
| Taylor Hall | EDM | LW | $6,000,000 | ||||||
| Tuukka Rask | BOS | G | $6,000,000 | ||||||
| Tyler Myers | BUF | D | $6,000,000 | ||||||
| Vincent Lecavalier | PHI | C | $5,900,000 | ||||||
| Brent Burns | SJS | RW | $5,760,000 | ||||||
| Andrei Markov | MTL | D | $5,750,000 | ||||||
| Carey Price | MTL | G | $5,750,000 | ||||||
| Dustin Byfuglien | WPG | D | $5,750,000 | ||||||
| Marc-Andre Fleury | PIT | G | $5,750,000 | ||||||
| Matthew Carle | TBL | D | $5,750,000 | ||||||
| Toby Enstrom | WPG | D | $5,700,000 | ||||||
| Bobby Ryan | OTT | RW | $5,562,500 | ||||||
| Ales Hemsky | OTT | RW | $5,500,000 | ||||||
| Andrej Meszaros | BOS | D | $5,500,000 | ||||||
| Braydon Coburn | PHI | D | $5,500,000 | ||||||
| Dion Phaneuf | TOR | D | $5,500,000 | ||||||
| Erik Karlsson | OTT | D | $5,500,000 | ||||||
| Jason Pominville | MIN | RW | $5,500,000 | ||||||
| Jimmy Howard | DET | G | $5,500,000 | ||||||
| Milan Lucic | BOS | LW | $5,500,000 | ||||||
| Patrik Elias | NJD | LW | $5,500,000 | ||||||
| Shane Doan | PHX | RW | $5,500,000 | ||||||
| Phil Kessel | TOR | RW | $5,400,000 | ||||||
| David Krejci | BOS | C | $5,250,000 | ||||||
| Joffrey Lupul | TOR | LW | $5,250,000 | ||||||
| Keith Yandle | PHX | D | $5,250,000 | ||||||
| Henrik Lundqvist | NYR | G | $5,125,000 | ||||||
| Alex Pietrangelo | STL | D | $5,000,000 | ||||||
| Brent Seabrook | CHI | D | $5,000,000 | ||||||
| Brian Gionta | MTL | RW | $5,000,000 | ||||||
| Claude Giroux | PHI | C | $5,000,000 | ||||||
| Dany Heatley | MIN | LW | $5,000,000 | ||||||
| Dennis Wideman | CGY | D | $5,000,000 | ||||||
| James Neal | PIT | LW | $5,000,000 | ||||||
| Jamie Benn | DAL | LW | $5,000,000 | ||||||
| Jason Spezza | OTT | C | $5,000,000 | ||||||
| Johan Franzen | DET | C | $5,000,000 | ||||||
| John Tavares | NYI | C | $5,000,000 | ||||||
| Kevin Bieksa | VAN | D | $5,000,000 | ||||||
| Marc Savard | BOS | C | $5,000,000 | ||||||
| Mark Streit | PHI | D | $5,000,000 | ||||||
| Martin Brodeur | NJD | G | $5,000,000 | ||||||
| Martin Havlat | SJS | RW | $5,000,000 | ||||||
| Nathan Horton | CBJ | C | $5,000,000 | ||||||
| Paul Martin | PIT | D | $5,000,000 | ||||||
| Ryan Kesler | VAN | C | $5,000,000 | ||||||
| Sergei Bobrovsky | CBJ | G | $5,000,000 | ||||||
| Sergei Gonchar | DAL | D | $5,000,000 | ||||||
| Tomas Plekanec | MTL | C | $5,000,000 | ||||||
| Tuomo Ruutu | NJD | RW | $5,000,000 | ||||||
| Ryane Clowe | NJD | LW | $4,850,000 | ||||||
| Ryan Callahan | TBL | RW | $4,825,000 | ||||||
| David Backes | STL | C | $4,750,000 | ||||||
| Brandon Dubinsky | CBJ | C | $4,650,000 | ||||||
| Alex Goligoski | DAL | D | $4,600,000 | ||||||
| Blake Wheeler | WPG | RW | $4,600,000 | ||||||
| Kris Versteeg | CHI | RW | $4,600,000 | ||||||
| Loui Eriksson | BOS | RW | $4,600,000 | ||||||
| Patrice Bergeron | BOS | C | $4,550,000 | ||||||
| Andrew Ladd | WPG | LW | $4,500,000 | ||||||
| David Booth | VAN | LW | $4,500,000 | ||||||
| David Clarkson | TOR | RW | $4,500,000 | ||||||
| Evander Kane | WPG | LW | $4,500,000 | ||||||
| Fedor Tyutin | CBJ | D | $4,500,000 | ||||||
| Jakub Voracek | PHI | RW | $4,500,000 | ||||||
| Jaroslav Halak | WSH | G | $4,500,000 | ||||||
| Jonas Hiller | ANA | G | $4,500,000 | ||||||
| Joni Pitkanen | CAR | D | $4,500,000 | ||||||
| Mike Ribeiro | PHX | C | $4,500,000 | ||||||
| Olli Jokinen | WPG | C | $4,500,000 | ||||||
| R.J. Umberger | CBJ | LW | $4,500,000 | ||||||
| Ray Whitney | DAL | LW | $4,500,000 | ||||||
| Teddy Purcell | TBL | RW | $4,500,000 | ||||||
| Tim Gleason | TOR | D | $4,500,000 | ||||||
| Tyler Seguin | DAL | C | $4,500,000 | ||||||
| Sam Gagner | EDM | C | $4,400,000 | ||||||
| Jeff Skinner | CAR | LW | $4,350,000 | ||||||
| Anton Volchenkov | NJD | D | $4,250,000 | ||||||
| Dan Hamhuis | VAN | D | $4,250,000 | ||||||
| Ed Jovanovski | FLA | D | $4,250,000 | ||||||
| John-Michael Liles | CAR | D | $4,250,000 | ||||||
| Marc-Edouard Vlasic | SJS | D | $4,250,000 | ||||||
| Mike Fisher | NSH | C | $4,200,000 | ||||||
| Chris Stewart | BUF | RW | $4,100,000 | ||||||
| Antti Niemi | SJS | G | $4,100,000 | ||||||
| Brad Marchand | BOS | LW | $4,000,000 | ||||||
| Brooks Laich | WSH | C | $4,000,000 | ||||||
| Bryan Little | WPG | C | $4,000,000 | ||||||
| Cam Fowler | ANA | D | $4,000,000 | ||||||
| Christian Ehrhoff | BUF | D | $4,000,000 | ||||||
| Cory Schneider | NJD | G | $4,000,000 | ||||||
| Daniel Briere | MTL | C | $4,000,000 | ||||||
| David Jones | CGY | RW | $4,000,000 | ||||||
| Derek Roy | STL | C | $4,000,000 | ||||||
| Drew Stafford | BUF | RW | $4,000,000 | ||||||
| Eric Brewer | TBL | D | $4,000,000 | ||||||
| Erik Cole | DAL | LW | $4,000,000 | ||||||
| Jiri Hudler | CGY | C | $4,000,000 | ||||||
| Joe Pavelski | SJS | C | $4,000,000 | ||||||
| John Carlson | WSH | D | $4,000,000 | ||||||
| Kyle Quincey | DET | D | $4,000,000 | ||||||
| Mark Giordano | CGY | D | $4,000,000 | ||||||
| Max Pacioretty | MTL | LW | $4,000,000 | ||||||
| Mike Smith | PHX | G | $4,000,000 | ||||||
| P.A. Parenteau | COL | RW | $4,000,000 | ||||||
| Pascal Dupuis | PIT | RW | $4,000,000 | ||||||
| Paul Gaustad | NSH | C | $4,000,000 | ||||||
| Rene Bourque | MTL | RW | $4,000,000 | ||||||
| Rob Scuderi | PIT | D | $4,000,000 | ||||||
| Ryan McDonagh | NYR | D | $4,000,000 | ||||||
| Shawn Horcoff | DAL | C | $4,000,000 | ||||||
| Stephen Weiss | DET | C | $4,000,000 | ||||||
| T.J. Oshie | STL | RW | $4,000,000 | ||||||
| Valtteri Filppula | TBL | C | $4,000,000 | ||||||
| Ville Leino | BUF | LW | $4,000,000 | ||||||
| Zach Bogosian | WPG | D | $4,000,000 | ||||||
| Zbynek Michalek | PHX | D | $4,000,000 | ||||||
| Josh Gorges | MTL | D | $3,900,000 | ||||||
| Matt Moulson | MIN | LW | $3,900,000 | ||||||
| Marc Staal | NYR | D | $3,875,000 | ||||||
| Antoine Vermette | PHX | C | $3,750,000 | ||||||
| Brooks Orpik | PIT | D | $3,750,000 | ||||||
| Devan Dubnyk | MTL | G | $3,750,000 | ||||||
| Erik Johnson | COL | D | $3,750,000 | ||||||
| James van Riemsdyk | TOR | LW | $3,750,000 | ||||||
| Martin Erat | PHX | RW | $3,750,000 | ||||||
| Matt Duchene | COL | C | $3,750,000 | ||||||
| Mattias Ohlund | TBL | D | $3,750,000 | ||||||
| P.K. Subban | MTL | D | $3,750,000 | ||||||
| Chris Kunitz | PIT | LW | $3,725,000 | ||||||
| Derick Brassard | NYR | C | $3,700,000 | ||||||
| Brad Stuart | SJS | D | $3,600,000 | ||||||
| Joel Ward | WSH | RW | $3,600,000 | ||||||
| Nick Schultz | EDM | D | $3,600,000 | ||||||
| Troy Brouwer | WSH | RW | $3,600,000 | ||||||
| Alexander Steen | STL | LW | $3,566,667 | ||||||
| Alex Tanguay | COL | LW | $3,500,000 | ||||||
| Bryan Allen | ANA | D | $3,500,000 | ||||||
| Chris Kelly | BOS | C | $3,500,000 | ||||||
| Craig Anderson | OTT | G | $3,500,000 | ||||||
| Daniel Alfredsson | DET | RW | $3,500,000 | ||||||
| David Desharnais | MTL | C | $3,500,000 | ||||||
| David Legwand | DET | C | $3,500,000 | ||||||
| David Perron | EDM | LW | $3,500,000 | ||||||
| Dennis Seidenberg | BOS | D | $3,500,000 | ||||||
| Dustin Brown | LAK | RW | $3,500,000 | ||||||
| Francois Beauchemin | ANA | D | $3,500,000 | ||||||
| Henrik Tallinder | BUF | D | $3,500,000 | ||||||
| Jack Johnson | CBJ | D | $3,500,000 | ||||||
| Kris Letang | PIT | D | $3,500,000 | ||||||
| Lubomir Visnovsky | NYI | D | $3,500,000 | ||||||
| Michael Ryder | NJD | RW | $3,500,000 | ||||||
| Nicklas Grossmann | PHI | D | $3,500,000 | ||||||
| Niklas Hjalmarsson | CHI | D | $3,500,000 | ||||||
| Oliver Ekman-Larsson | PHX | D | $3,500,000 | ||||||
| Ondrej Pavelec | WPG | G | $3,500,000 | ||||||
| Patric Hornqvist | NSH | RW | $3,500,000 | ||||||
| Sami Salo | TBL | D | $3,500,000 | ||||||
| Scottie Upshall | FLA | LW | $3,500,000 | ||||||
| Sheldon Souray | ANA | D | $3,500,000 | ||||||
| Travis Zajac | NJD | C | $3,500,000 | ||||||
| Trevor Daley | DAL | D | $3,500,000 | ||||||
| Tyler Bozak | TOR | C | $3,500,000 | ||||||
| Willie Mitchell | LAK | D | $3,500,000 | ||||||
| Dan Girardi | NYR | D | $3,400,000 | ||||||
| Johnny Boychuk | BOS | D | $3,400,000 | ||||||
| Dave Bolland | TOR | C | $3,375,000 | ||||||
| Rich Peverley | DAL | C | $3,375,000 | ||||||
| Luke Schenn | PHI | D | $3,350,000 | ||||||
| Johnny Oduya | CHI | D | $3,300,000 | ||||||
| Kevin Shattenkirk | STL | D | $3,300,000 | ||||||
| Alexander Edler | VAN | D | $3,250,000 | ||||||
| Andy Greene | NJD | D | $3,250,000 | ||||||
| Barret Jackman | STL | D | $3,250,000 | ||||||
| Bryce Salvador | NJD | D | $3,250,000 | ||||||
| Chris Phillips | OTT | D | $3,250,000 | ||||||
| Clarke MacArthur | OTT | LW | $3,250,000 | ||||||
| Devin Setoguchi | WPG | RW | $3,250,000 | ||||||
| Evgeni Nabokov | NYI | G | $3,250,000 | ||||||
| Jan Hejda | COL | D | $3,250,000 | ||||||
| Jarret Stoll | LAK | C | $3,250,000 | ||||||
| Jonathan Ericsson | DET | D | $3,250,000 | ||||||
| Marc Methot | OTT | D | $3,250,000 | ||||||
| Matt Greene | LAK | D | $3,250,000 | ||||||
| Patrik Berglund | STL | C | $3,250,000 | ||||||
| Steve Ott | STL | C | $3,200,000 | ||||||
| Dainius Zubrus | NJD | RW | $3,100,000 | ||||||
| Roman Polak | STL | D | $3,100,000 | ||||||
| Tyler Ennis | BUF | C | $3,062,500 | ||||||
| Boyd Gordon | EDM | C | $3,000,000 | ||||||
| Bryan Bickell | CHI | LW | $3,000,000 | ||||||
| Cody Hodgson | BUF | C | $3,000,000 | ||||||
| Dmitry Kulikov | FLA | D | $3,000,000 | ||||||
| Jussi Jokinen | PIT | LW | $3,000,000 | ||||||
| Kevin Klein | NYR | D | $3,000,000 | ||||||
| Kyle Brodziak | MIN | C | $3,000,000 | ||||||
| Kyle Okposo | NYI | RW | $3,000,000 | ||||||
| Ladislav Smid | CGY | D | $3,000,000 | ||||||
| Logan Couture | SJS | C | $3,000,000 | ||||||
| Marek Zidlicky | NJD | D | $3,000,000 | ||||||
| Matt Cullen | NSH | C | $3,000,000 | ||||||
| Michael Grabner | NYI | RW | $3,000,000 | ||||||
| Mikael Samuelsson | DET | RW | $3,000,000 | ||||||
| Mikhail Grabovski | WSH | C | $3,000,000 | ||||||
| Nick Foligno | CBJ | LW | $3,000,000 | ||||||
| Nikolay Kulemin | TOR | LW | $3,000,000 | ||||||
| Radim Vrbata | PHX | RW | $3,000,000 | ||||||
| Robyn Regehr | LAK | D | $3,000,000 | ||||||
| Semyon Varlamov | COL | G | $3,000,000 | ||||||
| Tomas Kopecky | FLA | RW | $3,000,000 | ||||||
| Victor Hedman | TBL | D | $3,000,000 | ||||||
| Rostislav Klesla | BUF | D | $2,975,000 | ||||||
| Michael Del Zotto | NSH | D | $2,900,000 | ||||||
| Carl Gunnarsson | TOR | D | $2,850,000 | ||||||
| Stephane Robidas | ANA | D | $2,850,000 | ||||||
| Karl Alzner | WSH | D | $2,800,000 | ||||||
| Steve Downie | PHI | RW | $2,800,000 | ||||||
| Wayne Simmonds | PHI | RW | $2,800,000 | ||||||
| Artem Anisimov | CBJ | C | $2,750,000 | ||||||
| Derek Morris | PHX | D | $2,750,000 | ||||||
| Lee Stempniak | PIT | RW | $2,750,000 | ||||||
| Martin Hanzal | PHX | C | $2,750,000 | ||||||
| Sean Bergenheim | FLA | LW | $2,750,000 | ||||||
| Slava Voynov | LAK | D | $2,750,000 | ||||||
| Brandon Sutter | PIT | C | $2,700,000 | ||||||
| Nazem Kadri | TOR | C | $2,700,000 | ||||||
| Andrew Cogliano | ANA | C | $2,670,000 | ||||||
| Michal Rozsival | CHI | D | $2,650,000 | ||||||
| Karri Ramo | CGY | G | $2,600,000 | ||||||
| Luca Sbisa | ANA | D | $2,600,000 | ||||||
| Brandon Prust | MTL | LW | $2,500,000 | ||||||
| Chris Higgins | VAN | LW | $2,500,000 | ||||||
| Corey Crawford | CHI | G | $2,500,000 | ||||||
| Curtis Glencross | CGY | LW | $2,500,000 | ||||||
| Damien Brunner | NJD | RW | $2,500,000 | ||||||
| Frans Nielsen | NYI | C | $2,500,000 | ||||||
| Kyle Turris | OTT | C | $2,500,000 | ||||||
| Matt Niskanen | PIT | D | $2,500,000 | ||||||
| Matt Stajan | CGY | C | $2,500,000 | ||||||
| Nikita Nikitin | CBJ | D | $2,500,000 | ||||||
| Niklas Backstrom | MIN | G | $2,500,000 | ||||||
| Roman Josi | NSH | D | $2,500,000 | ||||||
| Ryan Malone | TBL | LW | $2,500,000 | ||||||
| Saku Koivu | ANA | C | $2,500,000 | ||||||
| Tim Thomas | DAL | G | $2,500,000 | ||||||
| Viktor Stalberg | NSH | LW | $2,500,000 | ||||||
| Jonathan Bernier | TOR | G | $2,400,000 | ||||||
| Michal Neuvirth | BUF | G | $2,400,000 | ||||||
| Viktor Fasth | EDM | G | $2,400,000 | ||||||
| Ryan Wilson | COL | D | $2,375,000 | ||||||
| Tyler Kennedy | SJS | RW | $2,350,000 | ||||||
| Derek Stepan | NYR | C | $2,300,000 | ||||||
| Mikkel Boedker | PHX | LW | $2,300,000 | ||||||
| Andrew Ference | EDM | D | $2,250,000 | ||||||
| Jordan Leopold | STL | D | $2,250,000 | ||||||
| Ryan Smyth | EDM | LW | $2,250,000 | ||||||
| Anders Lindback | TBL | G | $2,200,000 | ||||||
| Ben Bishop | TBL | G | $2,200,000 | ||||||
| Josh Bailey | NYI | LW | $2,200,000 | ||||||
| Todd Bertuzzi | DET | RW | $2,175,000 | ||||||
| Carl Hagelin | NYR | LW | $2,100,000 | ||||||
| Chris Neil | OTT | RW | $2,100,000 | ||||||
| David Moss | PHX | RW | $2,100,000 | ||||||
| Josh Harding | MIN | G | $2,100,000 | ||||||
| Torrey Mitchell | BUF | C | $2,100,000 | ||||||
| Adam Henrique | NJD | C | $2,000,000 | ||||||
| Alexei Emelin | MTL | D | $2,000,000 | ||||||
| Cal Clutterbuck | NYI | RW | $2,000,000 | ||||||
| Cody Franson | TOR | D | $2,000,000 | ||||||
| Colin Wilson | NSH | C | $2,000,000 | ||||||
| Cory Sarich | COL | D | $2,000,000 | ||||||
| Dustin Penner | WSH | LW | $2,000,000 | ||||||
| Eric Nystrom | NSH | LW | $2,000,000 | ||||||
| Ilya Bryzgalov | MIN | G | $2,000,000 | ||||||
| Jaromir Jagr | NJD | RW | $2,000,000 | ||||||
| Jordin Tootoo | DET | RW | $2,000,000 | ||||||
| Lauri Korpikoski | PHX | LW | $2,000,000 | ||||||
| Maxime Talbot | COL | C | $2,000,000 | ||||||
| Nick Leddy | CHI | D | $2,000,000 | ||||||
| Pierre-Marc Bouchard | CHI | C | $2,000,000 | ||||||
| Ron Hainsey | CAR | D | $2,000,000 | ||||||
| Shane O`Brien | CGY | D | $2,000,000 | ||||||
| Teemu Selanne | ANA | RW | $2,000,000 | ||||||
| Tomas Vokoun | PIT | G | $2,000,000 | ||||||
| John Erskine | WSH | D | $1,925,000 | ||||||
| Brian Elliott | STL | G | $1,900,000 | ||||||
| Jamie McBain | BUF | D | $1,900,000 | ||||||
| Michael Frolik | WPG | RW | $1,900,000 | ||||||
| Adam Burish | SJS | RW | $1,850,000 | ||||||
| Jamie McGinn | COL | LW | $1,850,000 | ||||||
| Matt Hendricks | EDM | C | $1,850,000 | ||||||
| Travis Moen | MTL | LW | $1,850,000 | ||||||
| Marcus Johansson | WSH | C | $1,825,000 | ||||||
| Anton Stralman | NYR | D | $1,800,000 | ||||||
| Brian Boyle | NYR | C | $1,800,000 | ||||||
| Daniel Winnik | ANA | C | $1,800,000 | ||||||
| Jarome Iginla | BOS | RW | $1,800,000 | ||||||
| Jeff Petry | EDM | D | $1,800,000 | ||||||
| Mark Stuart | WPG | D | $1,800,000 | ||||||
| Vernon Fiddler | DAL | C | $1,800,000 | ||||||
| Andrej Sekera | CAR | D | $1,750,000 | ||||||
| Daniel Cleary | DET | RW | $1,750,000 | ||||||
| Darren Helm | DET | C | $1,750,000 | ||||||
| Marcel Goc | PIT | C | $1,750,000 | ||||||
| Raffi Torres | SJS | LW | $1,750,000 | ||||||
| TJ Brodie | CGY | D | $1,750,000 | ||||||
| Braden Holtby | WSH | G | $1,700,000 | ||||||
| Chris Butler | CGY | D | $1,700,000 | ||||||
| Gregory Campbell | BOS | C | $1,700,000 | ||||||
| Jason Chimera | WSH | LW | $1,700,000 | ||||||
| Jiri Tlusty | CAR | LW | $1,700,000 | ||||||
| Ray Emery | PHI | G | $1,650,000 | ||||||
| Shawn Matthias | VAN | C | $1,650,000 | ||||||
| Taylor Pyatt | PIT | LW | $1,650,000 | ||||||
| Aaron Rome | DAL | D | $1,600,000 | ||||||
| Grant Clitsome | WPG | D | $1,600,000 | ||||||
| Jakub Kindl | DET | D | $1,600,000 | ||||||
| James Reimer | TOR | G | $1,600,000 | ||||||
| Jim Slater | WPG | C | $1,600,000 | ||||||
| Justin Abdelkader | DET | LW | $1,550,000 | ||||||
| Adam McQuaid | BOS | D | $1,500,000 | ||||||
| Brenden Morrow | STL | LW | $1,500,000 | ||||||
| Christopher Tanev | VAN | D | $1,500,000 | ||||||
| Douglas Murray | MTL | D | $1,500,000 | ||||||
| Francis Bouillon | MTL | D | $1,500,000 | ||||||
| Jared Cowen | OTT | D | $1,500,000 | ||||||
| Jason Demers | SJS | D | $1,500,000 | ||||||
| Jay Harrison | CAR | D | $1,500,000 | ||||||
| Jay McClement | TOR | C | $1,500,000 | ||||||
| Jean-Sebastien Giguere | COL | G | $1,500,000 | ||||||
| Jonas Gustavsson | DET | G | $1,500,000 | ||||||
| Kris Russell | CGY | D | $1,500,000 | ||||||
| Lars Eller | MTL | C | $1,500,000 | ||||||
| Matt Carkner | NYI | D | $1,500,000 | ||||||
| Matt Cooke | MIN | LW | $1,500,000 | ||||||
| Mikael Backlund | CGY | C | $1,500,000 | ||||||
| Mike Weber | BUF | D | $1,500,000 | ||||||
| Nate Thompson | TBL | C | $1,500,000 | ||||||
| Nick Spaling | NSH | C | $1,500,000 | ||||||
| Ryan Jones | EDM | LW | $1,500,000 | ||||||
| Steve Mason | PHI | G | $1,500,000 | ||||||
| Zack Smith | OTT | C | $1,500,000 | ||||||
| Derek Dorsett | NYR | RW | $1,400,000 | ||||||
| Eric Fehr | WSH | RW | $1,400,000 | ||||||
| Mark Fayne | NJD | D | $1,400,000 | ||||||
| Peter Budaj | MTL | G | $1,400,000 | ||||||
| Drew Miller | DET | LW | $1,350,000 | ||||||
| Kyle Palmieri | ANA | RW | $1,350,000 | ||||||
| Benoit Pouliot | NYR | LW | $1,300,000 | ||||||
| Daniel Paille | BOS | LW | $1,300,000 | ||||||
| Matt Beleskey | ANA | LW | $1,300,000 | ||||||
| Scott Clemmensen | FLA | G | $1,300,000 | ||||||
| Sheldon Brookbank | CHI | D | $1,300,000 | ||||||
| Brendan Smith | DET | D | $1,250,000 | ||||||
| Jhonas Enroth | BUF | G | $1,250,000 | ||||||
| Justin Braun | SJS | D | $1,250,000 | ||||||
| Marcus Kruger | CHI | C | $1,250,000 | ||||||
| Mark Fraser | TOR | D | $1,250,000 | ||||||
| Patrick Kaleta | BUF | RW | $1,250,000 | ||||||
| Raphael Diaz | NYR | D | $1,250,000 | ||||||
| T.J. Galiardi | CGY | LW | $1,250,000 | ||||||
| Travis Hamonic | NYI | D | $1,250,000 | ||||||
| Ben Eager | EDM | LW | $1,200,000 | ||||||
| Erik Condra | OTT | RW | $1,200,000 | ||||||
| Mark Letestu | CBJ | C | $1,200,000 | ||||||
| Mike Rupp | MIN | LW | $1,200,000 | ||||||
| Patrick Eaves | NSH | RW | $1,200,000 | ||||||
| B.J. Crombeen | TBL | RW | $1,150,000 | ||||||
| Brad Richardson | VAN | RW | $1,150,000 | ||||||
| Cody McLeod | COL | LW | $1,150,000 | ||||||
| Jared Boll | CBJ | RW | $1,150,000 | ||||||
| Mats Zuccarello | NYR | RW | $1,150,000 | ||||||
| Philip Larsen | EDM | D | $1,150,000 | ||||||
| Cam Atkinson | CBJ | RW | $1,125,000 | ||||||
| Alec Martinez | LAK | D | $1,100,000 | ||||||
| David Schlemko | PHX | RW | $1,100,000 | ||||||
| Jannik Hansen | VAN | RW | $1,100,000 | ||||||
| John Mitchell | COL | C | $1,100,000 | ||||||
| Mathieu Perreault | ANA | C | $1,100,000 | ||||||
| Mike Weaver | MTL | D | $1,100,000 | ||||||
| Patrick Wiercioch | OTT | D | $1,100,000 | ||||||
| Shawn Thornton | BOS | LW | $1,100,000 | ||||||
| Tanner Glass | PIT | LW | $1,100,000 | ||||||
| Ben Lovejoy | ANA | D | $1,000,000 | ||||||
| Blake Comeau | CBJ | LW | $1,000,000 | ||||||
| Brad Boyes | FLA | RW | $1,000,000 | ||||||
| Carl Soderberg | BOS | C | $1,000,000 | ||||||
| Cody McCormick | MIN | C | $1,000,000 | ||||||
| Derek MacKenzie | CBJ | C | $1,000,000 | ||||||
| Dominic Moore | NYR | C | $1,000,000 | ||||||
| Erik Gustafsson | PHI | D | $1,000,000 | ||||||
| Jacob Markstrom | VAN | G | $1,000,000 | ||||||
| Jake Muzzin | LAK | D | $1,000,000 | ||||||
| Jason LaBarbera | CHI | G | $1,000,000 | ||||||
| Jay Beagle | WSH | RW | $1,000,000 | ||||||
| Jeremy Welsh | VAN | C | $1,000,000 | ||||||
| Magnus Paajarvi | STL | LW | $1,000,000 | ||||||
| Mason Raymond | TOR | LW | $1,000,000 | ||||||
| Matt Martin | NYI | LW | $1,000,000 | ||||||
| Matt Read | PHI | RW | $1,000,000 | ||||||
| Maxim Lapierre | STL | C | $1,000,000 | ||||||
| Michal Handzus | CHI | C | $1,000,000 | ||||||
| Patrick Bordeleau | COL | LW | $1,000,000 | ||||||
| Paul Ranger | TOR | D | $1,000,000 | ||||||
| Zenon Konopka | BUF | C | $1,000,000 | ||||||
| Justin Falk | NYR | D | $975,000 | ||||||
| Keith Aulie | TBL | D | $975,000 | ||||||
| Colin Greening | OTT | LW | $950,000 | ||||||
| George Parros | MTL | RW | $950,000 | ||||||
| Kyle Clifford | LAK | LW | $950,000 | ||||||
| Adam Larsson | NJD | D | $925,000 | ||||||
| Aleksander Barkov | FLA | C | $925,000 | ||||||
| Alex Galchenyuk | MTL | C | $925,000 | ||||||
| Andrej Sustr | TBL | D | $925,000 | ||||||
| Anton Belov | EDM | D | $925,000 | ||||||
| Antti Raanta | CHI | G | $925,000 | ||||||
| Cody Ceci | OTT | D | $925,000 | ||||||
| Colton Orr | TOR | RW | $925,000 | ||||||
| Connor Murphy | PHX | D | $925,000 | ||||||
| Cory Conacher | BUF | LW | $925,000 | ||||||
| Danny DeKeyser | DET | D | $925,000 | ||||||
| Dougie Hamilton | BOS | D | $925,000 | ||||||
| Elias Lindholm | CAR | C | $925,000 | ||||||
| Filip Forsberg | NSH | C | $925,000 | ||||||
| Frederik Andersen | ANA | G | $925,000 | ||||||
| Gabriel Landeskog | COL | LW | $925,000 | ||||||
| Hampus Lindholm | ANA | D | $925,000 | ||||||
| J.T. Miller | NYR | C | $925,000 | ||||||
| Jacob Trouba | WPG | D | $925,000 | ||||||
| Jayson Megna | PIT | RW | $925,000 | ||||||
| Joey MacDonald | CGY | G | $925,000 | ||||||
| Jonas Brodin | MIN | D | $925,000 | ||||||
| Jonathan Huberdeau | FLA | LW | $925,000 | ||||||
| Justin Schultz | EDM | D | $925,000 | ||||||
| Matt Dumba | MIN | D | $925,000 | ||||||
| Mika Zibanejad | OTT | C | $925,000 | ||||||
| Mikhail Grigorenko | BUF | C | $925,000 | ||||||
| Morgan Rielly | TOR | D | $925,000 | ||||||
| Nail Yakupov | EDM | RW | $925,000 | ||||||
| Nate Schmidt | WSH | D | $925,000 | ||||||
| Nathan MacKinnon | COL | C | $925,000 | ||||||
| Olli Maatta | PIT | D | $925,000 | ||||||
| Rasmus Ristolainen | BUF | D | $925,000 | ||||||
| Ryan Murphy | CAR | D | $925,000 | ||||||
| Ryan Nugent-Hopkins | EDM | C | $925,000 | ||||||
| Ryan Strome | NYI | C | $925,000 | ||||||
| Sean Couturier | PHI | C | $925,000 | ||||||
| Sean Monahan | CGY | C | $925,000 | ||||||
| Seth Jones | NSH | D | $925,000 | ||||||
| Sven Baertschi | CGY | LW | $925,000 | ||||||
| Tom Wilson | WSH | RW | $925,000 | ||||||
| Tomas Hertl | SJS | C | $925,000 | ||||||
| Valeri Nichushkin | DAL | RW | $925,000 | ||||||
| Zemgus Girgensons | BUF | C | $925,000 | ||||||
| Alex Chiasson | DAL | RW | $900,000 | ||||||
| Andre Benoit | COL | D | $900,000 | ||||||
| Anton Lander | EDM | C | $900,000 | ||||||
| Beau Bennett | PIT | RW | $900,000 | ||||||
| Brenden Dillon | DAL | D | $900,000 | ||||||
| Brett Connolly | TBL | RW | $900,000 | ||||||
| Brock Nelson | NYI | C | $900,000 | ||||||
| Casey Cizikas | NYI | C | $900,000 | ||||||
| Charlie Coyle | MIN | C | $900,000 | ||||||
| Chris Kreider | NYR | LW | $900,000 | ||||||
| Chris Thorburn | WPG | RW | $900,000 | ||||||
| Darcy Kuemper | MIN | G | $900,000 | ||||||
| Emerson Etem | ANA | RW | $900,000 | ||||||
| Erik Gudbranson | FLA | D | $900,000 | ||||||
| Erik Haula | MIN | C | $900,000 | ||||||
| Jaden Schwartz | STL | LW | $900,000 | ||||||
| Jakob Silfverberg | ANA | RW | $900,000 | ||||||
| Jason Zucker | MIN | LW | $900,000 | ||||||
| Jesse Joensuu | EDM | LW | $900,000 | ||||||
| Joe Corvo | OTT | D | $900,000 | ||||||
| Linden Vey | LAK | RW | $900,000 | ||||||
| Marco Scandella | MIN | D | $900,000 | ||||||
| Marcus Foligno | BUF | LW | $900,000 | ||||||
| Mark Fistric | ANA | D | $900,000 | ||||||
| Mark Pysyk | BUF | D | $900,000 | ||||||
| Matt Frattin | CBJ | RW | $900,000 | ||||||
| Matt Irwin | SJS | D | $900,000 | ||||||
| Mattias Ekholm | NSH | D | $900,000 | ||||||
| Mikael Granlund | MIN | C | $900,000 | ||||||
| Nick Bjugstad | FLA | C | $900,000 | ||||||
| Patrick Dwyer | CAR | RW | $900,000 | ||||||
| Reilly Smith | BOS | RW | $900,000 | ||||||
| Ryan Whitney | FLA | D | $900,000 | ||||||
| Sami Vatanen | ANA | D | $900,000 | ||||||
| Scott Gomez | FLA | C | $900,000 | ||||||
| Tom Gilbert | FLA | D | $900,000 | ||||||
| Vladimir Tarasenko | STL | RW | $900,000 | ||||||
| Justin Faulk | CAR | D | $890,000 | ||||||
| Aaron Ness | NYI | D | $875,000 | ||||||
| Alex Killorn | TBL | C | $875,000 | ||||||
| Jake Gardiner | TOR | D | $875,000 | ||||||
| Matt Donovan | NYI | D | $875,000 | ||||||
| J.T. Brown | TBL | RW | $874,125 | ||||||
| Daniel Carcillo | NYR | LW | $850,000 | ||||||
| Eddie Lack | VAN | G | $850,000 | ||||||
| Gustav Nyquist | DET | RW | $850,000 | ||||||
| Matt Calvert | CBJ | LW | $850,000 | ||||||
| Nate Prosser | MIN | D | $850,000 | ||||||
| Reto Berra | COL | G | $850,000 | ||||||
| Tommy Wingels | SJS | C | $850,000 | ||||||
| Brandon Saad | CHI | LW | $842,500 | ||||||
| Jon Merrill | NJD | D | $840,000 | ||||||
| Tyler Johnson | TBL | C | $840,000 | ||||||
| Tyson Barrie | COL | D | $840,000 | ||||||
| James Sheppard | SJS | LW | $830,000 | ||||||
| Colin Fraser | LAK | C | $825,000 | ||||||
| Stephane Da Costa | OTT | C | $825,000 | ||||||
| Ryan Spooner | BOS | C | $815,000 | ||||||
| Brayden Schenn | PHI | C | $810,000 | ||||||
| Calvin de Haan | NYI | D | $810,000 | ||||||
| Carter Ashton | TOR | RW | $810,000 | ||||||
| Dylan Olsen | FLA | D | $810,000 | ||||||
| Jerry D`Amigo | TOR | RW | $810,000 | ||||||
| John Moore | NYR | D | $810,000 | ||||||
| Nino Niederreiter | MIN | RW | $810,000 | ||||||
| Peter Holland | TOR | C | $810,000 | ||||||
| Robin Lehner | OTT | G | $810,000 | ||||||
| Ryan Ellis | NSH | D | $810,000 | ||||||
| Ryan Johansen | CBJ | C | $810,000 | ||||||
| Simon Despres | PIT | D | $810,000 | ||||||
| Zack Kassian | VAN | RW | $810,000 | ||||||
| Anton Khudobin | CAR | G | $800,000 | ||||||
| Corey Potter | BOS | D | $800,000 | ||||||
| Dan Ellis | FLA | G | $800,000 | ||||||
| Kyle Chipchura | PHX | C | $800,000 | ||||||
| Michael Stone | PHX | D | $800,000 | ||||||
| Peter Harrold | NJD | D | $800,000 | ||||||
| Ryan Carter | NJD | LW | $800,000 | ||||||
| Michael Raffl | PHI | LW | $792,500 | ||||||
| Johan Larsson | BUF | LW | $790,000 | ||||||
| Richard Panik | TBL | RW | $790,000 | ||||||
| Derek Smith | CGY | D | $775,000 | ||||||
| Steve Bernier | NJD | RW | $775,000 | ||||||
| Boone Jenner | CBJ | C | $767,500 | ||||||
| Tyler Toffoli | LAK | C | $765,000 | ||||||
| Andrew Desjardins | SJS | C | $750,000 | ||||||
| Brian McGrattan | CGY | RW | $750,000 | ||||||
| Dale Weise | MTL | RW | $750,000 | ||||||
| Dwight King | LAK | LW | $750,000 | ||||||
| Ian Cole | STL | D | $750,000 | ||||||
| John Scott | BUF | LW | $750,000 | ||||||
| Kevin Westgarth | CGY | RW | $750,000 | ||||||
| Krys Barch | FLA | RW | $750,000 | ||||||
| Paul Bissonnette | PHX | LW | $750,000 | ||||||
| Peter Regin | CHI | C | $750,000 | ||||||
| Thomas Greiss | PHX | G | $750,000 | ||||||
| Zac Rinaldo | PHI | C | $750,000 | ||||||
| Dmitrij Jaskin | STL | RW | $742,500 | ||||||
| Dmitry Orlov | WSH | D | $740,000 | ||||||
| Riley Sheahan | DET | C | $740,000 | ||||||
| Brad Malone | COL | C | $735,000 | ||||||
| Keaton Ellerby | WPG | D | $735,000 | ||||||
| Alexander Sulzer | BUF | D | $725,000 | ||||||
| Andrei Loktionov | CAR | C | $725,000 | ||||||
| Gabriel Bourque | NSH | LW | $725,000 | ||||||
| Jacob Josefson | NJD | C | $725,000 | ||||||
| Mike Brown | SJS | RW | $725,000 | ||||||
| Tomas Jurco | DET | RW | $717,500 | ||||||
| Brendan Gallagher | MTL | RW | $715,000 | ||||||
| David Savard | CBJ | D | $709,275 | ||||||
| Craig Adams | PIT | RW | $700,000 | ||||||
| Dalton Prout | CBJ | D | $700,000 | ||||||
| David Rundblad | CHI | D | $700,000 | ||||||
| Frazer McLaren | TOR | LW | $700,000 | ||||||
| Jack Hillen | WSH | D | $700,000 | ||||||
| Jeff Schultz | LAK | D | $700,000 | ||||||
| Joakim Andersson | DET | C | $700,000 | ||||||
| Jordan Nolan | LAK | C | $700,000 | ||||||
| Matt Gilroy | FLA | D | $700,000 | ||||||
| Mike Komisarek | CAR | D | $700,000 | ||||||
| Nick Bonino | ANA | C | $700,000 | ||||||
| Ryan White | MTL | C | $700,000 | ||||||
| Tim Kennedy | PHX | LW | $700,000 | ||||||
| Matt Nieto | SJS | LW | $692,500 | ||||||
| Nikita Kucherov | TBL | RW | $692,500 | ||||||
| Devante Smith-Pelly | ANA | RW | $690,000 | ||||||
| Martin Marincin | EDM | D | $690,000 | ||||||
| Michael Bournival | MTL | LW | $690,000 | ||||||
| Jimmy Hayes | FLA | RW | $687,500 | ||||||
| Will Acton | EDM | C | $680,000 | ||||||
| Jay Rosehill | PHI | LW | $675,000 | ||||||
| Andrew Alberts | VAN | D | $650,000 | ||||||
| Brian Lashoff | DET | D | $650,000 | ||||||
| Chris Porter | STL | LW | $650,000 | ||||||
| Eric Gelinas | NJD | D | $650,000 | ||||||
| Eric Tangradi | WPG | LW | $650,000 | ||||||
| James Wright | WPG | C | $650,000 | ||||||
| Matt Halischuk | WPG | RW | $650,000 | ||||||
| Matthew Bartkowski | BOS | D | $650,000 | ||||||
| Tom Sestito | VAN | LW | $650,000 | ||||||
| Tomas Tatar | DET | LW | $650,000 | ||||||
| Yannick Weber | VAN | D | $650,000 | ||||||
| Paul Byron | CGY | C | $645,000 | ||||||
| Blair Jones | CGY | C | $643,500 | ||||||
| Reid Boucher | NJD | RW | $642,500 | ||||||
| Jordan Caron | BOS | RW | $640,000 | ||||||
| Jordan Szwarz | PHX | RW | $638,354 | ||||||
| Luke Gazdic | EDM | LW | $635,000 | ||||||
| Connor Carrick | WSH | D | $630,000 | ||||||
| Eric O`Dell | WPG | C | $630,000 | ||||||
| Alex Stalock | SJS | G | $625,000 | ||||||
| Antoine Roussel | DAL | LW | $625,000 | ||||||
| Ben Scrivens | EDM | D | $625,000 | ||||||
| Brian Flynn | BUF | C | $625,000 | ||||||
| Brian Strait | NYI | D | $625,000 | ||||||
| Dustin Jeffrey | DAL | C | $625,000 | ||||||
| Matt Fraser | BOS | RW | $625,000 | ||||||
| Tim Jackman | ANA | RW | $612,500 | ||||||
| Marek Mazanec | NSH | G | $610,000 | ||||||
| Jean-Gabriel Pageau | OTT | C | $605,000 | ||||||
| Mark Barberio | TBL | D | $605,000 | ||||||
| Al Montoya | WPG | G | $601,000 | ||||||
| Adam Cracknell | STL | RW | $600,000 | ||||||
| Adam Hall | PHI | RW | $600,000 | ||||||
| Adam Pardy | WPG | D | $600,000 | ||||||
| Ben Street | CGY | C | $600,000 | ||||||
| Brandon Pirri | CHI | C | $600,000 | ||||||
| Brandon Pirri | FLA | C | $600,000 | ||||||
| Brett Bellemore | CAR | D | $600,000 | ||||||
| Chad Johnson | BOS | G | $600,000 | ||||||
| Colin McDonald | NYI | RW | $600,000 | ||||||
| Curtis McElhinney | CBJ | G | $600,000 | ||||||
| Drayson Bowman | CAR | LW | $600,000 | ||||||
| Eric Gryba | OTT | D | $600,000 | ||||||
| Jeff Halpern | PHX | C | $600,000 | ||||||
| Joe Colborne | CGY | C | $600,000 | ||||||
| Jordan Schroeder | VAN | C | $600,000 | ||||||
| Jordie Benn | DAL | D | $600,000 | ||||||
| Justin Fontaine | MIN | RW | $600,000 | ||||||
| Kevin Connauton | DAL | D | $600,000 | ||||||
| Linus Omark | BUF | LW | $600,000 | ||||||
| Manny Malhotra | CAR | C | $600,000 | ||||||
| Mark Arcobello | EDM | C | $600,000 | ||||||
| Matt Kassian | OTT | LW | $600,000 | ||||||
| Nick Holden | COL | D | $600,000 | ||||||
| Radek Dvorak | CAR | RW | $600,000 | ||||||
| Radek Martinek | NYI | D | $600,000 | ||||||
| Rob Klinkhammer | PHX | LW | $600,000 | ||||||
| Ryan Garbutt | DAL | LW | $600,000 | ||||||
| Ryan Reaves | STL | RW | $600,000 | ||||||
| Stephane Veilleux | MIN | LW | $600,000 | ||||||
| Stephen Gionta | NJD | C | $600,000 | ||||||
| Thomas Hickey | NYI | D | $600,000 | ||||||
| Tom Pyatt | TBL | C | $600,000 | ||||||
| Troy Bodie | TOR | RW | $600,000 | ||||||
| Victor Bartley | NSH | D | $600,000 | ||||||
| Andrew Shaw | CHI | C | $580,000 | ||||||
| Corey Tropp | CBJ | RW | $577,500 | ||||||
| Kevin Poulin | NYI | G | $577,500 | ||||||
| Lance Bouma | CGY | LW | $577,500 | ||||||
| Andrew MacDonald | PHI | D | $575,000 | ||||||
| Brandon Bollig | CHI | LW | $575,000 | ||||||
| Joe Vitale | PIT | C | $575,000 | ||||||
| Luke Glendening | DET | C | $575,000 | ||||||
| Patrick Maroon | ANA | LW | $575,000 | ||||||
| Radko Gudas | TBL | D | $575,000 | ||||||
| Aaron Volpatti | WSH | LW | $550,000 | ||||||
| Anthony Peluso | WPG | RW | $550,000 | ||||||
| Bracken Kearns | SJS | LW | $550,000 | ||||||
| Brian Gibbons | PIT | C | $550,000 | ||||||
| Cam Janssen | NJD | RW | $550,000 | ||||||
| Cam Talbot | NYR | G | $550,000 | ||||||
| Carlo Colaiacovo | STL | D | $550,000 | ||||||
| Carter Hutton | NSH | G | $550,000 | ||||||
| Chris VandeVelde | PHI | C | $550,000 | ||||||
| Chuck Kobasew | PIT | RW | $550,000 | ||||||
| Cody Eakin | DAL | C | $550,000 | ||||||
| Cory Emmerton | DET | C | $550,000 | ||||||
| Eric Boulton | NYI | LW | $550,000 | ||||||
| Jeff Zatkoff | PIT | G | $550,000 | ||||||
| Jerred Smithson | TOR | C | $550,000 | ||||||
| Justin Peters | CAR | G | $550,000 | ||||||
| Kevan Miller | BOS | D | $550,000 | ||||||
| Kevin Porter | BUF | C | $550,000 | ||||||
| Marc-Andre Cliche | COL | C | $550,000 | ||||||
| Martin Jones | LAK | G | $550,000 | ||||||
| Matt D`Agostini | BUF | RW | $550,000 | ||||||
| Matt Ellis | BUF | LW | $550,000 | ||||||
| Mike Santorelli | VAN | C | $550,000 | ||||||
| Nathan Gerbe | CAR | LW | $550,000 | ||||||
| Rich Clune | NSH | LW | $550,000 | ||||||
| Riley Nash | CAR | C | $550,000 | ||||||
| Robert Bortuzzo | PIT | D | $550,000 | ||||||
| Trevor Smith | TOR | C | $550,000 | ||||||
| Zac Dalpe | VAN | C | $550,000 | ||||||
| Nate Guenin | COL | D | $525,000 |
Hot Dog Price Sensitivity Meter
| The Chicago Blackhawks want to know how much to charge for a new gourmet hot dog at their concession stands. They have hired you to analyze data and report your findings. Construct a Van Westendorp price sensitivity meter (PSM) using the survey results below to find: 1. the indifference price point 2. the point of marginal cheapness 3. the point of marginal expensiveness 4. the optimal price point. | |||
| * Please use an interval size of $1.00 * | |||
| Considered Expensive | Considered Cheap | Expensive beyond consideration | Cheap beyond consideration |
| $8.00 | $5.00 | $10.00 | $1.00 |
| $7.00 | $5.00 | $10.00 | $3.00 |
| $6.00 | $3.00 | $7.00 | $2.00 |
| $5.00 | $4.00 | $6.00 | $2.00 |
| $6.00 | $4.00 | $7.00 | $3.00 |
| $9.00 | $5.00 | $10.00 | $2.00 |
| $6.00 | $4.00 | $8.00 | $2.00 |
| $8.00 | $5.00 | $10.00 | $2.00 |
| $9.00 | $4.00 | $12.00 | $1.00 |
| $6.00 | $3.00 | $9.00 | $2.00 |
| $7.00 | $4.00 | $8.00 | $3.00 |
| $6.25 | $3.00 | $7.50 | $3.00 |
| $7.00 | $4.00 | $9.00 | $3.00 |
| $8.00 | $4.00 | $9.00 | $3.00 |
| $9.00 | $4.50 | $9.50 | $4.00 |
| $8.00 | $5.00 | $9.00 | $3.00 |
| $7.00 | $4.00 | $8.00 | $3.00 |
| $7.00 | $4.50 | $8.00 | $3.50 |
| $6.00 | $4.00 | $7.00 | $3.00 |
| $7.00 | $4.00 | $7.50 | $3.00 |
| $7.50 | $3.50 | $9.00 | $3.00 |
| $8.00 | $4.00 | $8.00 | $3.00 |
| $6.50 | $3.50 | $7.00 | $2.00 |
| $8.00 | $4.00 | $9.50 | $2.00 |
| $5.00 | $4.00 | $9.00 | $2.00 |
| $8.00 | $5.50 | $8.00 | $3.50 |
| $7.00 | $5.00 | $7.50 | $4.00 |
| $7.50 | $5.50 | $9.00 | $4.75 |
| $7.75 | $5.75 | $7.75 | $5.00 |
| $8.00 | $4.00 | $10.00 | $2.00 |
| $7.00 | $4.00 | $8.50 | $3.00 |
| $8.00 | $5.00 | $9.00 | $3.00 |
| $9.00 | $5.00 | $9.50 | $4.00 |
| $7.00 | $4.00 | $8.00 | $2.00 |
| $9.00 | $5.00 | $10.50 | $4.00 |
| $8.00 | $3.00 | $9.00 | $2.00 |
| $7.50 | $4.00 | $8.00 | $3.00 |
| $9.00 | $6.00 | $11.00 | $5.00 |
| $9.00 | $4.00 | $11.00 | $2.00 |
| $10.00 | $5.00 | $13.00 | $3.00 |
| $8.00 | $5.00 | $10.00 | $3.00 |
| $10.50 | $6.50 | $15.50 | $5.00 |
| $10.25 | $5.00 | $12.00 | $3.50 |
| $12.00 | $5.00 | $15.00 | $3.00 |
| $12.00 | $5.00 | $15.00 | $3.00 |
| $7.50 | $5.50 | $10.00 | $4.00 |
| $7.00 | $3.50 | $10.00 | $1.50 |
| $8.00 | $5.00 | $12.00 | $3.00 |
| $9.00 | $5.00 | $10.00 | $3.00 |
| $10.00 | $3.00 | $11.00 | $1.00 |
| $8.00 | $4.00 | $15.00 | $2.50 |
| $8.00 | $5.00 | $9.00 | $3.00 |
| $9.00 | $7.00 | $12.00 | $3.00 |
| $9.00 | $7.00 | $12.00 | $3.00 |
| $10.00 | $6.00 | $12.00 | $3.00 |
| $15.00 | $8.00 | $20.00 | $4.00 |
| $8.00 | $6.00 | $10.00 | $4.00 |
| $8.00 | $5.00 | $10.00 | $3.00 |
| $8.00 | $5.00 | $10.00 | $3.00 |
| $9.50 | $5.00 | $12.00 | $3.00 |
| $9.00 | $5.00 | $15.00 | $2.50 |
| $10.00 | $6.00 | $15.00 | $4.00 |
| $8.00 | $2.50 | $10.00 | $1.50 |
| $7.00 | $4.00 | $11.00 | $2.00 |
| $9.00 | $5.00 | $13.00 | $3.00 |
| $6.00 | $5.00 | $9.00 | $2.50 |
| $8.00 | $3.00 | $12.00 | $1.00 |
| $7.00 | $4.00 | $9.00 | $4.00 |
| $8.00 | $3.00 | $12.00 | $1.00 |
| $5.00 | $4.00 | $9.00 | $2.00 |
| $8.00 | $5.00 | $12.00 | $3.00 |
| $5.00 | $4.00 | $7.00 | $4.00 |
| $5.00 | $2.50 | $6.00 | $2.25 |
| $6.00 | $3.00 | $7.00 | $1.50 |
| $10.00 | $5.00 | $11.00 | $4.50 |
| $6.00 | $2.00 | $7.00 | $1.00 |
| $2.00 | $1.00 | $5.00 | $0.50 |
| $6.00 | $4.00 | $10.00 | $1.00 |
| $6.00 | $3.00 | $8.00 | $1.00 |
| $7.00 | $4.50 | $8.00 | $3.00 |
| $7.00 | $4.00 | $8.00 | $2.00 |
| $8.00 | $5.00 | $15.00 | $2.50 |
| $8.00 | $4.00 | $10.00 | $3.00 |
| $7.00 | $4.00 | $10.00 | $3.00 |
| $8.00 | $3.00 | $10.00 | $1.50 |
| $8.00 | $5.00 | $11.00 | $4.00 |
| $8.00 | $5.00 | $11.00 | $4.00 |
| $9.50 | $4.50 | $10.50 | $3.50 |
| $8.00 | $4.00 | $10.00 | $3.00 |
| $7.00 | $5.00 | $8.00 | $3.00 |
| $9.50 | $4.50 | $10.50 | $2.50 |
| $8.25 | $3.50 | $9.00 | $2.50 |
| $9.00 | $4.00 | $10.00 | $3.00 |
| $7.00 | $3.00 | $8.00 | $2.00 |
| $7.00 | $4.00 | $8.00 | $2.00 |
| $8.00 | $4.00 | $9.00 | $3.00 |
| $7.00 | $4.00 | $9.00 | $2.00 |
| $6.00 | $4.00 | $8.00 | $2.00 |
| $7.00 | $3.00 | $8.00 | $2.00 |
| $8.00 | $5.00 | $9.00 | $4.00 |
| $6.00 | $4.00 | $8.00 | $3.00 |
| $9.00 | $5.00 | $10.00 | $3.00 |
| $9.00 | $6.00 | $10.00 | $4.00 |
| $8.00 | $5.00 | $10.00 | $4.00 |
| $9.00 | $6.00 | $10.00 | $3.50 |
| $9.00 | $5.00 | $10.00 | $4.00 |
| $8.00 | $4.00 | $12.00 | $2.00 |
| $9.00 | $5.00 | $15.00 | $1.00 |
| $9.00 | $3.00 | $11.00 | $2.00 |
| $8.00 | $5.00 | $10.00 | $3.00 |
| $10.00 | $6.00 | $15.00 | $4.00 |
| $10.00 | $5.00 | $13.00 | $3.00 |
| $9.00 | $4.00 | $11.00 | $2.00 |
| $10.00 | $5.00 | $13.00 | $3.00 |
| $11.00 | $5.00 | $14.00 | $4.00 |
| $7.00 | $4.00 | $9.00 | $2.00 |
| $6.00 | $4.00 | $8.00 | $2.50 |
| $5.50 | $3.50 | $8.00 | $1.50 |
| $6.00 | $4.50 | $7.00 | $2.00 |
| $7.00 | $4.00 | $7.50 | $2.00 |
| $5.50 | $2.50 | $6.00 | $1.99 |
| $6.00 | $4.00 | $8.00 | $2.50 |
| $6.00 | $3.99 | $7.99 | $2.00 |
| $5.00 | $4.00 | $6.00 | $2.00 |
| $6.00 | $3.00 | $7.00 | $2.50 |
| $8.00 | $4.00 | $8.50 | $3.00 |
| $7.00 | $3.50 | $8.00 | $3.00 |
| $6.00 | $3.00 | $8.00 | $2.00 |
| $8.50 | $5.50 | $10.00 | $3.00 |
| $8.25 | $4.25 | $9.25 | $1.25 |
| $8.00 | $4.00 | $8.00 | $3.00 |
| $4.00 | $3.00 | $6.00 | $1.50 |
| $6.00 | $4.00 | $8.00 | $3.50 |
| $7.00 | $5.00 | $10.00 | $2.50 |
| $6.00 | $4.00 | $7.00 | $2.50 |
| $6.00 | $4.00 | $7.00 | $2.00 |
| $9.00 | $3.50 | $10.00 | $3.00 |
| $7.00 | $4.00 | $8.00 | $3.00 |
| $7.00 | $3.00 | $8.00 | $2.50 |
| $5.99 | $4.99 | $10.99 | $1.99 |
| $6.00 | $4.00 | $10.00 | $2.00 |
| $4.00 | $2.00 | $6.00 | $0.50 |
| $5.00 | $3.50 | $5.00 | $2.00 |
| $8.00 | $4.00 | $9.00 | $0.00 |
| $6.00 | $4.50 | $8.00 | $3.00 |
| $6.00 | $4.50 | $8.00 | $3.00 |
| $6.00 | $4.50 | $7.00 | $3.50 |
| $7.50 | $5.00 | $10.00 | $4.00 |
| $7.00 | $5.00 | $9.00 | $3.00 |
| $8.00 | $4.00 | $9.00 | $3.00 |
| $7.00 | $4.50 | $8.50 | $3.00 |
| $7.00 | $3.00 | $8.00 | $2.00 |
| $8.00 | $4.00 | $10.00 | $3.00 |
| $8.00 | $3.00 | $9.00 | $2.00 |
| $7.00 | $2.00 | $8.00 | $2.00 |
| $7.00 | $5.00 | $20.00 | $3.50 |
| $9.00 | $5.00 | $13.00 | $0.50 |
| $10.00 | $1.50 | $12.00 | $1.00 |
| $10.00 | $3.00 | $15.00 | $2.50 |
| $9.50 | $1.50 | $13.00 | $1.00 |
| $8.00 | $2.00 | $10.00 | $1.00 |
| $6.00 | $3.00 | $10.00 | $2.00 |
| $10.00 | $4.00 | $12.00 | $1.00 |
| $7.00 | $3.00 | $10.00 | $1.00 |
| $8.00 | $3.00 | $10.00 | $1.00 |
| $8.00 | $3.00 | $9.00 | $2.00 |
| $9.00 | $4.00 | $10.50 | $2.00 |
| $8.50 | $3.50 | $10.00 | $2.00 |
| $10.00 | $5.00 | $12.00 | $3.00 |
| $9.00 | $3.00 | $10.00 | $2.00 |
| $6.45 | $2.95 | $9.95 | $1.75 |
| $4.99 | $3.99 | $5.99 | $1.99 |
| $6.00 | $4.00 | $7.00 | $3.00 |
| $5.99 | $2.99 | $7.99 | $1.99 |
| $5.00 | $3.00 | $7.00 | $2.00 |
| $6.00 | $4.00 | $8.00 | $2.00 |
| $5.50 | $4.25 | $7.25 | $3.75 |
| $6.00 | $4.50 | $8.00 | $0.00 |
| $6.50 | $4.00 | $7.50 | $2.50 |
| $7.50 | $4.00 | $10.00 | $1.00 |
| $6.00 | $4.00 | $10.00 | $2.00 |
| $7.00 | $4.00 | $10.00 | $2.00 |
| $7.00 | $6.00 | $9.00 | $3.00 |
| $6.00 | $4.00 | $8.00 | $3.00 |
| $6.50 | $3.00 | $8.00 | $2.50 |
| $7.00 | $4.00 | $10.00 | $2.00 |
| $6.00 | $5.00 | $9.00 | $2.00 |
| $7.00 | $4.00 | $9.00 | $1.00 |
| $10.00 | $7.00 | $15.00 | $4.00 |
| $6.00 | $4.00 | $9.00 | $2.00 |
| $6.00 | $3.00 | $10.00 | $1.00 |
| $5.00 | $4.00 | $6.00 | $3.00 |
| $5.00 | $3.00 | $7.00 | $1.00 |
| $7.50 | $5.00 | $10.00 | $2.50 |
| $8.00 | $4.00 | $9.00 | $3.00 |
| $9.00 | $5.00 | $10.00 | $3.00 |
| $6.00 | $3.50 | $8.00 | $1.00 |
| $10.00 | $5.00 | $10.00 | $3.00 |
| $6.00 | $4.00 | $8.00 | $2.50 |
| $5.00 | $3.00 | $7.00 | $2.00 |
| $8.00 | $5.00 | $12.00 | $3.00 |
| $11.50 | $6.50 | $16.00 | $4.50 |
| $9.00 | $6.00 | $11.00 | $4.00 |
| $9.00 | $6.00 | $11.00 | $4.00 |
| $11.00 | $6.50 | $15.00 | $4.00 |
| $10.00 | $7.50 | $14.00 | $2.00 |
| $11.00 | $7.00 | $15.00 | $3.00 |
| $12.00 | $7.00 | $14.00 | $3.00 |
| $11.25 | $7.50 | $13.00 | $3.00 |
| $11.50 | $6.25 | $12.50 | $3.00 |
| $6.00 | $4.00 | $8.00 | $2.00 |
| $7.00 | $3.00 | $10.00 | $2.00 |
| $9.00 | $5.00 | $11.00 | $3.00 |
| $7.00 | $5.00 | $11.00 | $4.00 |
| $8.00 | $4.00 | $11.00 | $3.00 |
| $9.00 | $4.50 | $12.00 | $2.00 |
| $7.00 | $5.00 | $10.00 | $4.00 |
| $8.00 | $4.00 | $9.50 | $3.00 |
| $8.00 | $5.00 | $11.00 | $3.00 |
| $8.50 | $5.00 | $10.00 | $3.50 |
| $6.00 | $2.00 | $8.00 | $0.50 |
| $10.00 | $4.00 | $15.00 | $2.00 |
| $8.00 | $3.00 | $10.00 | $1.50 |
| $10.00 | $3.00 | $20.00 | $1.00 |
| $10.00 | $3.00 | $12.00 | $1.00 |
| $7.00 | $3.00 | $10.00 | $1.00 |
| $8.00 | $2.50 | $15.00 | $0.50 |
| $10.00 | $4.00 | $20.00 | $1.00 |
| $15.00 | $5.00 | $25.00 | $2.00 |
| $5.50 | $4.00 | $8.00 | $3.00 |
| $4.00 | $1.50 | $4.00 | $0.75 |
| $8.00 | $5.00 | $10.00 | $2.00 |
| $6.00 | $3.00 | $8.00 | $1.50 |
| $5.50 | $2.50 | $6.00 | $2.50 |
| $7.00 | $4.00 | $8.00 | $2.00 |
| $9.00 | $5.00 | $10.00 | $3.00 |
| $9.50 | $4.50 | $10.00 | $4.00 |
| $8.00 | $6.00 | $10.00 | $2.00 |
| $7.00 | $3.00 | $9.00 | $1.50 |
| $9.00 | $4.00 | $12.00 | $3.00 |
| $10.00 | $4.00 | $10.00 | $3.00 |
| $8.00 | $5.00 | $10.00 | $4.00 |
| $7.00 | $3.00 | $8.50 | $2.00 |
| $6.50 | $3.50 | $10.00 | $2.50 |
| $9.00 | $5.00 | $10.00 | $3.00 |
| $13.00 | $5.00 | $15.00 | $2.00 |
| $11.00 | $5.00 | $12.00 | $3.00 |
| $7.00 | $4.00 | $9.00 | $3.00 |
| $6.00 | $3.50 | $9.00 | $2.50 |
| $8.00 | $4.00 | $10.00 | $3.00 |
| $10.00 | $4.00 | $11.00 | $3.50 |
| $8.50 | $4.00 | $10.00 | $3.00 |
| $8.00 | $3.00 | $10.00 | $2.00 |
| $7.00 | $3.00 | $8.00 | $1.00 |
| $7.00 | $4.00 | $9.00 | $3.00 |
| $9.00 | $4.50 | $10.00 | $3.50 |
| $12.00 | $6.00 | $13.00 | $5.00 |
| $8.00 | $5.00 | $10.00 | $3.00 |
| $7.00 | $5.00 | $9.00 | $4.00 |
| $9.00 | $4.00 | $10.00 | $3.00 |
| $8.00 | $5.00 | $10.00 | $3.00 |
| $7.00 | $4.00 | $8.00 | $2.00 |
| $10.00 | $5.00 | $10.00 | $5.00 |
| $8.00 | $6.00 | $10.00 | $5.00 |
| $9.00 | $4.00 | $10.00 | $3.00 |
| $8.00 | $6.00 | $10.00 | $5.00 |
| $5.00 | $3.00 | $5.50 | $2.00 |
| $9.00 | $6.00 | $12.00 | $5.00 |
| $6.00 | $4.50 | $7.00 | $4.00 |
| $7.50 | $6.00 | $10.00 | $5.00 |
| $8.00 | $6.00 | $10.00 | $4.00 |
| $7.50 | $5.50 | $8.50 | $4.00 |
| $7.00 | $4.50 | $10.00 | $4.00 |
| $8.50 | $6.50 | $9.00 | $5.00 |
| $6.50 | $5.00 | $8.50 | $3.00 |
| $8.00 | $4.00 | $10.00 | $2.00 |
| $7.00 | $5.00 | $8.00 | $3.00 |
| $8.00 | $7.00 | $10.00 | $4.00 |
| $6.00 | $3.50 | $6.00 | $2.00 |
| $9.00 | $5.00 | $11.00 | $2.00 |
| $10.00 | $5.00 | $12.00 | $3.00 |
| $7.00 | $3.00 | $9.00 | $2.00 |
| $6.00 | $3.00 | $8.00 | $1.00 |
| $9.00 | $3.00 | $11.00 | $2.00 |
| $7.00 | $3.00 | $10.00 | $1.00 |
| $6.00 | $4.00 | $9.00 | $2.00 |
| $7.00 | $2.00 | $10.00 | $1.00 |
| $6.00 | $2.00 | $8.00 | $1.00 |
| $8.00 | $5.00 | $10.00 | $1.00 |
| $7.00 | $4.00 | $11.00 | $1.00 |
| $9.00 | $4.00 | $12.00 | $1.00 |
| $8.00 | $4.00 | $10.00 | $3.00 |
| $10.00 | $5.00 | $12.00 | $2.00 |
| $9.00 | $6.00 | $11.00 | $4.00 |
| $10.00 | $7.00 | $12.00 | $3.00 |
| $12.00 | $5.00 | $13.00 | $1.00 |
| $7.00 | $4.00 | $10.00 | $2.00 |
| $9.00 | $5.00 | $10.00 | $3.00 |
| $8.50 | $6.00 | $10.00 | $2.50 |
| $10.00 | $7.00 | $11.00 | $2.00 |
| $9.00 | $6.00 | $12.00 | $3.00 |
| $8.00 | $4.00 | $10.00 | $1.00 |
| $9.00 | $5.00 | $10.00 | $2.00 |
| $8.00 | $4.00 | $9.00 | $1.00 |
| $9.00 | $5.00 | $11.00 | $3.00 |
| $6.00 | $2.00 | $8.00 | $1.00 |
| $8.00 | $4.00 | $11.00 | $2.00 |
| $7.00 | $4.00 | $9.00 | $1.00 |
| $8.00 | $4.00 | $9.00 | $2.00 |
| $9.00 | $5.00 | $12.00 | $3.00 |
| $5.00 | $2.00 | $8.00 | $1.00 |
| $7.00 | $2.00 | $9.00 | $1.00 |
| $6.00 | $3.99 | $7.99 | $2.99 |
| $5.00 | $2.99 | $15.00 | $0.50 |
| $6.00 | $3.00 | $8.00 | $2.00 |
| $8.00 | $6.00 | $10.00 | $4.00 |
| $8.00 | $5.00 | $11.00 | $3.00 |
| $7.00 | $4.00 | $9.00 | $3.00 |
| $8.00 | $3.00 | $10.00 | $2.00 |
| $8.00 | $4.00 | $11.00 | $2.50 |
| $7.00 | $4.00 | $8.00 | $3.00 |
| $9.00 | $5.00 | $10.00 | $3.00 |
| $9.00 | $5.00 | $12.00 | $4.00 |
| $10.00 | $4.00 | $10.00 | $2.00 |
| $9.00 | $4.00 | $10.00 | $2.00 |
| $10.00 | $6.00 | $12.00 | $4.00 |
| $12.00 | $4.00 | $12.00 | $3.00 |
| $10.00 | $5.00 | $11.00 | $3.00 |
| $10.00 | $4.00 | $12.00 | $4.00 |
| $9.00 | $4.00 | $11.00 | $3.00 |
| $10.00 | $5.00 | $15.00 | $3.00 |
| $11.00 | $6.00 | $13.00 | $4.00 |
| $9.00 | $7.00 | $12.00 | $4.00 |
| $8.00 | $6.00 | $13.00 | $2.00 |
| $9.00 | $6.00 | $12.00 | $4.00 |
| $8.00 | $5.00 | $11.00 | $2.00 |
| $8.00 | $6.00 | $10.00 | $3.00 |
| $9.00 | $5.00 | $11.50 | $3.00 |
| $10.00 | $6.00 | $15.00 | $2.00 |
| $10.00 | $5.00 | $13.00 | $3.00 |
| $8.00 | $2.00 | $10.00 | $1.00 |
| $7.00 | $1.00 | $9.00 | $0.75 |
Budweiser Beer Scenario
| Price | $ 8.50 | Quantity Sold | Profit | The Chicago Blackhawks have hired you to conduct an analysis of their Budweiser Beer sales. | ||||||||||
| Variable Cost | $ 2.37 | 1 | Conduct a breakeven analysis for their Budweiser Beer sales with quantity starting at zero and increasing sales by units of 100 up to 5000 | |||||||||||
| Fixed Cost | $ 8,250.00 | 2 | How many Budweisers to the Blackhawks have to sell to breakeven? (round to the nearest whole numner) | |||||||||||
| 3 | Construct a breakeven line chart with the appropriate labels and title. | |||||||||||||
| 4 | Complete the Budweiser Beer Scenario table below. Every column should be based on the initial condition | |||||||||||||
| Budweiser Beer Scenario | ||||||||||||||
| Initial Condition | 10% Increase in Price | 10% Increase in Sales Volume | 10% Decrease in Variable Cost | 10% Decrease in Fixed Cost | 10% Increase in Price and 10% Decrease in Volume | 10% Decrease in Price and 10% Increase in Volume | 10% Increase in Variable Cost and Quantity Sold | |||||||
| Price | $8.50 | |||||||||||||
| Sales Volume | 2,861 | |||||||||||||
| Variable Cost | $2.37 | |||||||||||||
| Fixed Cost | $8,250 | |||||||||||||
| Profit | ||||||||||||||
| Change in Profit | ||||||||||||||
| % Change in Profit | ||||||||||||||
| 3/18/15 0:00 |
Jersey Sales- >25 v ≤ 25
| How likely are you to purchase a Blackhawks jersey if the Blackhawks win the Stanley Cup? | The Blackhawks want to know if there is a difference in the likelihood a person will buy a jersey if the they win the Stanley Cup based on age. Two samples were taken; People over 25 and 25 and younger. | |||||||
| Response Items | Highly Unlikely | Somewhat Unlikely | Neither Likely nor Unlikely | Somewhat Likely | Highly Likely | |||
| Encoding | 1 | 2 | 3 | 4 | 5 | |||
| Sample A- Over 25 years old | Sample B- 25 and younger | |||||||
| 3 | 3 | Min | 1 | Calculate the average response for each group | ||||
| 3 | 2 | Max | 2 | Using 5 intervals for all data, identify the frequency distributions of responses for both samples | ||||
| 3 | 4 | Difference | 3 | Plot the frequency distributions for each category on the same column chart | ||||
| 2 | 3 | # of intervals | 4 | Conduct a t-test to determine the significance of the differences between sample measurements | ||||
| 4 | 4 | Min Interval size | a. How many tails should be used in the t-test? | |||||
| 3 | 4 | Chosen interval size | b. What type of data is this: paired, homoscedastic, heterosceddastic? | |||||
| 2 | 3 | c. What is the p-value of the t-test? | ||||||
| 3 | 2 | Answers: | d. What is the likelihood that a random sample error alone could explain the differences in the measurements? | |||||
| 4 | 2 | T Test P Value | 5 | At a 5% significance level | ||||
| 1 | 4 | Alpha Level | a. Is the P-value greater than or less than alpha? | |||||
| 2 | 3 | b. Should you reject or fail to reject the null hypothesis? | ||||||
| 3 | 4 | c. Are the differences due to random sample error or are the samples taken from different populations? | ||||||
| 3 | 2 | 6 | In plain English, give a complete, one sentence interpretation of the result appropriate for managerial decision making. | |||||
| 4 | 3 | |||||||
| 2 | 4 | |||||||
| 2 | 2 | |||||||
| 4 | 3 | |||||||
| 3 | 4 | |||||||
| 4 | 5 | |||||||
| 2 | 4 | |||||||
| 5 | 3 | |||||||
| 5 | 4 | |||||||
| 2 | 1 | |||||||
| 3 | 3 | |||||||
| 4 | 3 | |||||||
| 2 | 3 | |||||||
| 2 | 5 | |||||||
| 1 | 2 | |||||||
| 3 | 4 | |||||||
| 2 | 4 | |||||||
| 3 | 3 | |||||||
| 2 | 4 | |||||||
| 3 | 4 | |||||||
| 4 | 3 | |||||||
| 3 | 4 | |||||||
| 1 | 5 | |||||||
| Average | ||||||||
| Mar-15 |
Regression- Blackhaw Viewership
| Distance from United Center (miles) | Percentage of Weekly Blackhawks Game Watchers | The Blackhawks have asked you to determine if the proximity to United Center is related to watching Blackhawks games. A survey has been conducted to determine the percentage of people who watch Blackhawks games. The survey results are displayed to the left. *Please note Distance is your independent variable and Percentage of Game Watchers is your dependent variable.* | |||||||
| 720 | 64 | ||||||||
| 820 | 49 | ||||||||
| 1852 | 47 | 1. Create a scatter plot placing the percentage of individuals that watch Blackhawks games against distance to the United Center. (Y is your dependent variable, X is your independent variable) Be sure to include a trend line. | |||||||
| 255 | 98 | ||||||||
| 1276 | 23 | ||||||||
| 2019 | 19 | 2. Conduct a Regression Analysis using excel | |||||||
| 585 | 95 | a- Calculate the correlation and comment on it's strength | |||||||
| 705 | 81 | b- What is the expected percentage of people who watch Blackhawks games on a weekly basis who live 400 miles away from the United Center? | |||||||
| 272 | 82 | ||||||||
| 1216 | 41 | ||||||||
| 580 | 74 | ||||||||
| 703 | 77 | c- What is the expected percentage of people who watch Blackhawk games on a weekly basis who live 1200 miles away from the United Center? | |||||||
| 2111 | 8 | ||||||||
| 372 | 80 | ||||||||
| 1543 | 61 | ||||||||
| 288 | 91 | d- What is the expected percentage of people who watch Blackhawks games on a weekly basis who live 30 miles away from the United Center? | |||||||
| 439 | 88 | ||||||||
| 74 | 93 | ||||||||
| 587 | 81 | Bonus Question: Based on the regression equation, what is the percentage of people who watch Blackhawks games who live one mile away from the United Center? Does this make sense? Explain why or why not. | |||||||
| 135 | 96 | ||||||||
| 334 | 81 | ||||||||
| 985 | 39 | ||||||||
