Cse 6040X Computing For Data Analysis Updated Actual Questions And Correct Answers

CSE 6040X COMPUTING FOR DATA
ANALYSIS UPDATED ACTUAL QUESTIONS
AND CORRECT ANSWERS



◉ Auditing Formulas in Excel
Answer: Shows what goes into a formula (trace precedents)


◉ Examples of Charts in Excel
Answer: Bar graphs, pie charts, line charts


◉ Sparklines in Excel
Answer: Miniature graph in one cell


◉ Vlookup
Answer: Searches vertically down a column


◉ Hlookup
Answer: Searches horizontally down a row


◉ Sorting in Excel
Answer: Puts data in an order

,◉ Filters in Excel
Answer: Selects a subset based on a criteria


◉ Pivot Tables
Answer: Summarizes a large amount of data into a table


◉ Examples of Descriptive Statistics
Answer: Mean, Mode, Median, Standard Deviation


◉ Correlation
Answer: Strength & Direction (-1 to +1)
Strong: far from zero
Weak: close to zero
Sign gives direction (- & +)


◉ Linear Regression
Answer: Magnitude of change & direction


◉ Exponential Regression
Answer: Compounds (Ex: compound interest)


◉ Power Regression

, Answer: Learning curve and economies of scale


◉ Moving Average
Answer: Shows seasonality


◉ Multiple Regression
Answer: More than one X variable


◉ Multiple Regression Order
Answer: Check significance of F first, then R squared, then P-
values of the coefficients


◉ Significance of F
Answer: If less than 0.05, interpret
If greater than 0.05, DON'T INTERPRET
Don't even interpret coefficients, even if coefficients are
significant


◉ R Squared Examples
Answer: Ex: 12.34% of the change in y can be explained by the
change in x
Ex: 68.82% of the change in factory cost can be explained by the
change