Question: How can i make the style from non-numeric data into numeric data so that i can create an analysis with my data. Cup=1 Pack=2 Tray=3
FinalFiles Mauricio Miranda - AutoSave File Home insert Page Layout Formulas Data View Review Help 11 General X Cut Copy BIU-- A A == 29 Wrap Tot 4-A-EEEE Merge & Center Alignment $ - % 68 % Format Painter Clipboard Font Number X > F(B14:"Cup",11F(814-Pack",21F(814="Bowl", BIF(814-"Tray":4}}}} E F G H 1 K L D M MREFI 8 Review # Style Stars 2 2580 0 3.75 2579 Cup 1 4 2578 Cup 2.25 5 2577 Pack 2.75 6 2576 Pack 3.75 7 2575 Pack 4.75 8 2574 Cup 4 9 2573 Tray 3.75 10 2572 Pack 0.25 11 2571 Pack 2.5 12. 2570 Pack 5 13 2569 Pack 5 14 2568 Pack 4.25 15 2567 Bowl 4.5 16 2566 Pack 5 17 2565 Cup 3.5 18 2564 Pack 3.75 19 2563 Pack 5 20 2562 Pack 21 2561 Pack 4 22 2560 Cup 4.25 23 2559 Pack 5 24 2558 Cup 5 25 2557 Pack 4.75 26 2556 Pack 4,25 27 2555 Bowl 4.25 2B 2554 Pack 1.5 2553 Bowl 4.75 30 2552 Bowl 5 31 2551 Pack 4 32 2550 Pack 5 23 2549 Pack 4.5 34 3548 Pack Unrated 35 2547 Bow 4 36 2546 Bowl 3.75 25-45 Pack 2544 15 02 Tamnating Transformed Data
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
