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

  Calculating a con?dence interval

1. (a) Suppose we construct a 99% con?dence interval. What are we 99% con?dent about? (b) Which of the con?dence intervals is wider, 90% or 99%? (c) In computing a con?dence interval, when do you use the t-distribution and when do you use z, with nor..

  Should the null hypothesis be rejected

A magazine article stated that the average age of women who are getting married for the first time is 26 years. A researcher decided to test this hypothesis at α = .02. She selected a sample of 25 women who were recently married for the first time..

  Relationship between islam-judaism and christianity

Islam and the other monotheistic religions: Write an essay discussing the relationship between Islam, Judaism and Christianity. What does the Qur'an say about the "Peoples of the Book," and how they are to be treated?

  What is the osmolarity fluid used in part 2

What is the osmolarity fluid used in Part 2? Why is this important? Why is it essential to keep it cool?

  What would be a better type of graph for displaying data

The pie chart reports the number of hours of sleep "last night" for 118 college students. What would be a better type of graph for displaying these data?

  Normal distribution with mean

An auditor has reviewed the financial records of a hardware store and has found that its billing errors follow a normal distribution with mean $0 and standard

  Error in the mean coffee content of the six jars

What would have been the error in the mean coffee content of the six jars if the third value had been instant 3.16 recorded incorrectly as 6.40?

  Thus the population of production times is normal in shape

suppose a manufacturing company makes a certain item. the time to produce each item is normally distributed around a

  Report the number of minutes

Several hundred students enrolled in introductory statistics courses at a large university were surveyed on various days of the week and asked to report

  How long would it take for the company to break even

For the improved process in part (c), assuming that monthly demand is 5000 m3, how long would it take for the company to break even on its added capital expenditures?

  What is the name of distribution of number of customers

A) What is the name of the distribution of the number of satisfied customers from this sample? B) What is the expected value? C) What is the standard deviation?

  Who is the most famous athlete of all time

To determine who is the most famous athlete of all time, a student thinks up a sample of some acquaintances and calls to ask their opinion

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