Call / WhatsApp: UK: +44 7308 518706 | USA: +1 8126514131
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Assignment Studio

  • Services
    • Academic Writing Service
      • Assignment Help
      • Academic Assignment Help
      • Assignment Writers
      • Custom Writing Services
      • Online Assignment Help
      • Effective Note-taking – Assignment Help
      • Assignment Help Australia
      • Write My Assignment
      • Help on Assignments
      • Buy Assignment Online
      • Best Assignment Helper
      • Assignment Paper Help
      • College Assignment Help
      • Help with Assignments Online
      • Get Assignment Help
      • Homework Assignment Help
      • Thesis Writing Services
      • Online Assignment Writer
      • Collect material
    • Assignment By Cities
      • Perth Assignment Help
      • Brisbane Assignment Help
      • Adelaide Assignment Help
      • Gold Coast Assignment Help
      • Geelong Assignment Help
      • Newcastle Assignment Help
      • Sydney Assignment Help
      • Melbourne Assignment Help
      • Hobart Assignment Help
    • Assignments by Universities
      • Swinburne Assignment Help
      • Monash Assignment Help
      • Latrobe University Assignment Help
      • Monash Assignments
      • Coles Assignment Help
      • Melbourne University Assignment
      • CQU Assignment Help
      • NMIT Assignments
      • RMIT Assignments
    • Essays
      • Essay Writing Guide
        • How to Write an Essay
        • Creating an Essay Structure
        • Essay Marking Schemes
        • How To Write An Essay Plan
        • Interpreting Your Essay
        • Writing An Essay Title
        • Writing A Critical Evaluation
      • Essay Help
        • Argumentative Essay
        • Critical Essay
        • Essay Writing Help on Comparison Essay
        • College Essay
        • Deductive Essay
        • Essay Writer
        • Admission Essay
        • Online Essay Help
        • Do My Essay Online
        • Evaluative Essay
        • History Essay Help
        • Research Essay Help
        • Urgent Essay Help
        • Top Quality Essay
        • Top Essay Writing Companies
        • Cheap Essay Writing Help
        • Professional Essay Help
        • Cheap Essay Writer
        • Essay Writers Online
        • Need Help Writing Essay
        • Essay Homework Help
        • Write Essay Online
      • Types of Essay
        • Argumentative Essay
        • Admission Essay
        • College Essay
        • Comparison Essay
        • Definition Essay
        • Deductive Essay
        • Evaluative Essay
        • Narrative Essay
        • Personal Essay
      • Essay Writing Tips
        • College Essay Help
        • Essay Writing Help
      • Essay Help Cities
        • Assignment Writer Sydney
        • Assignment Writer Brisbane
        • Assignment Writer Melbourne
        • Assignment Writer Perth
        • Essay Writer Sydney
        • Essay Writer Melbourne
        • Essay Writer Perth
        • Essay Writer Australia
        • Essay Assignment Help
    • Other Services
      • Dissertation Writing Assignment Help
      • Cheap Assignment Help
      • Creating An Appendix
      • Assignment Help Tutors
      • Assignment Assistance Australia
      • Student Assignment Help
      • Last Minute Assignment Help
      • Urgent Assignment Help
      • Assignment Provider
      • Do My Assignment Help
      • Make My Assignment For Me
      • Solve My Assignment
      • Custom Assignment Writing
      • How to Write a Dissertation – Assignment Help
      • Quality Assignment Help
      • Write My Assignment For Me
      • Assignment Writing Tips
      • Buy Assignment
    • Article Writing Service
    • Assignment Help UK
    • Animation Assignment Help
    • Coursework Help
    • College Assignment Help
    • Leadership Assignment Help
    • Network Planning Assignment Help
    • Dissertation Proposal Writing Help
    • Report Writing Help
    • My Assignment Help
    • Microsoft PowerPoint Presentation
    • Pecha Kucha Presentation Help
    • Pestel Analysis Assignment Help
    • University Assignment Help
    • Video Presentation Assignment Help
  • Homework Help
  • Subjects
    • Accounting
      • Auditing Assignment Help
      • Business Accounting Assignments
      • Management Accounting Assignment Help
      • Professional Accounting Assignment Help
    • Economics
      • Economics Globalization Assignments
      • Micro Economics Assignments
      • Macro Economics Assignments
      • Business Economics Assignments
      • Managerial Economics Assignments
    • Finance
      • Principle Of Finance Assignments
      • Financial Management Assignment Help
      • Financial Accounting Assignments
      • Introduction Corporate Finance Assignments
    • Business
      • Entrepreneurship Assignment Help
      • Leadership Assignment Help
      • Business Assignment Help
      • Project Management Assignment
      • Supply Chain Management
      • Business Management Assignment Help
      • Human Resource Assignment Help
      • Operation Management Assignment
      • Leadership Assignment
      • Change Management Assignment Help
    • Law
      • Contract Law
      • Constitutional Law
      • Corporate Law
      • Common Law
      • Criminal Law
      • Commercial Law
      • International Law
      • Property Law Assignment
      • Taxation Law Assignment
      • Tort Law Assignment
    • Engineering
      • Engineering Assignment Help UK
      • Civil Engineering
      • Computer Engineering
      • Mechanical Engineering
      • Software Engineering
      • Online Engineering Assignment Help
      • CDR Writing
      • CDR Assignment Help
    • Marketing Assignment Help
      • Marketing Assignment Help
      • Social Media Marketing Help
      • Digital Marketing Assignment
      • 4ps Of Marketing Assignment Help
      • Pestel Analysis Assignment
    • Assignment Help On Companies
      • woolworths Assignment Help
      • Costco Assignment Help
      • Coles Assignment Help
    • Popular Assignments
      • Pricing Strategy Assignment
      • Sales Promotion Assignment
      • Porters Five Forces assignment
      • Solve Accounting Assignment
      • Bitcoin Assignment Help
      • Lehman Brothers and Enron Scandal Auditing Assignment
      • IT Management Assignment Help
      • Healthcare Management Help
      • Decision Making Assignment
    • Project Management Assignment Help
    • Artificial Intelligence Assignment Help
  • Sample Assignments
  • Resources
    • Assignment details
    • Give us a Feedback
    • Make a Payment
    • Plagiarism Checker
    • Privacy policy
    • Refer a Friend
    • Submit Documents & Earn
    • Terms of service
    • Word Counter
  • Blogs
  • Get a Quote
