Formulas/Codes Exam 1 ITAC

0.0(0)
Studied by 0 people
call kaiCall Kai
Locked
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/14

encourage image

There's no tags or description

Looks like no tags are added yet.

Last updated 2:30 PM on 7/20/26
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai
Chat

No analytics yet

Send a link to your students to track their progress

15 Terms

1
New cards

GM=

(data[sales]-data[cogs])/data[sales]

2
New cards

mRange_GM=

MAX(data[GM])-MIN(data[GM])

3
New cards

mPercentile=

PERCENTILE.INC(data[GM],PercentileOptions[m_selected_percentiles])

4
New cards

PercentileOptions=

{0.01,0.50,00.99}

5
New cards

m_selected_percentile=

SELECTEDVALUE(PercentileOptions[Value])

6
New cards

Assets_Lag=

VAR CurrentDate=data[date]

VAR CurrentKey=data[key]

Return

Calculate(

max(data[assets]),

Filter(

data,

data[key]=CurrentKey && data[date]=

Calculate(

max(data[date]),

Filter(

data,

data[key]=CurrentKey && data[date]<CurrentDate))))

7
New cards

AV_AT=

(data[assets]+data[Assets_Lag])/2

8
New cards

ROA_GM=

(data[sales]-data[cogs])/data[AV_AT]

9
New cards

mPercentile_ROA=

PERCENTILE.INC(data[ROA_GM],PercentileOptions[m_selected_percentile])

10
New cards

FirstDigit=

LEFT(data[sales],1)

11
New cards

NewTable:BenfordsLaw=

ADDCOLUMNS(GENERATESERIES(1,9,1),”Probability”,LOG10(1+ 1/[Value]))

12
New cards

mActualCountFirstDigit=

COUNT(data[FirstDigit])

13
New cards

mCountAll=

CALCULATE(COUNT(data[FirstDigit]),ALLEXCEPT(data,data[date]))

14
New cards

mActualPerc=

data[mActualCountFirstDigit]/data[mCountAll]

15
New cards

mExpectedCountFirstDigit=(inBenfordsLaw table)

[mCountAll]*AVERAGE(BenfordsLaw[Probability])