DATA ANALYSIS AND VISUALIZATION.

Running head: DATA ANALYSIS AND VISUALIZATION 1
Data Analysis and Visualization Paper
Student’s Name
Professor’s Name
Affiliation
Date

DATA ANALYSIS AND VISUALIZATION 2
Data Analysis and Visualization
Part A
A1: Pareto Charts by Operations Facilities
Other represents complaints 7 and 8
Other432615
100
75
50
25
0
Other432615
100
75
50
25
0
Facility = 100
Complaint
Count
Facility = 200
Facility = 300
5
1
6
2
3
4
Other
Complaint
Pareto Chart of Complaint by Facility
A2: Frequency Distribution Table for Complaints
Complaint Count Percent CumCnt CumPct
1 58 22.66 58 22.66
2 38 14.84 96 37.50
3 16 6.25 112 43.75
4 16 6.25 128 50.00
5 74 28.91 202 78.91
6 43 16.80 245 95.70
7 5 1.95 250 97.66
8 6 2.34 256 100.00
N= 256

DATA ANALYSIS AND VISUALIZATION 3
Hence the three most common defects/complaints are 5 (28.91%), 1 (22.66%), and 6 (16.80%). With regard to
the Pareto principle we can see that a sizable number of complaints are related to a few specific defects.
A3: Difference in Number of Complaints With Regard to Departments
Facility Count Percent CumCnt CumPct
100 116 45.31 116 45.31
200 69 26.95 185 72.27
300 71 27.73 256 100.00
N= 256
The table above was generated in Minitab with regard to the frequency of complaints for each facility and was
employed in the completion of the table below
Facility Number of Orders
shipped from facility
Number of Complaints at
the Facility
100 995 116
200 845 69
300 980 71
A4: Hypothesis Testing
The bar chart below clearly demonstrates that the pattern of complaints is different from that of
orders shipped with regard to each of the three facilities: Kansas, Idaho, and Texas.
Null hypothesis (H0): Complaints as a percentage of total orders shipped from each facility are
the same.
Alternative hypothesis (H1): There is a statistical difference in complaints as a percentage of
total orders shipped from each facility.

DATA ANALYSIS AND VISUALIZATION 4
Facility_1
Number of Complaints at the FacNumber of Orders shipped from f
300200100300200100
1000
800
600
400
200
0
Data
Chart of Number of Orders shipped, Number of Complaints at
Chi-Square Test for Association: Facility_1, Proportion
Rows: Facility_1 Columns: Proportion
Number of
Orders Number of
shipped Complaints
from f at the Fac
100 995 116
1018.5 92.5
200 845 69
837.9 76.1
300 980 71
963.5 87.5
Cell Contents: Count
Expected count
Pearson Chi-Square = 10.634, DF = 2, P-Value = 0.005
Likelihood Ratio Chi-Square = 10.421, DF = 2, P-Value = 0.005