Normalization

  • Thread starter Thread starter Guest
  • Start date Start date
Normalizations usually involve the transformation of data in the format
y=a*x+b
Let's put you a-factor in A1 and your b-factor in B1. If your raw data is
in C1 thru C100, then in D1 enter:
=$A$1*C1+$B$1
and copy down
 
Excel isn't a database, so it doesn't support relational database concepts.
(assume 1NF means first normal form and so forth as defined by Codd).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Normalisation 1
3nf 2
Nomalisation 4
everything is slow! 3
Normalisation 3
1NF Violations *promoted* in MS Access? 27
import form excel 3
Normalizing???????? 5

Back
Top