Juliana Rodrigues de Camargo Queiroz: Data Interpretation Report

This report presents an analysis of primary and secondary data collected through an online survey to understand the evolution and opportunities within social media marketing. The study, conducted by Juliana Rodrigues de Camargo Queiroz at Emirates Aviation University, examines various aspects of consumer behavior, including gender demographics, income levels, internet usage patterns, and preferences for social media platforms. Key findings highlight the dominance of Facebook, the increasing use of online shopping, and the primary payment methods utilized. The report also explores factors that influence consumer decisions, such as the desire for additional product information and the motivations behind online purchases. Furthermore, the report investigates the factors that discourage online shopping, such as the inability to physically examine products, and the impact of web marketing on consumer satisfaction. The data interpretation reveals valuable insights into the current state of social media marketing and its implications for businesses, with recommendations for future strategies.

Running head: DATA INTERPRETATION AND ANALYSIS
DATA INTERPRETATION ASSIGNMENT
Student: Juliana Rodrigues de Camargo Queiroz
Emirates Aviation University

2DATA INTERPRETATION ASSIGNMENT
Table of Contents
Introduction......................................................................................................................................4
Discussion........................................................................................................................................4
Question 1:...................................................................................................................................4
Question 2:...................................................................................................................................5
Question 3:...................................................................................................................................6
Question 4:...................................................................................................................................9
Question 5:.................................................................................................................................10
Question 6:.................................................................................................................................11
Question 7:.................................................................................................................................12
Question 9:.................................................................................................................................14
Question 10:...............................................................................................................................15
Question 11:...............................................................................................................................16
Question 12:...............................................................................................................................18
Question 13:...............................................................................................................................19
Question 14:...............................................................................................................................20
Question 15:...............................................................................................................................21
Question 16:...............................................................................................................................23

3DATA INTERPRETATION ASSIGNMENT
Question 17:...............................................................................................................................24
Question 18................................................................................................................................26
Conclusion.....................................................................................................................................28
Recommendations..........................................................................................................................30
References......................................................................................................................................31

4DATA INTERPRETATION ASSIGNMENT
Introduction
Social media marketing is a tool that has been powering companies and brands to reach
more customers as consumers are increasingly spending more and more time online. It is a topic
which has drawn attention to much interest and research owing to the vast potential it poses for
business and developing business intelligence. Social media has not only empowered brands in
reaching out to more people but it has allowed consumers with knowledge and more options
making for stiff competition in the markets. This paper focuses on primary and secondary data to
present a study of how social media marketing has evolved and the opportunities it holds for the
future.
Discussion
The following are the results of the online survey questionnaire used to collect data for
the study.
Question 1:
What is your Gender?

5DATA INTERPRETATION ASSIGNMENT
Figure 1
Table 1
The first question inquires about the gender of the respondent. It has been found that out
of the total 130 respondents 57.89% were female and 4.31% were males. Therefore, it can be
concluded that the females are active on the social media than that of males. Therefore, various
companies have to look for the females in the market ad provided products and services that are
suitable for the females.
Question 2:
Tick the option that corresponds to your range of monthly household income.
Figure 2

6DATA INTERPRETATION ASSIGNMENT
Table 2
34.62% of the respondents of the survey revealed that their monthly household income is
within 5000 Dhs, 16.15% of the respondents said that it is between 5000 Dhs and 10,000 Dhs,
15.38% of the respondents earn between 10,000 Dhs and 20,000 Dhs, 21.54% of the respondents
earn above 20,000 Dhs and the remaining 12.31% do not have a monthly income whatsoever.
Thus the modal class is the interval of monthly income of income being more than 0 and less
than equal to 5000 Dhs. Therefore, it can be concluded that the respondents are suffering from
low income problem.
Question 3:
In a typical month, what do you most often use the internet for?

7DATA INTERPRETATION ASSIGNMENT
Figure 3

