Task - statistics and data analysis project

Assignment Help Applied Statistics
Reference no: EM132218709 , Length: word count:1500

STATISTICAL DATA ANALYSIS AND DECISION MODELLING ASSIGNMENT -

ASSESSMENT TASK - STATISTICS AND DATA ANALYSIS PROJECT

The objective of this assignment is to apply statistical theory covered in the subject to business situations. Students are given data related to a simulated real-world business case. Students must read and analyse the case using appropriate statistical method and tests by using Microsoft Excel/PHStat.

Students are required to:

(a) Comprehensively explain and critically analyse the relationship between the business issues;

(b) Apply appropriate and accurate statistical model to solve the business issues;

(c) Evaluate, analyse, and discuss the model outcomes; and

(d) Communicate findings and draw critical justified conclusions and present recommendations with supporting evidences and implications.

Note: (a) to (c) is the ACTION PLAN and (d) is the MANAGEMENT REPORT.

For the first assignment, we want to predict the future price of a company's shares on the stock exchange. There are several companies to choose from:

CMP = Compumedics Limited (a pharmaceutical company)

ESL = ESL Australia (makes video games)

MCD = McDonalds (a fast food chain)

PKG = Packaging Corporation of America (makes packaging materials)

VLO = Valero Energy Corporation (refines petroleum)

WERN = Werner Enterprises (transportation and logistics)

In these files:

The last column is the future change in a company's share price, i.e., the change from the close of trading today to the open of trading tomorrow morning. This is the dependent variable (Y).

All the other columns are the price (or the changes in price) of various financial instruments, including the price of the same company's shares, interest rates, currency exchange rates, and the price of oil and certain metals (gold, silver, copper, aluminium). These are the independent variables (Xs).

The original price changes have been ranked and sorted, so that all numbers go from 0 to 1:

0 means the smallest value.

1 means the biggest value.

0.5 means the median value.

Some columns are also interaction variables, i.e., a new column created by multiplying 2 other columns. These have "_X_" in their title. For example, "30year_x_Aluminium" means the number is these two numbers multiplied together.

Students need to create a regression model to see if a relationship exists between an output variable and the input variables and improve the model stepwise. Students are also expected to critically evaluate and discuss the model (or models) and draw conclusions about how well we can (or can't) use the model to make predictions.

Students are required to submit a REPORT including the following:

(1) Action Plan - students should explain their approach to build the regression model(s) and discuss its regression outputs, the stepwise approach or best subset approach and the decision for the final model. Students should attach the Excel output as evidence of their work. In the action plan, students will meet the criteria (a) to (c). The action plan serves as the supporting evidence or reference for the management reporting. No word limits. Student's (1) knowledge and application and (2) analysis and evaluation will be assessed in this section.

(2) Management reporting - In this report, students will compare their models, summarise their findings, justify their conclusions and present their recommendations as requires in part (d). The management report will evaluate students' ability to communicate with management with correct writing style and syntax.

The word limit is 1500.

Attachment:- Assignment Files.rar

Reference no: EM132218709

Questions Cloud

How can you assess the financial viability : How can you assess the financial viability and merit of your program? What indications will inform you and others whether your financial strategies.
Discuss the scope of evaluation and the scream values : It is important to focus on values as they guide our decision making on an individual, organizational, and other relevant levels.
Explain christian perspective of the nature of spirituality : In 250-300 words, explain the Christian perspective of the nature of spirituality and ethics in contrast to the perspective of postmodern relativism.
What differences did you see in organization and agility : In your opinion, how was the outcome of this hurricane response and recovery effort different from the outcome of Katrina?
Task - statistics and data analysis project : CO5124: STATISTICAL DATA ANALYSIS AND DECISION MODELLING ASSIGNMENT, JAMESCOOK University, Australia. STATISTICS AND DATA ANALYSIS PROJECT
Identify a health information system : Identify a health information system, explain how it improves healthcare outcome. Identify the organization you work for uses this system.
Create a comprehensive mission statement for the clinic : Create a comprehensive mission statement for the clinic, and discuss how it will facilitate the provision of quality services.
Write an concept introduction of stakeholder analysis : Write an Concept introduction of Stakeholder analysis & Communication Plan, around 250-300, use APA reference
Discuss an ethical or legal implications : Post a brief summary of the article you selected. Include the key reimbursement issue addressed and how they would impact the NP in a collaborative practice.

Reviews

len2218709

1/19/2019 1:29:54 AM

The word limit is 1500. Usually, only the report is submitted. But keeping the Microsoft Excel spreadsheets is recommended just in case some clarification is needed. Assignment 1 is due on 11:59pm Friday 14. Reports should be submitted through SafeAssign on or before the deadline.

len2218709

1/19/2019 1:29:49 AM

Knowledge and Application - Application of concepts and statistical skills to analyse relevant data/information - Comprehensively explains and critically analyzes the relationship between the business issues and practice and solving using appropriate and accurate statistical techniques / models. Analysis and Evaluation - Interpret statistical models, draw conclusions and recommendations - All findings have been interpreted correctly and critically discussed. Draw critically justifies conclusions and present recommendation with supporting evidences and implications.

len2218709

1/19/2019 1:29:42 AM

Writing Style & Conventions Formal and informal rules inherent in the expectations for writing a professional report. Communication is superior, demonstrating excellence in knowledge of focus, purpose and intent. The report is presented professionally, using informative headings and figures/tables/graphs where appropriate in the correct style and format. Introduction well structured. Control of Syntax and Mechanics Sentence construction; grammar; punctuation & spelling. Uses appropriate language, correct punctuation, grammatically correct and good sentence construction that conveys meaning to readers with clarity and no spelling errors. Paragraphs are well constructed and appropriate transition between sections.

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd