You have been hired by a small investment company that manages an equity fund
comprised of 150 U.S. companies across multiple industries. The fund managers are
looking to rebalance the fund's holdings and would like you to provide an analysis of the
companies' performance based on data from the most recent quarter. The data can be
found in the supporting documents section as "D598 Data Set".
To aid in your analysis you must write programs in Python or R to perform the following
tasks:
• Import the data file into a data frame.
• Identify any duplicate rows in the data set.
• Group all IDs by state, then run descriptive statistics (mean, median, min, &
max) for all numeric variables by state and store this result as a new data frame.
(Code should be modified from "D598 Task 2 Original Code" in the supporting
documents section)
• Filter the data frame to identify all businesses with debt-to-equity ratios that are
negative.
• Create a new data frame that provides the debt-to-income ratio for every
business in the data set. Debt-to-income ratio is defined as long-term debt divided
by revenue.
• Concatenate the debt-to-income ratio data frame you created with the original
data frame.
Requirements
Your submission must represent your original work and understanding of the course
material. Most performance assessment submissions are automatically scanned
through the WGU similarity checker. Students are strongly encouraged to wait for the
similarity report to generate after uploading their work and then review it to ensure
Academic Authenticity guidelines are met before submitting the file for evaluation.
See Understanding Similarity Reports for more information.
Grammarly Note:
Professional Communication will be automatically assessed through Grammarly for
Education in most performance assessments before a student submits work for
evaluation. Students are strongly encouraged to review the Grammarly for Education
feedback prior to submitting work for evaluation, as the overall submission will not pass
without this aspect passing. See Use Grammarly for Education Effectively for more
information.
Microsoft Files Note:
Write your paper in Microsoft Word (.doc or .docx) unless another Microsoft product, or
pdf, is specified in the task directions. Tasks may not be submitted as cloud links, such
as links to Google Docs, Google Slides, OneDrive, etc. All supporting documentation,
such as screenshots and proof of experience, should be collected in a pdf file and
submitted separately from the main file. For more information, please see Computer
System and Technology Requirements.
, You must use the rubric to direct the creation of your submission because it provides
detailed criteria that will be used to evaluate your work. Each requirement below may be
evaluated by more than one rubric aspect. The rubric aspect titles may contain
hyperlinks to relevant portions of the course.
In this task you will prepare for your program writing by doing the following:
A. Create a flowchart for a program to perform the required task.
B. Write pseudocode for a program to perform the required task.
C. Provide an explanation of the relationship between the flowchart and
pseudocode that does the following:
1. Describe the logic behind the flowchart and pseudocode.
2. Explain the alignment between flowchart and pseudocode.
D. Acknowledge sources, using in-text citations and references, for content that is
quoted, paraphrased, or summarized.
E. Demonstrate professional communication in the content and presentation of your
submission.
File Restricti
The submission includes a flowchart. An appropriate flowchart that clearly illustrates the
solution, including all relevant nodes, paths and decisions, was not observed.
B. PSEUDOCODE
Approaching Competence
Approaching CompetencePseudocode is provided but is inappropriate for the required
task or contains errors.
Evaluator Comments: Attempt 1
The pseudocode is provided. The submission is insufficient because the flowchart and
pseudocode do not appropriately represent all of the steps of the required task, such as
the error-handling logic. This aspect will be assessed once revisions to part A have
been made.
C1. FLOWCHART EXPLANATION
Approaching Competence
, Approaching CompetenceThe response does not describe the logic behind the
flowchart and the pseudocode or contains errors.
Evaluator Comments: Attempt 1
An explanation of the logic behind the flowchart and pseudocode is included in the
submission. This aspect cannot be fully assessed before revisions to previous related
aspects are in place and all aspects align.
C2. PSEUDOCODE EXPLANATION
Approaching Competence
Approaching CompetenceThe response does not explain the alignment between the
flowchart and pseudocode or contains errors.
Evaluator Comments: Attempt 1
An explanation of the alignment between the flowchart and pseudocode is included in
the submission. This aspect cannot be fully assessed before revisions to previous
related aspects are in place and all aspects align.
D. APA SOURCES
Approaching Competence
Approaching CompetenceThe submission includes in-text citations and references for
content that is quoted, paraphrased, or summarized but does not demonstrate a
consistent application of APA style.
Evaluator Comments: Attempt 1
The submission provides a suitable citation list with citations in the report. This aspect
will be assessed once revisions to previous aspects have been made.
E. PROFESSIONAL COMMUNICATION
Approaching Competence
Approaching CompetenceThis submission includes substantial errors in professional
communication related to grammar, sentence fluency, contextual spelling, or punctuation.
Specific errors have been identified by Grammarly for Education under the Correctness
category.
comprised of 150 U.S. companies across multiple industries. The fund managers are
looking to rebalance the fund's holdings and would like you to provide an analysis of the
companies' performance based on data from the most recent quarter. The data can be
found in the supporting documents section as "D598 Data Set".
To aid in your analysis you must write programs in Python or R to perform the following
tasks:
• Import the data file into a data frame.
• Identify any duplicate rows in the data set.
• Group all IDs by state, then run descriptive statistics (mean, median, min, &
max) for all numeric variables by state and store this result as a new data frame.
(Code should be modified from "D598 Task 2 Original Code" in the supporting
documents section)
• Filter the data frame to identify all businesses with debt-to-equity ratios that are
negative.
• Create a new data frame that provides the debt-to-income ratio for every
business in the data set. Debt-to-income ratio is defined as long-term debt divided
by revenue.
• Concatenate the debt-to-income ratio data frame you created with the original
data frame.
Requirements
Your submission must represent your original work and understanding of the course
material. Most performance assessment submissions are automatically scanned
through the WGU similarity checker. Students are strongly encouraged to wait for the
similarity report to generate after uploading their work and then review it to ensure
Academic Authenticity guidelines are met before submitting the file for evaluation.
See Understanding Similarity Reports for more information.
Grammarly Note:
Professional Communication will be automatically assessed through Grammarly for
Education in most performance assessments before a student submits work for
evaluation. Students are strongly encouraged to review the Grammarly for Education
feedback prior to submitting work for evaluation, as the overall submission will not pass
without this aspect passing. See Use Grammarly for Education Effectively for more
information.
Microsoft Files Note:
Write your paper in Microsoft Word (.doc or .docx) unless another Microsoft product, or
pdf, is specified in the task directions. Tasks may not be submitted as cloud links, such
as links to Google Docs, Google Slides, OneDrive, etc. All supporting documentation,
such as screenshots and proof of experience, should be collected in a pdf file and
submitted separately from the main file. For more information, please see Computer
System and Technology Requirements.
, You must use the rubric to direct the creation of your submission because it provides
detailed criteria that will be used to evaluate your work. Each requirement below may be
evaluated by more than one rubric aspect. The rubric aspect titles may contain
hyperlinks to relevant portions of the course.
In this task you will prepare for your program writing by doing the following:
A. Create a flowchart for a program to perform the required task.
B. Write pseudocode for a program to perform the required task.
C. Provide an explanation of the relationship between the flowchart and
pseudocode that does the following:
1. Describe the logic behind the flowchart and pseudocode.
2. Explain the alignment between flowchart and pseudocode.
D. Acknowledge sources, using in-text citations and references, for content that is
quoted, paraphrased, or summarized.
E. Demonstrate professional communication in the content and presentation of your
submission.
File Restricti
The submission includes a flowchart. An appropriate flowchart that clearly illustrates the
solution, including all relevant nodes, paths and decisions, was not observed.
B. PSEUDOCODE
Approaching Competence
Approaching CompetencePseudocode is provided but is inappropriate for the required
task or contains errors.
Evaluator Comments: Attempt 1
The pseudocode is provided. The submission is insufficient because the flowchart and
pseudocode do not appropriately represent all of the steps of the required task, such as
the error-handling logic. This aspect will be assessed once revisions to part A have
been made.
C1. FLOWCHART EXPLANATION
Approaching Competence
, Approaching CompetenceThe response does not describe the logic behind the
flowchart and the pseudocode or contains errors.
Evaluator Comments: Attempt 1
An explanation of the logic behind the flowchart and pseudocode is included in the
submission. This aspect cannot be fully assessed before revisions to previous related
aspects are in place and all aspects align.
C2. PSEUDOCODE EXPLANATION
Approaching Competence
Approaching CompetenceThe response does not explain the alignment between the
flowchart and pseudocode or contains errors.
Evaluator Comments: Attempt 1
An explanation of the alignment between the flowchart and pseudocode is included in
the submission. This aspect cannot be fully assessed before revisions to previous
related aspects are in place and all aspects align.
D. APA SOURCES
Approaching Competence
Approaching CompetenceThe submission includes in-text citations and references for
content that is quoted, paraphrased, or summarized but does not demonstrate a
consistent application of APA style.
Evaluator Comments: Attempt 1
The submission provides a suitable citation list with citations in the report. This aspect
will be assessed once revisions to previous aspects have been made.
E. PROFESSIONAL COMMUNICATION
Approaching Competence
Approaching CompetenceThis submission includes substantial errors in professional
communication related to grammar, sentence fluency, contextual spelling, or punctuation.
Specific errors have been identified by Grammarly for Education under the Correctness
category.