8DATA INTERPRETATION ASSIGNMENT
Table 3
The survey revealed that in a typical month the activity that the respondents used the
internet for the most was to send emails and purchase some products or services. 80% of all
respondents listed sending emails as an activity they use the internet for in a typical month and
61.54% had listed purchasing some products as the same. Other activities listed by the
respondents were to keep in touch with friends at 57.69%, 54.62% selected getting directions as
a reason and 52.31% selected keeping up with current events as a reason. Instant messaging,
sharing photos and social networking, each were selected by 49.23% of the respondents. 36.15%
selected sharing videos as a reason for using social media, 26.92% selected reading other
people’s comments, blogs and news stories, 21.54% selected finding other people as a reason
and 10.77% selected making new friends. 6.15% selected starting new dating relationships and
7.69% selected all of the above mentioned reasons. 9.23% had selected others. The mode was
therefore “using emails” which has highest frequency.

9DATA INTERPRETATION ASSIGNMENT
Question 4:
How long have you been an internet user?
Figure 4
Table 4
92.31% of the respondents of the online survey were found to have been users of the
internet for more than 5 years, 4.62% had been internet users for between two to five years,
2.31% were the same for less than two years and only 0.77% had been users for less than a year.
The mode is therefore greater than five. According to the tables and graphs, it can be analysed

10DATA INTERPRETATION ASSIGNMENT
that most of the people are using internet more than five years. Therefore, companies need to
focus in the online marketing strategies to gather more and more customer over the internet.
Question 5:
With what frequency do you use the internet?
Figure 5
Table 5
74.62% of the respondents of the online survey had responded that they use the internet
many times during the day, 14.62% of the respondents had responded that they used the internet

11DATA INTERPRETATION ASSIGNMENT
2 to 3 times during the day,7.69% of the respondents selected once a week that they used the
internet and 0.77% responded that they used the internet only once a month. The mode is
therefore “many times”. As per the graphs and tables, most of the customers are using many
times daily internet in the market.
Question 6:
What is the average time that you spend on the internet?
Figure 6
Table 6

12DATA INTERPRETATION ASSIGNMENT
55.38% of the respondents of the survey revealed that they used the internet for a period
of between 1 to 5 hours a day, 27.69% revealed that they spent between 6 to 12 hours per day on
the internet, 10% revealed that they spent more than 12 hour a day on the internet and 6.92%
spent less than an hour per day. The mode is thus “between 1 to 5 hours per day”. Most of the
people have been using the internet for 1 to 5 hours a day. The use of the internet have been
helping in gathering information in the market.
Question 7:
List with numbers in order of importance to you, which social network do you use most
often? (Weighted average score of social networking sites used most often)
Table 7
The respondents were asked to rate social networks as per order of importance to them,
reflecting their usage of the networking sites. The weighted average of the scores for each of the
sites reveals that Facebook occupies the first position with 50.77% score, Instagram scored
11.54%, followed by Snapchat with 7.69% and twitter and Linkedin both having 4.62% score.
Most of the people are using Facebook as a social media over the internet. Therefore, companies
have to have to advertise their products and services over the Facebook. The use of social media
marketing strategies have helped in increasing the production of companies in the market.
Question 8:

13DATA INTERPRETATION ASSIGNMENT
Do you search for additional information on the product or service after viewing a
marketing campaign about it on social media?
Figure 8
Table 8
46.15% of the respondents selected sometimes in response to being asked whether they
searched for additional information on a particular product or service after viewing a marketing
campaign about it on social media. 13.08% selected the option always, 11.54% selected the
option “many times” and 29.23% selected never. Overall, 70.77% selected that they did follow
up on additional information. As discussed in the graphs and tables, the use of the additional

14DATA INTERPRETATION ASSIGNMENT
information have been searched by the people. This additional information might include about
the discount and other special offered provided by the companies to the customers.
Question 9:
Using a scale of 1 to 5, where 1 means “totally disagree” and 5 means “totally agree”, in
your opinion, what are the aims that drives companies to adopt this new marketing
approach in social networks?
Figure 9

