Question

1. Excel Simulation #1: Say that every single class in Full Sails Masters Degree in Game Design has a 5% failure rate per month. Say also that when a student fails once, he or she drops from the program. There are twelve months. Given a cohort of 100 that starts the program, about how many are left after twelve months? Remember that someone can only pass or fail.

Answer 1

well if you start with 100 students, and you lose 5% in the first month that leaves you with?

Answer 2

95, since 5% of 100 is 5 correct?

Answer 3

yep now to start month 2 you have 95 people, you lose another 5% how many are left?

Answer 4

remember you cannot have a partial person, so you need to round up

Answer 5

90 people left?

Answer 6

correct because \[0.05*95=4.75\]\[95-5=90\]
now can you continue this process?

Answer 7

Indeed I can thank you for the help. Now to trying and work it all together on Excel

Answer 8

And thank you*

Answer 9

oh on excel its just a formula and np if you need excel I can do that to

Answer 10

That would be awesome, first time using formulas on excel so am a tad lost

Answer 11

ok np so I'm going to draw up a doc real quick so I can run you through it

Answer 12

Thank you very much

Answer 13

Alright so sorry about the wait, I can't attah the file because my comp keeps crashing. But take column A and in the second row label that month

Answer 14

got it

Answer 15

now in B1 label that total students

Answer 16

alright

Answer 17

now in A3 put a 0 and in A4 put a 1
then use the autofill handle down to 12

Answer 18

so you have 12 total months

Answer 19

done

Answer 20

now we want to write that process we used to solve the equation in math terms

Answer 21

so if x=total students y=students after first drop out what is our eq?

Answer 22

y=X-0.05?

Answer 23

well that is almost it but remember .05 times what?

Answer 24

100. So 0.05*100 = 5

Answer 25

right but 100 = what in our variables?

Answer 26

total starting students

Answer 27

or what letter?

Answer 28

X

Answer 29

right so can you rewrite the formula?

Answer 30

y=100-5?

Answer 31

no use your previous eq that you had written

Answer 32

y=100-0.05

Answer 33

you had y=x-.05

Answer 34

y=100-0.05

Answer 35

no keep it in terms of x

Answer 36

if 5=.05(100) then that is the same as saying 5=.05(X)

Answer 37

so y =?

Answer 38

haha got it now

Answer 39

ok so what is the formula?

Answer 40

haha ive been at this for so long today that am brain dead I swear.
y=95

Answer 41

in terms of x please

Answer 42

95=100-.05

Answer 43

in terms of x!

Answer 44

variables only no numbers

Answer 45

btw what is 100-.05 and does that =95?

Answer 46

I honestly don't know how to write the formula out. Maybe if i see it i can come to sense of it then resume to punch myself in the face cause it was so easy

Answer 47

you already wrote it! lol just remember that .05x not .05

Answer 48

y=.05x

Answer 49

nooooo! ugh ok let's go through this again. what is y?

Answer 50

sorry i'm just frustrated I shouldn't have "ughhh-ed" you

Answer 51

I mean what does y mean

Answer 52

our definition of y was?

Answer 53

AHHH sigh... Alright so Y= students after first drop out

Answer 54

good now what is x?

Answer 55

X=total of students

Answer 56

now how did we get y when we were doing numbers? (in words)

Answer 57

Multiplied 0.05 by 100 (total number of students atm) to get 5 then subtract 5 by 100

Answer 58

to get 95

Answer 59

now write the first part with x=100

Answer 60

.05(100)

Answer 61

in one eq write the entire sentence

Answer 62

in terms of x

Answer 63

do NOT write 100

Answer 64

.05(x)

Answer 65

that only gives you how many people dropout. I want the total left

Answer 66

.05(x)-X=y

Answer 67

that would be a negative number

Answer 68

y=X-.05(x)

Answer 69

YES!

Answer 70

thats it!

Answer 71

Punchinh my self in the face atm

Answer 72

lmao

Answer 73

lol ok now, the x you have will be the cell above

Answer 74

at month 0 you have 100 insert the formula starting with month 1

Answer 75

then copy the formula down

Answer 76

how will i got about inserting it since Excel on read =PRODUCT for example

Answer 77

only reads*

Answer 78

no... you just type what i told you only instead of x click on the 100 cell should be like B2

Answer 79

there is no formula other than what you already have you don't need an excel fn

Answer 80

go it

Answer 81

got it*

Answer 82

ok!!! yay congrats

Answer 83

haha thank you very much

Answer 84

just remember to format the cells to 00 decimal places so you only have whole numbers

Answer 85

Thank you very much

Answer 86

Np, if you think I did a good job-and you have time- could you just write a testimonial?

Answer 87

of course, where do I write one out

Answer 88

Thanks! just click on my name and it should pop up

Answer 89

Strange I hover over your name and I know the tooltip so prompt me to writing one but its not popping up

Answer 90

tooltip is supposed to*

Answer 91

Got it, it stopped acting stupid

Answer 92

it takes a minute, it will say something like "hey write a testimonial! they will appreciate it!"

Answer 93

done :)

Answer 94

Thank you and it was wonderful =) Good luck with excel and your classes!

Answer 95

Thanks a bunch!

Answer 96

So is it 54 students left after the 12 months or 51?

Answer 97

54

Answer 98

How do type the formula for this problem in excel?