+ Reply to Thread
Results 1 to 2 of 2

Excel Graphing Help

  1. #1
    Registered User
    Join Date
    05-16-2012
    Location
    Minnesota
    MS-Off Ver
    Excel 2007/2010
    Posts
    7

    Excel Graphing Help

    Hello, I have been tasked to find out our optimal level of efficiency and I have had trouble trying to figure out how to graph this. I have 52 weeks, Cost, and then units in another. I know how to use standard deviation and normal distribution but I really don't know how I should graph this to get the results I'm looking for. I tried using a bell chart and a run chart looked the best with the mean and upper and lower control limits but I could only graph that using cost or units not both. Any help would be great.
    Last edited by ajmarti82; 06-22-2012 at 10:21 AM.

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Excel Graphing Help

    Well the first thing I'd do is, create a scatter chart:
    x: date (week)
    y1: cost
    y2: unit

    If it's efficiency, then you're probably looking for units / cost.

    I don't know that you can assume a normal distribution is even applicable. And then, and then, I don't know why you need that.

    If it's finding efficiency, first define efficiency, and then see what numbers push farthest in that direction.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1