15DATA INTERPRETATION ASSIGNMENT
Table 9
36.92% of the respondents selected the option of low cost of online marketing as the
primary reason that drives companies to use social media in the their marketing
approach.36.15% selected interaction with customers that online marketing through social media
allows, 34.62% selected greater accessibility of the product, 30% said that the personalization of
advertising messages is the reason and 19% selected customer concern as the reason that
companies may prefer marketing via social media.11.54% named some other reason. The cost of
marketing in then online system have lower than that of the offline mode. Therefore, most of
the customers are heading toe=wards the online shopping system. Therefore, companies needs to
focus on the rue online market than that of offline market.
Question 10:
Using a scale of 1 to 5, where 1 means “totally unsatisfied” and 5 “totally satisfied”, how do
you rate your degree of satisfaction with the effects of web marketing?

16DATA INTERPRETATION ASSIGNMENT
Figure 10
Table 10
28.46% of the respondents selected the possibility to compare prices easily as the reason
for their satisfaction with web marketing, possibility to be contact the company easily and
possibility of personalized treatment were each selected by 14.62% , 10.77% of the respondents
selected possibility to be contacted easily as their reason, 7.89% selected the option that
possibility to see the information of the products and services updated, 6.15% selected the reason
as being them being able to avail higher and better offers and 17.69% selected the reason to be
obligation to view undesired content for their dissatisfaction as the reason for why they may be
satisfied with web marketing. The use of the online marketing system might increase the price by
adding the delivery charges and other benefits.
Question 11:
Normally how much of your household income you spend through online shopping per
month?

17DATA INTERPRETATION ASSIGNMENT
Figure 11
Table 11
60.77% of the respondents revealed that they typically spend less than 500 Dhs through
online shopping each month, 20.77% revealed to be spending between 500 Dhs and 1000 Dhs,
8.46% of the respondents revealed to be spending between 1000 Dhs and 2000 Dhs, 5.38% spent
between 5000 Dhs and 10,000 Dhs and 0.77% of the respondents spent more than 10,000 Dhs
per month for online shopping. The mode is thus “less than 500Dhs”. Minimum amount of the
income have been performed the shopping by customers. Therefore, the savings of the

18DATA INTERPRETATION ASSIGNMENT
customers are more than that if the expenditure. The company needs to focus on low cost
products with proper quality of product that might attract the customers to the company.
Question 12:
What are the main products that you buy online?
Figure 12
Table 12

19DATA INTERPRETATION ASSIGNMENT
51.54% out of all the respondents of the online survey revealed that flight tickets and
hotel bookings were the main products or services that they bought online. 46.92% selected
apparel, shoes and accessories, 40.77% selected electronic gadgets as, 42.31% primarily bought
household items, 29.23% of the respondents bought books, newspaper and journals, 28.46%
selected the option that they bought tickets for events and festivals through online shopping and
23.08% selected food items as their primary objects of purchase through online shopping.
Question 13:
What is the main payment method that you use when buying online?
Figure 13

20DATA INTERPRETATION ASSIGNMENT
Table 13
Credit or debit cards are found to be the option for the mode of payment through online
transactions that 75.38% of the respondents of the study selected. This was followed by Paypal
accounts, selected by 16.15% of the respondents, followed by Cash on delivery with 6.15% of
the respondents choosing it as the mode through which they pay online. 2.31% said that they use
some other mode of payment. Credit cards have been mostly used for the payment of products
and services the company in the market. Comparing that to the data collected via the survey
where 36.15% selected interaction with customers through online marketing and 30% said that
the personalization of advertising messages is the reason that companies may prefer marketing
via social media, it suggests that perhaps these have indeed made an impact on these customers
to acknowledge them as so.
Question 14:
What discourages you to shop online?

21DATA INTERPRETATION ASSIGNMENT
Figure 14
Table 14
49.23% of the respondents selected not being able to try the products as a reason which
might discourage them to buy a product through online shopping. Distrust in the e-commerce
websites was selected by 14.62% of the respondents as a reason that discourages them from
making a purchase online.13.85% selected not being able to exchange the products if need be, as
a reason that might be discouraging them to shop online, 11.45% selected difficulty in making
transactions online as a reason for discouragement for online shopping and 10.77% said that their
distrust of the existing payment methods online is the reason that they are discouraged from

