Discussion: Bias, Statistics, News and Lies. Previous Next Statistics and Lies "There are three kinds of lies: lies, damned lies, and statistics." - Mark Twain. A mid-twentieth century book: Lesson

BUS520 Module 3. Session Long Project. Complete Module 3 SLP before Module 3 Case. How to Run a Correlation in Excel. • Make sure the columns of d ata are next to each other. • Highlight the data in the columns. Not the whole column. • Click Data. • Data Analysis. • Scroll down to Correlation. • Click OK. • Check Labels in First Row. • Select OK to run the correlation. This is the correlation. Creating a Scatterplot. Highlight the same columns as the correlation. Click Insert on the Menu. Select the Scatterplot Chart. Select More Scatter Charts. Under the Recommended Charts. Select the Scatter. Select the Design you prefer from the Choices. • Click your Scatterplot • Click on the PLUS sign • Check Trendline and Linear. Include Correlation and Scatterplot in Word document. You will have three sets of correlations and scatterplots. • Interpret the output. How is the data corr elated? • Is it a strong relationship? Discuss implications for management. Research correlations between organizational commitment and job satisfaction connections between the variables you tested. Include workplace applications that may be implemented based on the findings. (Research Required)