Using aggregation functions for data analysis

Using aggregation functions for data analysis

Using aggregation functions for data analysis

Total Marks 100, Weighting 20%

The provided zip file contains the data file [RedWine.txt] and the R code [AggWaFit718.R] to use with the following tasks, include these in your R working directory. You can use the R script [template.R] to organise your code.

Clarification and related resources are provided

Red wine quality Dataset

The given dataset, “RedWine.txt”, is used to model wine quality based on physicochemical tests. The dataset provides the 1,599 red wine samples from the north of Portugal. It is a modified version of the data used in the study [1]. This dataset includes 5 variables, denoted as X1, X2, X3, X4, X5, and Y, described as follows:

X1 – citric acid X2 – chlorides

X3 – total sulfur dioxide X4 – pH

X5 – alcohol

Y – quality (score between 0 and 10)

[1] P. Cortez, A. Cerdeira, F. Almeida, T. Matos and J. Reis. Modeling wine preferences by data mining from physicochemical properties. In Decision Support Systems, Elsevier, 47(4):547-553, 2009.

Assignment Tasks

  • Understand the data
    1. Import the txt file (RedWine.txt) and save it to your R working directory.
    1. Assign the data to a matrix, e.g. using the.data <- as.matrix(read.table(“RedWine.txt “))
    • The variable of interest is quality (Y). To investigate Y, generate a subset of 440 data, e.g. using:

my.data <- the.data[sample(1:1599,440),c(1:6)]

[The following tasks are based on the 440 sample data]

  • Using scatter plots and histograms to understand the relationship between each of the variables X1, X2, X3, X4, X5 and the variable of interest Y.
  • Transform the data

Choose any four from the five variables (X1, X2, …, X5). Make appropriate transformations to the chosen four variables and the variable of interest Y individually, so that the values can be aggregated in order to predict the variable of interest. Assign your transformed data along with your transformed variable of interest to an array.

[All the following tasks are based on the saved transformed data]

  • Build models and investigate the importance of each variable
    • Import AggWaFit718.R file to your working directory and load into the R workspace using, source(“AggWaFit718.R”)
    • Evaluating the following fitting functions on the transformed data:
      • A weighted arithmetic mean (WAM)
      • Weighted power means (WPM) with P=2
      • An ordered weighted averaging function (OWA)
  • Use your model for prediction

Using your best fitting model based on Q3, predict the wine quality for the input: X1=1; X2= 0.075; X3=41; X4=3.53; X5=9.3.

[Apply the same pre-process as Q2 for the new input]

  • Summarising your data analysis procedures in up to 20 slides for a 5-minutes presentation. The slides should include the following contents:
  • What kinds of the data distribution you have identified in the raw data.
  • Explain the transformations applied for the selected four variables and the variable of interest.
  • Include two tables – one with the error measures and correlation coefficients, and one summarising the weights/parameters and any other useful information learned for your data.
  • Explain the importance of each of the variables (the four variables that you have selected).
  • Which fitting function is the best fitting model on your selected data.
  • Give your prediction result and comment on whether you think it is reasonable.
  • Discuss the best conditions (in terms of your chosen four variables) under which a higher quality wine will occur.
  • Comment the implications and the limitations of the fitting model you used for prediction.

The 5-minutes presentation can be using a simple and accessible platform such as YouTube or PowerPoint Audio.

Submission requirements

Submit to the SIT718 CloudDeakin Dropbox. Your final submission must include the following TWO files:

  1. The slides with audio (a link to YouTube/Dropbox is acceptable).
  2. The R code file (that you have written to produce your results) named “name- code.R” (where “name” is replaced with your surname or first name).

Your assignment will not be assessed if the code is missing, or the outputs of the code are inconsistent with the slides.

Following Harvard style for code citation and reference in your R script with comments

You must cite all the datasets and packages you used for this assessment. You will lose some scores for inappropriate citations/references.

Order Now

Get expert help for Using aggregation functions for data analysis and many more. 24X7 help, plag free solution. Order online now!

Universal Assignment (February 29, 2024) Using aggregation functions for data analysis. Retrieved from https://universalassignment.com/using-aggregation-functions-for-data-analysis/.
"Using aggregation functions for data analysis." Universal Assignment - February 29, 2024, https://universalassignment.com/using-aggregation-functions-for-data-analysis/
Universal Assignment May 22, 2023 Using aggregation functions for data analysis., viewed February 29, 2024,<https://universalassignment.com/using-aggregation-functions-for-data-analysis/>
Universal Assignment - Using aggregation functions for data analysis. [Internet]. [Accessed February 29, 2024]. Available from: https://universalassignment.com/using-aggregation-functions-for-data-analysis/
"Using aggregation functions for data analysis." Universal Assignment - Accessed February 29, 2024. https://universalassignment.com/using-aggregation-functions-for-data-analysis/
"Using aggregation functions for data analysis." Universal Assignment [Online]. Available: https://universalassignment.com/using-aggregation-functions-for-data-analysis/. [Accessed: February 29, 2024]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Categories

