+ Reply to Thread
Results 1 to 2 of 2

Normalizing Data

Hybrid View

  1. 09-30-2018, 01:36 PM #1
    diorp3963
    diorp3963 is offline
    Registered User
    Join Date
    09-05-2018
    Location
    California
    MS-Off Ver
    2011
    Posts
    5

    Normalizing Data

    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?
    Reply With QuoteRegister To Reply
  2. 10-01-2018, 05:16 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Normalizing Data

    First of all, you will probably get a better response if you attach a sample workbook. Secondly, I'm not sure we have the same concept of Normalized Data. Given the limited amount in the pictures the data would look something like the picture.


    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Attached Images Attached Images
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Normalizing data
    By dflak in forum Tips and Tutorials
    Replies: 4
    Last Post: 02-12-2019, 09:38 AM
  2. [SOLVED] Help with normalizing data
    By Spyderwoman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-22-2016, 11:29 AM
  3. [SOLVED] Normalizing The Data
    By zanshin777 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-15-2015, 07:47 AM
  4. Normalizing data
    By jviola in forum Excel General
    Replies: 5
    Last Post: 06-07-2013, 10:05 AM
  5. Normalizing Data
    By folkda in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-11-2013, 03:53 PM
  6. normalizing data
    By 4gokycats in forum Excel General
    Replies: 2
    Last Post: 03-26-2005, 11:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1