Question
You will need to download the Excel dataset: Australian Salesdata (XLS 114 KB) . You can also download the Assignment 2 details (PDF 41 KB)
You will need to download the Excel dataset: Australian Salesdata (XLS 114 KB). You can also download the Assignment 2 details (PDF 41 KB) if you like, or read them below.
The data set is about office supply sales. There are 2002 orders for the year in this data set, and nine
variables as follows:
1. ORDER ID: Order number in no particular order.
2. ORDER PRIORITY: Importance of order (4: Critical; 3: High; 2: Medium; 1: Low and 0: Not specified).
3. ORDER QUANTITY: The number of items within the order.
4. SALES: The total dollar amount of the order ($).
5. SHIP MODE: The type of mode of delivery (1:Regular Air; 2: Delivery Truck; 3: Express Air).
6. SHIPPING COST: The total dollar amount of the shipping cost ($).
7. REGION: Delivered to a Western state (W) or to an Eastern state (E).
8. CONSUMER SEGMENT: Type of customer (Corporate, Home Office, Consumer or Small Business).
9. DAYS TO SHIP: Number of days to ship the order from the day the order was placed.
Order ID Order Priority Order Quantity Sales Ship Mode Shipping Cost Region Customer Segment Days to ship
29383 2 20 $157.13 1 $2.38 E Corporate 2
1095 2 28 $142.18 1 $4.72 E Consumer 2
Task 2
Use data summary methods to describe the orders in your sample using eight variablesitems 2 to 9 above. (Note: Do NOTuse ORDER ID). Use an appropriate graphical and summary statistical technique, chosen according to the type of variable. (Note that less appropriate/inappropriate techniques will receive fewer/no marks.) Choose your techniques from:
- Tabular techniquesfrequency tables and grouped frequency tables.
- Summary statisticsmode, median, mean, standard deviation, range, coefficient of variation
- and interquartile range.
- Graphical techniquespie chart, bar graph, histogram, frequency polygon.
- Do not draw an ogive curve, stem plot or a box plot in this assignment, and do not draw 3D graphs.
1. For a nominal or an ordinal variable draw a graph and present a frequency table in percentages.
2. For a ratio or an interval variable draw a graph and a summary statistics table, including summary statistics appropriate to the type of distribution only.
3. Try to use variation in drawing graphs e.g. pie chart/bar chart or histogram/polygon.
4. Do not draw two different graphs for the same variable. You can draw the same type of graph for two variables.
5. Do not include any information that you will not include in your discussion such as kurtosis.
6. Display and describe one variable at a time.
## Can you please advise for variables 2-9 and from the extract above the correct graphical and summary statistical technique to use for each one.
Thanks,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started