Assignment Questions -

Question 1 - The following data shows the retail turnover (in $ millions) from January 2016 to September 2017 in Tasmania and Australian Capital Territory.

(a) Construct a stem-and-leaf display with one stem value in the middle, and Australian Capital Territory leaves on the right side and Tasmania leaves on the left side. (Must use EXCEL or similar for the plot.).

(b) Construct a relative frequency histogram for Tasmania and a frequency polygon for Australian Capital Territory on the same graph with equal class widths, the first class being "$400 millions to less than $450 millions". Use two different colours for Tasmania and Australian Capital Territory. Graph must be done in EXCEL).

(c) Draw a group bar chart for both Tasmania and Australian Capital Territory and explain them. (Use 30 to 50 words to answer this part).

Question 2 - The following data shows the share prices (in dollars) of S&P/ASX 50 and S&P/ASX 200 in the month of October 2017.

(a) Calculate the mean and standard deviation for S&P/ASX 50 and S&P/ASX 200 data.

(b) Calculate the Minimum, Q1, Median, Q3 and Maximum values for S&P/ASX 50 and S&P/ASX 200 data.

(c) Draw a box and whisker plot for the share prices for both S&P/ASX 50 and S&P/ASX 200 and put them side by side on one graph with the same scale so that the share prices can be compared. (This graph must be done in EXCEL or similar software and cannot be hand-drawn.)

(d) Discuss the overall performance of S&P/ASX 50 and S&P/ASX 200 in the month of October 2017. 1 mark

Question 3 - The table below is taken from the Australian Bureau of Statistics website. It provides data on mortgage repayment (monthly) by Australian households living in different dwelling structures in the year 2011.

(a) Find the probability that a randomly selected households live in separate house dwelling?

(b) In a total occupied private dwellings, what is the probability that a randomly selected households make a monthly mortgage repayment of $800-$999?

(c) What is the probability that a randomly selected households make a monthly mortgage repayment of $1,800-$2,399 or $2,400-$2,999?

(d) What is the probability that a randomly selected households make a monthly mortgage repayment of $300-$449 in a flat, unit or apartment dwelling structure?

Question 4 -

(a) According to the 2017 Real Estate Statistics, residential property in Melbourne have increased by 13%. If a sample of 10 properties is taken, what is the probability of that exactly two or three residential properties have increased in their prices?

(b) A customer service officer at a local bank serves an average of 10 customers per hour. What is the probability that the next customer will be served at least 5 minutes from now?

(c) In a study conducted by a fast food restaurant, the average spending for a family of three is normally distributed with a mean of $27 and a standard deviation of $2.

(i) What proportion of the spending is between $25 and $35?

(ii) What value do the upper 5% of the spending exceed?

Question 5 -

(a) A travel agency acts as a selling agent for two airline companies. The two airline companies are charged the same monthly fee for this service and it is assumed that they will each receive approximately half the calls coming in. Based on this assumption, find the probability that in the next 150 calls 90 or more will be for one agent. (Use normal approximation of the binomial distribution.)

(b) In 2017, it is found that 60% of video games purchasers are men. If a random sample is taken of 15 people who purchase video games, what is the approximate probability that there will be an exactly 11 men?

(c) The personnel department of a large corporation employing 2,500 workers wants to find out whether men spend more than women in dental expenses. The study found that men spend a mean of $2,401 on dental expenses per year, whereas women spend a mean of $1,527 on dental expenses per year. Suppose that the study was based on a sample of 600 men and 700 females, and the standard deviation of the amount spent was $1,200 for men and $1,000 for women.

At the 0.01 level of significance, is there evidence that the mean amount spent is higher for men than for women?

Need everything as per the guidelines.