normalization

Hi guys I want to build VBA code for normalization if the data is populated in excel like this( 4 columns) a h o v b i p w c j q x d k r y e l s z f m t a g n u b i need to rearrange the data like given below a h a h b i b i c j c j d k d k...

I realize this is very easy for most on this board, but my expertise is quite limited. I would like to build a formula to add a unique normalization factor to scores that that individual has given. <tbody> Individual Score Score + NF Normalizing Factor AM 2 AM 0.00540 AM 1...

I realize this is very easy for most on this board, but my expertise is quite limited. I would like to build a formula to add a unique normalization factor to scores that that individual has given. <colgroup><col width="100"><col width="100"><col width="100"><col width="100"><col...

Hi, I have plotted a 2 x 2 according to the instructions here: How to Create a Static Four Quadrant - Matrix Model in an Excel Chart | Critical to Success ...but I'm encountering some problems: 1) Not all of the labels are showing up for all of the dots on the map - any idea why this is...

Hi, I want to design a table with the sales for further use in my database. I am only displaying two types of Products here, but in reality it could be about 20. What would be the correct table design in according to the first normal form? Date Department Seller SummaryField...

I have been working on this issue for several hours now. I am essentially trying to normalize data based on item numbers and their description. I would like to have one unique description description for every unique item number but currently the descriptions have small differences in them...

Hi All Hope your all well, I need some help in creating a pivot table for the data I have attached. I have tried everything from normalising it and using all possible pivots available with the informaiton if i create one but it is not being created. The problem I am facing is that the values...

I have a very large dataset (~5000 points in a 2D array) which I need to plot and fit a linear trendline to. There are 90 subjects each of which has a daily binary event checked over its lifespan. eg: Day: 1 2 3 4 5 6 7 8 9 10 subj 1 0 1 0...