Date Due: Refer to Course Description
Total Marks: 25
Worth: 10% 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 minor assignment you will 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 sales and price of produce. Initially, it is particularly interested in a comparison of Price per kilogram (Price$/kg) across the type of produce. Further comparisons will be explored in the major assignment.
The data collected is contained in a file called ‘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| Season| 1= Summer2= Winter|
E| Produce| 1= Apple2= Orange3= Potato4= Tomato|
F| Quantity sold (t/day)| Tonnes sold per day|
G| Price$/kg| Price in dollars per kilogram|
H| % of produce damage| Percentage of produce damaged |
Before you begin any analysis you must take a random sample of 200 customers from the 335 provided in the file Market.xls. Use the Random Sample Generator, imbedded in this file, to do this. 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, and we will use it again in the major assignment.
To prepare your data file ready for analysis, you must take the following steps:
1. Use the file Sample Generator in the data file Market.xls to generate a random...