22DATA INTERPRETATION ASSIGNMENT
online shopping. Therefore, it can be analysed that customers are not to try their products, which
create dissatisfaction among them related to the online shopping.
Question 15:
What is your age?
Figure 15

23DATA INTERPRETATION ASSIGNMENT
Table 15
Out of all the respondents of the online survey, 26% were found to be in the age group
which is greater than sixty years of age, 29% were found to be within the age group forty five
years to sixty years of age, 27% were found to be within the age group interval of thirty to forty
four years, 18% were found to be within the age interval of eighteen to twenty nine years and no
respondents were found to be less than eighteen years of age. 30 out of 130 respondents had
skipped answering the question all together. As discussed previously making short interactions
with customers through electronic modes have always helped them in gaining their advices for
enhancements in services
Question 16:
What device do you use to access social media?

24DATA INTERPRETATION ASSIGNMENT
Figure 16
Table 16
49% of the respondents of the study were found to use Windows desktop or laptop as a
device to access social media. 25% of the respondents of the survey selected iOS phone or tablet
as the device that they use to access social media, 18% reported using android phone or tablet for
social media access, 7% selected MacOS desktop or laptop as their device of choice to access
social media and 1% reported some other devices. 30 out of 130 respondents had skipped
answering the question all together. Most of the participants have used laptop and windows for
accessng the social media. The use of other devices including mobile are used for accessing
internet and social media. Therefore, companies need to prepare an attracting website for
attracting customers to the company.
Question 17:
What is your household Income?

25DATA INTERPRETATION ASSIGNMENT
Figure 17

26DATA INTERPRETATION ASSIGNMENT
Table 17
Out of the 130 respondents, 30 out of the total respondents did not respond to this
particular question regarding their household income. Among the ones who responded, 12% said
that they preferred to not reveal their household income,8% said that it was between $0 to
$9999,11% said that it was between $10,000 and $24,999, 24% said that is was between $25,000
and $49,999, 19% said that its between $50,000 and $74,999, 9% said that its between $75,000
and $99,999 ,7% said that its between $100,000 and $124,999 and 3% said that its between
$125,000 and $149,999. The household income intervals $150,000 to $174,999 and $175,000 to
$199,999 each were selected by 1% of the respondents and finally 5% said that their household
income exceeded $200,000. The mean household income of the respondents were thus found to
be $65709.76. The standard deviation was $27011.85.The median was however found to be
$51315.74. The interquartile range was found to be $57985.75.The data is quite dispersed about
the mean and it seems there is presence of extreme high values making the distribution left
skewed.
Question 18
Regions

27DATA INTERPRETATION ASSIGNMENT
Figure 18
Table 18

28DATA INTERPRETATION ASSIGNMENT
5% of the respondents of the survey belonged to New England region, 12% said that they
were from the Middle Atlantic, 12% were from East North Central and 1% selected West North
Central, 23% responded that they were from South Atlantic region, 4% were from East South
central region, 8% were from west south central region, 17% said that they from Mountain
region and finally, 18% selected the Pacific as the region that they were from.
Conclusion
55.38% of the participants of the survey revealed that they spent an average of between
one to five hours on the internet, 26.92% selected reading other people’s comments, blogs and
news stories as what drives them to use media, thus creating an ideal opportunity for companies
and brands to engage with such people through social networking. As discussed previously
making short interactions with customers through electronic modes have always helped them in
gaining their advices for enhancements in services. Comparing that to the data collected via the
survey where 36.15% selected interaction with customers through online marketing and 30%
said that the personalization of advertising messages is the reason that companies may prefer
marketing via social media, it suggests that perhaps these have indeed made an impact on these
customers to acknowledge them as so. Viral advertising has become a trend in delivering
information regarding services and products to consumer and gathering insights by studying their
habits online. Social media has thus become a promising opportunity for companies to engage
them, apply marketing schemes and educate potential customers or consumers about their
products and services. Social media had opened up marketing channels for the various brands
and companies and the data supports these claims to a large extent, in that a considerable
proportion of people in the study vouched for the importance that social networking and
blogging have assumed. 57.69% had stated online purchasing to be a major motivation for using

