Answer the questions in memo 1 – you will need to do your work in the excel spreadsheet as well as provide a typed page of relevant explanations (about half a page double spaced), 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. Under tools go to add ins and check analysis tool pack, click OK. Now under tools you should be able to see data analysis. 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. Answer all the questions in the memo.
"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."