Order Instructions
nstructions
In this assignment, you will be required to use the Heart Rate Dataset to complete the following:
Use the classification of variables from the Unit 1 assignment to match each variable to one appropriate type of graph
Create graphs of those variables
Give a brief written description of how the values of each variable are distributed in the sample. What does the graph tell us about the data in the heart rate sample?
Steps
Open the Heart Rate Dataset in Excel
Using the classification of variables from Unit 1 assignment as qualitative, quantitative discrete, or quantitative continuous, match each of the 3 variables to the most appropriate graph type. (For example, qualitative data can best be displayed with a pie chart or bar graph; continuous numerical data can best be displayed using a histogram)
Use the graphing functions in Excel to create an appropriate graph of the data for each variable. Remember to properly label and title your graphs to clearly identify what the graph is about.
Review these videos as needed:
Excel 2016: Creating a Pie Chart
(Tom Kleen, 2017)
Estimated time to complete: 9 minutes
Making a Simple Bar Graph in Excel
(Scott Stevens, 2014)
Estimated time to complete: 5 minutes
Additional Instructions:
Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must include
Running head
A title page with
Assignment name
Your name
Professor’s name
Course
Estimated time to complete: 3 hours
References
Scott Stevens. (2014). Making a simple bar graph in Excel [Video]. Retrieved from https://youtu.be/_Txpfyn4ipI
Tom Kleen. (2017). Excel 2015: Creating a pie chart [Video]. Retrieved from https://youtu.be/ZKa35Iz-aZ4
Assignment Files
Heart Rate Data Set
Rubric
MA320 Unit 2 Assessment
MA320 Unit 2 Assessment
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeContent
MA320-CO1
25 pts
Level 5
Expresses content knowledge with the assignment purpose in a complete, organized, clear, professional, and culturally respectful manner.
22.5 pts
Level 4
Expresses content knowledge with the assignment purpose in a complete, organized, clear, professional, and culturally respectful manner with minor weaknesses in one or more of the areas.
20 pts
Level 3
Partially expresses content knowledge with the assignment purpose. Expresses ideas in a complete, organized, clear, professional, and culturally respectful manner with weaknesses in these area.
17.5 pts
Level 2
Partially expresses content knowledge with the assignment purpose. Ideas are partially expressed in an organized, professional, and culturally respectful manner with major weaknesses in these areas.
15 pts
Level 1
Expresses limited content knowledge with the assignment purpose. Ideas are not expressed in a complete, organized, clear, professional, and/or culturally respectful manner.
0 pts
Level 0
The assignment was not completed or there are no constructed concepts that demonstrate analytically skills and no evidences to support the content does not align to the assignment instructions
25 pts
This criterion is linked to a Learning OutcomeAnalysis
MA320-CO1
25 pts
Level 5
Constructs concepts related to course content, demonstrating strong analytical skills with strong evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.
22.5 pts
Level 4
Constructs concepts related to course content, demonstrating strong analytical skills with evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.
20 pts
Level 3
Constructs concepts related to course content, demonstrating analytical skills with some evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.
17.5 pts
Level 2
Constructs concepts related to course content, demonstrating weak analytical skills with minimal evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.
15 pts
Level 1
Constructs concepts related to course content, demonstrating inadequate evidence of analytical skills. There is minimal or no evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.
0 pts
Level 0
The assignment was not completed or there was no evidence of constructed concepts that are supported by professional and personal subject knowledge through details, supporting evidence, and idea differentiation.
25 pts
This criterion is linked to a Learning OutcomeTechnology
10 pts
Level 5
Manipulates multiple technological resources to effectively implement all assignment requirements.
8.75 pts
Level 4
Manipulates multiple technological resources to effectively implement most assignment requirements.
7.5 pts
Level 3
Manipulates multiple technological resources to effectively implement some assignment requirements.
6.25 pts
Level 2
Manipulates multiple technological resources for some assignment requirements.
5 pts
Level 1
Manipulates technological resources to minimally meet some assignment requirements.
0 pts
Level 0
The assignment was not completed or difficulties with technological manipulation were evident. The assignment submitted does not meet requriements.
10 pts
This criterion is linked to a Learning OutcomeWriting
5 pts
Level 5
The assignment exhibits a excellent command of written English language conventions. The assignment has no errors in mechanics, grammar, or spelling.
4.5 pts
Level 4
The assignment exhibits a good command of written English language conventions. The assignment has no errors in mechanics, or spelling with minor grammatical errors that impair the flow of communication.
4 pts
Level 3
The assignment exhibits a basic command of written English language conventions. The assignment has minor errors in mechanics, grammar, or spelling that impact the flow of communication
3.5 pts
Level 2
The assignment exhibits a limited command of written English language conventions. The assignment has frequent errors in mechanics, grammar, or spelling that impede the flow of communication.
3 pts
Level 1
The assignment exhibits little command of written English language conventions. The assignment has errors in mechanics, grammar, or spelling that cause the reader to stop and reread parts of the writing to discern meaning.
0 pts
Level 0
The assignment does not demonstrate command of written English language conventions. The assignment has multiple errors in mechanics, grammar, or spelling that cause the reader difficulty discerning the meaning.
5 pts
This criterion is linked to a Learning OutcomeAPA
5 pts
Level 5
In-text citations of sources and references in proper APA style are included with no errors.
4.25 pts
Level 4
In-text citations of sources and references in proper APA style are included but have 1-2 minor APA errors.
3.75 pts
Level 3
In-text citations of sources and references in proper APA style are included but have 3 – 4 minor APA errors.
2.5 pts
Level 2
In-text citations of sources and references in proper APA style are included but have more than 4 errors.
1.25 pts
Level 1
The errors demonstrate limited understanding of in-text citation and reference requirements
0 pts
Level 0
There are no in-text citations AND/OR references.
5 pts
Total Points: 70
Interested in getting help with this assignment?
Get a professional writing team to work on your assignment!
Order Now
Recent posts
For this final assignment, you will prepare a brief paper detailing the steps undertaken to complete a presentation that disseminates information you assemble
Please choose to answer only one of the 2 following questions. Option 1: In your opinion and based on scientific, peer-reviewed published evidence, does child
At the beginning of the previous academic year, the institution announced it would drop football at the conclusion of the season. The announcement created pub
you will review current research in Personality and provide a critical evaluation of that personality research through an annotated bibliography. An annotated
In Module 5, we considered the third in our three-part series on research design. Specifically, the focus was on the longitudinal studies, in which the resear
Need help with a similar or different Task?
We have the best writers to help you. Hire Writer Now
