Assume once again that you are a consultant who works for the Diligent Consulting Group. You are continuing to work on the analysis of the customer database
SIMPLE LINEAR REGRESSION
Assume once again that you are a consultant who works for the Diligent Consulting Group. You are continuing to work on the analysis of the customer database from Modules 1 and 2.
SLP Assignment Expectations
Complete the following tasks in the Module 3 SLP assignment template:
Create a scatterplot in Excel with “Annual Amount Spent on Organic Food” on the y (vertical) axis and “Age” on the x (horizontal) axis.
Insert a trendline.
What does the trendline indicate about the relationship between these two variables?
Calculate the correlation coefficient for these two variables using the =CORRELATION() formula in Excel.
Interpret the correlation coefficient.
Does the correlation coefficient agree with the slope of the best fit line? Explain.
Add the equation for the best fit line on the chart.
Does this equation match the linear regression equation from the Case for this module? Explain.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
