Reference no: EM131355519
Interpret and use financial statistics and tools Case Study Assignment
Question 1: Explain the following, illustrating your explanation with examples and diagrams where necessary:
- Scatter diagram
- Correlation of r = 0
- Line of best fit
- The difference between positive and negative correlation
Question 2: The financial reports of Brisbane North Pty Ltd and Brisbane South Pty Ltd disclosed the following profits for last five years. Both companies manufacture the same product.
|
Year
|
Brisbane North P/L
|
Brisbane South P/L
|
|
2011
|
$250,000
|
$110,000
|
|
2012
|
$310,000
|
$170,000
|
|
2013
|
$450,000
|
$250,000
|
|
2014
|
$650,000
|
$470,000
|
|
2015
|
$890,000
|
$550,000
|
Assessment task:
Draw a scatter diagram and analyse and explain your analysis
Calculate and discuss the correlation coefficient of the two companies using the product moment method
If Brisbane North P/L makes a profit of $750 000, estimate the profit for Brisbane South P/L using:
- A line of best fit through the scatter diagram
- A line of best fit using the least-squares method
Question 3: Explain the following terms, illustrating your explanation with examples where necessary:
- Non-sampling error
- Primary data
- Random sampling
- Multistage sample
- Stratified sample
Question 4: The following table shows the average award rates of pay and consumer price index of Super land.
|
Year
|
Weekly Award Wage $
|
Consumer Price Index
(2005-6 =100)
|
|
June 2005
|
250.00
|
97.2
|
|
June 2006
|
265.00
|
103.5
|
|
June 2007
|
285.00
|
110.0
|
|
June 2008
|
310.00
|
112.0
|
|
June 2009
|
320.00
|
114.7
|
|
June 2010
|
335.00
|
125.3
|
|
June 2011
|
350.00
|
131.6
|
|
June 2012
|
365.00
|
139.0
|
Assessment task:
Prepare a spreadsheet with columns for Year, Weekly Award, CPI, Real Weekly Award and Revised CPI
Using the price index given, calculate real weekly award wages for each year for 2005-06 prices, round up to the nearest cent.
Calculate an index for weekly award wages using June 2005 as the base year, round up to the nearest cent.
Hint: June 2006 real weekly award = (Old CPI/Old CPI of New base year) x 100 i.e. =(103.5/97.2) x 100 = 106.5 thus Revised CPI for June 2006 is 106.5.
Question 5: The following sales data have been extracted from Brisbane North Pty Ltd for the years 2006 to 2013.
|
Year
|
Sales (Y)
|
|
2006
|
17,000
|
|
2007
|
17,500
|
|
2008
|
18,200
|
|
2009
|
19,000
|
|
2010
|
19,500
|
|
2011
|
20,100
|
|
2012
|
20,500
|
|
2013
|
21,000
|
Assessment task: Prepare a spreadsheet showing Exponential Smoothing of the data with a smoothing constant of 45%.
Question 6: Standard deviation is commonly used by businesses to measure confidence in statistical conclusions. Unlike the variance, the standard deviation is expressed in the same units as the data.
Assessment task
Explain the standard deviation and how it is used in business. Illustrate your explanation by examples and application in some industries.
Question 7: History students scored an average of 82% in their final exam. Assuming a normal curve with a standard deviation of 5%:
(i) What is the probability of a student scoring less than 50%?
(ii) What percentage of students scored higher than 75%?
(iii) What percentage of students scored between 60% and 75%?
|
Overview of social engineering
: Explain how Social Engineering can be seen as a threat to the corporate entity by using a creative tool such as PowerPoint® Include all of the following in your explanation:
|
|
Produce a random sample by taking all columns of randu
: Produce a random sample by taking all columns of randu, and reproduce Figure.- Show that the triplets randu[i,] lie on one of 15 parallel hyperplanes.
|
|
Write a topic paper based on the criteria
: Select from one of the three topics provided and write a topic paper based on the criteria provided below. Each student may select a topic of his or her own choosing, but the topic must be pre-approved by the course instructor. Each topic paper sho..
|
|
Can cultural relativism be used to excuse behavior
: Determinism versus the free will debate has important implications for ethics. The trend toward seeing forces outside our control as responsible for our actions has contributed to relabeling behaviors and have enabled people to avoid taking respo..
|
|
Calculate and discuss the correlation coefficient
: FNSINC602 Interpret and use financial statistics and tools Case Study Assignment. Draw a scatter diagram and analyse and explain your analysis. Calculate and discuss the correlation coefficient of the two companies using the product moment method
|
|
Give the answer of muliple choice question
: Those members of society whose cultural understandings and backgrounds are different from one another and from the dominant culture are. Collections of persons from common racial or ethnic backgrounds who share common cultural interests are.
|
|
Describe the importance of genetic diversity in populations
: Describe the importance of genetic diversity in populations. Explain how genetic diversity in plants and animals supports long-term viability, biodiversity, and biotic integrity.
|
|
Determine the optimal value
: Show that we can assume β = 1 by using the transformation y = βx.- When the G(n, 1) distribution is generated from an Exp(λ) distribution, determine the optimal value of λ.
|
|
Identify the problems that were experienced
: 1. Identify the problems that were experienced. 2. Discuss what preventative measures are now suggested to avoid similar issues in the future.
|