Critically evaluate summary statistics

Assignment Help Basic Statistics
Reference no: EM132087726

Assessment - Group Presentation

Learning Outcomes

a) Analyse and present data graphically using spreadsheet software (Excel).
b) Critically evaluate summary statistics against suitable benchmarks.
c) Apply judgment to select appropriate methods of data analysis drawing on knowledge of regression analysis, probability, probability distributions and sampling distributions.
d) Select and apply a range of data analysis tools to inform problem solving and decision making.
e) Conduct quantitative research both individually and as part of a team and articulate and present findings to a wide range of stakeholders, from accounting and non- accounting backgrounds.

Context:

The main aims to develop students' competency in statistical literacy for decision making in the local and global business environment. It reviews statistical techniques for the quantitative evaluation of data in Financial applications. Students will develop analytical and statistical skills to enable them to transform data into meaningful information for the purpose of decision making.

Objectives:

- To more broadly understand the statistical literacy for decision making.
- Interpret statistical results and communicate their statistical analysis in business reports.

Instructions:
This group assignment requires your team to apply statistical knowledge and skills learned from STAT6003 lectures between week 1 to 8.
- Each assignment group will comprise no more than 4 members. Each team member is expected to work collaboratively with one another and contribute their fair share of effort in completing this group assignment. Team members must be from the same tutorial group. It is important that there is coordination among team members to ensure this assignment is duly completed.
- Please use Excel for statistical analysis in this group assignment. Relevant Excel statistical output must be properly analysed and interpreted.
- Please provide a number for every table, graph or figure used and make clear reference to the table/graph/figure in your discussion.
- The word limit for this group assignment is 1,000 words (excluding Excel output) in the report format.
- Your findings are to be presented within 15 mins time limit. Each member of the group is expected to be engaged in the presentation.
- The presentations will be conducted in class in weeks 9 and 10 as directed by your facilitator.

Assignment tasks:

The variables for this assignment are as follows: House Price Index (a)(b): Brisbane, Sydney and Melbourne, 2002-03 to 2016-17.

V1) Financial year
V2) Capital city Brisbane Index V3) Capital city Brisbane Annual % change
V4) Capital city Sydney Index
V5) Capital city Sydney Annual % change V6) Capital city Melbourne Index
V7) Capital city Melbourne Annual % change

1) Module 1 topic - Descriptive Statistics
Present V2, V4 and V6 variables using the following descriptive statistics* and compare them across these cities:

Topics

Module 1: Descriptive Statistics - presenting charts

Histogram plots

Module 1: Descriptive Statistics - numerical descriptive measures

Central tendency (mean, median)

Non-central tendency (95 percentile, 1st quartile)

Variability (range, variance, standard deviation, coefficient of variation and interquartile range)

2) Module 4 topic - Estimation

2a) Construct a confidence interval to estimate the population mean at 95% confidence interval for these cities for V2, V4 and V6 variables. Interpret each confidence interval in context and make a comparison across cities in your analysis.

3) Module 4 - Hypothesis Tests

Variable

Hypothesis statement for test:

V2: Brisbane house Price Index

Test whether the population's average house Price Index for Brisbane is different from 100.

V4: Sydney house Price Index

Test whether the population's average house Price Index for Sydney is different from 100.

V6: Melbourne house Price Index

Test whether the population's average house Price Index for Melbourne is different from 100.

- Requirements for each hypothesis test:
- Formulate the null and alternative hypotheses.
- State your statistical decision using significant value (??) of 5% for each test.
- State your conclusion in context.
- Perform a one-sample test for each city:

Attachment:- Property data Assessment.zip

Reference no: EM132087726

Questions Cloud

What complex issues and obstacles may frustrate its efforts : As government or holder continues its attempts to demonstrate good corporate citizenship, what complex issues and obstacles may frustrate its efforts?
Explore your understanding of these attribution categories : Read the following case study and submit a 2 page program for helping Lucille regain her motivation by overcoming her outcome goal orientation.
Identify a useful basis for segmenting the market : The objective of this project is to deepen students' understanding of the utility of the consumer behavior concepts discussed in class and to sharpen.
What is the average tax rate for that individual : Assume a single taxpayer is taxed at 10% on the first $9,075 of taxable income, What the average tax rate for that individual if her taxable income is $41,350
Critically evaluate summary statistics : STAT6003 : Statistics for Financial Decisions - more broadly understand the statistical literacy for decision making - Interpret statistical results
How much additional tax will the firm owe : Assume a firm increases its revenue by $100 while increasing its cost of goods sold by $85. How much additional tax will the firm owe
How might they most effectively be implemented : What criminal justice policies and practices are suggested by the theories you've been discussing for the past several weeks?
How would each of the markets increase enrollment : Your Marketing Research class has been charged with increasing enrollment at Rasmussen College. There are several markets worthy of targeting.
What are the relevant factors in the decision : What are the relevant factors in the decision? Which alternative is in the best interest of the company over the next two years? Show your calculations

Reviews