Get 90%* Discount on Assignment Help

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

ORGANISATIONAL STRATEGY PLANNING AND MANAGEMENT ASSIGNMENT

POSTGRADUATE DIPLOMA IN BUSINESS MANAGEMENT ORGANISATIONAL STRATEGY PLANNING AND MANAGEMENT ASSIGNMENT NOTE: At postgraduate level, you are expected to substantiate your answers with evidence from independent research. INTRODUCTION TO THE ASSIGNMENT • This assignment consists of FOUR compulsory questions. Please answer all of them. • When you answer, preferably use

Read More »

Solution: Scenario 1, Mirror therapy in patients post stroke

Title: Scenario 1, Mirror therapy in patients post stroke Part 1 : Summary Ramachandran and colleagues developed mirror therapy to treat amputees’ agony from phantom limbs. Patients were able to feel their amputated limb without experiencing any pain by presenting them a mirror image of their healthy arm. Since then,

Read More »

Solution: Exploring the Dominance of Silence

Slide 1: Title – Exploring the Dominance of Silence The title, “Exploring the Dominance of Silence,” sets the stage for a deep dive into the portrayal of silence in Philip K. Dick’s “Do Androids Dream of Electric Sheep?” Our presentation will dissect the literary techniques used by the author to

Read More »

Solution: Assessment: Critical Reflection S2 2023

The policies that hampered the cultural survival of Indigenous groups have a major effect on their health (Coffin, 2007). Cultural isolation can cause an identity crisis and a sense of loss, which can exacerbate mental health problems. Indigenous people have greater rates of chronic illness and impairment due to historical

Read More »

Solution: The Market – Product and Competition Analysis

Section 1: The Market – Product and Competition Analysis Industry and Competition Analysis: The baking mix market is very competitive, but My Better Batch is entering it anyhow. The prepackaged baking mixes sold in this market allow busy people to have bakery-quality products on the table quickly without sacrificing quality

Read More »

Solution: PDCA model for Riot

Student Name: Student ID: University Name: Date: Learning Outcome 1: Engage actively in recognizing a new product/service for Riot and detect the vital tasks required for its effective growth. In this comprehensive learning outcome, Riot’s progress towards innovation superiority is characterized by a deliberate scheme that draws on components from

Read More »

Solution: EDEN 100 – ASSIGNMENT 1

Part 1: Reflections on the Register Variables Use the questions in Column 1 and analyse the sample oral interactions provided under the assessment tile. The transcript for Viv’s conversation is provided on pages 4-5. Probe Questions  Link to readings and theory Interaction 1 Interaction 2 PART 1 – ANALYSING THE

Read More »

Solution: TCP/IP Questions

Table of Contents Question 1. 1 1. IPSec datagram protocol 1 2. Source and destination IP addresses in original IP datagram.. 1 3. Source and destination IP addresses in new IP header 2 4. Protocol number in the protocol field of the new IP header 2 5. Information and Bob.

Read More »

Solution: Fundamentals of Employment Assistance Program and Counselling

ASSESSMENT 3 Subject: Fundamentals of Employment Assistance Program and Counselling Case study Question 1 a)     Major Issues for Theo that could be addressed in counselling: b)    Issues to Address First in Short-Term Counselling:             The cognitive processes of memory, focus, and decision-making are all impacted by insufficient sleep. Such cognitive

Read More »

Solution: EQUITY AND INCLUSION IN EARLY CHILDHOOD IN AUSTRALIA

Written Policy Recommendation Name: Student Number: Email: Date: Introduction: The early years of a child’s life are important for their holistic development, making early childhood education a foundation for their future accomplishments. Nevertheless, guaranteeing equality and inclusion in early childhood education stays a major problem in our society. This policy

Read More »

Solution: Report Health Issue

Table of Contents Executive Summary                                                                                                   3 Introduction                                                                                                                5 Examination of the Chosen Health Issue in the Context of Lambeth                        5 Application of Health Inequality Framework and Analysis of Determinants: Psychotropic Drug Use in Lambeth                                                                           6 Exploration and Discussion of Strategies to Manage Psychotropic Drug Use in Lambeth                                                                                                                        7 Conclusion                                                                                                                  8

