Date Due: Refer to Course Description
Total Marks: 40
Worth: 20% of final assessment
This assignment requires a considerable amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave things until too late. Each question carefully describes what you are required to do, so please follow these carefully.
In this assignment, you will again examine data from a fruit and vegetable market that supplies fresh produce to supermarket outlets in NSW and Victoria. The market is conducting an evaluation of customers in Sydney and Melbourne. The fruit and vegetable market wants to examine the % of produce damage at each of the outlets and is particularly interested in the relationship between % produce damage with: the type of produce; the customer; and, quantity (sold per day).
The data collected is contained in a file called ‘Fruit and Veggie Market.xls’ and the columns of the file contain the following information:
Column| Name| Description|
A| ID Number| Customer Number|
B| Customer| 1= Coles2= Private3= Safeway|
C| City| 1= Sydney2= Melbourne|
D| Produce| 1= Apple2= Orange3= Potato4= Tomato|
E| Quantity (sold/day)| Total quantity of produce sold per day| F| Price$/kg| Price in dollars per kilogram|
G| % of produce damage| Percentage of produce damaged |
Use your random sample of 200 customers from the minor assignment. Your answers to the assignment tasks below are to be based on your sample of 200 customers. Make sure you keep a safe copy of your sample, since you cannot use Random Sample Generator to reproduce the first sample. (If necessary, talk to your tutor about generating a new sample.)
For each task below, you must submit all of the required printouts, graphs, tables and summaries required. NB: Each graph and table should have a heading and each axis should have a label!!...