data analysis

I am in charge of compiling data for my work into a report every month. There are 5 different data sets that go into the report. So every month, 5 excel worksheets with new data are put into a folder, to add to my report. I have a master worksheet that compiles data for them all. For each of the...

Hello, I am having a problem with counting specific binary strings (with the value of "1" in a specific position) and was hoping for some advice. I am importing data into Excel and converting each point to binary (I think this is the best way). An example: Event 1 has the value 001. Event 3...

I have excel sheet with two columns (Employee Name and Technology).I need formula to filter data on technology column,instead of manually applying filter and sorting the data. Is there any formula which gives me the result to find out the employee name based on technology. (Example:If i want...

It would be helpful if you can find a formula for these lines. <tbody> Date Particulars Amount Result 2/1/2016 SB-TRANSFER 44342960 SB REF. 7038594 B/O NETWORK INTERNATIONAL LLC NI POS SETT 010116 109866251 Value DATE, 02/01/2016 - S11702254 619.6 109866251 2/1/2016 SB-TRANSFER 44342961 SB...

Hello, I am creating a template that starts with a time series of daily values for the past year (the specific dates will depend on what day I am updating it for). I need to be able to manipulate monthly data from the time series. I am running into issues because there are gaps in the data...

how to plot time series data in excel? i have some data set like this : day between two dates are not fixed, sometimes 2 days, sometimes 3 days, .. 5 data are collected on certain day: 29/03/2013...26/03/2013 ...and so on.. thanks in advance for any help!!:confused::) <tbody>...

Before I begin, I should tell you all that I am a complete noob to excel and VBA macro. I am trying to compare two excel sheet data by using EXACT formula. sometimes the data ranges to 50 columns and 10000+ rows, So I am using a VBA macro to define the range and applying the formula. perhaps...

Hello experts; I have a huge data, say 100000 values, each value between 0 to 255. Values are in random order. I first find the average of all values. by simply using the AVERAGE formula. Next I find the values which are greater than average. Highlight them, using "Conditional formatting"...

Hi I'm looking for help on isolating and breaking down some figures Customer Type Payment Credit Limit Credit Check Total Amount Difference Bus test 1 Direct Debit 90 <=100 80 10 Business Cash 90...

I've been given a university assignment where I am trying to predict corrosion rate based off moisture content for a buried pipe. The teacher wants a function based off corrosion rate (cr) (of which I have 130 values) and those 130 values corresponding moisture content (mc). These will also be a...

Hello, I have 23 worksheets (named 1, 2, . . . , 23) all based in the same template. In a summary worksheet, I'd like to do some summary analyses, e.g., medians of data from all of the 23 worksheets. To find the median of the values in column D of all of the sheets, I have found this array...

<tbody> 0down votefavorite I am compiling a data base on Tennis players for a college project. I have two spreadsheets with lots of relevant information, one with performance related statistics for every ATP match played over the last five years and another spreadsheet with their ranking at...

Hi, I need to convert a string of data within a single cell into multiple rows, for multiple columns. The data in the first column (column A) is in the format of Yes [1], No [2], No [2], etc. and is associated with data in the following column (column B) which is in the format of xxxxx [123.1]...

Hi, when I click in my pivot table it opens up a new sheet showing what is being counted in the cell I clicked. At first I thought it was only when I double-clicked or when i pressed something but it seems to happens more often. I'm not sure what I'm doing but it is very annoying. Anyone know...

Hi there, I have survey data where each respondents answers correspond to a row in my data. The columns are the questions. A question that can have only one answer has each of the possible answers coded as a number. For example: 1 - stronly agree 2 - agree 3 - disagree 4 - strongly disagree...

Hey everyone. I have the problem that the data I am plotting in Excel is arranged in the following way: Rowid Count Value 1 2 1 2 3 4 ..... Is there a way to get excel to understand the structure of this data? So that...

I have this example data... A. B. C. <colgroup><col><col><col></colgroup><tbody> Topeka SE-6/9/2015 6/9/2015 Topeka SE Man Spa-6/9/2015 6/9/2015 Man Spa Manhattan West-6/9/2015 6/9/2015 Manhattan West Mcpherson-6/9/2015...

Hello All I am creating an inventory sheet for a restaurant. I am having an issue figuring out how to add inventory items and have them automatically remain (copy over) to the following months. Example: If I add "Mark West Pinot Noir" in June I would like it to show in July, August, and so on...

Hey Guys, Thank you for reading my question(plea for help), I really appreciate your help (I'm on my knees, begging) I am making a bowling league excel sheet, I will have 10 - 15 teams. Each team will start of with a rating. - There may be no games on a particular day, or more than 1...

Hello, I need a simple formula for calculating Average Time Between Calls, aka Prep Time or Average Idle Time. I have done this in the past but can't for the life of me, remember my old formula. Some call center reporting does this for you, but not the one my company uses. Here is the data I...