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%?