The following data lists the number of iPhone sales (in millions) and the number of apple genius (sales persons) employed from 2007 to 2013. Use a scatter plot to plot the data. Calculate the value of βo and β1 and fit a regression line for the following data set in excel. How many apple geniuses should the company hire in 2014 if the expected number of iPhone sales for 2014 is 55 million? Submit the output you get from regression analysis in excel along with your answer.
Year |
iPhone sales (in million) |
Apple Geniuses |
2007 |
2.3 |
1000 |
2008 |
4.3 |
1900 |
2009 |
8.8 |
3800 |
2010 |
16.2 |
7500 |
2011 |
37 |
16000 |
2012 |
47.8 |
20000 |
2013 |
51 |
21000 |
NOTE: The following references may help you:
Subject | General |
Due By (Pacific Time) | 10/19/2014 02:00 pm |
Tutor | Rating |
---|---|
pallavi Chat Now! |
out of 1971 reviews More.. |
amosmm Chat Now! |
out of 766 reviews More.. |
PhyzKyd Chat Now! |
out of 1164 reviews More.. |
rajdeep77 Chat Now! |
out of 721 reviews More.. |
sctys Chat Now! |
out of 1600 reviews More.. |
sharadgreen Chat Now! |
out of 770 reviews More.. |
topnotcher Chat Now! |
out of 766 reviews More.. |
XXXIAO Chat Now! |
out of 680 reviews More.. |