Analyzing data with R

gbadebo94
1624740359028_part3visualizationassignment1.docx

Is there an association between consumers local area population, the type of product the consumer identified in the complaint, mode of complaints submission and timely response to the complains in the state of Arizona between the period 2018-2021?

1. Figure1.0 Bar Chart showing Most Complained Product

Chart, bar chart Description automatically generated

From the above figure 1.0 we can clearly see that in Arizona the most complained product by consumers was Credit reporting, credit repair services, or other personal consumer reports with a total of 4541 complaints. Mortgage Complaints come second.

2. Figure 1.1 shows a pie Chart submission method of Complains used by Consumers

Chart, radar chart Description automatically generated

Figure 1.1 above show that majority of consumers aired their complaints regarding different products via web. We can clearly see that Consumers living in Arizona hate submitting their complains via post mail and fax

3. Figure 1.2 pie chart showing products that failed to provide timely response

Chart, pie chart Description automatically generated

Figure 1.2 above show that Companies in the state of Arizona failed to issue timely responses majorly on Credit reporting, credit repair services, or other personal consumer reports complains.

Figure 1.3 Showing relationship between Timely response by Products

Chart, waterfall chart Description automatically generated

From figure 1.3 above we can clearly see that response scale varies with reference to the number of complains per product. Products with many complains tend to receive a lower response rate as compared to products with complaints.

Figure1.4 Tree map showing Consumers complaints by Mode of submission

Chart, treemap chart Description automatically generated

Figure 1.4 show that Web method is the most preferred mode of submitting the complains by Arizona Consumers.

Figure 1.5 Time series of Consumer Complaints from Jan 2018-Dec 2021

Chart, line chart Description automatically generated

Figure 1.5 show that consumers complaints through the years had weak seasonality with no clear trendline. There is no clear evidence as to the dip and rise in complains especially in 2019 and late 2020.

Figure 1.6 Box plot showing products complaints variation in 2018-2021

Chart, box and whisker chart Description automatically generated

From figure 1.6 above we can clearly see increase of complaints rising as months progress to mid-year then begins to fall towards the end of the year. The box plot doesn’t pot lay a clear trend.

Figure 1.7 Seasonal plot for time response over the period 2018-2021

Chart, line chart Description automatically generated

Figure 1.7 extends to show that there is no clear trend between response rate accorded to different products complaints over the years.

Figure 1.8 Seasonal plot for time response over the period 2018-2021

Chart, line chart Description automatically generated

The above figure 1.8 shows the seasonal patterns a bit more clearly and makes it easy to spot that 2018 began with a very low minimum and early 2020 had a sharp spike.

Figure 1.9 Mosaic Plot showing relationship between products complaints, Timely response, and Mode of submission of the complaints

A picture containing table Description automatically generated

Figure 1.9 show that majority of complaints were not timely responded to in Arizona. Majority of complaints that were submitted via web were no attended to on the right time.