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 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 from the Quantitative Reasoning I Project Topics and Scenarios workbook. 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.
Review the data sets help document if you need assistance with locating 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?
The purpose of this assignment is to have you practice creating visuals using the data from the topic you chose in Week 2. Creating charts and trendlines are important skills used in many careers.
Watch How to Create Trendlines and Scatterplots in Excel®.
Watch Week 4 Lynda.com® Video: Data-Analysis Fundamentals with Excel.
Create at least two visuals using your data from the data you chose in Week 2.
- Create one scatter plot of the data, and apply a linear model (also known as a regression) in Excel®. Include the equation, R2 value, and prediction value on the visual.
- Create one scatter plot of the data, and apply an exponential model in Excel®. Include the equation, R2 value, and prediction value on the visual.
- Determine whether the linear or the exponential model is a better representation of your data to base your prediction on. Explain why the model you chose is a better representation of your data.
Hints for Making an Effective Chart:
- Decide why you are making a chart from this data.
- Title each chart so that it aligns with the data and selected model.
- Create descriptive labels for both the x- and y axes.
- Resize the chart as needed so it can be viewed easily.
The purpose of this assignment is to use the skills you have learned throughout the course. You will apply what you have learned to solve the real-world scenario that you selected in Week 2.
Create a 3- to 4-slide Microsoft® PowerPoint® presentation including:
- One slide on your topic and scenario (approximately 1 minute)
- Introduce the topic and scenario you selected in Week 2.
- Explain why you are interested in the topic and scenario you chose.
- One to two slides of your visuals (approximately 2 to 3 minutes)
- These should be clear, neat, organized, and labeled from Week 4.
- Explain why either the linear model or the exponential model is better for predicting future results. In your explanation, include the significance of the R2 value and how the R2 value influenced the model you chose.
- Explain how your visuals support your conclusion.
- One slide for a conclusion (approximately 1 minute)
- Restate your topic and scenario and give your findings for the scenario.
- Discuss how your topic and scenario relates to a real-world scenario.
- Discuss what you learned from this project.
- Include detailed speaker notes for each slide.