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 rsquo xxxxx operating xxxxxxxx can xx estimated xx dividing xxx total xxxxxxx with xxxxxx of xxxxxxxxx segments xxx best xxxxxx would xx finding xxxxxxxx average xxxxx each xxxxxxxxx segment xx assigned x weight xxxxx on xxx or xxxx parameters xxx example xxx weight xxx be xxxxxxxx on xxx basis xx cost xx products xxxxxxxx Each xxxxxxxxx segment xx given x weight xxxxxxxxxx to xxx ratio xx the xxxx of xxxxxxxx supplied xx it xx total xxxx of xxxxxxxx supplied xxxx the xxxxxxx can xx calculated xx a xxxx suitable xxxxxx by xxxxx of xxxxxxxxx products xxxxxxxx to xxxxxxxxx operating xxxxxxxx Average xxxxxx countries xx estimated xx first xxxxxxxx the xxxxxxxxx segments xxxx different xxxxxxxxx from xxxxx Apple xxxxxxxxx its xxxxxxx Then xxxxxx arithmetic xxxx can xx calculated xx dividing xxxxx revenue xxxx total xxxxxx of xxxxxxxxx from xxxxx the xxxxxxxx are xxxxxxxxx b xx there xx not xxxxxx information xx estimate xxx average xxxxx the xxxxxx you xxxxxxxxx We xx not xxxx how xxxx units xx each xxxxxxx are xxxxxxxx to xxxx Operating xxxxxxx So xx cannot xxxxxxxx the xxxxx revenue xx that xxxxxxx in x particular xxxxxxxxx Segment x In xxxxxxx summary xx is xxxxxxxxx to xxxx the xxxxx listed xxxxxxx by xxxx we xxx have xx estimate xx which xxxxxxx is xxxxxxxxxx more xxxxxxx for xxxxx By xxxxxxx the xxxxx we xxx set xxxxxxxxxxx weights xx each xxxxxxxxx segment xxx a xxxxxx average xxx be xxxxxxxxx based xx it xxx estimating xxx average xxxxxxx for xxxxx products x would xxxx the xxxxx because xxxxxxx revenue xxx each xxxxxxx will xx revenue xxxxxxxxx by xxxx product xxxxxxx by xxx number xx units xx that xxxxxxx For xxxxxxx iPhone xxxxxxxxx a xxxxxxx of xx Q xxxxx 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)
