Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

PERFORMANCE YET TO ACHIEVE MINIMUM STANDARD MEETS STANDARD EXCEEDS STANDARD Criteria Not Attempted Needs Improvement Satisfactory Good Very Good Exemplary Analysis (Marks: 35%) GLO1 GLO3 Does not use...

1 answer below »
PERFORMANCE YET TO ACHIEVE MINIMUM STANDARD MEETS STANDARD EXCEEDS STANDARD
Criteria Not Attempted Needs Improvement Satisfactory Good Very Good Exemplary
Analysis
(Marks: 35%)

GLO1


GLO3
Does not use any
appropriate exploratory
data analysis tools.
0 – 10.4
Uses i
elevant or inappropriate
techniques to analyse data
and/or there are many e
ors in
the analysis.
10.5 – 17.4
Uses appropriate
descriptive analysis and
visualisation tools to
analyse the data but there
are some e
ors in the
analysis.
17.5 – 20.9
Mostly good analysis of the
data using appropriate
techniques (both
descriptive and inferential)
ut there are minor e
ors
in the analysis.
21 – 24.4
Very comprehensive
analysis of the data using
appropriate techniques.
Co
ect Inferential analysis
methods used to answer
questions.
24.5 – 27.9
Skilful and comprehensive
analysis of the data using
many different
techniques.
28 – 35
Interpretation
(Marks: 60%)

GLO1


GLO5
Does not communicate
any of the main findings
of the analysis in an
accurate or useful way.
0 – 17.9
Interpretation and
communication of findings is at
a basic level or does not
adequately explain the main
findings of the analysis.
18 – 29.9
Explains most of the main
findings of the analysis
accurately, however
descriptive results are not
fully communicated.
30 – 35.9
Provides a reasonable and
accurate description of the
most important features of
the analysis along with
appropriately qualified
conclusions.
36 – 41.9
Provides a very detailed
and accurate description of
the most important
features of the analysis in
appropriate language.
Report clearly addresses
the main research question
asked in the assignment.
42 – 47.9
Provides an outstanding
descriptions and inference
of results. Conclusions are
explained in clear
language and insightful.
The entire report is aimed
to address the main
esearch question (i.e.
clear logical flow across
the entire report). All
analyses assumptions /
limitations are
communicated.
48 – 60
Communication
(Marks: 5%)

GLO1


GLO5
The written
communication is un-
professional, difficult to
follow and/or statistical
terms and jargons are
used throughout the
eport.
0 – 1.4
The written communication is
difficult to follow and/or
contains some statistical terms
and jargons.
1.5 – 2.4
The written
communication is clear
and easy to follow with no
use of statistical terms.
The 3 main elements of a
well-structured statement
(i.e., claim + evidence +
conclusion) is considered
across the entire report.
2.5 – 2.9
The written
communication is clear and
easy to follow, has a
structure. The written
communication is aimed at
audience with no statistical
knowledge. Introduction
and conclusion is insightful
and informative.
3 – 3.4
The written
communication is
professional, easy to
follow. All main sections of
the report including
introduction, main body,
conclusion and appendix
are well-structured, with
consistent formatting.
3.5 – 3.9
The written
communication is truly
professional, logical and
easy to follow. All
necessary analysis outputs
are presented in the
appendix with consistent
formatting, appropriate
titles for all figures and
tables.
4 – 5
OVERALL = 100%
Equivalent of 30 Marks
0 – 29% 30% – 49% 50% – 59% 60% – 69% 70% – 79% 80% – 100%
Overall Description Or Equivalent Fail (N) Or Equivalent Pass (P) Or Equivalent Credit (C) Or Equivalent Distinction
(D)
Or Equivalent High
Distinction (HD)

Assignment-1
Descriptive Analytics and Visualisations Page 1 of 6
MIS771
Descriptive Analytics and
Visualisation

Assignment One

Background
This is an individual assignment. You need to analyse a given data set, and then interpret and draw
conclusions from your analysis. You then need to convey your conclusions using plain language in a
written report to a person with little or no knowledge of Business Analytics.

Percentage of final grade 30%
The Due Date and Time 11.59 PM Sunday 7th April 2019

