Hi all,

CPI.png
normalized.png



I have two data type
1. Customer Contacts: the number of contacts via phone, chat, email, etc. for a given time
2. Contacts Per (Order Line) Item: Ratio showing contact rate per order. Total contacts divided by total orders placed within a time period.

My question is, I need to find out a way to normalize the data using excel. I need to present the data in a way that shows if, for example, a rise in contacts in one week is driven by Order volume.

I was given the graph attached as a way to show normalized data, but I'm not sure how to interpret it. Any thoughts? I've also included the data that I need to graph to show normalization. Can someone please tell me how graphing the data would show the relationship between contact volume and order volume and what inferences I can make using the data?