len2087726

8/16/2018 9:59:47 PM

Presentation focused on only part of audience with a sporadic eye contact. The audience was distracted. Could be heard by only half of the audience. Body language was distracting. Presenter minimally contributing to the group efforts. Primarily prepared but with some dependence on just reading off slides. Spoke to majority of the audience with steady eye contact and at a suitable pace and volume. The audience was engaged by the presentation. Some fidgeting by the presenter. Slight domination of one presenter. Presenters helped each other. Very well prepared. Regular/constant eye contact. The audience was engaged, and the presenter held the audience’s attention. Appropriate speaking volume & body language. All presenters knew the information, participated equally, and helped each other as needed. Extremely prepared and rehearsed.

len2087726

8/16/2018 9:59:41 PM

Presentation 10% No eye contact. Inappropriate body language. Difficult to understand. No effort made to keep the audience engaged. Little use of presentation aids or materials used were irrelevant. Presenters not cooperating with each other. No evident rehearsal prior to presenting. Minimal eye contact with focus on a small part of the audience. The audience was not engaged. Spoke too quickly or quietly making it difficult to understand. Inappropriate/disinterested body language. Unbalanced presentation or tension resulting from over- helping. {resenter not participating. Evident lack of preparation/rehearsal. Dependence on slides.

len2087726

8/16/2018 9:59:30 PM

Effective conclusions were partially provided. Specific data or facts were occasionally referred when necessary to support the analysis and conclusions. Adequate grammar, spelling, punctuation, professional writing, and syntax. The document is referenced but some referencing is missing. Effective conclusions were provided. Specific data or facts were referred to when necessary to support the analysis and conclusions. Excellent grammar, spelling, punctuation, professional writing, and syntax. The document was properly referenced with both reference list and in text references.

len2087726

8/16/2018 9:59:24 PM

Correct citation of key resources and evidence 10% Overall structure, appearance and referencing of the report are assessed. Effective conclusions were not provided. Specific data or facts necessary to support the analysis and conclusions were not provided. Very badly written, incorrect grammar, inappropriate language used, no proper structure of the document, badly organised with no logical flow of the arguments. The document is missing in text referencing and/or a reference list. Limited conclusions were provided. Specific data or facts necessary to support the analysis and conclusions were not provided. Grammar, spelling, punctuation, professional writing and syntax needs significant improvement. The document is very poorly referenced. Effective conclusions were provided in some areas. Specific data or facts were not referred when necessary to support the analysis and conclusions. Grammar, spelling, punctuation, professional writing, and syntax needs improvement. The document is partially referenced, reference list or in text referencing is missing.

len2087726

8/16/2018 9:59:16 PM

Application of Framework 40% SLO addressed: b) Identify and apply appropriate frameworks and tools to the problems and challenges Demonstrates no understanding of the framework and concepts relevant to the data analysis. Demonstrates little understanding of the framework and concepts relevant to the data analysis. Demonstrates good knowledge of the framework and concepts relevant to the data analysis. Demonstrates correct knowledge of the framework and concepts relevant to the data analysis. Demonstrates correct and complete knowledge of the framework and concepts relevant to the data analysis.

len2087726

8/16/2018 9:59:08 PM

Data Analysis using Excel 40% SLO addressed: a) Examine the statistical analysis through Excel Limited or no understanding of the statistical data analysis. Identifies a proportion of the understanding of the statistical data analysis. Identifies a majority of the understanding of the statistical data analysis. Correctly identifies all of the analytical techniques and understanding of the statistical data analysis. Not only identifies all of the analytical techniques with good understanding of the statistical data analysis.

len2087726

8/16/2018 9:59:00 PM

Distinction (Advanced) (75-84) High Distinction (Exceptional) (85-100) Distinction is awarded for work of superior quality in achieving all learning outcomes and a superior integration and understanding of theory and application of skills. Evidence of in-depth research, reading, analysis and evaluation is demonstrated. A consistent academic referencing system is used and sources are appropriately acknowledged. High Distinction is awarded for work of outstanding quality in achieving all learning outcomes together with outstanding integration and understanding of theory and application of skills. Evidence of in-depth research, reading, analysis, original and creative thought is demonstrated. A consistent academic referencing system is used and sources are appropriately acknowledged.

len2087726

8/16/2018 9:58:54 PM

Assessment Attributes Fail (Unacceptable) (0-49) Pass (Functional) (50-64) Credit (Proficient) (65-74) Grade Description (Grading Scheme) Fail grade will be awarded if a student is unable to demonstrate satisfactory academic performance in the subject or has failed to complete required assessment points in accordance with the subject’s required assessment points. Pass is awarded for work showing a satisfactory achievement of all learning outcomes and an adequate understanding of theory and application of skills. A consistent academic referencing system is used and sources are appropriately acknowledged. Credit is awarded for work showing a more than satisfactory achievement of all learning outcomes and a more than adequate understanding of theory and application of skills. A consistent academic referencing system is used and sources are appropriately acknowledged.

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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