R and Python similarities - ANSWER>>Both widely used in data science with extensive
libraries.
R unique challenges - ANSWER>>Steeper learning curve, limited web dev capabilities.
Advantage of storing code in R - ANSWER>> Allows reproducibility and collaboration
among analysts.
Programming languages and use cases - ANSWER>>Python: web dev, data science,
ML, automation.
MIN function in spreadsheets - ANSWER>> Returns the smallest value in a cell range.
COUNTIF formula in spreadsheet applications - ANSWER>>Counts the number of cells
that meet one given criteria.
Pivot table elements - ANSWER>>Rows, columns, values, filters for summarizing data.
SELECT in SQL- ANSWER>>Retrieve data from one or more database tables.
JOINs in SQL- ANSWER>>There are several types of JOINs: INNER, LEFT, RIGHT, FULL
OUTER.
Delimiters for code chunk - ANSWER>>Triple backticks or markup to delineate code
,chunks.
Document output formats - ANSWER>>HTML, PDF, Word (docx), Markdown.
Presentation formats - ANSWER>>Slides, Dashboards, Interactive web apps.
Knit button in R - ANSWER>>Compiles R Markdown into desired output formats.
Comment symbol in R - ANSWER>>Comments in R are preceded by the pound sign
(`#`).
Using nested functions - ANSWER>>Simplifies operations. Improves readability of
code.
Logical operators - ANSWER>>AND (&&), OR (||), NOT (!).
Advantage of tidyverse - ANSWER>> Integrated data manipulation packages in R.
Some important functions in ggplot2 - ANSWER>>ggplot(), geom_point(), geom_line(),
aes().
Plus sign in ggplot2 - ANSWER>> It adds layers to ggplot objects for customization.
Common mistakes when using ggplot2 - ANSWER>> Aesthetic mapping errors, syntax
misunderstanding.
Simple aesthetic attributes - ANSWER>> x-axis, y-axis, color to customize the plot.
Smoothing line - ANSWER>> It is used as a visualization to show the trend.
,dplyr filter() function - ANSWER>>Subsets rows in R based on particular conditions.
VLOOKUP function in spreadsheets - ANSWER>>Searches for values in a vertical
column.
Locking table array in VLOOKUP - ANSWER>>Prevents range changes for formula
accuracy.
Different JOIN functions in SQL - ANSWER>>INNER, LEFT, RIGHT, FULL OUTER JOIN
types.
COUNT vs. COUNT DISTINCT in SQL - ANSWER>>COUNT: total rows, COUNT
DISTINCT: unique values.
SQL statements are employed to - ANSWER>> Retrieving data from one or more
tables.
SQL FROM statement - ANSWER>> The name given to the tables from which to obtain
data in SQL queries.
Tibble versus data frame - ANSWER>> Data frames with improved features
modernized
Primary operators in R - ANSWER>> Arithmetic, relational, logical, assignment
operators
sample() with biased data - ANSWER>> Creates random unbiased data samples.
Fill in the blank The spreadsheet function returns the number of cells within a
range that meet a given value.
, COUNTIF
ARRAY
COUNT bDISTINCT
VALUE b- ANSWER>>COUNTIF
Which bof bthe bfollowing bis ban bexample bof ban barray bfor ba bspreadsheet?
All bnumeric-valued bcells
Cells bD7, bE14, band bF20
b
The bvalues bin bcells bB2 bthrough bB31
All bthe bcells bcontaining ba bvalue bgreater bthan b100 b- ANSWER>>The bvalues bin
bcells bB2 bthrough bB31
Which bformula bwill bsum bthe bproducts bof bthe bcorresponding bitems bin bthe branges bM1:M4
band bP1:P bP4?
=SUMPRODUCT(M1:M4, b P1:P4)
=MULTIPLY(M1:M4, b P1:P4)
=PRODUCT(M1:M4, b P1:P4)
=ARRAY(M1:M4, b P1:P4) b - ANSWER>>=SUMPRODUCT(M1:M4, b P1:P4)
Fill bin bthe bblank: bThe b of ba bpivot btable barrange band borganize bthe bselected bdata
bacross bhorizontally.
columns
rows
b
filters
b
libraries.
R unique challenges - ANSWER>>Steeper learning curve, limited web dev capabilities.
Advantage of storing code in R - ANSWER>> Allows reproducibility and collaboration
among analysts.
Programming languages and use cases - ANSWER>>Python: web dev, data science,
ML, automation.
MIN function in spreadsheets - ANSWER>> Returns the smallest value in a cell range.
COUNTIF formula in spreadsheet applications - ANSWER>>Counts the number of cells
that meet one given criteria.
Pivot table elements - ANSWER>>Rows, columns, values, filters for summarizing data.
SELECT in SQL- ANSWER>>Retrieve data from one or more database tables.
JOINs in SQL- ANSWER>>There are several types of JOINs: INNER, LEFT, RIGHT, FULL
OUTER.
Delimiters for code chunk - ANSWER>>Triple backticks or markup to delineate code
,chunks.
Document output formats - ANSWER>>HTML, PDF, Word (docx), Markdown.
Presentation formats - ANSWER>>Slides, Dashboards, Interactive web apps.
Knit button in R - ANSWER>>Compiles R Markdown into desired output formats.
Comment symbol in R - ANSWER>>Comments in R are preceded by the pound sign
(`#`).
Using nested functions - ANSWER>>Simplifies operations. Improves readability of
code.
Logical operators - ANSWER>>AND (&&), OR (||), NOT (!).
Advantage of tidyverse - ANSWER>> Integrated data manipulation packages in R.
Some important functions in ggplot2 - ANSWER>>ggplot(), geom_point(), geom_line(),
aes().
Plus sign in ggplot2 - ANSWER>> It adds layers to ggplot objects for customization.
Common mistakes when using ggplot2 - ANSWER>> Aesthetic mapping errors, syntax
misunderstanding.
Simple aesthetic attributes - ANSWER>> x-axis, y-axis, color to customize the plot.
Smoothing line - ANSWER>> It is used as a visualization to show the trend.
,dplyr filter() function - ANSWER>>Subsets rows in R based on particular conditions.
VLOOKUP function in spreadsheets - ANSWER>>Searches for values in a vertical
column.
Locking table array in VLOOKUP - ANSWER>>Prevents range changes for formula
accuracy.
Different JOIN functions in SQL - ANSWER>>INNER, LEFT, RIGHT, FULL OUTER JOIN
types.
COUNT vs. COUNT DISTINCT in SQL - ANSWER>>COUNT: total rows, COUNT
DISTINCT: unique values.
SQL statements are employed to - ANSWER>> Retrieving data from one or more
tables.
SQL FROM statement - ANSWER>> The name given to the tables from which to obtain
data in SQL queries.
Tibble versus data frame - ANSWER>> Data frames with improved features
modernized
Primary operators in R - ANSWER>> Arithmetic, relational, logical, assignment
operators
sample() with biased data - ANSWER>> Creates random unbiased data samples.
Fill in the blank The spreadsheet function returns the number of cells within a
range that meet a given value.
, COUNTIF
ARRAY
COUNT bDISTINCT
VALUE b- ANSWER>>COUNTIF
Which bof bthe bfollowing bis ban bexample bof ban barray bfor ba bspreadsheet?
All bnumeric-valued bcells
Cells bD7, bE14, band bF20
b
The bvalues bin bcells bB2 bthrough bB31
All bthe bcells bcontaining ba bvalue bgreater bthan b100 b- ANSWER>>The bvalues bin
bcells bB2 bthrough bB31
Which bformula bwill bsum bthe bproducts bof bthe bcorresponding bitems bin bthe branges bM1:M4
band bP1:P bP4?
=SUMPRODUCT(M1:M4, b P1:P4)
=MULTIPLY(M1:M4, b P1:P4)
=PRODUCT(M1:M4, b P1:P4)
=ARRAY(M1:M4, b P1:P4) b - ANSWER>>=SUMPRODUCT(M1:M4, b P1:P4)
Fill bin bthe bblank: bThe b of ba bpivot btable barrange band borganize bthe bselected bdata
bacross bhorizontally.
columns
rows
b
filters
b
