Question.2957 - I. Find the sales data for Apple here: http://images.apple.com/pr/pdf/q1fy13datasum.pdf. (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 1Rank County Media n 1 Forsyth $84,56 7 2 Fayette $77,49 1 3 Oconee $74,63 0 4 Columbia $68,98 65 Cherokee $66,97 2 6 Henry $63,89 2 7 Paulding $63,66 3 8 Harris $63,35 1 9 Cobb $62,89 3 10 Coweta $59,84 8 11 Gwinnett $58,73 2 12 Bryan $58,09 2 13 Lee $57,04 4 14 Fulton $56,31 3 15 Pike $55,67 4 16 Effingha m$54,67 8 17 Monroe $53,80 5 18 Dawson $53,21 5 19 Rockdale $51,26 5 20 Douglas $50,79 8 21 Pickens $50,79 0 22 Houston $50,73 3 23 Jackson $50,59 1 24 Walton $50,32 1 25 Newton $50,13 7 26 DeKalb $50,09 2III. Display the data in Table 1 using Stem Leaf approach and dot plot. (20 points)
Answer Below:
a xxx average xxxxxxxx for x using xxxxxxxxx segments xxx be xxxxxxxxx by xxxxxxxx the xxxxx revenue xxxx number xx operating xxxxxxxx The xxxx method xxxxx be xxxxxxx weighted xxxxxxx where xxxx operating xxxxxxx is xxxxxxxx a xxxxxx based xx one xx more xxxxxxxxxx For xxxxxxx the xxxxxx can xx assigned xx the xxxxx of xxxx of xxxxxxxx supplied xxxx operating xxxxxxx is xxxxx a xxxxxx equivalent xx the xxxxx of xxx cost xx products xxxxxxxx to xx by xxxxx cost xx products xxxxxxxx Also xxx average xxx be xxxxxxxxxx in x more xxxxxxxx manner xx units xx different xxxxxxxx supplied xx different xxxxxxxxx segments xxxxxxx across xxxxxxxxx is xxxxxxxxx by xxxxx dividing xxx operating xxxxxxxx into xxxxxxxxx countries xxxx which xxxxx generates xxx revenue xxxx simple xxxxxxxxxx mean xxx be xxxxxxxxxx by xxxxxxxx total xxxxxxx from xxxxx number xx countries xxxx which xxx revenues xxx generated x No xxxxx is xxx enough xxxxxxxxxxx to xxxxxxxx the xxxxxxx using xxx method xxx recommend xx do xxx know xxx many xxxxx of xxxx product xxx supplied xx each xxxxxxxxx Segment xx we xxxxxx estimate xxx exact xxxxxxx by xxxx product xx a xxxxxxxxxx Operating xxxxxxx c xx product xxxxxxx it xx important xx have xxx units xxxxxx because xx this xx can xxxx an xxxxxxxx of xxxxx product xx generating xxxx revenue xxx Apple xx listing xxx units xx can xxx appropriate xxxxxxx to xxxx operating xxxxxxx and x better xxxxxxx can xx estimated xxxxx on xx For xxxxxxxxxx the xxxxxxx revenue xxx Apple xxxxxxxx I xxxxx need xxx units xxxxxxx average xxxxxxx for xxxx product xxxx be xxxxxxx generated xx that xxxxxxx divided xx the xxxxxx of xxxxx of xxxx product xxx example xxxxxx generated x revenue xx in x and xxxxx units xx iPhone xxxx So xxx average xxxxxxx generated xx iPhone xx unit x Rank xxx he xxxx fall xxxxx in xxx income xxxxx b xx would xxxxxxxxxx the xxxx based xx range xx median xxxxxx we xxxx form xxxxxxx bin xxx shall xxx the xxxxx tool xx find xxx number xx datas xx respective xxx c xx find xxx of xxx data xxxxxxx to x would xxxx to xxxx bin xx and xxxxx place xx data xx bins xx - x and xx on xxx frequenc x We xxx see xxx distribution xxx graph xxxxx Stem xxx leaf xxxxxx will xx best xx this xxxx d xxx frequency x s xxxx Mean xxxxxx Standard xxxxxxxxx Sample xxxxxxxx Range xx quartile xxxxxx rd xxxxxxxx f xxxx of xxxxxxxxx between xx and xxxxx quartilePaulding xxxxxx Cobb xxxxxx Gwinnett xxxxx Lee xxxxxx Pike xxxxxxxx m xxxxxx Dawson xxxxxxxx Douglas x mean xxxxxx std xxx minimum xxxxxx m xxxxxxxxxxxxx Display xxxx unit xxx plot xxxxx Whiske x Lower xxxxx Median xxxxx Hinge xxxxx Whiske xMore Articles From Statistics
.ico)
.ico)
.ico)
.ico)
