Reference no: EM13867111
Question 1: What do the numbers on the bottom of the chart represent? _______________________
Question 2: What do the numbers on the vertical axis represent? _______________________________
Next you are going to add a "Trendline" in the chart. Pick any dot on the scatterplot. Right click on that dot. It will cause a dropdown menu. At this point, select "Add a Trendline".
Make sure that "Linear" is selected. Also, at the bottom of this menu, check on "Display Equation on Chart" and "Display r-squared value on chart".
Close this page. This will bring you back to your excel page with your chart.
This line shows the relationship between the two variables. If the line goes up as you go right, it is a positive correlation. If the line goes down as you go right, it is a negative correlation. The "r2" value shows you how strong the relationship is. The closer the value is to 1 - the stronger the relationship.
Question 3: Is your relationship positive or negative?
Question 4: How strong do you feel the relationship is and why?
Question 5: Write the correlation (relationship) in a sentence form using the names of the data.
Question 6: Are there any other variables that could be contributing to the results?
Attachment:- mat.xls
|
Bribery when doing business in the executive, country.
: TI asked 3,016 senior business executives in 28 countries around the world for their perceptions of the likelihood of companies, from countries they have business dealings with, to engage in bribery when doing business in the executive, country.
|
|
The estimated economic life of the machine
: On January 1, 2010, Von Company entered into two noncancelable leases for new machines to be used in its manufacturing operations. The first lease does not contain a bargain purchase option. The lease term is equal to 80% of the estimated economic li..
|
|
Global supply chain re-engineering
: Analyze the differences between the current supply chain and the proposed turnkey strategy.
|
|
Where does leadership fit into the picture
: Think of an organization that has been in existence for as long as you can remember. A Fortune 500 company for example. Why and how has the company managed to survive all the years despite radical growth in technology, political changes, and econo..
|
|
What do the numbers on the vertical axis represent
: What do the numbers on the bottom of the chart represent and what do the numbers on the vertical axis represent?
|
|
Discuss this problem as a class and draw up an action plan
: Assume that you are part of a management team of a medium-size business that sells goods to consumers online. You know that your system was recently hacked, and that accounts and customer information may have been stolen. How do you respond to the si..
|
|
Dimensions of system dependability
: "Dimensions of System Dependability" Please respond to the following: Consider the four principal dimensions of dependability. Choose two dimensions, describe them, and explain the relationship between your chosen dimensions. Provide at least two ..
|
|
Identify aspect of current configuration that could improved
: Identify one aspect of the current configuration that could be improved. Explain why have you chosen that aspect and suggest ways in which it could be improved.
|
|
A standard product known as px standard quantity
: The Following Data apply to the production of a standard product known as PX standard quantity 1000 kg materials M Standard price per Kg Rs-2.40 During the Certain Month 1150 kg of M was actually used.
|