Reference no: EM132333846
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
|
What is the nature of human resource managerial work
: In your experience, what is the nature of human resource managerial work? Describe the relationship between employee planning and development.
|
|
What types of media will be used for recruiting
: You are the Chief Human Resource Officer (CHRO) at your organization. As the CHRO, one of your primary roles is to be the workforce strategist.
|
|
Write an essay on Child poverty is a real issue in Toronto
: Child poverty is a real issue in Toronto. Write an essay (5 paragraph) to suggest some pragmatic solutions to address this problem
|
|
Prepare a managerial problem-solving memo
: Imagine that you are a leader in an industrial cleaning supply organization. Over the past three months, the sales in the organization have declined significant
|
|
Create a scatter plot of the data
: Math 123 Assignment - Linear Models and Trendlines. In IvyLearn, you will find an Excel spreadsheet of the US vehicle sales data. Create a scatter plot of data
|
|
Descrie the theoretical perspectives in brief
: Write a 2 - 4 page paper, detail four of the theoretical perspectives outlined in your text reading. Compare and contrast the theories using examples.
|
|
How might the statements affect the strategic choices
: Organizational vision statements can take interesting directions. Using the Web, find three examples of organizational vision statements and write them down.
|
|
Describe the interaction and labeling theory
: In detail, describe the Interaction and Labeling Theory. Include the three propositions of George Herbert Meade and whether you find them to be reasonable.
|
|
Describe the may-can-should model in detail
: Policy Briefs Instructions: For Modules/Weeks 3-7, you are expected to submit a 1 1/2-2-page paper (not including the title page, abstract, and reference page).
|