SignupLogin
 June 7, 2025

Get online Expert's Help on

7318AFE - Business Data Analytics

7318AFE – Business Data Analytics Assignment Help

Assignment Guide

  • Answer ALL questions.
  • Total marks: 40.
  • Data for this assignment are available from the course L@G website.
  • Use Jupyter Notebook/Python to achieve the answers.
  • Justification is required if your (Python) coding is beyond what have been taught in the class – lack of clear justification will be marked off (even if the results are correct).
  • Type up your answers in a Word file (you may copy & paste some of the Python outcomes to the file).
  • Assignment submission: upload two files – [1] the Word file [2] the Jupyter Notebook/Python file (either pdf (preferred) or ipynb).
  • Note that the Word file should be self-contained (answers + supported Python outcomes + discussion/interpretation).
  • You must complete the Academic Integrity Declaration for online exams & safe assignment check before submission.
  • Late submission without approval is subject to penalty.
  • Due: 1pm (Friday) 09 October 2020.

Question 1 (10 marks)

Use data from H2019.csv to answer this question. The dataset has the following variables

  • Country: country name
  • Hscore: happiness score (higher score implies higher degree of happiness)
  • logGDP: log GDP per capita
  • Freedom: freedom to make life choice (higher score implies higher degree of freedom)
  • GQuality: Government Quality (higher score implies higher degree of government qaulity)
  1. Classify countries with logGDP larger than 9.9 as ‘Rich’ countries & all others as ‘not-Rich’ countries. How many countries are in the Rich group? Test if the mean of Hscore for Rich countries is the same as it is of not-Rich countries. Use the 6 steps of hypothesis testing to report the testing outcomes.
  2. Find the 99% confidence interval (CI) of the mean of GQuality of Rich and Not-Rich countries, separately. Present the CI formula and interpret the results.
  3. Report the OLS regression results of Hscore on logGDP, Freedom, and GQuality with statsmodels for all countries. Interpret the estimated slope coefficients (the partial effects) and the R-squared.
  4. Obtain the predicted Hscore based on the regression result of Part 3. Is the country with highest predicted Hscore the same as the one with highest acutal HScore? Which country’s Hscore is most over-predicted? Which country’s Hscore is most under-predicted?
  5. Extend the regression model in Part 3 to assess if logGDP and GQuality show a synergy (complementary) effect to Hscore? Comment on the results.

