Icon

Big Data Term Project

AMD Cleaning Data and Quality Check

S&P500 Cleaning Data and Quality Check

NVDIA Cleaning Data and Quality Check

Return

Assign the Period

Get Out of S&P500

Standard Deviation

Calculate |t-value|

Get Back In S&P500

Standard Deviation

Calculate |t-value|

p-value

p-value

Row Filter
|t-value|
Math Formula
JoinerColumn FilterColumn mergerString to NumberMissing ValueTimestamp
Clean the Data
Column Filter
CSV Reader
CSV Reader
CSV Reader
CSV Reader
3 year before out
Date&Time-based Row Filter
Quality check
Evaluate Data Quality
3 year after got out
Date&Time-based Row Filter
Add mission value on day off and find simple return of S&P 500
Calculate Return
Integrate AMD and S&P 500 data (price, return, volume)
Joiner
3 year before Re-enter
Date&Time-based Row Filter
Add mission value on day off and find simple return of AMD
Calculate Return
3 year before out
Date&Time-based Row Filter
Price after clean
Line Plot
3 year after re-enter
Date&Time-based Row Filter
Add mission value on day off and find simple return of NVDIA
Calculate Return
Price before clean
Line Plot
3 year after got out
Date&Time-based Row Filter
Price after clean
Line Plot
Price after clean
Line Plot
Degree of Freedom
Column Filter
t-value
Row Filter
Row Filter
|t-value|
Math Formula
Column Filter
P-value
Column Filter
JoinerColumn mergerColumn FilterMissing ValueTimestamp
Clean the Data
Row Filter
Degree of Freedom
Column Filter
Stdev
Column Filter
t-value
3 year after re-enter
Date&Time-based Row Filter
P-value
Column Filter
3 year before Re-enter
Date&Time-based Row Filter
STDEV
Row Filter
|t-value|
Math Formula
Column Filter
STDEV
Compare MA(return) of AMD, NVDA and S&P 500 3 years before out and after out
Visualization
Row Filter
Degree of Freedom
Column Filter
Stdev
Column Filter
t-value
P-value
Column Filter
STDEV
Row Filter
|t-value|
Math Formula
Degree of Freedom
Column Filter
Column Filter
JoinerColumn FilterColumn mergerString to NumberMissing ValueTimestamp
Clean the Data
CSV Reader
Compare MA(return) of AMD, NVDA and S&P 500 3 years before re-enter and after re-enter
Visualization
Row Filter
CSV Reader
CSV Reader
Quality check
Evaluate Data Quality
Price before clean
Line Plot
Stdev
Column Filter
CSV Reader
Price before clean
Line Plot
t-value
Stdev
Column Filter
P-value
Column Filter
CSV Reader
Quality check
Evaluate Data Quality
STDEV

Nodes

Extensions

Links