Reference no: EM13278642
Question 1
The Australian divorce rate has been steadily increasing over the years until late 1990s. However, data suggests that the rate has fallen in the most recent years. Age specific Australian divorce rates (in percentages) of male and female for few years between 1992 and 2012 are given in the attached Excel file
(GB513Assignment-Q1.xls).
Using the information given in the data file, complete following tasks.
a. Use a graphical technique to compare the divorce rates in 1992, 2008 and 2012 broken down by age for Australian Male. Describe your graph.
b. Use a graphical technique to compare the divorce rates in 1992, 2008 and 2012 broken down by age for Australian Female. Describe your graph.
c. Compare your observations in parts (a) and (b) above to comment on the differences in divorce rate for male and female over the years.
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| Australian Bureau of Statistics |
|
|
|
|
|
|
|
|
|
| 3310.0 Marriages and Divorces, Australia, 2012 |
|
|
|
|
| Released at 11.30am (Canberra time) 27 November 2013 |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| Selected divorce indicators (Age-specific divorce rates), Australia, Selected years, 1992-2012 |
| |
|
|
|
|
|
|
|
|
|
| |
1992 |
2002 |
2008 |
2009 |
2010 |
2011 |
2012 |
|
|
| MALES |
|
|
| Age groups (years) |
|
|
|
|
|
|
|
|
| 16-24(g) |
1 |
0.4 |
0.3 |
0.3 |
0.3 |
0.4 |
0.4 |
|
|
| 25-29 |
8.6 |
5.5 |
3.8 |
3.7 |
3.7 |
3.9 |
3.9 |
|
|
| 30-34 |
12.7 |
11.5 |
7.9 |
7.9 |
7.7 |
7.3 |
7.4 |
|
|
| 35-39 |
13.1 |
13.1 |
9.9 |
10.1 |
10.2 |
9.3 |
9.4 |
|
|
| 40-44 |
11.8 |
13.2 |
10.3 |
10.5 |
10.7 |
10.3 |
10.4 |
|
|
| 45-49 |
10.2 |
12.1 |
9.7 |
10.2 |
10.5 |
9.8 |
10 |
|
|
| 50-54 |
7.6 |
9.5 |
8.6 |
9 |
8.9 |
8.8 |
8.9 |
|
|
| 55-59 |
4.9 |
6.9 |
6.6 |
6.8 |
6.6 |
6.6 |
6.6 |
|
|
| 60-64 |
3 |
4.2 |
4.4 |
4.6 |
4.6 |
4.4 |
4.7 |
|
|
| 65 and over |
1.1 |
1.5 |
1.6 |
1.6 |
1.7 |
1.5 |
1.7 |
|
|
| |
|
|
|
|
|
|
|
|
|
| FEMALES |
|
|
| 16-24 |
2.4 |
1.2 |
0.8 |
0.8 |
0.9 |
1 |
0.9 |
|
|
| 25-29 |
12.5 |
8.9 |
6.2 |
6.1 |
6.1 |
6 |
6.1 |
|
|
| 30-34 |
13.3 |
13.7 |
9.5 |
9.5 |
9.2 |
8.7 |
8.8 |
|
|
| 35-39 |
12.5 |
13.6 |
10.6 |
10.8 |
11 |
10.1 |
10.3 |
|
|
| 40-44 |
10.8 |
12.7 |
10.4 |
10.7 |
10.9 |
10.5 |
10.7 |
|
|
| 45-49 |
8.6 |
10.4 |
9.1 |
9.8 |
9.8 |
9.5 |
9.5 |
|
|
| 50-54 |
5.5 |
7.3 |
7.2 |
7.3 |
7.3 |
7.2 |
7.5 |
|
|
| 55-59 |
2.9 |
4.6 |
4.6 |
4.9 |
4.8 |
4.6 |
4.9 |
|
|
| 60-64 |
1.7 |
2.6 |
2.7 |
2.8 |
2.8 |
2.8 |
2.9 |
|
|
| 65 and over |
0.4 |
0.6 |
0.6 |
0.6 |
0.7 |
0.6 |
0.7 |
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
Question 2
The Australian Bureau of Statistics recently released figures on petrol usage. Following are the 15 leading cities in 2012.
City value ($ billions)
Bourke 7.84
Mt Isa 6.48
Weipa 4.20
Newcastle 4.17
Wollongong 4.00
Kalgoorlie 3.30
Darwin 3.21
Tennant Creek 2.74
Broken Hill 2.08
Perth 2.05
Alice Springs 2.05
Adelaide 1.89
Canberra 1.85
Dubbo 1.81
Albury 1.68
(a) Using the Data Analysis Tool in Excel, calculate the descriptive statistics.
(b) Briefly explain what each of the metrics in the summary statistics means.
(c) Comment on the figures in the report. What are they telling you about this data set? Is it symmetrical, flat, skewed, does it have outliers, and so on?
Question 3
A popular media poll revealed that 44% of Australian adults in the 18-34 years category think that 'Made in Australia' ads boost sales. A different interactive poll showed that 78% of Australian adults in the 18-34 years category use social media. Suppose that 85% of Australian adults in the 18-34 years category think that 'Made in Australia' ads boost sales or use social media. If an Australian adult in the 18-34 years category is randomly selected:
(a) What is the probability that the person thinks that 'Made in Australia' ads boost sales and uses social media?
(b) What is the probability that the person thinks that 'Made in Australia' ads boost sales given that the person does not use social media?
Please be sure to include all workings with your answers.
Question 4
The proportion of credit-card holders who pay their bill in full each month is 20%; the other 80% make only a partial or no payment.
(a) In a random sample of 17 customers, what is the probability that:
i. 4 customers pay their bill in full?
ii. More than 4 customers pay their bill in full?
(b) What is the expected number of customers who credit card bill in full?
(c) What is the standard deviation? Page 3 of 3
Question 5
The number of calls received by a phone operator at an emergency department between 10-11am has a Poisson distribution with a mean of 12.
(a) Find the probability that the operator received at least 5 calls during the following period.
I. 10-11am
II. 10-10.30am
III. 10-10.15am
(b) What is the probability that fever than 4 calls were received between 10 & 10.30am?
(c) What is the probability that 6 or more calls were received between 10 & 10.30am?
Question 6
According to a recent research report, the average monthly household mobile phone bill is $73.
Suppose monthly household mobile phone bills are normally distributed with a standard deviation of $11.35.
(a) What is the probability that a randomly selected monthly mobile phone bill is no more than $55?
(b) What is the probability that a randomly selected monthly mobile phone bill is more than $100?
(c) What is the probability that a randomly selected monthly mobile phone bill is between $80 and $90?
(d) What is the probability that the average mobile phone bill of randomly selected sample of 25 bills is
between $71 and $80?
Please be sure to include all workings with your answers.
Question 7
Suppose a study reports that the average price for a kilogram of grapes is $3.16. You believe that the priceis higher in your area of the country. You decide to test this claim by randomly calling grocery stores.
Your random survey of 25 stores produces the following prices (all in $). Assume grape prices for a region are normally distributed. Does the data you obtained provide enough evidence to support your belief?
Conduct a hypothesis test at 1% level of significance and clearly state your conclusion.
3.27 3.29 3.16 3.20 3.37
3.20 3.23 3.19 3.20 3.24
3.16 3.07 3.27 3.09 3.35
3.15 3.23 3.14 3.05 3.35
3.21 3.14 3.14 3.07 3.10
Note: You will need to explain how you determined the answer to the question. Submitting answers without
an explanation for this question is not sufficient.
End of Assessment