Question 1:

Question 1 of the assignment requires you to analyse a given data set, interpret, and draw conclusions from your analysis using EXCEL.

Question 1 relates to the data file Smartphone.xls which can be downloaded from the assignment tab on the portal. Analysis of the data for this question requires the use of techniques taught in week 1 and week 2, that is Descriptive Statistics.

Please complete the following table by classifying the variables as being either Discrete or Continuous:

Part (ii)

Please provide a descriptive statistics summary of Monthly Bill. (Hint: You should use the Data Analysis tool pack from Excel to perform the necessary analysis. Please attach the Excel output in your answer.

In addition, you should provide a relevant chart or graph that will illustrate the important features of the data.

Present your answer in a report format of no more than 200 words.

Part (iii)

Following the discussion you have carried out in part (i) above, now please provide an analysis of the Monthly Bill by gender using the same data set. Present your answer in a report of no more than 200 words. All answers must be accompanied with the relevant Excel output with necessary charts.

Question 2:

Information about trade union menii-,ership and gender was obtained from the results of a surrey conducted in 2010 by the ABS. The data about trade union membership and gender are presented in the two-way table below.

a. Copy the table into your assignment and complete all row and column totals in the table.

b. If one employee is selected at random from those surveyed, find the probability that this employee is a member of a trade union.

c. If one employee is selected at random from those surveyed, find the probability that this employee is female given that the selected employee is not a trade union member.

d. Are the events. "member of a trade union' and 'being a female employee' independent? Justify your answer using probabilities.

Question 3:

A study into the survival rates of Australian Businesses found that of the businesses operating in 2007. 95.8% were classified as small businesses (i.e. they had fewer than 20 employees). If a business is not classified as a small business, the probability that it is still operating after four wars is 75.7%. If a business is classified as a small business, then the probability of its still operating after four years is 59.7%.

a. Using letters of the alphabet and appropriate probability notation, define the two simple events described in this problem their complements.

b. Draw a probability tree to represent the information given in the question using the letters that you used to define the simple events in part a.

c. Determine the probability that a randomly chosen business has fewer than 20 ernployees and will still be operating after four years.

d. Determine the probability that a randomly chosen business will no longer be operating after four years.

e. Given that a business that had been operating more than tour years ago is no longer operating, what iN the probability that it had been a business?

Question 4:

Government research has found that 78% of people aged 15 to 19 who live in a major city are attending an educational institution. The research also found that only 40% of people aged 15 to 19 who live in very remote parts of the country are attending an educational institution.

A sample of 25 people aged 15 to 19 living in very remote areas of the country is selected.

a. Identify the type of distribution being described bv the random variable in the sentence above and write down the value(s) of its parameter(s).

b. Calculate the probability that less than half of these 25 people are attending an educational institution.

Another sample of one hundred 15-to 19-year-olds living in a major city is selected. The number attending an educational institution is counted.

c. Calculate the probability that more than three quarters of these 15- to 19-year olds are attendirig an educational institution.

d. Calculate the probability that more than 25 but fewer than 7 of these 15- to 19- year-olds are attending an educational institution.

Attachment:- Assignment.rar