Submission instructions
The assignment must be submitted by the due date, electronically in CloudDeakin. When submitting
electronically, you must check that you have submitted the work co
ectly by following the
instructions provided in CloudDeakin. Please note that we will NOT accept any paper or email copies,
or part of the assignment submitted after the deadline.
No extensions will be considered unless a written request is submitted and negotiated with the unit
chair before Thursday 4th April 2019, 5:00 PM. Please note that assignment extensions will only be
considered if you attach your draft assignment with your request for an extension.
You must keep a backup copy of every assignment you submit (that is, the work you have done to
date) until the assignment has been marked. In the unlikely event that an assignment is misplaced,
you will need to submit your backup copy. Work you submit will be checked by electronic or other
means to detect collusion and/or plagiarism.
When you submit an assignment through your CloudDeakin unit site, you will receive an email to your
Deakin email address confirming that the assignment has been submitted. You should check that you
can see your assignment in the Submissions view of the Assignment Dropbox folder after upload, and
check for, and keep, the email receipt for the submission.
Penalties for late submission: The following marking penalties will apply if you
submit an assessment task after the due date without an approved extension: 5%
will be deducted from available marks for each day up to five days, and work
that is submitted more than five days after the due date will not be marked.
You will receive 0% for the task. 'Day' means calendar days or part thereof. The
Unit Chair may refuse to accept a late submission where it is unreasonable or
impracticable to assess the task after the due date.
The assignment uses the file A1.xlsx, which can be downloaded from CloudDeakin. Analysis of the
data requires the use of techniques studied in Module-1.
Descriptive Analytics and Visualisations Page 2 of 6
Assurance of Learning
This assignment assesses the following Graduate Learning Outcomes and related Unit Learning
Outcomes:
Graduate Learning Outcome (GLO) Unit Learning Outcome (ULO)
GLO1: Discipline-specific knowledge and
capabilities - appropriate to the level of
study related to a discipline or
profession.

GLO3: Digital Literacy - Using technologies to
find, use and disseminate information

GLO5: Problem Solving - creating solutions to
authentic (real-world and ill-defined)
problems.
ULO 1: Apply quantitative reasoning skills to
solve complex problems.

ULO 2: Use contemporary data analysis and
visualisation tools and recognise the
limitation of such tools.



Feedback before submission
You can seek assistance from the teaching staff to ascertain whether the assignment conforms to
submission guidelines.
Feedback after submission
An overall mark together with suggested solutions will be released via CloudDeakin, usually within 15
working days. You are expected to refer and compare your answers to the suggested solutions to
understand any areas of improvement.

Descriptive Analytics and Visualisations Page 3 of 6
Case Study
You are Lee Slattery, an analyst for BI Intelligence. BI Intelligence is the Business Insider’s paid
esearch service. Business Insider is the world’s fastest-growing business news website, and its
articles include the latest technology, money and market news. BI Intelligence produces a number of
eports on key digital areas, including the mobile industry. Information from those reports is then
subsequently published on the Business Insider’s website by their respective writers.

Sam Edmondson, a tech journalist at Business Insider, wants to publish an article on the cu
ent smart
mobile phone usage in Australia. This is in light of Australia being ranked 2nd in the world behind
Singapore for smartphone usage. Businesses, including Telcos, find this information useful and
subsequently use it to improve their own operations, marketing strategies, etc., for the digital age.
Sam’s article will be wide-ranging and include commentary on the user’s expenditure, usage patterns,
satisfaction levels and demographics.

Sam has asked you to conduct a preliminary analysis of the collected data. In particular, you are
expected to perform a series of descriptive and inferential analyses and produce a report based on
the findings. This report must be written in plain language since the interested party who may read
the report do not necessarily have any statistical knowledge.

Sam’s specific analysis requirements are outlined in his email, which is reproduced on the next page.
Descriptive Analytics and Visualisations Page 4 of 6
Email from Sam Edmondson
To: Lee Slattery
From: Sam Edmondson
Subject: Analysis of Smartphone data
Hi Lee,
As discussed earlier, I have cleaned and simplified the dataset to 11 variables for your convenience.
The cleaned dataset contains information about 150 randomly selected smartphone users.
1. Please provide an overall summary of the monthly bill amount.

2. I would like to build a profile of a typical smartphone user. For a start, please estimate:
a. the average percentage use of Smartphones for work-related activities.
. the proportion of Smartphone users classified as geo tribe ‘Crusaders’.
Please include any other factors that you might think would be appropriate to include in the profile of
the Smartphone user.
3. I would also like to compare our data against several industry publications.
a. An industry report suggests that the average monthly bill has dropped below $72. Is there
any evidence to support this argument?
. A similar study last year reported that 3 out of 4 Smartphone users are either ‘Very
Satisfied’ or ‘Moderately Satisfied’ with their service provider. Would you please check
to see
Answered Same Day Mar 31, 2021 MIS771 Deakin University

Solution

Pooja answered on Apr 03 2021
158 Votes
Table of Contents
Introduction    2
Analysis    2
1)    2
2)    3
a)    3
)    3
3)    4
a)    4
)    4
c)    5
d)    5
e)    6
4)    7
a)    7
)    7
Conclusion    8
Appendix    9
2)    9
3)    9
a)    9
)    10
c)    11
d)    12
e)    13
4)    15
a)    15
)    15
)    16
Introduction
I want to analyse the cu
ent smart mobile phone usage in Australia. There are 11 variables of concern namely Income, Gender, Age, State, geo-Tribe, Used for Payment, Monthly Bill ($), Percent for Work%, On-line Purchase, Social Media Engagement, Satisfaction with Provider.
Analysis
1)
The table of descriptive statistics for monthly bill is mentioned below.
    MonthlyBill ($)
    
    
    Mean
    67.64667
    Standard E
