Phoenix MTH215 Quantitative Reasoning 1 Project
SharkByte187
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.
- Do not submit anything, i will do that part, just the assignment to homework market.
- Attached is the data that you will need for the charts and graphs. Use the #2 tab on the bottom titled CRIMINAL JUSTICE.
- 5 years ago
- 60
Answer(2)
Purchase the answer to view it
- Dataforproject.xlsx
Purchase the answer to view it
NOT RATED
- QuantitativeReasoningIProjectCreatingVisualfromData.xlsx
other Questions(10)
- EXECPTIONAL PROFF
- For A-Plus Writer Only
- CIS 245 Unit 1 Assignment Network Diagram
- Leadership and Ethical Decision Making – Policy Implementation - UWEAR and PALEDENIM
- Marketing paper
- m4a2
- STAT 200 Week 3 Homework Complete Solution
- Which of the following keywords progress from broad to narrow? Select one: a. AIDS, acquired immunodeficiency syndrome b. Insects, butterflies c. Computer literacy, information...
- for genius alert presentation
- View the positive authentication results for www.google.com. Use SnadBoy’s Revelation tool to see the actual password behind the asterisks.