This question has 3 parts!!!
Part 1 choosing a topic
The purpose of this assignment is to get you to think about what types of data-oriented problems you will be solving in your chosen career. In this assignment, you will select a topic and an associated problem to solve. You will continue to work on analyzing and solving this problem throughout the remainder of this course.
Select a topic with your data set from the Quantitative Reasoning II Project Topics and Scenarios. After opening the file, access the topics along with their data sets and problems by clicking the individual worksheet tabs near the bottom of the workbook. For this project, six topics that align to various career disciplines have been made available for your selection. You will be using this data throughout the course.
Review the data sets help if you are struggling to locate all of the data sets.
Compose a 175-word response that addresses the following questions:
- What topic did you choose?
- Why does it interest you?
- What do you hope to discover in your analysis?
In this stage you will do statistical reasoning and mathematical modeling to show central tendency and two variable analyses, including regression with equation and R squared value from the data set you chose in Week 2. The purpose of this assignment is to have you practice creating visuals using your own data. This shows you how you will be working with data in your own careers.
The purpose of this assignment is to gain experience creating visuals using the data for the topic you selected in Week 2. Use statistical reasoning and mathematical modeling to show central tendency and two-variable analyses, including regression with equation and R2value.
Watch How to Create Trendlines and Scatterplots in Excel®.
Watch Lynda.com® Video: Adding Trendlines to Charts.
Watch Lynda.com® Videos: Creating Pie Charts, Histograms, & Box-and-Whisker Plots.
Create at least three visuals.
- One visual must be a scatter plot with trend line, equation, R2 value, and prediction value.
- Two of the remaining required visuals can be of the following format: histogram, box and whisker plot, or pie chart.
- Please note that the data set that you chose in Week 2 includes data that will not be needed to create your visuals. Quantitative reasoning requires critical thinking to decide what data is necessary.
Create a Microsoft® Word document that includes your three visuals and the following items:
- Title of your project and the scenario you are addressing
- Brief description of each visual (15 to 50 words)
- Consider including the following for each visual when applicable:
- A chart title that is appropriate for the data
- A descriptive x-axis label
- A descriptive y-axis label
- For your xy scatter plot, make at least one prediction using the trend line equation for a date in the future. How confident are you in this prediction? State your prediction and provide justification (50 to 150 words).
- If you created a box and whisker plot, describe the central tendency of the values. What does this tell you about the data and about your project?
- Calculate the mean of the sample data.
Click to view an example of the visuals expected for this assignment.
Your assignment will be graded using the Week 3 Quantitative Reasoning II Project Grading Guide.
The purpose of this assignment is to use skills you have learned throughout all five weeks of the course. You will be able to apply what they have learned to solve a real world problem that you could use to in your future career.
Create a 5- to 6-slide presentation that must include:
- One slide on the Introduction
- Introduce your topic and question that you chose in Week 2.
- Why did it interest you? How does it relate to life?
- What should the audience learn from your presentation?
- Three to four slides of your visuals
- Show your tables, scatter plot, other 2 visuals, calculations, and any other evidence to support your conclusion(s) that you created in Week 3.
- Explain what information in the data tables is not needed for your analysis.
- Discuss what you can conclude from the visuals. How do these visuals support your conclusion?
- One slide for a conclusion
- Restate your topic and question and give your answer to the scenario.
- How confident are you that your conclusion is sound?
- What work would need to be done to increase your confidence?
- Discuss what you learned from this project.
Include detailed speaker notes for each slide.
Your assignment will be graded using the Quantitative Reasoning II Project Rubric.