Results 1 to 10 of 10

Shifting columns using excel formula

Threaded View

  1. #1
    Registered User
    Join Date
    12-13-2015
    Location
    Greenbelt, MD
    MS-Off Ver
    Office 2010
    Posts
    50

    Shifting columns using excel formula

    Hi, would you please help me with this? I have many datasets, I have posted an example of two othem (A and B) to illustrate the problem I am having. A dataset has 2 columns of data for a histogram. The x-axis: the histogram bin centers and y-axis: the counts per bin. These data are listed starting from row 2. I would like to plot this data points and overlay with a binomial distribution curve. In another column, I calculated the normal binomial distribution using the excel function. The binomial distribution data also starts from row 2. Note that the length of data in the column with the binomial distribution is the same as that of the column with the y-axis data, not including the starting and ending zero-values. However, the zero-values in between the integers are counted. I would like to graph the the histogram with the overlapping binomial distribution curve. To do so, I would need the binomial distribution column to be shifted down in order to match the first integer in the y-axis column. How would I go ahead to do that using excel worksheet formulas? I have been reading about the Offset function, but it is confusing how it would work here. I need the formulas to be repeatable with many of my other data sets which have varying lengths.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Shifting columns in a workbook
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2014, 08:06 AM
  2. Shifting and combining columns using VBA
    By texas979 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2013, 03:02 AM
  3. Stopping Excel Table from shifting other rows/columns
    By NortheasternStudent in forum Excel General
    Replies: 1
    Last Post: 08-12-2013, 01:41 PM
  4. [SOLVED] shifting columns
    By clc3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 12:00 PM
  5. Replies: 0
    Last Post: 03-24-2009, 08:31 PM
  6. Question with shifting columns in a formula
    By siulonbow in forum Excel General
    Replies: 4
    Last Post: 08-21-2008, 05:37 PM
  7. Shifting online data comes to excel to be shifted to adjacent cells as per formula
    By cramatr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2007, 08:30 PM
  8. shifting online data comes to excel as per formula with very minimum timelag
    By cramatr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2007, 10:08 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1