Eynesbury: Quantitative Methods for Business 2016(1) Assignment 2: Due Week 12 (May 16 2016)
The assignments are to be submitted online no later than the date shown above at 9:00am. Failure to submit by this date may result in a mark of zero for this assignment.
Assignments submitted late, without an extension being granted, will attract a penalty of 10% per each working day or part thereof beyond the due date and time. Please refer to the Course Information Booklet for the course policy regarding extensions.
Please make sure that the pages of your submission are in the correct order and that they are stapled securely in the top left-hand corner only. Please make sure that each page shows your name and the page number.
Your assignment submission must be typed. Poor presentation, including poor layout of formulae and/or explanations of the process, will attract a penalty of 10%. Use of Microsoft Equation Editor 3.0 is encouraged.
We do not require the data to be repeated in your submission. If copies of the original data are included in the submission, whether it be by way of repeating the information or shown as part of a calculation marks will be deducted for poor presentation.
For this assignment you must show all your work, including formulae used, explanation of variables, together with a discussion on the process employed. All steps of the process must be shown. Any items omitted will result in loss of marks.
Please remember to complete and attach a cover sheet with a plagiarism declaration. Plagiarism is the use of another person’s ideas (and words) without saying where you got the information. “the taking and using as one’s own the thoughts, writings or inventions of another” The Shorter Oxford English Dictionary on historical principles, Onions CT, third edition. The lack of in text references together with a reference list will, as a minimum, result in zero marks for the section in question. The maximum penalty will be zero marks for the paper. The copying (even partially) of another person’s work will result in both the person who supplied the work to be copied and the person doing the copying receiving zero marks.
Do not rewrite the questions as part of your submission.
Question 1 (Total of 8 marks)
Your colleagues have undertaken a study of personal income with data provided by a random survey of 300 employees in metropolitan Adelaide by asking “how much money did you earn last financial year?” They found that the mean income is $41,000; the median is $35,000; and the highest and lowest incomes are $250,000 and $2,400, respectively.
(a) (2 marks) Was the survey technique appropriate? What type of variable was being collected? Fully explain.
(a) (4 marks) Determine if the distribution of income is symmetric, rightskewed or left-skewed? How many people in the sample earned less than $35,000? Fully explain how you know.
(b) (2 marks) Based on the information supplied, can you determine how many families earned more than $41,000? Why or why not?
Question 2 (Total 32 marks)
Three entrepreneurs have opened KidsKorner Toys, a shop selling high-quality toys. Items are consigned to the shop by individuals who then receive a percent of the selling price of their items. Daily data for November 2014 is shown in Sheet1 of the Excel file called Assignment2.xls (available from the Assignments page of the course website). The data consists of each day’s gross sales, broken down by the method of payment (cash or credit card). ‘Gross sales’ in retailing are overall dollar sales, not adjusted for returns or discounts. The data record the number of items sold and the dollar amount of gross sales for each payment method on the day. The three owners of KidsKorner Toys expect credit card purchases to differ from cash purchases. You are requested to examine the distributions of the sale amounts for these two payment methods to see if this is indeed the case.
(a) (16 marks) Make a histogram and obtain Descriptive Statistics, including Quartile 1 and Quartile 3, for gross cash sales and for gross credit card sales.
EXCEL Instructions: Add your ID to the column names for gross cash and gross credit card sales (Gross-Cash should become GrossCash bloggsj001 etc). Please use the bins given in Sheet1 of Assignment 2.xls. Please make sure that the title of your histogram ends with your network ID (e.g. Histogram of gross cash sales bloggsj001). Ensure you conform with all rules of good chart presentation.
(b) (8 marks) Describe the shape (symmetry, modality and outliers) of each distribution.
(c) (8 marks) Nominate appropriate summary measures for the
distribution of gross cash sales, and for the distribution of gross credit card sales. Give reason(s) for your choice. For each distribution, give and interpret the values of the summary measures you have chosen.
Note: In order to achieve full marks for this question it is essential that you fully explain what you are doing, why you are doing it and the steps involved in providing a final solution. Ensure your answer is not just a set of calculations as 25% of the marks for this question are set aside for your explanation.
Question 3 (Total of 14 marks) Six hundred investors were surveyed to determine whether a person who uses a full-service stockbroker has better performance in his or her investment portfolio than one who uses a discount stockbroker. In general, discount brokers offer no investment advice to their clients, whereas full-service brokers offer help in selecting stocks but charge larger fees. The data, based on the last 12 months, are summarized in the table below. Answer the questions that follow. In each case show the calculation and interpret your answer in words.
Increase Decrease Total
Full service 320 80 400
Discount 160 40 200
Total 480 120 600
(a) (2 marks) What is the probability that an investor uses a full-service stockbroker?
(b) (2 marks) What is the probability that an investor’s portfolio increases in value?
(c) (2 marks) What is the probability that an investor uses a discount stockbroker and the value of his or her portfolio increases?
(d) (2 marks) Suppose an investor uses a full-service stockbroker. What is then the probability that his or her portfolio increases in value?
(e) (2 marks) Suppose that an investor’s portfolio increases in value.
What is then the probability that this investor uses a discount stockbroker?
(f) (4 marks) Are ‘type of broker’ and ‘portfolio value’ independent or dependent? How do you know? Show calculations that support your answer.
Note: In order to achieve full marks for this question it is essential that you fully explain what you are doing, why you are doing it and the steps involved in providing a final solution. Ensure your answer is not just a set of calculations as 25% of the marks for this question are set aside for your explanation.
Question 4 (Total of 16 marks) Employers may ask job applicants to take an IQ test because the test has been shown to predict performance on the job. One such test is the Wechsler Adult Intelligence Scale (WAIS). Scores on the WAIS for a 20 to 34 age group are approximately normally distributed with mean 110 and standard deviation 25.
(a) (8 marks) What proportion of people in this age group have scores above 160 and hence ‘exceptional’ intelligence? Use an appropriate diagram to assist to describe the proportion.
(b) (8 marks) Suppose that an employer examines WAIS test scores of 20 randomly chosen job applicants from this age group. What is the probability that the average test score in this sample is below 120? Use a diagram to assist in your explanation!
Note: In order to achieve full marks for this question it is essential that you fully explain what you are doing, why you are doing it and the steps involved in providing a final solution. Ensure your answer is not just a set of calculations as 25% of the marks for this question are set aside for your explanation.
Question 5 (Total of 18 marks) A marketing consultant observed 50 consecutive shoppers at a supermarket. One variable of interest was how much each shopper spent in the store. The data are in Data of the Excel file called Assignment 2.xls (available from the portal).
(a) (2 marks) What sampling method was used? Was it the best choice of method for this data set? Fully explain.
(b) (6 marks) Obtain a histogram of the data. Does it suggest a normal distribution for spending amounts? Fully explain.
EXCEL Instructions: Add your ID to the column name for spending amounts. Please use the bins given in Data of Assignment 2.xls. Please make sure that the title of your histogram ends with your ID.
(c) (10 marks) Assume that the standard deviation is $22. Use EXCEL to calculate the sample mean (include a copy of the output in your submission). Then find and interpret a 95% confidence interval for the mean amount spent by shoppers in similar circumstances. Does the population have to be normal here?
Fully explain.