Read More »

Solution: Section III: Marketing

Section III: Marketing Channels for Advertising: Understanding Who Makes Baking Product Purchase Decisions is Crucial for My Better Batch’s Business Success (Sampson et al, 2017). Home bakers may make up a disproportionate share of the decision-makers in the UK. As a result, My Better Batch has to target people, especially

Read More »

Solution: Analytics Project Project Management Plan

Analytics Project Project Management Plan Date: 22-10-2023 Author: Name Here Version: 2.0 Project Management Plan (PMP) This project management plan will outline the strategies and plans used to manage ‘analytics project’ for the Style-Hub organization. It will include the tasks such as project governance, management, planning, budget and controlling. It

Read More »

Solution: Report Health Issue

Table of Contents Executive Summary                                                                                                   3 Introduction                                                                                                                5 Examination of the Chosen Health Issue in the Context of Lambeth                        5 Application of Health Inequality Framework and Analysis of Determinants: Psychotropic Drug Use in Lambeth                                                                           6 Exploration and Discussion of Strategies to Manage Psychotropic Drug Use in Lambeth                                                                                                                        7 Conclusion                                                                                                                  8

Read More »

Solution: Mirror therapy in patients post stroke

Title: Scenario 1, Mirror therapy in patients post stroke Part 1 : Summary Ramachandran and colleagues developed mirror therapy to treat amputees’ agony from phantom limbs. Patients were able to feel their amputated limb without experiencing any pain by presenting them a mirror image of their healthy arm. Since then,

Read More »

Solution: Case Study – HR Activities

Cover Page Case Study – HR Activities title of assessment unit code unit name semester and year assignment title student name student number tutor name and word count Executive Summary The research suggests two main HR initiatives to help Actualise Health deal with its workforce issues: acquiring and developing talent,

Read More »

Solution: Building a Foundation for Equity and Inclusion

Script – Slide 1: Title and Introduction Greetings, everyone. My name is…, and I would like to discuss a vital concern in early childhood education – equality and inclusion. At present, I’m going to explain why this matter is so important and what research and guidelines indicate about it. Slide

Read More »

Solution: EQUITY AND INCLUSION IN EARLY CHILDHOOD IN AUSTRALIA

Written Policy Recommendation Name: Student Number: Email: Date: Introduction: The early years of a child’s life are important for their holistic development, making early childhood education a foundation for their future accomplishments. Nevertheless, guaranteeing equality and inclusion in early childhood education stays a major problem in our society. This policy

Read More »

Expression of Interest (EOI)

The focus of this Expression of Interest is to demonstrate why you are a good fit for the selected project based on your learning in IKC101.Context:You are submitting an Expression of Interest (EOI) to lead a project connected to the organisation you have chosen. You are required to explain your

Read More »

COM10007 Professional Communication Practice

Assignment 3: PresentationWord/time limit: Five minutes (+/- 10%)Weighting: 15% (Presentation + reference list)Assignment detailsFor this assignment, you are required to consider those who work in the following sectors and describe the key responsibilities of a professional communicator in a particular context—including types of audiences, key messages and delivery modes. You

Read More »

ELT2014 Special Educational Needs and Disabilities

ELT 2014 Assessment 1 – Case Study Module code ELT2014 Module title Special Educational Needs and Disabilities Submission date, time 27/2/24 @ 5pm: Group Presentation slides for part (a) uploaded to TurnItIn 28/2/24 : Group Presentations in class for part (a) – ALL MUST ATTEND 22/3/24 @ 9pm: Suggested deadline

Read More »

Applied Pathobiology Assessment 2 – case study

This assessment covers 30% of the marks for this module. Instructions   Case 1 Vivienne A. (mother) and Isabel A. (daughter) go to the GP for prolonged fatigue in the last four months. Vivienne is a retired 74-year-old teacher, who reports fatigue, tingling and numbness in her hands and feet,

Read More »

Assignment Legislative Framework for Governance

It’s now time to complete your assessment. At Level 5, you must demonstrate that you can follow academic writing standards, including checking your writing for spelling and grammar, referencing using Harvard referencing (or similar) guidelines and utilising critical analysis skills. If you are unsure about these, speak to your Advanced

Read More »

BIK0028/BIH2014 Tips for Individual report assessment

Guidance document: Tips for Individual report assessment BIK0028/BIH2014 Individual report Assessment Assessment brand of your choice. rarity, extraordinariness and a high degree of non-functional associations” (Heine, 2012, p.62). Your work should include the following •       A brief introduction to the selected brand characteristics etc.) •       Your analysis of consumers’ behaviour

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?