29DATA INTERPRETATION ASSIGNMENT
internet. Venkatachari and German Wala (2014) research showed us (discussed in the SLR) how
people have taken to social media marketing and online shopping in relation to the aviation
industry. Their paper addresses how the aviation industry has made use of the opportunities
provided through social media in communicating to fliers regarding commercial flights. Jet
Airways for example was identified as a leader in social media marketing who have successfully
been able to judge customer expectation and preference through interactions via social media and
thus translate it into a positive business outcome. This survey has revealed airfare and hotel
bookings as one of the major avenues of online transactions by the respondents which further
establish how airline industry has been successful in the marketing strategy. It indicates that
consumers have taken to social media as a medium for making their choice of airlines and as per
the information made available to them and that a significant portion of business done by airlines
is done via the virtual medium. Fotis (2015) (
find it in the SLR) explored how social media has also impacted the tourism industry. Instant
messaging, sharing photos and social networking, each had been listed by 49.23% of the
respondents as activities that drive them to use internet. This means that they share experiences
of their lives, thoughts, day to day activities and specially vacations. 36.15% selected sharing
videos as a reason for using social media. This created an immense scope for the tourism
industry to promote sites via visitors who may have gone to a vacation to that particular place. A
person who might perhaps be inspired through online advertisement would most likely share the
experiences online and in turn attracting more people who are connected to him. The data from
this survey thus supports Fotis’s data.

30DATA INTERPRETATION ASSIGNMENT
The survey thus provides some interesting first hand insights about how much significant
social media and digital marketing has become with people engaging copious amount of their
time online and how habits of people is changing the dynamics of the marketing industry.
Recommendations
Social media marketing is a powerful tool which is fast evolving along with changing
consumer behaviour. However a key deterrent of online marketing and advertisement has been
identified as the fact that it does not allow the consumer to be able to see and try the product first
hand and thus creating distrust. Although it is not feasible for all products and services, certain
products such as apparel and gadgets could be allowed the feature of trial and return so that
customers could have an option of switching their choice after they have the product at hand and
are not satisfied. This could work to mitigate their apprehensions and make consumers more
comfortable in making an investment online. Social media marketing needs to have strategic plan
for the taking part in the marketing process of the companies. The use of social media have
been able to provide a keen interest among the customers in order to maintaining the revenue of
the company in the market. The use of the social media tools have been used in order to
maintain and control the social media services. Therefore, there is a need of maintaining the
social phenomenon of the social media. The use of the social media in the market might be
changed in the system that might help in maintaining the sales of company in the market.
Action plan
Task Name Duration Start Finish Predecessors
Social Media Marketing 65 days Wed 02-05-18 Tue 31-07-18
Social Marketing Project Plan
Development 11 days Wed 02-05-18 Wed 16-05-18
Initiating Social Marketing Plan 5 days Wed 02-05-18 Tue 08-05-18
Plan Review 6 days Wed 09-05-18 Wed 16-05-18 2

