# Assignment Detail

Tutors

## Create a scatter plot of the data

### Assignment Instructions

Assignment Help >> Applied Statistics

Assignment – Linear Models and Trendlines
U.S. Vehicle Sales, 1951-2014 is attached.
1. In IvyLearn, you will find an Excel spreadsheet of the US vehicle sales data. Use the data to perform the following tasks:
a. Create a scatter plot of the data.
b. Include a title for the scatter plot and labels for both the horizontal and vertical axes.
c. Add a linear trend line to the graph.
d. Create a two-paragraph report with your graph (showing the trend line) addressing the following items:
i. How good is the correlation between x and y for this data?
ii. Interpret the slope of the trendline in a complete sentence.
iii. Use the trend line equation to estimate the sales for 2014, and compare this estimate to the actual production.
iv. Use the trend line equation to estimate the sales from your birth year. Compare that estimate to the actual 2014 value. How much have sales changed since your birth year? Find the relative change in sales since your birth year and interpret the meaning of this value.
v. Should we use the trend line model to estimate the sales value for 2020? Why or why not?
Note – Turn in the answers to the questions and an Excel file via the link in IvyLearn. Show work to receive full credit. Make sure to show the values you put into the linear models.
Attachment:- Linear Models Assignment Files.rar

Need fresh solution to this Assignment without plagiarism?? Get Quote Now

##### Plagiarism Checked
4.6/5

Plagiarism free Answer files are strictly restricted for download to the student who originally posted this question.

#### Analyze nestle csr initiative plan focuses on society issues

This is a CSR project, and choose to nestle as our company Note: Please give answer on mentioned words (must add intext citation) and required

#### Discuss three good corporate governance practices

You are an independent consultant, counseling companies on corporate governance issues. You have been engaged by JKL Renew Pty Ltd (JKL) to advise them on

#### Describe organizational culture in two different workplaces

Explore the following linked resources that describe organizational culture in two different workplaces: the Gjøa offshore platform and Volkswagen (during 2006-2015). 1. The Life Onboard

#### What communication technology should bob use communicating

Bob is project manager for a construction company. The firm is the general contractor and is building a skyscraper in a well-known Middle Eastern country.

#### What are the standards and values of the organisation

Explain via a report the values and standards required by an organisation and how they relate to performance management. Include in the report team and

#### Implement a new electronic health record system

Our healthcare organization, Health First, is embarking on a project to implement a new electronic health record (EHR) system. This project aims to streamline patient

Our customer support team is here to answer your questions. You can send Assignments directly to support team.
👋 Hi, how can I help?