Question

Tips on how to use Excel to code data sets? This is an assignment for a CS class.
(Instructions attached in the file section. I do not need an entire run-through, just tips.)

Answer 1

Files: data & instructions

Answer 2

I don't know how to use Excel, nor do I know much about code, but I think that if you somehow were able to take certain data values ( let's say 753 and 1001) and tell the computer what certain values need to be (let's say less than 950) or if values exceed a number ( let's say greater than 950), then you can tell the computer to lay out the numbers that exceed that set number or are less than that set number. This way, the computer can lay out those values at position x and position y (let's say the numbers that are less than 950 are set to (1,1) while values greater than 950 would be (1,2) as you've probably already figured out).
It's a rough idea of how it could be done, but I have no clue as to how to input the data to the computer and tell it how to complete those tasks, sorry if this didn't answer your question.

Answer 3

You might also be able to take values already set (like the number for the race) and rename them to their proper name (3 to American Indian) and place them in the location where they need to be set.

Answer 4

use the formula bar

Answer 5

Formula bar? @imqwerty

Answer 6

Oh, that. has zero Excel knowledge aside from random formulas

Answer 7

I mean, I have a rough idea of what to do but there are so many parameters for a first-timer. No wonder the professor is notorious for being the most difficult on campus at least in CS

Answer 8

The given questions are the standard ones; you will be able to find formulas for them online.
for example, if you want the median of the cells F2 to F2500 and you want to store it in cell I2 then you simply click on I2 and type `=MEDIAN(F2:F2500)`

However, if you get stuck anywhere, you may tag me

Answer 9

The first step after cloning the data to a new sheet asks that I code certain categories in the data to match this format.

While it says I can use any method/formula, I don't exactly know how to go about this yet.

Answer 10

Looks like the SWITCH formula might be the answer to my problems. If anyone disagrees please let me know ASAP lol[/s[

Answer 11

i'm not familiar with excel and switch gave me this error: "#NAME?"

Answer 12

an alternative would be an \(IF~statement\), it worked for me

Answer 13

I don't know what an IF statement is, but SWITCH is said to be very similar so...

Answer 14

is the switch thing working for ya?

Answer 15

Currently in progress 👌🏻

Answer 16

coolio

Answer 17

btw, this helped me understand how to SWITCH

Answer 18

Er... I meant the article. But also that.

Answer 19

ye, i saw that article as well :]

Answer 20

i tried this: =SWITCH(C2, 1, "MALE", 2, "FEMALE", "null") but it gave me that error

Answer 21

Attempting IF.

Answer 22

...no, that doesn't have enough parameters for me

Answer 23

btw, SWITCH is working on my end, but idk how to make it apply to an entire column...

Answer 24

Nevermind I found it.

Answer 25

great :-]