Stuck with your Assignment?

Hire Qualified Writers for Assignment Help at Low Price

WhatsApp Get a Quote

Question 2 (10 marks)

Load Covid19 data from the following link https://raw.githubusercontent.com/datasets/covid-19/master/data/countries-aggregated.csv and use the data to answer this question. Obtain data till the end of September (2020-09-30). (Alternatively, use covid0930.csv.) Note that the three numerical variables (Deaths, Confirms, and Recovered) in the dataset are accumulated figures (i.e. ‘total’ numbers up to date).

  1. Find countries with total (accumulated) deaths over 15000 and obtain the first date for each of these countries when it happened. Find the dates that the total covid death number globally surpass 500000 and 1000000, respectively.
  2. Compute the global daily death rate (i.e. “Deaths” divided “Confirmed” across all countries in each day) and plot it in a line chart. Identify the period that the overall daily death rate is higher than 4%.
  3. Find countries with at least one day having more than 20000 new confirmed cases. How many countries have never experienced over 100 daily new confirmed cases?
  4. Find ‘increased deaths’ globally during each of the following months: March, April, May, June, July, August, and September (i.e. new deaths in each month) and make a bar plot to present these 7 monthly death figures. Comment on the plot.
  5. Make 3 line plots (in one graph) of daily new confirmed cases in Australia: original, 7-day rolling (moving average), and 14-day rolling. Comment on the plot and identify the peak date of each series (line).

Question 3 (10 marks)

Use the dataset yelp1000.xlsx to answer this question. The dataset contains the following columns: date, stars, text (restaurant text reviews), cool, useful, and funny.

  1. Create a pie plot of the number of reviews (texts) for each type of star rating. Find the most frequent word used (excluding stopwords) for each type of star rating.
  2. Obtain sentiment scores (compound, neg, neu and pos) of each review (text). Report the most positive text and the most negative one. How many texts are with neu score equal to 1?
  3. Find the interquartile range of compound for each stars group (1 to 5) and make a boxplot of compound using different color for each stars group. Comment on the outcomes.
  4. Find the total number of reviews in 2011 and 2012, respectively. Find the proportion of compound below zero in 2011 and 2012, respectively. Compute the 90% confidence interval of the proportion of compound below zero in 2011 and 2012, respectively. Comment on the results.
  5. Use “apply(len)” to create a new column called “length” which is the number of words in the text column. Test if 60% (60 per cent) of the reviews (texts) are with more than 500 words (including space). State the null hypothesis and the alternative hypothesis. Comment on the results.

 

Question 4 (10 marks)

