Quantitative Reasoning I Project: Creating Visuals from Data

profilelmbinney

 

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.- I chose  health services and nursing scenario 

Watch How to Create Trendlines and Scatterplots in Excel®.


https://d3qlakwpo3n83o.cloudfront.net/content/public/02-VIDEO-57c466e6d0463b5ca0f0fac1/renditions/57c4830a29bb1adc50e38103/original_700.mp4


Watch Week 4 Lynda.com® Video: Data-Analysis Fundamentals with Excel.


https://www.lynda.com/Excel-tutorials/Data-Analysis-Fundamentals-Excel/196583-2.html?srchtrk=index%3a1%0alinktypeid%3a2%0aq%3aData-Analysis+Fundamentals+with+Excel%0apage%3a1%0as%3arelevance%0asa%3atrue%0aproducttypeid%3a2


Create at least two visuals using your data from the data you chose in Week 2. 

  1. 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.
  2. 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.
  3. 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.

Your assignment will be graded using the Week 4 Grading Guide.

Select the Assignment Files tab to submit your visuals as either an Excel® file or a Word document.

  • Posted: a year ago
  • Due: 
  • Budget: $25
  • 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 …

  • Rated 1 times

    MATH

    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 …

  • Use the data from the nursing scenario from the file I uploaded.


    Create at least two visuals using your data from the data you chose in Week 2.

    1. Create one scatter plot of the data, …

  • 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 …

  • 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 …