Instructions - Retail Analytics
Sheet 1:This sheet gives Harris Teeter supermarket transaction data for customers shopp
lift for all possible product combinations.
A) Use the appropriate formula tool to create named ranges from selection for all 8 product
Instructions - Linear Regression
Sheet 1:This sheet contains monthly returns for the Standard and Poor's stock index and
Dell Stock from the monthly return of the Standard and Poor's index by doing the
A) Graph Dell Return (Y) by S&P Return (X).
Instructions - Price Optimization
Sheet 1This sheet gives data for coffee purchases at Port City Java coffee house. Use the
elasticity estimates for select price points.
A) In the space provided, graph the linear relationship between price and coffee sale
Instructions - Web Based Analytics
Sheet 1: Suppose you are considering purchasing placement on search results for the key
click that enable you to breakeven.
A) Calculate the estimated conversions per month for swim goggles on your website
B) Estimate th