31DATA INTERPRETATION ASSIGNMENT
Data Collection and Data
Analysis 24 days Thu 17-05-18 Tue 19-06-18
Business Analysis in Details 4 days Thu 17-05-18 Tue 22-05-18 3
Assessing Current Capabilities
of Business 5 days Wed 23-05-18 Tue 29-05-18 5
Research Practices 5 days Wed 30-05-18 Tue 05-06-18 6
Analysis Findings 4 days Wed 06-06-18 Mon 11-06-18 7
Conclusions and Review 6 days Tue 12-06-18 Tue 19-06-18 8
Design Phase 29 days Thu 17-05-18 Tue 26-06-18
Developing Project
Specifications 5 days Wed 20-06-18 Tue 26-06-18 9
Developing Design Details 5 days Thu 17-05-18 Wed 23-05-18 1
Implementation Plan 4 days Thu 24-05-18 Tue 29-05-18 12
3-5 Years Implementation Plan
and Business Case 4 days Wed 30-05-18 Mon 04-06-18 13
Implementing Social Media
Marketing Plan 39 days Tue 05-06-18 Fri 27-07-18
Auditing Current Social
Presence 5 days Tue 05-06-18 Mon 11-06-18 14
Preparing Document Who Ideal
Customer Is 5 days Tue 12-06-18 Mon 18-06-18 16
Developing Social Media
Mission Statement 6 days Tue 19-06-18 Tue 26-06-18 17
Recognising Key Success
Metrics 6 days Wed 27-06-18 Wed 04-07-18 18
Creating Customer Engaging
Content 5 days Thu 05-07-18 Wed 11-07-18 19
Investment on Social Media
Management Tool 5 days Thu 12-07-18 Wed 18-07-18 20
Tracking, Analysing and
Optimise 7 days Thu 19-07-18 Fri 27-07-18 21
Project Closure 2 days Mon 30-07-18 Tue 31-07-18 22

32DATA INTERPRETATION ASSIGNMENT
References
Chu, S.C., 2009. Determinants of Consumer Engagement in Electronic Word-of-Mouth in Social
Networking Sites. [Online] Available at:
https://repositories.lib.utexas.edu/bitstream/handle/2152/6585/chus00644.pdf [Accessed 19
September 2017].
Claywell, C.R., n.d. Advantages and Disadvantages of Social Networking. [Online] Available at:
http://socialnetworking.lovetoknow.com/Advantages_and_Disadvantages_of_Social_Networkin
g [Accessed 20 September 2017].
Creative Commons , n.d. Factors That Influence Consumers’ Buying Behavior. [Online]
Available at: https://open.lib.umn.edu/principlesmarketing/chapter/3-1-factors-that-influence-
consumers-buying-behavior/ [Accessed 19 September 2017].
Elison, D.M.B.a.N.B., 2007. Social Network Sites: Definition, History, and Scholarship. [Online]
Available at: http://onlinelibrary.wiley.com/doi/10.1111/j.1083-6101.2007.00393.x/full
[Accessed 20 September 2017].
Fakete, S.A.a.M., 2017. Short Communication: The Effect Of Social Media On Customer
Behaviour And Firms’ Activities. [Online] Available at:
http://real.mtak.hu/40613/7/222_Management_and_Organization-Pearson-2017j%C3%BAn08-
DOI_CrossRef-2017j%C3%BAn13f.pdf [Accessed 19 September 2017].
FOTIS, J.N., 2015. The Use Of Social Media And Its Impacts On Consumer Behaviour: The
Context Of Holiday Travel. [Online] Available at:

33DATA INTERPRETATION ASSIGNMENT
http://eprints.bournemouth.ac.uk/22506/1/JOHN%20FOTIS%20-%20PhD.pdf [Accessed 19
September 2017].
Godey, B., 2016. Social media marketing efforts of luxury brands: Influence on brand equity and
consumer behavior. [Online] Available at:
https://www.researchgate.net/profile/Joonas_Rokka2/publication/304493675_Social_media_mar
keting_efforts_of_luxury_brands_Influence_on_brand_equity_and_consumer_behavior/links/
577a4ba508aec3b743356345/Social-media-marketing-efforts-of-luxury-brands-Influen
[Accessed 19 September 2017].
Lumen, n.d. Theory of Consumer Choice. [Online] Available at:
https://courses.lumenlearning.com/boundless-economics/chapter/theory-of-consumer-choice/
[Accessed 19 September 2017].
Paquette, H., 2013. Social Media as a Marketing Tool: A Literature Review. [Online] Available
at: http://digitalcommons.uri.edu/cgi/viewcontent.cgi?article=1001&context=tmd_major_papers
[Accessed 19 September 2017].
Parker, A., 2006. Public Attitudes, Perceptions and Behaviours towards Cabin Safety
Communications. [Online] Available at: https://www.atsb.gov.au/media/32927/b20040238.pdf
[Accessed 19 September 2017].
Popova, D., n.d. The Good And Bad Of Social Networks. [Online] Available at:
http://research.bfu.bg:8080/jspui/bitstream/123456789/86/1/BFU_2011_T_XXV_Popova.pdf
[Accessed 20 September 2017].