Use loans1000.csv for this question. There are 6 variables in the dataset (see below) — it is of interest to use [1]-[5] to predict [6]. Set random_state=1234 throughout (when required).

  • [1] credit.policy: 1 if the customer meets the credit underwriting criteria, and 0 otherwise.
  • [2] log.annual.inc: The natural log of the self-reported annual income of the borrower.
  • [3] dti: The debt-to-income ratio of the borrower (amount of debt divided by annual income).
  • [4] fico: The FICO credit score of the borrower.
  • [5] delinq.2yrs: The number of times the borrower had been 30+ days past due on a payment in the past 2 years.
  • [6] not.fully.paid: 1 if not fully paid the loan, and 0 otherwise.
  1. How many borrowers do not pay the loan fully? Are the mean values of FICO credit score significantly different between fully-paid borrowers and not.fully.paid borrowers? Justify.
  2. Apply KMeans clustering using [1]-[5] (i.e. credit.policy, log.annual.inc, dti, fico, and delinq.2yrs). Find the optimal number clusters (set the maximum number of clusters as 10) without scaling. Justify your answer.
  3. Form 2 clusters (with KMeans) and use the crosstab to examine if the clustering outcome is in line with borrower’s “not.fully.paid” status. Comment on the results.
  4. Create a random partition of the loans1000.csv dataset with 70% of observations in the training set and the remaining 30% in the test set. Report the sample mean and standard deviation for each of the variables in both train and test sets, separately. Comment on the results.
  5. Based on the data split of Part 4, apply Decision Tree, Random Forest, and Gradient Boosting (with n_estimators=1000) to the Train set and use the obtained models to predict the Test set. Use accuracy, precision, and recall to evaluate the performance of these models. Comment on the results.

For Complete Assignment Solution 

Place your Order Now

 

Need Urgent Academic Assistance?

Price Starts from $10 Per Page

*
*
*
*

Get Instant Help through WhatsApp

Assignment Studio - Your Partner in Academic Success!

For Students in UK

WhatsApp

For Students in USA

WhatsApp

Popular Services

Assignment Help

Homework Help

Essay Help

Dissertation Help

Assignment Help UK

Thesis Help

Research Paper Help

Report Writing Help

CDR Writing

Popular Subjects

Law Assignment Help

Engineering Assignment Help

Marketing Assignment Help

Project Management Assignment Help

Accounting Assignment Help

Business Assignment Help

Economics Assignment Help

Artificial Intelligence Assignment Help

Assignment Help on Companies

Finance Assignment Help

Auditing Assignment Help

Leadership Assignment Help

Video Presentation Assignment Help

Nursing Assignment Help

Statistics Assignment Help

IT Assignment Help

Database Assignment Help

Programming Assignment Help

Social Media Assignment Help

Samples

Sample Assignment Solutions

Essay Writing Samples

Literature Review Samples

Case Study Samples

Marketing Report Samples

Worldwide Services

United Kingdom

United States

Australia

Canada

United Arab Emirates

Singapore

Resources

Word Counter

Submit Documents & Earn

Plagiarism Checker

Refer & Earn

Give us a Feedback

Order a New Assignment

Quick Links

Terms & Conditions

Refund Policy

Privacy Policy

Blog

Refer & Earn upto 4000$

Our Globally Trusted Assignment Help Service Delivers Tailored Solutions with Expert Guidance, Timely Delivery, and Unmatched Quality for Students in the UK, Australia, and USA!

Contact Us

UK Office

101, Gower Street,WC1E 6AA, London, United Kingdom

Mobile

+44 7308 518706

USA Office

Brooklyn 11216, New York, United States

Mobile

+1 8126514131

Australia Office

533 Little Collin Street, Melbourne, Australia

Assignment Studio © 2025 All rights reserved.

TOP
Order Notification

[variable_1] from [variable_2] has just ordered [variable_3] Assignment [amount] minutes ago.

Get 1-On-1 Customized Essay Assistance

Order Now and Get 40% Off

*
*
*
*

Get 1-On-1 Customized Research Proposal Assistance

Order Now and Get 40% Off

*
*
*

Get 1-On-1 Customized Dissertation Assistance

Order Now and Get 40% Off

*
*
*

Get 1-On-1 Customized Thesis Assistance

Order Now and Get 40% Off

*
*
*

Order Now

Order Now and Get 40% off on your Assignment 

*
*
*
*

Order Now and Get 25% off For September-October only

textbox6129
textarea1740
Select FileChangeRemove
fileupload7305

‹›×

    Get Assignment Help from Expert Writers

    From World's No.1 Assignment Help Company

    *
    *
    *
    *
    *
    *
    Hire Professional Writers at Low Prices!
    *
    *
    *
    *