Download the file Starz.xls from Blackboard, and also Memo 1. Answer the questions in memo 1 - you will need to work in the excel spreadsheet as well as provide a typed page of relevant explanations 2 , and submit both to me. To estimate the demand curve you need to perform a regression using excel. Open excel, go to tools, under tools go to data analysis and you should be able to see regression under that. If you dont see a data analysis option under tools, you will need to perform an add in - refer to the document I have posted under assignments titled "Instructions for Installing Analysis Toolpack". Once you have this, in data analysis go to regression, this will open up a box - under input y range, put (right click and highlight) in the price column including the header, under input x range put in the quantity(subscribers) column including the header, check labels, confidence level 95%, name a worksheet ply and click OK. You should see the results - the constant is the intercept term of your demand equation, the coefficient with subscribers is your slope. Use this to calculate elasticities in excel. Answer all the questions in the memo. (15 points)