Data Analysis Using Sas Eg

Assignment 6 – Data Analysis

ETM 5943

10/29/2012

I have used SAS Enterprise Guide 5.1 to analyze the given data.

Part 1 (Basic statistics and graphical analysis)

Data: ETM_data_analysis1.xls, tab Shipping

A project team is assigned a task to determine why customer complaints are increasing regarding the shipping operation. The attached data set provides several weeks of data with due dates, ship dates and the day of the week the orders shipped. Days Late is calculated from the Ship Date – Due Date. A negative number is an early shipment and a positive is late. Zero is on-time. This data is in columns B-F.

Customers have requested that all shipments be on time and nothing be shipped earlier than 5 days.

1. Analyze the data for shape, center, spread and stability.

Shape: Normal

[pic]

The above figure shows that the data is fairly ‘Normal’.

[pic]

The above Scatter Plot diagram suggests that the there is a linear rise in the data points.

[pic]

The mean is denoted by the ‘diamond’ shape. The above Box and Whisker plot shows the degree of dispersion, skewness in the data. It also shows the outliers.

2. Calculate the descriptive statistics

[pic]

[pic]

[pic]

3. Is the data normally distributed?

[pic]

A Normally distributed graph is continous probability distribution that has a bell-shaped probability density function.

The above graph shows that the data is fairly normally distributed.

4. Conduct a process capability study. What is the % out-of-spec?

Process capability study:

[pic]

[pic]

The % out-of spec are all observed in the tables above.

[pic]

I have considered the upper and lower limits as 0 and -5.

5. Use any other tools presented in class to analyze any patterns which may be present in the data....