WGU D465 Data Applications Exam With Complete
Solutions 100% Verified!!
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 DISTINCT
VALUE - ANSWER>>COUNTIF
Which of the following is an example of an array for a spreadsheet?
All numeric-valued cells
Cells D7, E14, and F20
The values in cells B2 through B31
All the cells containing a value greater than 100 - ANSWER>>The values in cells B2
through B31
Which formula will sum the products of the corresponding items in the ranges M1:M4
and P1:P P4?
=SUMPRODUCT(M1:M4, P1:P4)
=MULTIPLY(M1:M4, P1:P4)
=PRODUCT(M1:M4, P1:P4)
=ARRAY(M1:M4, P1:P4) - ANSWER>>=SUMPRODUCT(M1:M4, P1:P4)
Fill in the blank: The _____ of a pivot table arrange and organize the selected data across
horizontally.
columns
rows
filters
Solutions 100% Verified!!
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 DISTINCT
VALUE - ANSWER>>COUNTIF
Which of the following is an example of an array for a spreadsheet?
All numeric-valued cells
Cells D7, E14, and F20
The values in cells B2 through B31
All the cells containing a value greater than 100 - ANSWER>>The values in cells B2
through B31
Which formula will sum the products of the corresponding items in the ranges M1:M4
and P1:P P4?
=SUMPRODUCT(M1:M4, P1:P4)
=MULTIPLY(M1:M4, P1:P4)
=PRODUCT(M1:M4, P1:P4)
=ARRAY(M1:M4, P1:P4) - ANSWER>>=SUMPRODUCT(M1:M4, P1:P4)
Fill in the blank: The _____ of a pivot table arrange and organize the selected data across
horizontally.
columns
rows
filters
