Hello, can anyone assist with the following information 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, R 2 value, and prediction valueon the visual Create one scatter plot of the data, and apply an exponential model in Excel Include the equation, R 2 value,and prediction valueon 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 Education Scenario Topic 6 Elementary Education Math Skills Scenario 6 Review the data involving elementary students in Apache County who passed the AZ Merit Test from 2006 2015 Predict the number of students who will pass the AZ Merit test in 2018 Fiscal Year Students in Apache County who Pass the AZ Merit Test 2006 12 2007 7 2008 14 2009 18 2010 25 2011 37 2012 33 2013 39 2014 45 2015 42

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 14, 2024

Hello, can anyone assist with the following information. The purpose of this assignment is to have you practice creating visuals using the data from the

Hello, can anyone assist with the following information.

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.

WatchHow to Create Trendlines and Scatterplots in Excel.

WatchWeek 4 Lynda.comVideo: Data-Analysis Fundamentals with Excel.

Createat 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, R²value, and prediction valueon the visual.
Create one scatter plot of the data, and apply an exponential model in Excel. Include the equation, R²value,and prediction valueon 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.

Education Scenario

Topic 6 Elementary Education: Math Skills

Scenario 6 Review the data involving elementary students in Apache County who passed the AZ Merit Test from 2006-2015. Predict the number of students who will pass the AZ Merit test in 2018.

Fiscal Year Students in Apache County who Pass the AZ Merit Test

2006 12

2007 7

2008 14

2009 18

2010 25

2011 37

2012 33

2013 39

2014 45

2015 42