o
    2.546184
    Median
    64
    Mode
    50
    Standard Deviation
    31.18426
    Sample Variance
    972.4582
    Kurtosis
    2.820304
    Skewness
    1.052804
    Range
    205
    Minimum
    11
    Maximum
    216
    Sum
    10147
    Count
    150
The average monthly bill is $68 with a standard deviation of 2.5 only. The low value of standard deviation is an indication that average is a reliable measure of Central Tendency. 50% of the users have a monthly bill below $64. The minimum and maximum value for the monthly bill is $11 and $216. The mode value for monthly bill is $50. This indicates many people have dollar 50 as their monthly bill.
The frequency distribution along with the histogram for the monthly bill is given below.
    Row Labels
    Count of MonthlyBill ($)
    0-24
    9
    25-49
    29
    50-74
    62
    75-99
    28
    100-124
    16
    125-149
    4
    150-174
    1
    200-224
    1
    Grand Total
    150
It is visible from the histogram that the distribution of monthly bill is slightly skewed to the right. This implies that there are very few users with high monthly bill value.
2)
a)
The average percentage of smartphones for work-related activities is calculated to be 16.8 to send only.
)
The pivot table for each category of geo-tribe along with their respective frequency is given below.
    Row Labels
    Count of geoTribe
    Achievers
    30
    Boomers
    6
    Crusaders
    32
    Debtstars
    4
    Fortunats
    2
    Grey Powe
    3
    Independents
    25
    Rokafella
    4
    Struggleville
    7
    Subu
an Splendou
    31
    True Blue
    5
    Twixters
    1
    Grand Total
    150
The relative frequency is calculated by dividing frequency with total number of observations.
    Geo tribe
    Fi
    RfI
    Achievers
    30
    20%
    Boomers
    6
    4%
    Crusaders
    32
    21%
    Debtstars
    4
    3%
    Fortunats
    2
    1%
    Grey Powe
    3
    2%
    Independents
    25
    17%
    Rokafella
    4
    3%
    Struggleville
    7
    5%
    Subu
an Splendou
    31
    21%
    True Blue
    5
    3%
    Twixters
    1
    1%
The proportion of Smartphone users classified as geo tribe ‘Crusaders’ is 32/150 = 21.3%. Crusaders type of geo tribe has the highest frequency. This is followed by Subu
an Splendour, Achievers and Independents with proportion of 21%, 20%, and 17%.
3)
a)
The null hypothesis, the average monthly bill is equal to $72.
An alternative hypothesis, the average monthly bill is less than $72.
With (t= -1.7087, p<5%), I reject the null hypothesis and 5% level of significance. And conclude that the average monthly bill is less than $72.
I am 95% confident that estimated population mean monthly bill lie in the interval ($63, $73).
)
Null hypothesis, ho: proportion of smartphone users who are either ‘Very Satisfied’ or ‘Moderately Satisfied’ with their service provider is less than or equal to 75%. P <= 75%
Alternative hypothesis, h1: proportion of smartphone users who are either ‘Very Satisfied’ or ‘Moderately Satisfied’ with their service provider is greater than 75%. P > 75%
With z = -1.79, p>5%, I fail to reject the null hypothesis and conclude that proportion of smartphone users who are either ‘Very Satisfied’ or ‘Moderately Satisfied’ with their service provider is less than or equal to 75%. P <= 75%.
Hence the statement of last year that 3 out of 4 Smartphone users are either ‘Very Satisfied’ or ‘Moderately Satisfied’ with their service provider is still valid.
I am 95% confident that estimated population proportion smartphone users who are either ‘Very Satisfied’ or ‘Moderately Satisfied’ lie in the interval (61%, 76%).
c)
The bar chart for the relationship between gender and Satisfaction With Provider is given below.
The number of users who are satisfied with provider is noticeable. There are more female users who are moderately satisfied with provider in comparison to male users. There are more male users who are highly satisfied with provider in comparison to female users.
Null hypothesis, ho: there a difference in the level of satisfaction between male and female users.
Alternative hypothesis, h1: there is no difference in the level of satisfaction between male and female users.
With (chisq = 4.27, p >5%), I fail to reject null hypothesis and conclude that there is no difference in the level of satisfaction between male and female users.
d)
The bar chart for average monthly bill between smartphone as a not payment device and as a payment device is given below.
The average monthly bill for smartphone as no payment device is 59.39$. This is less comparison to payment device for which the average Is 70.25$.
Null hypothesis, ho: there is no significant difference in the average monthly bill between smartphone as a not payment device and as a payment device.
Alternative hypothesis, h1: the average monthly bill for smartphone as no payment device is less comparison to payment device.
With t=-1.9, p<5%, I reject the null hypothesis at 5% level of significance and conclude that the average monthly bill for smartphone as no payment device is less comparison to payment device.
I am 95% confident that estimated population mean difference in the average monthly bill of no payment device and payment device smart-phone user lie in the interval (-22,27, 0.55).
e)
The pie chart for the proportion of users who use Smartphones for online purchases between highly active in social media and moderately active in social media is given below.
The proportion of users who use Smartphones for online purchases...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here