I.     Find the sales data for Apple here: http://images.apple.com/pr/pdf/q1fy13datasum.pdf.  (30[] points)

I.    
Find the sales data for Apple here:
http://images.apple.com/pr/pdf/q1fy13datasum .  (30 points)

a.      

How would you estimate the average revenues for Q1’13 using operating segments? Which is the best method? How would you interpret an average across countries here?

b.     

Is there enough information to estimate the average using the method you recommend?

c.      

In product summary why it is important to have the units listed? If you want to estimate average revenue for Apple products do you need to use the units? How?

 

II.  
 Review the data in Table 1. It covers the median income for the top 25 Georgia counties.  (50 points)

a.       If John earns $62,591 annually in Henry County what would change for him if he moves to Cherokee county?

b.      You want to demonstrate this data, how would you categorize it?

c.       If you want to show the number of counties with a median income within a certain range how do you identify those ranges? How many bins you will choose? What kind of representation you will choose?

d.     
Use Excel to draw the graph and submit it as part of your work.

e.      
Consider the Median Income as a variable, report Mean, Median, STD, Variance and Quartiles for it.

f.       
Would you identify the counties which are between 25 percentile and 75 percentile (second and third quartiles)?

Table 1RankCountyMedian1Forsyth$84,5672Fayette$77,4913Oconee$74,6304Columbia$68,9865Cherokee$66,9726Henry$63,8927Paulding$63,6638Harris$63,3519Cobb$62,89310Coweta$59,84811Gwinnett$58,73212Bryan$58,09213Lee$57,04414Fulton$56,31315Pike$55,67416Effingham$54,67817Monroe$53,80518Dawson$53,21519Rockdale$51,26520Douglas$50,79821Pickens$50,79022Houston$50,73323Jackson$50,59124Walton$50,32125Newton$50,13726DeKalb$50,092  

III.
Display the data in Table 1 using Stem Leaf approach and dot plot. (20 points)