Project #43860 - Management engineering

 

 

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:

 

  1. Regression in Excel (you tube video): http://www.youtube.com/watch?v=afd-ifguZsQ
  2. Regression in Excel (wiki instructions): http://www.wikihow.com/Run-Regression-Analysis-in-Microsoft-Excel

 

 

Subject General
Due By (Pacific Time) 10/19/2014 02:00 pm
Report DMCA
TutorRating
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..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy