Nathaniell
Badges: 9
Rep:
?
#1
Report Thread starter 5 years ago
#1
Does any one know how i would measure rates of adoption? I have an assignment to complete and the brief goes like this:


-------------------------------------------------------------------------------------------------------------------------------
Dear xxxx

I would greatly appreciate it if you could write me a brief report concerning the matters described below.As you know, we have just completed an extensive advertising of our company’s new multi-player online game. In the attached Excel file (game_data.xls) I have entered the number of annual subscriptions obtained from each city. Unfortunately this is all the information which is disappointing. Nevertheless, I hope that this information will help to inform us how to proceed in the future.

Please can you display this information in a suitable manner so that the overall picture can be easily seen? I have also inserted the total population of each city; so please can you use this also to show the adoption rates in each city? I really need something that gives an overall picture at a glance if possible, not only for my own benefit but also because I will be wanting to show this the board of directors of our company. So please give us diagrams and charts rather than just large tables of numbers. However, some numbers are of course important, and so it would be helpful if you could include useful averages and measures of variation alongside these diagrams, charts, graphs etc.

I suspect that the data may show rather different adoption rates for different cities, and I would like to find out the reasons for this. Please therefore can you try to dig a little deeper and present further diagrams, graphs, charts etc. that might help explain this variation. Three theories have been put to me:

· The different age distributions in different cities may have an effect. Are older people more likely to purchase annual subscriptions? Are parents more likely to buy the game for their children? We really don't have much of a clue about this.

· People living in cities where there was a higher rate of adoption last year are more likely to come forward to obtain an annual subscription this year.

· Because of the time involved in commuting to the demonstration centres, the adoption rate may tend to be lower for cities with high average commuting time.


Please can you test these theories? I have included some information in the Excel file that should help you with this.

Also, as part of an attempt to get to know the areas better and why they have had different adoption rates so far, I intend to spend some time based at some of our demonstration centres. However, I won't have time to visit more than about ten of them, and so I was wondering how I should choose which centres to visit. I'm wondering if you could advise me on this matter, please? I want to make the choice at least partly at random, to avoid bias, and also so that no centre manager feels that he or she is being picked on (or overlooked) intentionally, but I also want to ensure that I see a representative sample of centres, especially with regard to adoption rates.

What do you think? I vaguely remember from my student days learning about cluster samples and quota samples and systematic samples and stratified samples and simple random samples .... I can remember the names but I can't remember what they all mean.

Please can you therefore recommend a sampling method to use for this survey, or perhaps some different alternatives, together with any pros and cons? Please be as precise as you can about the exact way in which I should choose my sample.

________________________________ ________________________________ _________--

A snapshot of the data, which is in an excel document goes like this (Student room wont let me copy and paste it, but the headers with their respective numbers are..):

Purchases of Annual Subscription this year ('000)
38.1
4.8
49.4
Last year purchases of annual subscription Population ('000)
10005
3080
7255


Population under 17 ('000)
176
59
223

Population over 40 ('000)
74
22
90


Average Commuting time to demonstration centre
14
45
16

If anyone can help with this, that would be amazing. I've also highlighter other parts that i'm currently struggling with if anyone can shed a light on them too..Thanks!
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

University open days

  • University of Bristol
    Undergraduate Open Afternoon Undergraduate
    Wed, 23 Oct '19
  • University of Exeter
    Undergraduate Open Day - Penryn Campus Undergraduate
    Wed, 23 Oct '19
  • University of Nottingham
    Mini Open Day Undergraduate
    Wed, 23 Oct '19

Have you made up your mind on your five uni choices?

Yes I know where I'm applying (150)
59.52%
No I haven't decided yet (57)
22.62%
Yes but I might change my mind (45)
17.86%

Watched Threads

View All