34DATA INTERPRETATION ASSIGNMENT
Ray, L., 2017. How Does Social Media Influence the Buying Behavior of Consumers. [Online]
Available at: http://smallbusiness.chron.com/social-media-influence-buying-behavior-
consumers-61504.html [Accessed 19 September 2017].
Rohampton, J., 2017. How Does Social Media Influence Millennials' Shopping Decisions?
[Online] Available at: https://www.forbes.com/sites/jimmyrohampton/2017/05/03/does-social-
media-influence-millennials-shopping-decisions/#64daffb4cf3a [Accessed 19 September 2017].
Sen, S.K., 2017. Seeking education loan to study abroad? Here’s what you should know.
[Online] Available at: http://www.moneycontrol.com/news/business/personal-finance-business/
seeking-education-loan-to-study-abroad-heres-what-you-should-know-2354881.html [Accessed
19 September 2017].
Smith, K., 2016. Cars and Millennials: Investigating the Impact of Social Media. [Online]
Available at: https://www.brandwatch.com/blog/millennials-cars-investigating-the-impact-of-
social-on-sales/ [Accessed 19 September 2017].
Wala, K.V.a.A.G., 2014. Social Media Marketing: A Case Study on Jet Airways. [Online]
Available at: http://www.bvimsr.com/documents/publication/2012V4N2/12.pdf [Accessed 19
September 2017].

35DATA INTERPRETATION ASSIGNMENT
Appendix
Calculation of mean, median, Quartile 1, Quartile 3, Inter-quartile range of monthly
household income in USD.
Class
Interval
class
midpoi
nt
fre
qu
enc
y
%freq
uency
income*fr
equency
%
cumulati
ve
frequenc
y
cumula
tive
frequen
cy (x-mean)
(x-
mean)^2
0-9999 4999.5 8 9% 39996 9% 8 -60710.3
368573514
5
10000-
24999 17499.5 11 13% 192494.5 22% 19 -48210.3
232422875
3
25000-
49999 37499.5 24 27% 899988 49% 43 -28210.3 795818526
50000-
74999 62499.5 19 22% 1187490.5 70% 62 -3210.26
10305741.
5
75000-
99999 87499.5 9 10% 787495.5 81% 71 21789.74 474792957
100000
-
124000
112499.
5 7 8% 787496.5 89% 78 46789.74
218928017
3
125000
-
149999
137499.
5 3 3% 412498.5 92% 81 71789.74
515376738
9
150000
-
174000
162499.
5 1 1% 162499.5 93% 82 96789.74
936825460
5
175000
-
199999
187499.
5 1 1% 187499.5 94% 83 121789.7
1.4833E+1
0
20000+ 225000 5 6% 1125000 100% 88 159290.2
2.5373E+1
0
total 88 sum 5782458.5 total
6.4208E+1
0
mean 65709.75568
variance 729639852.8
standard deviation 27011.84653

36DATA INTERPRETATION ASSIGNMENT
N Sum of frequencies
L lower class limit of class containing median
C cumulative frequency of class preceding median class
h class length
f frequency of median class
Median L+(N/2-C)*h/f
N/2 44
L 50000
C 43
h 24999
f 19
Median 51315.73684
First Quartile L+(N/4-C)*h/f
N/4 22
L 25000
C 19
h 24999
f 24
First Quartile 28124.875
Third Quartile L+(3N/4-C)*h/f
3N/4 66
L 75000
C 62
h 24999
f 9
Third Quartile 86110.66667