Exercise #3

September 5, 2013

Exercise #3, described below, is due in class on Tue, Sep 10th.

1. Complete Problems 2.30, 2.31, 2.32, and 2.33 on p 43-44

2. Use the black_7e_excel_database to complete the following.

  • Use graphical analysis to estimate the retail price of gasoline assuming a per-barrel spot price of $200.
  • Use graphical analysis to estimate average annual household food expenditures in Pueblo County.
  • Present appropriate graphs to support your estimates.

Justin

Justin Holman is CEO of Aftermarket Analytics, where he leads efforts to develop cutting edge sales forecasting and inventory optimization technology for the Automotive Aftermarket. Prior to joining Aftermarket Analytics, Justin managed corporate consulting for the Strategy & Analytics division at MapInfo Corporation, leading major projects for retail clients including The Home Depot, Darden Restaurants, Bridgestone-Firestone, Sainsbury’s and New York & Company. Before that, Justin served as Vice President of Software Development at LogicTools, now part of IBM's supply chain application software group. Justin holds a B.A. from Claremont McKenna College, a Ph.D. from the University of Oregon and an Executive Management certificate from Northwestern University's Kellogg School of Management.

2 Comments

  • Reply
    Kellen Lask 11 years ago

    So to concatenate in excel, use the ampersand (&) as in: [=A1&” -Under “&B1] to concatenate a number in A1 with the text ” -Under ” and a number in B1.

    To de-concatenate, specifically for a stem and leaf plot, use Left(cell, number) as in: [=Left(A1, 2)] which will take the first two digits of the number in A1.

    These two functions help a lot in Excel.

Leave a Reply to Kellen Lask Cancel reply