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 »
Attached


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 irrelevant or inappropriate techniques to analyse data and/or there are many errors in the analysis. 10.5 – 17.4 Uses appropriate descriptive analysis and visualisation tools to analyse the data but there are some errors in the analysis. 17.5 – 20.9 Mostly good analysis of the data using appropriate techniques (both descriptive and inferential) but there are minor errors in the analysis. 21 – 24.4 Very comprehensive analysis of the data using appropriate techniques. Correct 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 research 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 report. 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 correctly 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 research 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 reports 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 current 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. b. 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? b. 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 DayMar 31, 2021MIS771Deakin University

Answer To: PERFORMANCE YET TO ACHIEVE MINIMUM STANDARD MEETS STANDARD EXCEEDS STANDARD Criteria Not Attempted...

Pooja answered on Apr 03 2021
145 Votes
Table of Contents
Introduction    2
Analysis    2
1)    2
2)    3
a)    3
b)    3
3)    4
a)    4
b)    4
c)    5
d)    5
e)    6
4)    7
a)    7
b)    7
Conclusion    8
Appendix    9
2)    9
3)    9
a)    9
b)    10
c)    11
d)    12
e)    13
4)    15
a)    15
b)    15
b)    16
Introduction
I want to analyse the current 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.
    Mon
thlyBill ($)
    
    
    Mean
    67.64667
    Standard Error
    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.
b)
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 Power
    3
    Independents
    25
    Rokafella
    4
    Struggleville
    7
    Suburban Splendour
    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 Power
    3
    2%
    Independents
    25
    17%
    Rokafella
    4
    3%
    Struggleville
    7
    5%
    Suburban Splendour
    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 Suburban 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).
b)
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